<?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 — Upgrade from V475 to V521 SQL errors]]></title>
		<link>https://www.luxsoft.eu/lcforum/viewtopic.php?id=445</link>
		<atom:link href="https://www.luxsoft.eu/lcforum/extern.php?action=feed&amp;tid=445&amp;type=rss" rel="self" type="application/rss+xml"></atom:link>
		<description><![CDATA[The most recent posts in Upgrade from V475 to V521 SQL errors.]]></description>
		<lastBuildDate>Thu, 01 Sep 2022 20:24:54 +0000</lastBuildDate>
		<generator>PunBB 1.4.4</generator>
		<item>
			<title><![CDATA[Re: Upgrade from V475 to V521 SQL errors]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?pid=1673#p1673</link>
			<description><![CDATA[<p>Hi Pat,</p><p>The PHP Session Timeout issue is very annoying! So you should definitively upgrade the calendar.</p><p>Yes, if you could send me the SQL error log (via the Contact Page), that would be very helpful.<br>From your post I think that you are using the display1 to show upcoming events in one of your club&#039;s webpages. And I get the impression from the error message that the version of your display1.php file is not compatible with the calendar version.<br>When you send me the SQL error log, could you please also send me a link to the web page where the upcoming events are shown, so that I can have a look how the calendar is used.</p><p>Roel</p>]]></description>
			<author><![CDATA[null@example.com (Roel)]]></author>
			<pubDate>Thu, 01 Sep 2022 20:24:54 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?pid=1673#p1673</guid>
		</item>
		<item>
			<title><![CDATA[Upgrade from V475 to V521 SQL errors]]></title>
			<link>https://www.luxsoft.eu/lcforum/viewtopic.php?pid=1670#p1670</link>
			<description><![CDATA[<p>I&#039;m trying to upgrade from V475 to V521 but have struck an error.&nbsp; According to the error log, it comes up with the following errors ..</p><p>ERROR Script: /luxcal/display1p.php - SQL query error: SQLSTATE[42S22]: <br>Column not found: 1054 Unknown column &#039;c.olapGap&#039; in &#039;field list&#039;</p><p>... and seems to be related to the displayx.php files.&nbsp; The above error message is the first of many in the log file.</p><p>The PHP version running on the server is V5.5.34</p><p>Has the structure of the database tables changed i.e. more columns ?<br>If so, do I need to prep the tables with these new columns ?</p><p>I do make copies of database tables via phpMyAdmin in csv format.&nbsp; So I haven&#039;t lost any data and have re-instated the older version (V475) for now.&nbsp; </p><p>But the PHP Session Timeout issue is a BIG PROBLEM for us so am keen to upgrade asap.</p><p>I have noticed that the upgrade script has prepared the database tables (mycal_....etc ) by creating a copy of all tables and appending X at the end.</p><p>I can send the SQL error log file if required.</p>]]></description>
			<author><![CDATA[null@example.com (pat)]]></author>
			<pubDate>Thu, 01 Sep 2022 02:38:04 +0000</pubDate>
			<guid>https://www.luxsoft.eu/lcforum/viewtopic.php?pid=1670#p1670</guid>
		</item>
	</channel>
</rss>
