Just purchased and am trying to install and test for a client and get the following error (see below) and don't know how to correct it. Can anyone help. Here's the error message:

JInstaller::install: SQL Error. DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 7 SQL=CREATE TABLE IF NOT EXISTS `jos_rsevents_events_cat` ( `IdEventCategory` int(11) NOT NULL AUTO_INCREMENT, `IdEvent` int(11) NOT NULL, `IdCategory` int(11) NOT NULL, PRIMARY KEY (`IdEventCategory`), KEY `IdEvent` (`IdEvent`,`IdCategory`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_rsevents_events_cat` (
`IdEventCategory` int(11) NOT NULL AUTO_INCREMENT,
`IdEvent` int(11) NOT NULL,
`IdCategory` int(11) NOT NULL,
PRIMARY KEY (`IdEventCategory`),
KEY `IdEvent` (`IdEvent`,`IdCategory`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 7 SQL=CREATE TABLE IF NOT EXISTS `jos_rsevents_events_cat` ( `IdEventCategory` int(11) NOT NULL AUTO_INCREMENT, `IdEvent` int(11) NOT NULL, `IdCategory` int(11) NOT NULL, PRIMARY KEY (`IdEventCategory`), KEY `IdEvent` (`IdEvent`,`IdCategory`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_rsevents_events_cat` (
`IdEventCategory` int(11) NOT NULL AUTO_INCREMENT,
`IdEvent` int(11) NOT NULL,
`IdCategory` int(11) NOT NULL,
PRIMARY KEY (`IdEventCategory`),
KEY `IdEvent` (`IdEvent`,`IdCategory`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
It was not possible to delete the selected file.: 'uninstall.rsevents.php'
It was not possible to delete the selected file.: 'install.rsevents.php'

Hello,

Please download the component from our site again and perform a fresh install. This will solve the issue you are experiencing.

Hi there,
Was there any solution to this? I have the same error:

JInstaller::install: SQL Error. DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 6 SQL=CREATE TABLE IF NOT EXISTS `jos_rsevents_themes` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `default` int(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `jos_rsevents_themes` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`default` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 6 SQL=CREATE TABLE IF NOT EXISTS `jos_rsevents_themes` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `default` int(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `jos_rsevents_themes` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`default` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Hey guys,

I deleted the following line of code:

ENGINE=MyISAM DEFAULT CHARSET=utf8

from the file:

com_rsevents/admin/install.mysql.nonutf8.sql

and then zipped and installed and it worked!

Error Installing RS Events - removing the suggested line worked like a charm, Cheers!

Hello,

Thank you for pointing this to us. The component is now updated.
Regards!

Hi,

I've got another db-error by trying to install RSEvents:
Can anybody help me?

Installer::install: SQL-Fehler DB function failed with error number 1074
Column length too big for column 'redirect' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS `joo_rsevents_payments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `details` text NOT NULL, `tax_type` tinyint(1) NOT NULL, `tax_value` int(11) NOT NULL, `redirect` VARCHAR(550) NOT NULL, `published` tinyint(1) NOT NULL, PRIMARY KEY (`id`) );
SQL =

CREATE TABLE IF NOT EXISTS `joo_rsevents_payments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`details` text NOT NULL,
`tax_type` tinyint(1) NOT NULL,
`tax_value` int(11) NOT NULL,
`redirect` VARCHAR(550) NOT NULL,
`published` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
);