126 Reply by Roel

(12 replies, posted in Problems)

If we want this to be optional per event category, the selection needs to be stored in the categories table in the DB.
I'm not very keen on changing the DB schema only for this purpose.
If in the help for subcats (see Stefan's first post) I change the text from . . .

If, when adding/editing and event, no subcategory has been selected, the event will have the normal category colors in the various views.

to . . .

If, when adding/editing and event, subcategories are available, then a subcategory must be selected.

and leave the code unchanged, the problem is solved wink

Do you agree?

Roel

Go to forum: Problems

127 Reply by Roel

(12 replies, posted in Problems)

Hi Stefan,
You are right, good point!
I will add the option "None" to the subcategory drop-down menu.

Temporary solution:
Edit the file "pages/eventform1.php" and change line 32 to:

echo $options ? "<option value='0'>None</option>\n".$options : "<script>showX('scMenu',0)</script>\n";

Roel

Go to forum: Problems

128 Reply by Roel

(7 replies, posted in Problems)

Hi there,

I was able to reproduce this problem and believe it's occurring when the MySQL database has as default set AUTOCOMMIT = 1.
The solution for this problem can be found under the topic Known Issues and Fixes.

Roel

Go to forum: Problems

129 Reply by Roel

(9 replies, posted in Problems)

Hi Jan,

No this project is not open source. But suggestions for improvements or fixes are always welcome. We will validate all suggestions and adopt them, if they are good.

For example the null coalescing operator (??) in your post above is a very good solution, but we cannot adopt it (yet) for the LuxCal calendar because it was introduced in PHP 7 and not all calendar users are running the calendar with PHP 7 or 8.

Roel

Go to forum: Problems

130 Reply by Roel

(3 replies, posted in Problems)

You've done the right thing Jan! The X tables are temporary tables and will normally be dropped at the end of the upgrade process.

Roel

Go to forum: Problems

131 Reply by Roel

(9 replies, posted in Problems)

Hi Jan,

Yes, you are right and that is what I expected. I will fix this in a new calendar version. In the mean time i will see if I can create a work around and post the result in the forum under Known Issues and Fixes.

Roel

Go to forum: Problems

132 Reply by Roel

(9 replies, posted in Problems)

Hi Mark,

The strpos() function is one of the most common string search functions in PHP and in the PHP reference manual which is up-to-date with PHP 8 it is NOT indicated as deprecated. Currently in the PHP 8 reference manual it is advised to use the strpos() function for simple text searches.
So don't worry.
If it is really deprecated, I'm sure it will take at least take a few years before it will be completely dropped. Once it is 100% sure this function is deprecated, I will take care that in a next LuxCal release this function will be replaced by a replacement function.

Roel

Go to forum: Problems

133 Reply by Roel

(7 replies, posted in Problems)

Hi there,

Have you applied the fix which you can find in this forum under Known Issues and Fixes (the last one)?

https://www.luxsoft.eu/lcforum/viewtopi … 1575#p1575

Roel

Go to forum: Problems

134 Reply by Roel

(1 replies, posted in Problems)

Hi Bert,

We need to know what calendar version you are using. You can find the version at the top of the Settings page, or you can send me the link to your calendar (via the Contact Us page).

Roel

Go to forum: Problems

135 Reply by Roel

(1 replies, posted in Problems)

Hi there,

It looks like the calendar folder has not the right permissions, but I need more info to be able to reply in more detail.
Could you send me the web address of your calendar. If you prefer, you can send it to me via the Contact Us page.

Roel

Go to forum: Problems

136 Reply by Roel

(1 replies, posted in Problems)

Hi there,
No it's not possible to hide the Venue field, but what maybe could help to make things simpler is the following:
On the Settings page, in the section Views you can check the "Reduced event window" box and select Save settings.
Once you've done this, the lower part of the Add/Edit Event window will initially be hidden. If you need the lower part, you can click the "down arrow".
Roel

Go to forum: Problems

137 Topic by Roel

(0 replies, posted in Known Issues and Fixes)

When upgrading to calendar V5.2 or when restoring a databse backup file via the Database page, depending on the MySQL database configuration, the following SQL error message may occur:

SQL query error: SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DOUBLE value: ''
Query string: UPDATE `mycal_settingsX` SET `value` = '' WHERE (`name` = 'spMiniCal' OR `name` = 'spImages' OR `name` = 'spInfoArea') AND `value` = 0

This can be solved by editing the file "common/toolboxx.php" and on line 877 and 878 enclosing the values 0 and 1 in single quotes. In other words, change . . .

AND `value` = 0");

to . . .

AND `value` = '0'");

and change . . .

AND `value` = 1");

to . . .

AND `value` = '1'");

Roel

Go to forum: Known Issues and Fixes

138 Reply by Roel

(3 replies, posted in Problems)

Hi Stefan,
Thank you very much for digging into this problem. I've changed this in the toolboxx.php file.
I will also add the solution to the "Known Issues" section of the forum.

(The SQL error message "Invalid datetime format" is very misleading, since there is no datetime involved.)
Roel

Go to forum: Problems

139 Reply by Roel

(1 replies, posted in Suggestions)

Hello Karl-Heinz,
A new script would be needed for this, which directly converts .ics events into LuxCal events and add them to the database.
I will keep this in mind for a new calendar version.

Cheers, Roel

Go to forum: Suggestions

140 Reply by Roel

(3 replies, posted in Problems)

Hi Stefan,
This problem has been reported twice before and so far I could not reproduce it and solve it.
For the other users it appeared that the problem occurred when they migrated to PHP 8.
And when they went back to PHP 7 the problem disappeared.

On the web I saw that many other people with different applications are having this same problem.

Are you using PHP 8? and if so, could you go back to PHP 7.4 and try the Restore again? and let us know your findings.
Roel

Go to forum: Problems

141 Reply by Roel

(3 replies, posted in Problems)

Hi Mustafa,
You should create a cron job on your server (in cPanel) which runs daily early in the morning (for example at 3:00) and which starts the lcalcron.php script in the calendar root.
Thereafter email reminders should work. Of course you will have to specify in the Event window that a reminder should be sent  x days before the event date.

Note: open the file lcalcron.php in your editor and have a look at the description at the top of the file.

Roel

Go to forum: Problems

142 Reply by Roel

(2 replies, posted in Problems)

Hi Frederick,
That depends . . .
If all events are private events, as is probably the case in your calendar, this could be done. But if not, a user might be interested to search for a specific topic posted by a manager or by the administrator. So in the latter case, the User Group drop-down menu will be needed.

Roel

Go to forum: Problems

143 Reply by Roel

(2 replies, posted in Suggestions)

Hi there,
Sorry, this time I will have to disappoint you - no this is not possible sad

Roel

Go to forum: Suggestions

144 Reply by Roel

(2 replies, posted in Need Help)

Hi there,
Yes, that's possible.
Go to the Settings page and in the section "Views" hover over "Weeks to show in Month view" (5th from the top) and have a look at the last two lines of the pop-up info.

Roel

Go to forum: Need Help

145 Reply by Roel

(2 replies, posted in Need Help)

Hi there,
This can be done via the Settings.
Open the Settings page and in the section Events set "Posting of private events" to "always". Press save settings and you're done.
Roel

Go to forum: Need Help

146 Reply by Roel

(2 replies, posted in What's New)

Hi Stefan,
We're considering to add an option to the calendar to send reminder messages via a messenger. In this case the field msingID will be the ID of the sender.
I would prefer to use WhatsApp, but it has no free API, but for instance Telegram has a simple API and is free.

Roel

Go to forum: What's New

147 Reply by Roel

(7 replies, posted in Need Help)

Forget sending SMSes; send emails.
If there is enough interest, at some point we may add the possibility to send Telegram messages from the calendar. Telegram is open source and has a good API. This would be much better, more flexible and free.

Roel

Go to forum: Need Help

148 Reply by Roel

(4 replies, posted in Need Help)

Hi Stellan,
Yes correct, line 232.
You can turn the downside into an upside by editing the file common/toolbox.js and on line 254 change '40px' to '20px' wink
Roel

Go to forum: Need Help

149 Reply by Roel

(4 replies, posted in Need Help)

Hi there,
There is no setting for this.
If you want, I can give you a simple software change to hide the "User Profile" option.
After all, the admin can access all user profiles through the calendar's Users page.

Let me know if you want this.

Roel

Go to forum: Need Help

150 Reply by Roel

(2 replies, posted in Problems)

Great John,
Thanks for letting us know!
Roel

Go to forum: Problems