1

Firstable, I´m designer, hence my ignorance. It´s been awhile since I didn´t updated a site. The client asked me to make a new member in EE. I´ve been able always to do that on the spot, but this time I always get the SQL error of the email subject (1364). After some researching, I tried to publish some entry and I got the same SQL error.

Then i found this post here Database Error 1364 in Solspace Calendar

The point is that i´m not sure if I have to adding a default value (0) to all the tables or there is a way to do that for the whole site.

Thank you in advance

1 Answer 1

0

Hmm, I had this error on a site recently and I fixed it by removing strict mode from MySQL.

https://stackoverflow.com/questions/37964325/how-to-find-and-disable-mysql-strict-mode

^ That has some information on the matter. I'm not sure what your current setup is but the update is fairly standard. Find the cnf file, remove "STRICT_TRANS_TABLES" from the string and save, then restart MySQL.

8
  • I tried to turn strict mode off in phpmyadmin, but I get the Error Number: 1227. Description: Access denied; you need (at least one of) the SUPER privilege(s) for this operation. And I can´t see users or privileges in the phpmyadmin tabs, so I guess I´ll have to contact with my hosting provider, right? Thank you Apr 11, 2018 at 16:01
  • Hmm, this does change things a bit. I've had issues with shared hosting locking me out of this too. Depending on what they say you may want to look back into the adding a default zero for the tables. Apr 11, 2018 at 17:25
  • They said that I can't modify globally the server.I have to do that with php. The sent me this example Apr 12, 2018 at 18:18
  • <?php $mysqli = mysqli_init(); if (!$mysqli) { die('mysqli_init failed');} if (!$mysqli->options(MYSQLI_INIT_COMMAND, "set session sql_mode = 'NO_ENGINE_SUBSTITUTION'")) { die('Setting MYSQLI_INIT_COMMAND failed');} if (!$mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 5)) { die('Setting MYSQLI_OPT_CONNECT_TIMEOUT failed');} if (!$mysqli->real_connect('localhost', 'my_user', 'my_password', 'my_db')) { die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());} echo 'Success... ' . $mysqli->host_info . "\n"; $mysqli->close(); ?> Apr 12, 2018 at 18:20
  • But not quite sure how to implement this code. Some clue would be really appreciated. Thanks a lot Apr 12, 2018 at 18:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.