Support

Akeeba Ticket System

#17623 Mysql error installing ATS 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 user31431 on Monday, 23 September 2013 10:24 CDT

user31431
 Hello,
I have got this error message while installing ATS 1.2.3
Joomla 3.1
PHP 5.3.27
Any idea?
Regards,
Christophe

0 SQL=/* CREATE TABLE IF NOT EXISTS `dze1t_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;

tampe125
Akeeba Staff
Hello Christophe,

this is a known issue that will be fixed in the latest version.
Please download the latest dev version from this page

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user31431
Thank you,
The installation was ok.
However, I don't have a menu to the component in the backend, so I can't configure it...
thanks in advance,
Christophe

tampe125
Akeeba Staff
Please try installing it again, without uninstalling it first.

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user31431
Ah ah, that's ok now,
Thanks for the trick:)
Christophe

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!