Skip to forum content
LuxCal Web Calendar
The place for news, questions and suggestions
You are not logged in. Please login or register.
Active topics Unanswered topics
Post new reply
Post new reply
Compose and post your new reply
You may use: BBCode Images Smilies
All fields with bold label must be completed before the form is submitted.
Topic review (newest first)
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 
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 
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
Roel
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