Support

Akeeba Ticket System

#17512 error installing ATS PRO 1.2.3

Posted in ‘Akeeba Ticket System for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Akeeba Ticket System version
n/a

Latest post by paddyrolls on Monday, 16 September 2013 07:41 CDT

paddyrolls
Hi

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

nicholas
Akeeba Staff
Manager
Please try installing the latest dev release from https://www.akeebabackup.com/download/developer-releases/ats-dev/78e2b21/com_ats-pro-git_78e2b21-zip.raw It is the same package with the installation SQL script modified to not cause Joomla! throw this error.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

paddyrolls
Hi Nicholas

The latest dev installed without error.

Thanks

Patrick

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!