<?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 — LuxCal 5.1.1 SQL error when adding an event in a "no overlap" category]]></title>
		<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=371</link>
		<atom:link href="https://www.luxsoft.eu/lcforum/extern.php?action=feed&amp;tid=371&amp;type=rss" rel="self" type="application/rss+xml"></atom:link>
		<description><![CDATA[The most recent posts in LuxCal 5.1.1 SQL error when adding an event in a "no overlap" category.]]></description>
		<lastBuildDate>Sun, 19 Sep 2021 15:27:27 +0000</lastBuildDate>
		<generator>PunBB 1.4.4</generator>
		<item>
			<title><![CDATA[LuxCal 5.1.1 SQL error when adding an event in a "no overlap" category]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?pid=1390#p1390</link>
			<description><![CDATA[<p>When adding an event in an event category for which &quot;No overlap allowed&quot; has be set to &quot;same category&quot;, an SQL error occurred.</p><p>This can be solved by editing the file &quot;common/toolbox.php&quot; and replacing . . .<br>line 386 ($filter = &quot;(e.type = {$typ} AND c.`noverlap` = 2)&quot;;) by<br></p><div class="codebox"><pre><code>$filter = &quot;(c.`noverlap` = 2)&quot;;</code></pre></div><p>and line 388 ($filter = &quot;(e.type = {$typ}&quot;.($eid ? &quot; AND e.`ID` != {$eid}&quot; : &#039;&#039;).&quot; AND ((c.`noverlap` = 1 AND c.`ID` = $cid) OR c.`noverlap` = 2))&quot;; //if update, exclude event self) by<br></p><div class="codebox"><pre><code>$filter = &quot;((c.`noverlap` = 1 AND c.`ID` = $cid) OR c.`noverlap` = 2)&quot;.($eid ? &quot; AND e.`ID` != {$eid}&quot; : &#039;&#039;); //if update, exclude event self</code></pre></div><p>and line 414 (retrieve($sDate,$eDate,&#039;&#039;,$filter);) by<br></p><div class="codebox"><pre><code>retrieve($sDate,$eDate,&#039;&#039;,$filter,$typ);</code></pre></div><p>Use cut &amp; paste !</p><p>You can also send us an email via the Contact Us page and we will send you the updated toolbox.php file.<br>Roel</p>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Sun, 19 Sep 2021 15:27:27 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?pid=1390#p1390</guid>
		</item>
	</channel>
</rss>
