|
Search:     Advanced search
Browse by category:
Glossary

How to turn off MySQL Strict Mode

Add comment
Votes: 0
Comments: 0
Posted: 22 Mar, 2008
by: Pope L.
Updated: 02 Aug, 2008
by: Pope L.
By default, MySQL is enabled with strict_mode ON.
Mambo currently does not fully support MySQL5.x in strict_mode (this is on the roadmap and will be dealt with when we move to database portability so Mambo will run on other database servers, not just MySQL).

So, for now, strict_mode needs to be turned off.
This can be done in two ways...

Open your "my.ini" file within the MySQL installation directory, and look for the text "sql-mode".
Find:
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Replace with:
# Set the SQL mode to strict
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Or, you can run an SQL query within your database management tool, such as phpMyAdmin:

SET @@global.sql_mode= '';
If you have any questions about this, just post on the Mambo forums.
Others in this Category
document What is the .htaccess file?
document How to make a strong password.
document What is FTP? How do I use it?
document What is Fantastico?
document What are Domain Names?
document What's the difference between an URL and a Domain Name?
document What are IP addresses?
document What is a Subdomain?
document 20 ways to Secure your Apache Configuration
document Guide to .htaccess
document How to find your version of PHP & other useful information
document session save path issues
document Changing/Creating your own favicon
document How to determine Absolute Path

RSS