Installation: 6.1 install fails using Mysql 5.5.9
- Status
- Closed
- Subject
- Installation: 6.1 install fails using Mysql 5.5.9
- Version
- 6.x
- Category
- Error
- Feature
- Installer (profiles, upgrades and server-related issues)
- Resolution status
- Invalid
- Submitted by
- ravas
- Lastmod by
- Ushindi Gedeon
- Rating
- Description
Three queries fail during the installation of version 6.1 when using Mysql 5.5.9 because the deprecated syntax timestamp(14) has been removed and should now be timestamp.
The queries that fail are the table creation queries for tiki_banning, tiki_friendship_requests, and tiki_users_score.
This is essentially a duplicate of Ticket ID 2213 except to clearly note the solution and that it affects TikiWiki 6.1 and Mysql version 5.5.9.
- Solution
- Change the table create queries for tiki_banning, tiki_friendship_requests, and tiki_users_score to remove (14) after the timestamp column types.
- Workaround
- Copy the queries from the error message and manually run them against the database after replacing timestamp(14) with timestamp
- Priority
- 25
- 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
- 3798
- Created
- Friday 18 February, 2011 20:12:29 UTC
by ravas - LastModif
- Tuesday 30 June, 2026 15:44:26 UTC