Table creation failed error message

More
11 Dec 2019 15:23 #3546 by ms@greatbrands.net
Hello,

I get the following message at the creation of the Database:

CREATE TABLE vte_report_stats ( reportid INTEGER(19) NOT NULL, userid INTEGER(19) NOT NULL, generatedtime TIMESTAMP DEFAULT '0000-00-00 00:00:00', rows INTEGER(19), PRIMARY KEY (reportid, userid) )
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows INTEGER(19), PRIMARY KEY (reportid, us' at line 5
ALTER TABLE vte_report_stats ADD INDEX report_stats_user_idx (userid)
Table 'gr8brands_vtecrm1.vte_report_stats' doesn't exist
Error: Tables partially created. Table creation failed.

How can I fix tis?

Thanks a lot

Marc

Please Log in to join the conversation.

More
11 Dec 2019 15:35 #3547 by dende
Mysql version ?

Please Log in to join the conversation.

More
11 Dec 2019 15:44 #3548 by ms@greatbrands.net
Server-Version: 10.3.20-MariaDB - MariaDB Server

Please Log in to join the conversation.

More
11 Dec 2019 15:59 #3549 by dende
In mariadb, "rows" is a protected word so might be an unescaped word on vte table definition.
You could switch to mysql 5.7 version to solve this till we rollout a patch

Please Log in to join the conversation.

More
11 Dec 2019 16:01 #3550 by ms@greatbrands.net
Ok, thanks for the answer. I am not too much into this. I am using CPanel, how can I change this?

Please Log in to join the conversation.

More
11 Dec 2019 16:07 #3551 by dende
You should ask to your hosting provider.
We don't know your stack configuration

Please Log in to join the conversation.

Time to create page: 0.192 seconds