• Registered: 2019-06-11
  • Posts: 2

Topic: INSERTS with Strict mode

Hi Roel!

I am running LuxCal 4.2.2M.
My website has been moved to a new infra structure with "Strict SQL Mode".
This prevents INSERT INTO sending empty strings, resulting in error:
[ calendar/index.php - SQL execute error: SQLSTATE[HY000]: General error: 1364 Field 'editor' doesn't have a default value ]
And there is my problem. I cannot input new events into the calendar.

Is there (hopefully) an easy fix to this?
If not - and an upgrade is necessary - does version 4.7.5M handles this "strict mode" correctly?

Kind regards from a previous translator of your calendar smile

Quote Post 1

  • Roel
  • Roel
  • Administrator
  • Offline
  • Registered: 2018-02-26
  • Posts: 565

Re: INSERTS with Strict mode

Hi Scunder,

Last week there was a calendar user with exactly the same problem and the good news is that I know how to solve it wink
There are two possibilities:
1) You upgrade to the latest version + this fix. This is a version I can send you (if you send me your email address).
2) You go to your server and use phpMyAdmin and in all tables of the calendar database change all fields which are set to "default Not null" and have no default value to "default Null". Altogether this has to be done 17X (sigh).

If you want to upgrade, which I of course recommend, let me know your email address and I will send you the latest calendar version with the "SQL strict" fix and instructions how to do this.

I of course would not mind if at the same time you translate the new texts in the language files of the upgraded calendar smile

Roel

Quote Post 2

  • Registered: 2019-06-11
  • Posts: 2

Re: INSERTS with Strict mode

Thanks Roel for the quick response.
Actually, I was working on a solution while you posted the two alternatives, and had already found a third possibility:

In event.php there is two occurences of INSERT INTO.
I just changed that into INSERT IGNORE INTO.
The error transforms into a warning that does not show, and it works. So I think I will stick with that for the time being. That being said, I won't mind doing some more translating for you. If you do not have my email address that I registered with, I will send it to you.

/Christer smile

Quote Post 3