The Evanced Event Calendar, Room Reserve and Summer Reader software version 7 and up requires the use of MySQL5. If your system is upgraded you may need to upgrade MySQL as well. The following information contains detailed instructions on installing MySQL and upgrading your database from 3 to 5 for use with the newer versions of Events, Room Reserve and Summer Reader. These instructions do not remove the MySQL 3 installation. Rather it simply adds MySQL 5. Any existing applications using MySQL 3 will continue to operate.
Required Evanced software versions for using MySQL 5 * Event Calendar version 6.5 or newer * Room Reserve version 6.5 or newer * Summer Reader version 7 or newer
To determine the version of MySQL being used by your system run the following command from the 'bin' folder under the 'MySQL' directory or contact suupport@evancedsolutions.com.
c:\mysqladmin -V mysqladmin Ver 8.41 Distrib 5.0.67 for Win32on ia32
The version of MySQL is listed after the "Distrib".
Please note that moving the database will involve minor interruption of the site, so it is recommended to make this change during the slowest traffic.
Send an email to support@evancedsolutions.com requesting the download links and passwords for obtaining the MySQL 5 and ODBC 3.51 installation files. Download MySQL 5.0 and then run it selecting the "Complete” installation option (take a note of port# used). And also download the MySQL 5.0 ODBC driver "3.51” and then run it.
Ensure that MySQL 5.0 installed successfully and is running (check for the "MySQL5" service in the Services Panel). If not, use the uninstall functions to remove it. Be sure that all MySQL 5 files have been removed and the "MySQL5" service is no longer running before trying to reinstall.
NOTE: To confirm the DSN name, go to your system’s web folder (usually in this location: c:\inetpub\wwwroot\evanced\lib), open the "common” folder then open "defines.inc" file using Notepad. The DSN name should be listed there somewhere in the first part of that file (DSN="autoemail").
If your site was not previously on a version that supported MySQL5 then you will need to complete the upgrade process before it will function properly. This include copying the upgrade files into the web folder and running the upgrade script. Once complete your site should come back up running on MySQL5.
Article ID: 162
Created On: Wed, Sep 28, 2011 at 3:53 PM
Last Updated On: Tue, Aug 27, 2013 at 2:07 PM
Online URL: https://kb.demcosoftware.com/article.php?id=162