· 8 years ago · Dec 02, 2017, 07:12 PM
1JInstaller::install: SQL Error. DB function failed with error number 1064
2 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 '`lastupdate` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `' at line 3 SQL=CREATE TABLE IF NOT EXISTS `abc_ak_storage` ( `tag` VARCHAR(255) NOT NULL, `lastupdate` `lastupdate` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `data` LONGTEXT, PRIMARY KEY (`tag`) ) DEFAULT CHARACTER SET utf8;
3 SQL =
4
5 CREATE TABLE IF NOT EXISTS `abc_ak_storage` (
6 `tag` VARCHAR(255) NOT NULL,
7 `lastupdate` `lastupdate` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
8 `data` LONGTEXT,
9 PRIMARY KEY (`tag`)
10 ) DEFAULT CHARACTER SET utf8;
11
12 Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1064
13 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 '`lastupdate` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `' at line 3 SQL=CREATE TABLE IF NOT EXISTS `abc_ak_storage` ( `tag` VARCHAR(255) NOT NULL, `lastupdate` `lastupdate` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `data` LONGTEXT, PRIMARY KEY (`tag`) ) DEFAULT CHARACTER SET utf8;
14 SQL =
15
16 CREATE TABLE IF NOT EXISTS `abc_ak_storage` (
17 `tag` VARCHAR(255) NOT NULL,
18 `lastupdate` `lastupdate` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
19 `data` LONGTEXT,
20 PRIMARY KEY (`tag`)
21 ) DEFAULT CHARACTER SET utf8;