Support

Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: 2.5.11
PHP version: (unknown) 5.3.25
MySQL version: (unknown) 5.5.28
Host: (optional, but it helps us help you) Siteground.com

Hello. When attempting to install ATS I get the following error (have tried multiple times).

JInstaller: :Install: Error SQL 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 '`timespent` FLOAT NOT NULL DEFAULT 0, `created_on` datetime NOT NULL DEFAULT '' at line 11 SQL=CREATE TABLE IF NOT EXISTS `emft_ats_tickets` ( `ats_ticket_id` bigint(20) NOT NULL AUTO_INCREMENT, `catid` bigint(20) NOT NULL, `status` ENUM('O','P','C','1','2','3','4','5','6','7','8','9') NOT NULL DEFAULT 'O', `ats_bucket_id` bigint(20) NULL DEFAULT NULL, `title` varchar(1024) NOT NULL, `alias` varchar(255) NOT NULL DEFAULT '', `public` tinyint(3) NOT NULL DEFAULT '1', `origin` varchar(10) NOT NULL DEFAULT 'web', `assigned_to` BIGINT(20) NOT NULL DEFAULT '0' `timespent` FLOAT 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', `params` TEXT NULL DEFAULT NULL, PRIMARY KEY (`ats_ticket_id`) ) DEFAULT CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `#__ats_tickets` (
`ats_ticket_id` bigint(20) NOT NULL AUTO_INCREMENT,
`catid` bigint(20) NOT NULL,
`status` ENUM('O','P','C','1','2','3','4','5','6','7','8','9') NOT NULL DEFAULT 'O',
`ats_bucket_id` bigint(20) NULL DEFAULT NULL,
`title` varchar(1024) NOT NULL,
`alias` varchar(255) NOT NULL DEFAULT '',
`public` tinyint(3) NOT NULL DEFAULT '1',
`origin` varchar(10) NOT NULL DEFAULT 'web',
`assigned_to` BIGINT(20) NOT NULL DEFAULT '0'
`timespent` FLOAT 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',
`params` TEXT NULL DEFAULT NULL,
PRIMARY KEY (`ats_ticket_id`)
) DEFAULT CHARSET=utf8;

Component Install: SQL error 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 '`timespent` FLOAT NOT NULL DEFAULT 0, `created_on` datetime NOT NULL DEFAULT '' at line 11 SQL=CREATE TABLE IF NOT EXISTS `emft_ats_tickets` ( `ats_ticket_id` bigint(20) NOT NULL AUTO_INCREMENT, `catid` bigint(20) NOT NULL, `status` ENUM('O','P','C','1','2','3','4','5','6','7','8','9') NOT NULL DEFAULT 'O', `ats_bucket_id` bigint(20) NULL DEFAULT NULL, `title` varchar(1024) NOT NULL, `alias` varchar(255) NOT NULL DEFAULT '', `public` tinyint(3) NOT NULL DEFAULT '1', `origin` varchar(10) NOT NULL DEFAULT 'web', `assigned_to` BIGINT(20) NOT NULL DEFAULT '0' `timespent` FLOAT 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', `params` TEXT NULL DEFAULT NULL, PRIMARY KEY (`ats_ticket_id`) ) DEFAULT CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `#__ats_tickets` (
`ats_ticket_id` bigint(20) NOT NULL AUTO_INCREMENT,
`catid` bigint(20) NOT NULL,
`status` ENUM('O','P','C','1','2','3','4','5','6','7','8','9') NOT NULL DEFAULT 'O',
`ats_bucket_id` bigint(20) NULL DEFAULT NULL,
`title` varchar(1024) NOT NULL,
`alias` varchar(255) NOT NULL DEFAULT '',
`public` tinyint(3) NOT NULL DEFAULT '1',
`origin` varchar(10) NOT NULL DEFAULT 'web',
`assigned_to` BIGINT(20) NOT NULL DEFAULT '0'
`timespent` FLOAT 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',
`params` TEXT NULL DEFAULT NULL,
PRIMARY KEY (`ats_ticket_id`)
) DEFAULT CHARSET=utf8;

Yes Nicholas, that worked fine.

If it matters, I noticed that, after installation, I saw the warning about "enabling the custom fields plugin" when I selected that option in the Administration. Looking at the plugins screen it showed that plugin as being enabled. Disabling it and re-enabling it made the warning go away and it works properly.

Thanks again.