126

(1 replies, posted in Problems)

Hi Stefan,
You are absolutely right, this is something to be fixed wink
This is the fix::
Edit the file "common/vfunctions.php and change line 29 from . . .

if (($evt['sti'] == '' and $evt['eti'] == '') or $evt['ald']) { //all day (takes up 1 slot at the top)

to . . .

if ($evt['ntm'] or $evt['ald']) { //no time or all day (takes up 1 slot at the top)

Thanks again for reporting this problem.
Roel

127

(2 replies, posted in Problems)

Hi Stefan,
No, it's not just you! This is a bug.
To solve this problem, edit the file "common/dtpicker.js" and change line 184 from . . .

var tpDiv = $I("tpDiv");

to . . .

var tpDiv = $I("tPicker");

This problem will of course be solved in the next calendar version.
Thanks for reporting this problem! You are an excellent calendar tester smile
Roel

Hi Doss,

This known problem, occurring as of PHP 8.1, will be solved in the next calendar version, which is planned for end of May.
In the mean time you could apply the following fix:
Edit the file "common/retrieve.php" and replace line 202 . . .

if (strpos($row['xda'], $curD) !== false) { continue; } //exception: skip

by . . .

if (strpos($row['xda'] ?? "", $curD) !== false) { continue; } //exception: skip

(In other words: add ?? "" after $row['xda']).

Roel

When upgrading a calendar with a MySQL database to LuxCal 5.2.0, the following error can occur: SQL transaction error: There is no active transaction. Query: commit transaction.

This problem can be solved by editing the calendar file "pages/toolboxx.php" and moving line 672 . . .

dbTransaction('begin');

to line 885 (so just before the line with text "//drop original tables and rename new upgraded tables".

Roel

130

(12 replies, posted in Problems)

Hi there,
I've almost completed a more elegant solution, however, the code changes are so complicated that  I've decided to drop it all.
The point is that by adding just an indicator "user must select a subcategory" to the categories table in the DB everything would be extremely simple. So I think it is much better to put this change on our "todo" list for the next calendar release with a DB schema change.

I assume Stefan, that you can live with the "temporary solution" in my first reply above wink

Roel

131

(12 replies, posted in Problems)

Hi there,
You are right, this could be confusing. I think my current 'solution' is not the best solution.
I'm working on a more elegant solution.
Once this new solution is ready, I will sent you some changed files.
Roel

132

(12 replies, posted in Problems)

I've done the following:
When editing an event category, if the admin adds a subcategory with the name "-" (hyphen), it will result in "None" (no subcategory) in the subcategory drop-down menu in the Add/Edit Event window. So in other words: If the admin has added a subcategory with name "-", the user will be able to select "no subcategory" and otherwise the user will have to select a subcategory.

Stefan, I will send you an updated file eventfrom1.php by email.
Let me know if this works for you please.

Roel

133

(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

134

(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

135

(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

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

137

(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

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

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

140

(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

141

(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

142

(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

143

(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

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

145

(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

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

147

(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

148

(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

149

(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

150

(2 replies, posted in Suggestions)

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

Roel