Hi there,

The way events are stored and retrieved from the database has not changed since very long. So if you could retrieve an event from the database in a past LuxCal version, it should be possible now.
But to answer your "If so, how?" question, I need much more details of what you exactly want to do, like . . .
- Are you using the MySQL or SQLite version of the calendar?
- What kind of program "outside of LuxCal"? An existing external application, or a PHP script produced by you, or something else?
- What do you exactly mean by "to open events to edit"?

Roel

352

(4 replies, posted in Problems)

Hi Riaan,

Have you tried to refresh the calendar page (Ctrl-F5)?
If so, on the Settings, in the section Views,  try to delete the Map viewer URL. Often mod_security on Apache servers doesn't like URLs in web forms.
If this solves the problem, please let me know and then I will give you a hint on how to solve this.

Roel

Most "displays" have the following setting in the GENERAL SETTINGS section:

$evtWin = 1; //on click open event window (0: no, 1: yes). If the user has post rights, the event add/edit window will open, otherwise the event report window will open

In LuxCal v4.7.5, when in the display $evtWin is set to '1', clicking events does not result in opening the Event window.
This is caused by a JavaScript error in the toolbox.js file.
To solve this problem, edit the file 'common/toolbox.js' and replace line 128 . . .

pars.cal1x = calID;

by . . .

if (typeof calID !== 'undefined') { pars.cal1x = calID; } //if defined, use calID; but don't store in session

Roel

354

(11 replies, posted in Problems)

Hi Greg,

I think it's a matter of clearing the browser cache and maybe deleting some old cookies after a V7.4.5 installation.

I'll make you an offer:
Export your current v4.7.3 database to a .sql file (with phpMyAdmin), send me the file and I will upgrade it for you. Thereafter you can import the upgraded .sql file in your second new installation and then together we will make it work, without PHP Session Expired messages.

Deal?
wink
Roel

355

(2 replies, posted in Need Help)

Hi Marc,

I think that 82 items could be too much to import in one go. Try splitting the .ics file in two parts and import both parts separately.

If this doesn't work, could you please send me the .ics file via email (via the Contact Us page), so that I can analyze the problem.

Roel

Thanks Dan,

We have been discussing to add a registration option to the events since quite some time already, but so far I could not find the time and energy to start coding
Maybe later this year. I had a look at the link you posted and the OperSource Registration script  looks inspiring wink

Roel

Hi Dan,

Yes, I agree. This is rather serious and should be cured as soon as possible.

Hi Minne,

Please send me your email address as soon as possible (via the Contact Us page).

Regards,
Roel

Hi Minne,

Please don't post all that information in a forum. It's sensitive data which can be misused by malicious forum visitors. It's a wild world out here wink
You should always sent this kind of data by email just to me.
I removed the sensitive part and kept a copy for myself to further analyze the problem.

Roel

Phpdummy,

I don't know if you are the same as cpcnw (first post), but send me your email address (via the Contact Us page) and I will send you a small script to test your PHP sessions.

Roel

360

(1 replies, posted in Need Help)

Thanks Jim,

2. Installation guide updated.
3a. On which pages is this happening? This could happen if PHP displays a Notice or Warning message.
3b. It's impossible to print which pages? And where can I find that Firefox article.
4. Elections in two years time. Everything will be file thereafter wink

Regards,
Roel

Hi Minne,

A couple of questions . . .
Did you install the latest calendar version 4.7.5 from the LuxSoft site? MySQL or SQLite version?
Did you follow the instructions when installing the calendar? You unzipped the calendar file and uploaded all files and folders to a web-accessible folder on your server?
And did thereafter the installation window open? And did the installation run successfully?
If that all went fine, could you please send me the URL of your calendar (via the Contact Us page).

Roel

Yes, please do so. Could you create a temporary account with admin rights for me in your calendar?

Roel

Hi Patp,

For version 4.7.5: Have you tried refreshing the calendar with Ctrl-F5 on your computer and "reload" on your mobile.

Concerning the error messages for version 4..1 it looks like V4.7.5 and V 4.6.1 are mixed up a bit. In v4.6.1 go to the Settings page and click the "Save Settings" button.

I have the feeling is's all related to the browser history.

Roel

Jonathan don't panic, I will help!

Upgrade to v4.7.5! (not 4.7.4) and thereafter start the calendar and refresh the calendar page (Ctrl-F5).
If thereafter you still have problem, we will help you solve them!

Roel

365

(3 replies, posted in Problems)

Concerning the spam filter: I will let you know by email.

Roel

366

(3 replies, posted in Problems)

Hi Fred,

Was your .sql backup file from LuxCal 4.7.1 or later? I had a look at your calendar and did not see any problem. You wrote that you uploaded the .sql backup file and all seemed normal, When I looked however, the calendar was empty. Did you deleted all events?
Have you tried refreshing the calendar page (Ctrl-F5)?

Roel

367

(5 replies, posted in Problems)

Hi Laur and Schwartz,

Yes,this is a bug. To solve this problem, edit the file "views/month.php" and replace line 22 . . .

$cBoxAtt = $mayCheck ? "class='chkBox floatL point' onclick=\"checkE(this,{$evt['eid']},'{$date}',{$usr['ID']});\"" : 'class="chkBox floatL arrow"';

by . . .

$cBoxAtt = $mayCheck ? "class='chkBox floatL point' onclick=\"checkE(this,{$evt['eid']},'{$date}',{$usr['ID']}); event.stopPropagation();\"" : 'class="chkBox floatL arrow"';

In other words: directly after "{$usr['ID']});" add " event.stopPropagation();"

Roel

368

(5 replies, posted in Problems)

Hi there,

It looks like there is a PHP warning message at the top of your calendar which pushes down the calendar heading.
Have you tried refreshing the calendar page (Ctrl F5) and try opening the UI Styling page (in the side menu) and select once the "Save Theme" button.

Roel

369

(9 replies, posted in Problems)

It's just a question of using the right magic wand wink

Roel

We've implemented a few improvements for the mini calendar (display0):

  • The left and right arrows in the calendar header now stay at a fixed location when browsing through the months; so they don't jump anymore depending on the length of the month name.

  • The click-sensitive area of the arrows has been widened, so that it is easier to browse through the months.

  • The color of the text in the footer is now taken from the specified colors in the configuration section and is therefore also visible on a dark background.

Furthermore, if you want the height of the iframe container to adjust automatically to the height of the mini-calendar (depending on the month, it will show 4, 5 or 6 weeks), then you will find the solution in the user guide (display0.txt) which is included in the display0.zip file.

You can download the latest mini-calendar version from the LuxCal Displays page (menu on the left).

Roel

Users are encouraged to upgrade to this new version 4.7.5.

Highlights

This new LuxCal version 4.7.5 is an important bug-fix release with technical issues solved and a few new features.
Most important new features / improvements:
• In Year, Month and Matrix view, to add a new event for a specific day, rather than clicking the top bar of a day cell, any free space of the day cell can now be clicked.
• The way to log in, log out and to change the user account credentials have changed to a more modern look.
• A new setting has been added to the admin's settings page to enable/disable the display of the end time (if specified) in the day cells of Month view following the event start time.
Hereafter you will find a full summary of all changes since LuxCal version 4.7.3.

This new release has been tested again with the help of John from Denmark. Thank you John, great job again!

New features/Improvements
• In Year, Month and Matrix view, if a user has post rights, rather than clicking the top bar of a day cell, any free space of the day cell can now be clicked to add a new event
    for the selected day. At the same time the hover box with event details has been slightly moved downwards to make the event title more visible.
• The way to log in, log out and     to change the user account credentials have changed. When the user is not logged in, at the right upper corner, a Log-in link is displayed, replacing the log in button on the navigation bar. Once logged in, in the right upper corner the user name is displayed as a hyper link. When clicking on the user name, two options drop down: 1) Log out, which replaces the log out button on the navigation bar, and 2) User profile. When selecting User profile, a new page will open where the user can change his/her profile data..
• A <title> tag has been added to the event title hyper-links showing "Edit event", "See event details" or nothing, depending on what is applicable.
• On the Alert page, when the message "Session expired, please restart the Calendar" is displayed, a Restart button has been added to restart the calendar and, if on the admin's Settings page a "Link to parent page" has been defined, also a Back button will be shown.
• When a user logs out and on the Settings page a link to a parent page has been specified, the user will be automatically redirected to the parent page.
• Whenever relevant, the calendar ID has been added to the messages logged in the luxcal.log and sql.log files. This is in particular useful in case of multiple calendars.
• In the past, in case of multiple calendars, the visitors counter and the visitors data log files were combined for all calendars. In this version the visitors counter and the visitors data log files are kept for each individual calendar.
• When the calendar is opened via the hyper-link at the bottom of a reminder email message, the day cell at the date of the event concerned has a slightly contrasted background color and border.
• The date hyper-link in the calendar's top bar did not show the same shadow as the other text hyper-links.
• A new setting has been added to the admin's settings page to enable/disable the display of the end time (if specified) in the day cells of Month view following the event start time.

Technical issues
• The implementation of the Single Sign On (SSO) feature in combination with calendar-specific PHP sessions was too complicated and caused too many problems. Therefore the system with one individual PHP session per calendar has been replaced by a more straightforward system with one PHP session per user, where calendar-specific data is store in the session variables using an array with the calendar ID as index.
• The regexes $rxCalURL, $rxPhone and $rxIMGTags and the regexes used in messaging to check for user names contained one or more un-escaped hyphens (-) in a square bracket list of characters, which is considered a regex error by the latest PCRE library (V10.32 2018-09-10), which is normally used by PHP 7.3.
• In the footer of the alert page, when hovering powered by LuxCal, it showed V4.7.2 (hard coded). This has been changed to dynamically showing the current calendar version.
• The drag-able area in the week and day views was always active, even if the user had no post rights. This resulted in an Event window with the message "You are not authorized to perform this action". This has been changed, the area is now only active if the user has post rights.
• FOR APACHE SERVERS ONLY! The protection of the calendar folders against unauthorized direct browser access has been revisited and where possible access has been restricted via .htaccess files. For the "db", "files", "attachments", logs and reciplists folders all direct access is denied. Authorized access, via the calendar's user interface, is performed indirect.
• When deleting an event the "editor" field was not set to the current user, resulting in a wrong "edited by" name in the Changes view. This has been rectified and now deleting an event is treated similar to editing an event, as far as the "edited by" and "date/time edited" fields.
• The text "Check all ignore boxes" was still hard-coded and has been moved to the language files.
• In the installation_guide section "Single Sign On (SSO) it is specified that SSO can be achieved by saving the user email address or the user name in the session variable lcUser, in the code however, only the user email address was accepted. This has been corrected, either email address or user name will be accepted.
• The setting to select to show the event owner in front of the event title has been moved from the section "Events" to the section "Views".

Bug fixes
• When upgrading from v4.6 the row "symbol" in the categories table was not copied, so after the upgrade symbols specified for certain categories in V4.6 were lost.
• Users with manager rights were not able to chose the "to be approved" list from the side menu (hamburger button) and event owners could still edit events that already had been approved, which should not be possible.
• When hovering an event in a narrow window or on a narrow screen (< 500px), the hover box with event details was not displayed at the correct location and was too wide.
• When on the Settings page, under Views, "Show images in month view" is not checked, then in the hover box with event details, thumbnails are shown next to each other. However, if "Show images in month view" has been checked, in the day cells in Month view the images are shown under each other.
• When on the admin's Settings page the logging of visitors data has been enabled, in the left lower corner of the calendar a hit counter is displayed. When a user has at least manager rights this counter becomes a hyper-link to the visitors data details. However, due to direct file access restrictions, the hyper link was blocked. When revisiting the unauthorized direct browser access of files and folders, this has been solved.
• In the Event window the "Edited" date/time and name were not updated when the event repetition was changed or when the Save (without close) button was clicked.
• When on the categories page a fixed event duration was selected with an event duration of 0 hours and 0 minutes, then the events in this category were shown in the various views with an identical start and end time.
• An error in the regex ($rxEML) to find email addresses in the event description fields, caused email addresses without dot to be accepted.
• The text color of admin page titles on the navigation bar and the hit counter and RSS feeds link on the footer bar was not set properly, making it hard to see on a dark navigation and footer bar background.
• When editing one occurrence of a repeating or multi-day event and deleting an attachment from the event, resulted in the attachment file to be deleted from the "attachment" folder, leaving the remaining events of the series without attachment. This has been solved by never deleting the attachment files from the attachment folder.
• In the "validGets" function, there was an error in the regex to validate the GET variable "cal".
• The RSS feeds were not working due to a call to a name change of the toolbox.php function to validate possible GET variables.
• Uploaded attachment or thumbnail files with spaces in the file name caused problems when using these files. Solved by replacing all spaces in file names by underscore characters during the upload process.
• Thumbnails in the event description fields were not shown in (reminder) email messages. The reason was that the URI to the thumbnails folder was used, instead of the URL.
• When specifying a recurring event every xth weekday of a specific month, this resulted in every xth weekday of "each month". This problem was introduced when enhancing the overlap check to include recurring events.
• When uploading an iCal file on the admin's iCal File Import page with the Timezone adjustment check box checked, for events with an end time this resulted in a call to an undefined function 'strotime' (typo).
• When in the uploaded iCal file no events were found occurring as of the specified date, this resulted in PHP errors.
• The printNice function did not work. (querySelectorAll does not return an array, but a NodeList).
• There was a backslash character displayed just under the text Manage Thumbnails in the left upper corner.

Roel

372

(9 replies, posted in Problems)

@RdeW: There is no way to configure the calendar to show the Venue in the day cells of Month view. I can however give you a code change to show the venue. If you want this, please let me know where you would like to see the venue (e.g. after the title, on a new line, etc.), and if you want the word "Venue:" in front of it.

@cousinhub:
1) Concerning the Print function, could you send me the URL of your calendar (via the Contact Us page) so that I can analyze what's going wrong.
2) Concerning the start and end times in week and day view: Edit the file "views/dw_functions.php" and change line 148 . . .

echo "<div class='{$class}'>{$chBox}{$onClick}{$popAttr} title=\"{$title}\">{$stiPrefix}{$evt['tix']}</span></div></div>\n";

to . . .

echo "<div class='{$class}'>{$chBox}{$onClick}{$popAttr} title=\"{$title}\">{$time} {$evt['tix']}</span></div></div>\n";

So in other words: replace {$stiPrefix} by {$time}, followed by a space.
Please note that there are no plans to add this change to the next LuxCal calendar version.

Roel

373

(1 replies, posted in Problems)

Hi there,

Correct, in Month view only the start time and event title are shown in the day cells (and the end time with the code change, or enabled in V4.7.5). The calendar "policy" is to keep the Month view as tidy and simple as possible and for details the user can hover the event title or click on it to get the full event report. So the General View template doesn't apply to the day cell of the Month view.

Roel

374

(9 replies, posted in Problems)

I'm (almost) convinced that printing does work after the change wink
Did you refresh the calendar page (Ctrl-F5) after implementing the changes?

Roel

375

(4 replies, posted in Need Help)

Hi Hubert,

Please see "Adding more fields / Changing current extra fields" under "Suggestions" in this forum.

Roel