Attempting to install 'Expression Engine' on a MS Windows (IIS) server, using a mySQL 5 database.
Getting the warning from the installer wizard, as I see many others have run into, " ExpressionEngine will not run on a MySQL server operating in strict mode"
The easy fix is editing the my.ini file, or passing in a global command to turn off strict mode globally, but in this case I do not want to alter the strict mode of my other sites on the same server.
Q: Is there any way to disable strict mode just for this database?
I have seen where i can do it per session, but the mySQL code is coming from the setup process, and I'd have to edit the EE setup files. Turning strict mode off for just this database would be a lot easier!
Alternately, i am open to any suggestions that allow us to get around this 'must not be in strict mode' issue. Surprised EE doesn't have a fix available... if it does, I haven't found it (that will be a great answer to this question as well!)
As a side note, why won't it play nicely with Strict mode? Does it depend on some null values being passed in as keys, or some other easily-remedied-in-the-pro
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
@psycle - thanks, this is just what I've seen so far. Thing is the EE script is all part of the setup wizard and related files. Maybe we can edit that ourselves to include this "SET sql_mode" line first?
I didn't find an ExpressionEngine category on EE but wonder if anybody here has experience with this issue directly.
Seems like it would pop up on just about any shared hosting environment with mySQL 5, unless global 'strict' mode is not commonly used.
strict mode is very uncommon in shared environments where tech support wishes to keep calls to a minimum. Most MySQL users are used to the relaxed mode that MySQL has always had since its beginnings in the late 90's.
I'm afraid the only option I see is to either disable strict mode on the server configuration file or issue "SET sql_mode..." with every new connection the application makes.
The only downside is that Oracle folks and ANSI SQL standard weenies would gripe. :-) Other than that, I think you'll find that the existing code that you have will work as expected while the stuff that doesn't work will start working.
The manual for sql modes is actually not a bad read: http://dev.mysql.com/doc/r
Best of luck
Business Accounts
Answer for Membership
by: psyclePosted on 2009-06-26 at 14:27:48ID: 24724856
sql mode is global - server-side.
You can change it per session like so:
SET sql_mode = '';
The downside to that is that you must do it every time you make a new connection.