<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[LuxCal Web Calendar — Known Issues and Fixes]]></title>
		<link>https://www.luxsoft.eu/lcforum/index.php</link>
		<atom:link href="https://www.luxsoft.eu/lcforum/extern.php?action=feed&amp;fid=2&amp;type=rss" rel="self" type="application/rss+xml"></atom:link>
		<description><![CDATA[The most recent topics at LuxCal Web Calendar.]]></description>
		<lastBuildDate>Fri, 07 Nov 2025 21:03:28 +0000</lastBuildDate>
		<generator>PunBB 1.4.4</generator>
		<item>
			<title><![CDATA[LuxCal 5.3.4 - Problem with email addresses with a sub domain]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=532&amp;action=new</link>
			<description><![CDATA[<p>When using an email address with a sub domain, like John@Dowd.co.uk, the last part (.uk) of the email address was lost.<br>This can be solved by editing the file &quot;common/toolbox.php&quot; and replacing line 13:<br></p><div class="codebox"><pre><code>$rxEML = &quot;~(^|\s)([\w!#$%&amp;&#039;*+/=`{|}\^\~\-\.]{1,64})@([a-z0-9-]{2,50})\.(\w{2,6})(?:\s*\[([^&lt;&gt;\[]*?)\])?(\.|\s|&lt;|$)~imu&quot;; //jd@skyweb.com [title]</code></pre></div><p> by </p><div class="codebox"><pre><code>$rxEML = &quot;~(^|\s)([\w!#$%&amp;&#039;*+/=`{|}\^\~\-\.]{1,64})@([a-z0-9-]{2,50})\.([\w.]{2,8})(?:\s*\[([^&lt;&gt;\[]*?)\])?(\.|\s|&lt;|$)~imu&quot;; //jd@skyweb.com [title]</code></pre></div><p>Use cut and paste <img src="https://www.luxsoft.eu/lcforum/img/smilies/smile.png" width="15" height="15" alt="smile"></p>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Fri, 07 Nov 2025 21:03:28 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?id=532&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[LuxCal 5.3.3 - Bug in Finnish and Slovenian language file]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=521&amp;action=new</link>
			<description><![CDATA[<p>When selecting the Finnish or the Slovenian language in the calendar and go to the Log In page or one of the administrator pages, the page will not be loaded and a PHP error will appear.<br>This problem can be solved by editing the file lang?ai-suomi.php (Finnish) or ai-slovenski.php (Slovenian) and deleting the complete line 873:<br></p><div class="codebox"><pre><code>&quot;xpl_edit_info&quot; =&gt;</code></pre></div><p>Roel</p>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Wed, 29 Jan 2025 17:12:55 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?id=521&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[LuxCal 5.3.3 - PHP error messages on page: Changes]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=520&amp;action=new</link>
			<description><![CDATA[<p>When the Changes page is selected and changed events are found, a list with PHP error messages appears in the background of the page.</p><p>This can be solved as follows:<br>• Edit the file &quot;common/retrievc.php and on lines 105, 106 and 107 replace $row by $evt. Ten times!</p><p>So lines 105 - 107 should look like: </p><div class="codebox"><pre><code>      $evt[&#039;ald&#039;] = ($evt[&#039;sti&#039;] == &#039;00:00&#039; and $evt[&#039;eti&#039;] == &#039;23:59&#039;);
      $evt[&#039;ntm&#039;] = ($evt[&#039;sti&#039;] == &#039;00:00&#039; and $evt[&#039;eti&#039;] == &#039;00:00&#039;);
      if ($evt[&#039;ald&#039;] or $evt[&#039;ntm&#039;]) { $evt[&#039;sti&#039;] = $evt[&#039;eti&#039;] = &#039;&#039;; } //all day or no time: start/end time = &#039;&#039;</code></pre></div><p>Roel</p>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Tue, 28 Jan 2025 14:00:34 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?id=520&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[LuxCal 5.3.3 - Syntax error in Danish language file]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=519&amp;action=new</link>
			<description><![CDATA[<p>The Danish language file ui-dansk.php contains a syntax error. This problem can be solved as follows:<br>Edit the calendar file &quot;lang/ui-dansk.php&quot; and on line 253 add a double quote ( &quot; ) just before the comma at the end of the line.<br>So line 253 should look like:</p><div class="codebox"><pre><code>&quot;evt_select_recips&quot; =&gt; &quot;Vælg modtagere&quot;,</code></pre></div><p>Roel</p>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Tue, 14 Jan 2025 10:39:48 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?id=519&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[LuxCal 5.3.3 - Time in notification message title not always visible]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=517&amp;action=new</link>
			<description><![CDATA[<p>When the event start or end time starts with a 9 (i.e. 9:00 - 9:59), in notification email and SMS messages the start and/or end time is not always visible.<br>This problem can be solved as follows:<br>Edit the file &quot;common/toolbox.php&quot; and change line 59<br>from . . . .<br></p><div class="codebox"><pre><code>if (!$time or $time[0] == &#039;9&#039;) { return &#039;&#039;; }</code></pre></div><p>to . . . . </p><div class="codebox"><pre><code>if (!$time or substr($time,0,2) == &#039;99&#039;) { return &#039;&#039;; }</code></pre></div><p>Roel</p>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Fri, 03 Jan 2025 17:09:53 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?id=517&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[LuxCal 5.3.1L - Opening event from search results not working]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=498&amp;action=new</link>
			<description><![CDATA[<p>When using the Search function, clicking an event in the search results to open the event does not work.</p><p>This problem can be solved by editing the file &quot;pages/search.php&quot; and change line 204 from . . .<br></p><div class="codebox"><pre><code>$click = ($evt[&#039;mayE&#039;] ? &#039;editE&#039; : &#039;showE&#039;).&quot;({$evt[&#039;eid&#039;]},&#039;{$date}&#039;)&quot;;</code></pre></div><p>to<br></p><div class="codebox"><pre><code>$click = ($evt[&#039;mayE&#039;] ? &#039;editE&#039; : &#039;showE&#039;).&quot;({$evt[&#039;eid&#039;]},`{$date}`)&quot;;</code></pre></div><p><strong>It&#039;s hard to see, but the single quotes around {$date} towards the end of the line have been replaced by backticks ( ` ).</strong><br>(Back ticks can be found on a US/UK keyboard left upper corner next to the 1 key.)</p><p>Roel</p>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Sun, 07 Apr 2024 13:35:01 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?id=498&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[LuxCal 5.3.1L - Invalid calendar ID after upgrading]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=496&amp;action=new</link>
			<description><![CDATA[<p>If you have the SQLite version of the calendar installed and after upgrading you get an &quot;Invalid calendar ID error, this can be solved as follows:</p><p>• In the database folder (default &quot;db&quot;) change the uppercase characters in the database file name to lowercase characters<br>• In the lcconfig.php file in the calendar root folder, if uppercase characters are present in the default calendar name, change them to lowercase.<br>• Start the calendar (just once) with the ?cal=&lt;calendar name&gt; URL parameter. Where &lt;calendar name&gt; is the calendar name changed above.</p><p>Thereafter the problem should be solved.</p><p>Roel</p>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Thu, 04 Apr 2024 19:32:44 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?id=496&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[LuxCal 5.3.1 - Time picker problem when 12-hour (am/pm) time format]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=495&amp;action=new</link>
			<description><![CDATA[<p>When on the Settings page the 12-hour time format (am/pm) has been selected, then on the Add / Edit Event page the time picker doesn&#039;t work anymore.<br>This can be solved by editing the file /common/dtpicker.js and on lines 152 and 153 replace &quot;const&quot; by &quot;var&quot;, as indicated below:<br></p><div class="codebox"><pre><code>var am = apm[0].replace(&quot;a&quot;,&quot;am&quot;).replace(&quot;A&quot;,&quot;AM&quot;);
var pm = apm[0].replace(&quot;a&quot;,&quot;pm&quot;).replace(&quot;A&quot;,&quot;PM&quot;);</code></pre></div><p>Roel</p>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Thu, 04 Apr 2024 11:42:16 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?id=495&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[LuxCal 5.3.0 withdrawn because of problems]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=491&amp;action=new</link>
			<description><![CDATA[<p>Because the LuxCal version 5.3.0 MySQL had some problems, both the MySQL and the SQLite versions have been withdrawn and replaced by version 5.3.1.<br>If you have downloaded LuxCal version 5.3.0, you should replace it by the new version 5.3.1.</p><p>We are sorry for the inconvenience.</p>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Tue, 19 Mar 2024 15:46:20 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?id=491&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Database and display issue upgrading from 521 to 524]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=489&amp;action=new</link>
			<description><![CDATA[<p>Hi,<br>I &quot;maydayed&quot; Roel for an issue described in problems topics.<br>We together found the solution.<br>Description : <br>After upgrade, display of many php errors, first line (name, date, login) not visible when logged in.<br>Impossible to logout ... and impossible to make change in settings as it sends me an &quot;invalid request&quot; answer.<br>Errors linked to settings table according to Roel.<br>As I have another 524 but brand new on the server, made a comparison between 521 and 524 settings table.<br>It shows differences and more fields in 524.<br>Made a copy of liable settings table from brand new to my imported datas, scratching imported settings table.<br>All ok, no more issue ! Just some data to change, minor problem.</p><p>Conclusion :<br>Roel thinks an error occured in the upgrade procedure which is supposed to correct the structure to new standard.<br>No key for this trouble as it seems nobody else encountered, just a solution .. <img src="https://www.luxsoft.eu/lcforum/img/smilies/wink.png" width="15" height="15" alt="wink"><br>Could be&nbsp; a tricky external cause, nobody knows.</p><p>I write this here after Roel asked me to, in case anybody encounters the issue.</p>]]></description>
			<author><![CDATA[null@example.com (cousinhub)]]></author>
			<pubDate>Tue, 27 Feb 2024 09:57:03 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?id=489&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[LuxCal 5.2.4 - A "reset to default" bug on the admin's Settings page]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=481&amp;action=new</link>
			<description><![CDATA[<p>A bug on the admin&#039;s settings page causes a reset of all check boxes and single-character input fields to their default values each time the Settings page is opened.<br>The actual settings however, are not reset, unless the settings are saved again after the &quot;reset to default&quot;.<br>This problem can be solved by editing the file &quot;/pages/settings.php&quot; and changing line 57<br>from . . . .<br></p><div class="codebox"><pre><code>$pSet[$key] = $set[$key] ?: $value[0];</code></pre></div><p>to . . . .<br></p><div class="codebox"><pre><code>$pSet[$key] = $set[$key] ?? $value[0];</code></pre></div><p>In other words: by replacing ?: by ??.</p><p>This fix will be included in the next LuxCal version</p><p>Roel</p>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Tue, 19 Dec 2023 09:19:04 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?id=481&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[LuxCal 5.2.0 SQL error No active transaction when upgrading]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=428&amp;action=new</link>
			<description><![CDATA[<p>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.</p><p>This problem can be solved by editing the calendar file &quot;pages/toolboxx.php&quot; and moving line 672 . . .<br></p><div class="codebox"><pre><code>dbTransaction(&#039;begin&#039;);</code></pre></div><p>to line 885 (so just before the line with text &quot;//drop original tables and rename new upgraded tables&quot;.</p><p>Roel</p>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Fri, 06 May 2022 15:03:03 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?id=428&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[LuxCal 5.2.0 SQL error Invalid datetime format when upgrading]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=418&amp;action=new</link>
			<description><![CDATA[<p>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:</p><p>SQL query error: SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DOUBLE value: &#039;&#039;<br>Query string: UPDATE `mycal_settingsX` SET `value` = &#039;&#039; WHERE (`name` = &#039;spMiniCal&#039; OR `name` = &#039;spImages&#039; OR `name` = &#039;spInfoArea&#039;) AND `value` = 0</p><p>This can be solved by editing the file &quot;common/toolboxx.php&quot; and on line 877 and 878 enclosing the values 0 and 1 in single quotes. In other words, change . . .<br></p><div class="codebox"><pre><code>AND `value` = 0&quot;);</code></pre></div><p>to . . .<br></p><div class="codebox"><pre><code>AND `value` = &#039;0&#039;&quot;);</code></pre></div><p>and change . . .<br></p><div class="codebox"><pre><code>AND `value` = 1&quot;);</code></pre></div><p>to . . .<br></p><div class="codebox"><pre><code>AND `value` = &#039;1&#039;&quot;);</code></pre></div><p>Roel</p>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Sat, 26 Feb 2022 11:16:42 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?id=418&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[LuxCal 5.2.0 SQL error when opening User Profile]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=401&amp;action=new</link>
			<description><![CDATA[<p>When you are logged in and select your user name and then User Profile, an SQL error may occur.</p><p>To solve this, edit the file &quot;pages/account.php&quot; and on line 73 remove the text &quot;,`number`&quot; (in the middle).<br>So thereafter line 73 should be:<br></p><div class="codebox"><pre><code>$stH = stPrep(&quot;SELECT `ID`,`name`,`email`,`phone`,`language` FROM `users` WHERE `ID` = ?&quot;);</code></pre></div>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Thu, 27 Jan 2022 09:44:18 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?id=401&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[LuxCal 5.1.1 In the Event Report the sub-category color is not shown]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=372&amp;action=new</link>
			<description><![CDATA[<p>For events in a category with sub-category colors, the sub-category color is not shown in the Event Report.<br>Solution:<br>Edit the file &quot;pages/eventreport.php&quot; and move line 72 . . .<br></p><div class="codebox"><pre><code>$sCats = json_decode($row[&#039;subCats&#039;]);</code></pre></div><p>. . . to line 67, just before the &quot;if&quot;.<br>Roel</p>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Wed, 22 Sep 2021 15:42:33 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?id=372&amp;action=new</guid>
		</item>
	</channel>
</rss>
