- Messaggi: 10
- Ringraziamenti ricevuti 1
Table creation failed error message
- ms@greatbrands.net
-
Autore della discussione
- Offline
- Fresh Boarder
-
Riduci
Di più
11/12/2019 15:23 #3546
da ms@greatbrands.net
Table creation failed error message è stato creato da 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
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
Si prega Accedi a partecipare alla conversazione.
11/12/2019 15:35 #3547
da dende
Risposta da dende al topic Table creation failed error message
Mysql version ?
Si prega Accedi a partecipare alla conversazione.
- ms@greatbrands.net
-
Autore della discussione
- Offline
- Fresh Boarder
-
Riduci
Di più
- Messaggi: 10
- Ringraziamenti ricevuti 1
11/12/2019 15:44 #3548
da ms@greatbrands.net
Risposta da ms@greatbrands.net al topic Table creation failed error message
Server-Version: 10.3.20-MariaDB - MariaDB Server
Si prega Accedi a partecipare alla conversazione.
11/12/2019 15:59 #3549
da dende
Risposta da dende al topic Table creation failed error message
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
You could switch to mysql 5.7 version to solve this till we rollout a patch
Si prega Accedi a partecipare alla conversazione.
- ms@greatbrands.net
-
Autore della discussione
- Offline
- Fresh Boarder
-
Riduci
Di più
- Messaggi: 10
- Ringraziamenti ricevuti 1
11/12/2019 16:01 #3550
da ms@greatbrands.net
Risposta da ms@greatbrands.net al topic Table creation failed error message
Ok, thanks for the answer. I am not too much into this. I am using CPanel, how can I change this?
Si prega Accedi a partecipare alla conversazione.
11/12/2019 16:07 #3551
da dende
Risposta da dende al topic Table creation failed error message
You should ask to your hosting provider.
We don't know your stack configuration
We don't know your stack configuration
Si prega Accedi a partecipare alla conversazione.
Tempo creazione pagina: 0.136 secondi