Official 1.9.11 patch build #11 released to fix MySQL 5.5 compatibility and to provide a new upgrade system.
- 0000438: [Bugs] Inconsistent Spacing in Post Preview (miqrogroove) - resolved.
- 0000434: [Bugs] New Token System Needed (miqrogroove) - resolved.
- 0000437: [Bugs] Invalid Casing of "Name" Attribute in viewthread_modoptions (miqrogroove) - resolved.
- 0000436: [Bugs] Wrong Field Name in Prune Form (miqrogroove) - resolved.
- 0000407: [Bugs] String Updates 2010 -> 2011 (miqrogroove) - resolved.
- 0000410: [Bugs] Member Profile Code Needs to be Optimized (miqrogroove) - resolved.
- 0000429: [Bugs] Review use of stripslashes (miqrogroove) - resolved.
- 0000323: [New Features] Thumbnails for BMP Images (miqrogroove) - resolved.
- 0000417: [Meta] Get Rid of the Legacy Upgrader (miqrogroove) - resolved.
-- 0000433: [Bugs] MySQL 4.x SHOW Syntax Has No WHERE Condition (miqrogroove) - resolved.
-- 0000419: [New Features] Full XMB 1.8 Upgrade Compatibility (miqrogroove) - resolved.
-- 0000418: [New Features] Full XMB 1.9.x Upgrade Compatibility (miqrogroove) - resolved.
-- 0000413: [Bugs] fixBirthdays() Does Not Work (miqrogroove) - resolved.
-- 0000292: [New Features] Shell Upgrader (miqrogroove) - resolved.
- 0000408: [Bugs] MySQL 5.5 Compatibility (miqrogroove) - resolved.
-- 0000427: [Bugs] ALTER TABLE Failure in MySQL 5.5 (miqrogroove) - resolved.
-- 0000426: [Bugs] Strange db.php Errors When Posting Replies (miqrogroove) - resolved.
- 0000432: [Bugs] Cursor moves when Firefox inserts smilies (miqrogroove) - resolved.
- 0000401: [Bugs] Image w/Wrong Extension Has No Thumbnail (miqrogroove) - resolved.
- 0000431: [Bugs] Fatal Error When FreeType is Missing (miqrogroove) - resolved.
- 0000428: [New Features] Add Description for UPLOAD_ERR_NO_TMP_DIR (miqrogroove) - resolved.
- 0000415: [Bugs] Zero Columns of Smilies? (miqrogroove) - resolved.
- 0000403: [Bugs] Reply button title missing (miqrogroove) - resolved.
- 0000423: [Bugs] Quote Button Missing on Closed Threads (miqrogroove) - resolved.
- 0000425: [Bugs] Guests Should Not Have Subscription Privileges (miqrogroove) - resolved.
- 0000402: [Bugs] Captcha Size Settings Don't Work (miqrogroove) - resolved.
- 0000424: [Bugs] Allow CAPTCHA and DEBUG Together (miqrogroove) - resolved.
- 0000416: [Bugs] Threads Table Optimization (miqrogroove) - resolved.
- 0000414: [Bugs] Language Upload Errors Should be Clearer (miqrogroove) - resolved.
- 0000420: [Bugs] $action == 'printable' Memory Exhaustion (miqrogroove) - resolved.
- 0000411: [Bugs] $wollocation Should be Truncated Before Query (miqrogroove) - resolved.
- 0000406: [Bugs] No Warning if You Rename Yourself (miqrogroove) - resolved.
- 0000404: [Bugs] Entity References Broken in Profiles (miqrogroove) - resolved.
Bug Source: Various
Symptoms: Unable to install using MySQL 5.5, unable to correctly upgrade XMB 1.8, MySQL warnings and notices not logged in debug
mode, memory exhaustion errors caused by long threads in printable view, foreign characters not displayed correctly in member profiles on English-only
boards.
Security Impact: Medium. This patch adds new token system functions to protect staff accounts.
Fixed By: XMB-1.9.11.11.zip and later are not affected.
Schema Change: To take advantage of the performance optimizations offered by this patch, you will need to carry out this optional
step in the "Insert Raw SQL" panel of your board.
Code:
ALTER TABLE $table_threads DROP INDEX fid, ADD INDEX forum_optimize (fid, topped, lastpost);
ALTER TABLE $table_posts DROP INDEX tid, ADD INDEX thread_optimize (tid, dateline, pid);
