View Issue Details

IDProjectCategoryView StatusLast Update
0000188XMB1Research Taskspublic2008-12-07 21:41
Reportermiqrogroove Assigned Tomiqrogroove  
PriorityhighSeverityfeatureReproducibilityN/A
Status closedResolutionfixed 
Target Version1.9.11Fixed in Version1.9.11 
Summary0000188: Do We Need to Raise the MySQL Version Requirement?
DescriptionThe post linked below has alerted me to the fact that we are writing queries that may not be compatible with the currently required version of MySQL.

The MySQL manual says, "Before MySQL 4.1, only nested queries of the form INSERT ... SELECT ... and REPLACE ... SELECT ... are supported."
Additional Informationhttp://forums.xmbforum.com/viewthread.php?tid=773581
http://dev.mysql.com/doc/refman/4.1/en/rewriting-subqueries.html
TagsNo tags attached.
MySQL Version
PHP Version
Web Server
Browser
Flags
Original ReporterLoveriot
SVN Revision1423

Relationships

related to 0000004 closedmiqrogroove Redesign Moderator Log System 
related to 0000148 closedmiqrogroove Orphaned Polls 

Activities

miqrogroove

2008-11-30 18:22

administrator   ~0000093

The following features in XMB 1.9.11 are definitely not compatible with MySQL 4.0.x:

Fix Forum Totals
Fix Thread Totals
Fix Member Posts
Fix Last Posts
Merge Threads
Viewthread (new modlog feature)

Issue History

Date Modified Username Field Change
2008-11-30 17:17 miqrogroove New Issue
2008-11-30 17:17 miqrogroove Original Reporter => Loveriot
2008-11-30 17:52 miqrogroove Status new => assigned
2008-11-30 17:52 miqrogroove Assigned To => miqrogroove
2008-11-30 18:22 miqrogroove Note Added: 0000093
2008-12-01 17:17 miqrogroove SVN Revision => 1423
2008-12-01 17:17 miqrogroove Status assigned => resolved
2008-12-01 17:17 miqrogroove Fixed in Version => 1.9.11
2008-12-01 17:17 miqrogroove Resolution open => fixed
2008-12-05 12:59 miqrogroove Relationship added related to 0000148
2008-12-05 13:00 miqrogroove Relationship added related to 0000004
2008-12-07 21:41 miqrogroove Status resolved => closed