Error in upgrade script (function upgrade_20120429_fix_collation_tiki)
- Status
- Closed
- Subject
- Error in upgrade script (function upgrade_20120429_fix_collation_tiki)
- Version
- 12.x
- Category
- Error
- Feature
- Installer (profiles, upgrades and server-related issues)
- Resolution status
- Invalid
- Submitted by
- samandiriel
- Lastmod by
- Ushindi Gedeon
- Rating
- Description
File installer/schema/20120429_fix_collation_tiki.php contains an error on line 20:
- if ( $results= $installer->fetchAll('SELECT DISTINCT(TABLE_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ?', $dbs_tiki)
If the DB name has a character in it such as a dash, this returns FALSE and the script (incorrectly) reports that the MySQL version is too old.I just hardcoded my DB name into the query, but the following code patch should work:
- if ( $results= $installer->fetchAll("SELECT DISTINCT(TABLE_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '$dbs_tiki'")
This problem has burned at least one other person, as can be seen on the forum: http://tiki.org/tiki-view_forum_thread.php?forumId=6&threadId=50478&comzone=show&display=&fullscreen=&PHPSESSID=- if ( $results= $installer->fetchAll('SELECT DISTINCT(TABLE_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ?', $dbs_tiki)
- Solution
- Workaround
- Importance
- 10 high
- Easy to solve?
- 10 easy
- Priority
- 99
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 5103
- Reviewed by Wishlist Team On
- 17 Apr 26 14:57 UTC
- Created
- Friday 17 January, 2014 21:55:07 UTC
by samandiriel - LastModif
- Friday 17 April, 2026 14:57:20 UTC