Support Tickets - DB Error (Prefix)

DB Error (Prefix)

Live Chat 16.01.2016 624 Support Status: Closed Solution: Yes khprem


While installing I receive this error below. Please help

DB ErrorMessage:MySQL Query fail: CREATE TABLE a-zautoproactive ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` varchar(200) NULL DEFAULT NULL, `message` varchar(200) NULL DEFAULT NULL, `showalert` smallint(1) unsigned NOT NULL DEFAULT '1', `wayin` varchar(100) DEFAULT NULL, `wayout` varchar(100) DEFAULT NULL, `timeonsite` smallint(3) unsigned NOT NULL DEFAULT '2', `visitedsites` smallint(2) unsigned NOT NULL DEFAULT '1', `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `path` (`path`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1MySQL 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 '-zautoproactive ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` varchar(200) ' at line 1Date:Saturday, January 16, 2016 at 10:31:02 AM

Replies (3)

  • avatar Jerome

    Thank you for opening a support ticket.

    Please open your include/db.php file and change your database prefix. MySQL does not allow prefixes with:

    a-

    you should use:

    a_

    Thank you.

    16.01.2016 0
  • avatar khprem

    Thank you Jerome its woking fine now.

    16.01.2016 0
  • avatar Jerome

    Thank you for your feedback.

    *** Ticket closed ***

    16.01.2016 0