Error 1067
Permalink
Dear All,
I am new to the PHP and concrete5 as well. While installing concrete5 with WAMP i am having the following error. Can somebody help me with this
mysqli error: [1067: Invalid default value for 'entryDate'] in EXECUTE("CREATE TABLE btGuestBookEntries ( bID INTEGER, cID INTEGER DEFAULT 1, entryID INTEGER NOT NULL AUTO_INCREMENT, uID INTEGER DEFAULT 0, commentText LONGTEXT, user_name VARCHAR(100), user_email VARCHAR(100), entryDate DATETIME DEFAULT '0000-00-00 00:00:00', approved INTEGER DEFAULT 1, PRIMARY KEY (entryID) )")
Thanks in advance
I am new to the PHP and concrete5 as well. While installing concrete5 with WAMP i am having the following error. Can somebody help me with this
mysqli error: [1067: Invalid default value for 'entryDate'] in EXECUTE("CREATE TABLE btGuestBookEntries ( bID INTEGER, cID INTEGER DEFAULT 1, entryID INTEGER NOT NULL AUTO_INCREMENT, uID INTEGER DEFAULT 0, commentText LONGTEXT, user_name VARCHAR(100), user_email VARCHAR(100), entryDate DATETIME DEFAULT '0000-00-00 00:00:00', approved INTEGER DEFAULT 1, PRIMARY KEY (entryID) )")
Thanks in advance
Could be a case (capitalisation) issue. Use phpMyAdmin or equivalent to look into the concrete5 database and see whether the table and column names are camelCased as they are in the error message. If they aren't, that's probably the problem. There are a few possible fixes, but check first.
Hello Gondwana,
Thank you for your quick support. But I have all the tables in small case. Should I remove the complete database and load it again?
Thank you for your quick support. But I have all the tables in small case. Should I remove the complete database and load it again?
On its own, I don't think that would help you. My guess is that the MySQL environment needs to be configured to honour the capitalisation required. I had to add "lower_case_table_names = 2" in my.ini before attempting c5 installation—but that was using XAMPP. See previous discussions at
https://www.concrete5.org/community/forums/installation/moving-site-...
and
https://www.concrete5.org/community/forums/5-7-discussion/database-e...
and maybe elsewhere.
https://www.concrete5.org/community/forums/installation/moving-site-...
and
https://www.concrete5.org/community/forums/5-7-discussion/database-e...
and maybe elsewhere.
I have tried both, reinstalltion and suggestions from discussion. I have also tried to edit the db file (from confi.) But I am still getting the same error.
Do you have any other suggetion or workaround to solve this?
However, thanks a lot for your suggestion. Really appreciated.
Do you have any other suggetion or workaround to solve this?
However, thanks a lot for your suggestion. Really appreciated.
I should try this one.
https://www.concrete5.org/community/forums/installation/some_tables_...
https://www.concrete5.org/community/forums/installation/some_tables_...
