Error in upgrade script (function upgrade_20120429_fix_collation_tiki)
- Status
- Open
- 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
- New
- Submitted by
- samandiriel
- Lastmod by
- samandiriel
- 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=- Importance
- 10 high
- Easy to solve?
- 10 easy
- Priority
- 99
- Demonstrate Bug (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
- Ticket ID
- 5103
- Created
- Friday 17 January, 2014 21:55:07 GMT-0000
by samandiriel - LastModif
- Friday 17 January, 2014 23:24:33 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- Threaded comment listing sort order
- fresh opening of tiki home page tiki-index (I removed a warning) is it OK
- Tracker with field type "Numeric" won't
- tiki 25.1 Database 'xxxx'. Unable to connect to database (when 25.0 will connect)
- Kanban plugin; the Swimlane field throw an error if using a category field type
;){kind=link}
;){kind=link}