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

Topic: SQL error in LuxCal 4.6.0 download before 2018-02-20 10:00

Unfortunately there was an issue with LuxCal 4.6.0 downloaded before 2018-02-20 10:00.
When adding a new user group, an SQL error occurred.
If you encounter this problem, you should download the current luxcal460X.zip file, unzip the luxcal460X-calendar.zip and upload the file pages/groups.php to the pages folder of your calendar installation on your server.

You can also fix the problem by editing the file pages/groups.php in the calendar installation on your server and change line 198 from . . .

$stH = stPrep("INSERT INTO `groups` (`name`,`privs`,`vCatIDs`,`eCatIDs`,`upload`,`sendSms`,`rEvents`,`mEvents`,`pEvents`,`color`) VALUES (?,?,?,?,?,?,?,?,?)");

to . . .

$stH = stPrep("INSERT INTO `groups` (`name`,`privs`,`vCatIDs`,`eCatIDs`,`upload`,`sendSms`,`rEvents`,`mEvents`,`pEvents`,`color`) VALUES (?,?,?,?,?,?,?,?,?,?)");

(to the series of ',?', one ',?' was added).

Quote Post 1

2 Reply by ubaTaeCJ

  • ubaTaeCJ
  • Guest

Re: SQL error in LuxCal 4.6.0 download before 2018-02-20 10:00

highlow wrote:

Hi,

A strange problem here.
I have 2 calendars, both updated recently to 5.3.2M.
In one of them the date format in the reminder emails can't be set to "d.m.y" when an end date is set.

It shows like this in the reminder email:
Datum / Zeit:    09.06.2025 - 25..2.10.0

The start date ist correct, only the end date is affected (it should be 10.06.2025).

In my other calendar it works correctly.

Any ideas?

Best regards
highlow

Quote Post 2