When trying to install ATS PRO 1.2.3 on a site I get the following error:
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 '/* CREATE TABLE IF NOT EXISTS `ckfa_ats_overloads` ( `ats_overload_id` bigint(2' at line 20 SQL=/* CREATE TABLE IF NOT EXISTS `ckfa_ats_overloads` ( `ats_overload_id` bigint(20) NOT NULL AUTO_INCREMENT, `trigger_type` enum('totalposts','totaltickets','statustickets') NOT NULL DEFAULT 'totalposts', `trigger_count` integer not null default 0, `trigger_period` integer not null default 0, `status` ENUM('O','P','C','1','2','3','4','5','6','7','8','9') NOT NULL DEFAULT 'O', `catid` bigint(20) NOT NULL, `action` ENUM('warning','noreplies','nonewtickets','all'), `warning_module_group` VARCHAR(255) NULL DEFAULT 'ats-overload-warning', `peruser` TINYINT NOT NULL DEFAULT '0', `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` bigint(20) NOT NULL DEFAULT '0', `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` bigint(20) NOT NULL DEFAULT '0', `enabled` tinyint(3) NOT NULL DEFAULT '1', PRIMARY KEY (`ats_overload_id`) ) DEFAULT CHARSET=utf8;
My site is currently configured to use:
PHP Version: 5.3.15
Joomla: 3.1.5 Stable
Error Reporting: None
Thanks for your assistance
Patrick