mysql server operating in a strict mode

Posted on 2009-04-21
Last Modified: 2012-05-06
I am trying to run this applicaiton eecore/expressengine and it says that "ExpressionEngine will not run on a MySQL server operating in strict mode"

Can you assist me in changing the mysql mode or what ever I have to do to be able to run expressengine

Question by:joedubois
    LVL 21

    Accepted Solution

    Check your my.cnf for sql_mode variable value.
    You may set it to null and reload.

    Or Through mysql prompt: SET @@global.sql_mode= '';
    LVL 21

    Expert Comment


    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
    More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now