Unable to install suitecrm versin 7.10.27

Error creating table: : Query Failed: CREATE TABLE ( NULL ) CHARACTER SET utf8 COLLATE utf8_general_ci: MySQL error 1064: 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 ‘( NULL ) CHARACTER SET utf8 COLLATE utf8_general_ci’ at line 1

Hey,

I’ve just installed a copy of 7.10.27 there, and all seemed fine

Was this a clean install of 7.10.27, or were you trying to upgrade to it from a previous version?

Also, to have some more info, what sort of setup are you installing onto?

(ie: MySQL/MSSQL? Windows/Linux? Which PHP version?, etc)

@John this is definitely a bug, we’ve seen several people with this error in the Forums lately. But I don’t know what is causing it, perhaps it is not easy to reproduce :frowning:

1 Like

Ah, that’s good to know, thank you @pgr !

Yeah, it seems rather strange

Mysql 8 renaming rank column in users feed
php 7.3
Centos 8

Sorry for the delay in replying

Well, if this is only in MySQL 8.0, then it isn’t a bug, it’s just people using an unsupported version