|
Enable MySQL 5 Support For Joomla |
|
|
|
Tutorials / FAQs -
Joomla
|
|
I started using MySQL 5, and was unable to save any new data in Joomla. For a long time I thought this was a problem with my installation. but eventually I found that it was an incompatibility with MySQL 5. The upcoming version of Joomla addresses the compatibility issues, but I didn't want to wait that long. It turns out that disabling strict SQL mode in the MySQL configuration solved my problem. Simply open your "my.ini" file within the MySQL installation directory, and look for the text "sql-mode"
Original Entry:
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
New Entry:
# Set the SQL mode to strict
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
|
