-
home page
-
vtenext - Official Forum
-
vtenext CE
-
Table creation failed error message
Table creation failed error message
Less
More
-
Posts: 10
-
Thank you received: 1
-
-
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.
Less
More
-
Posts: 380
-
Thank you received: 26
-
-
Less
More
-
Posts: 10
-
Thank you received: 1
-
-
Less
More
-
Posts: 380
-
Thank you received: 26
-
-
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.
Less
More
-
Posts: 10
-
Thank you received: 1
-
-
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.
Less
More
-
Posts: 380
-
Thank you received: 26
-
-
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.
-
home page
-
vtenext - Official Forum
-
vtenext CE
-
Table creation failed error message
Time to create page: 0.150 seconds