Install Error: mysql error 1064
Permalink
Hi everybody.
I was looking around for a good CMS and I saw Concrete5, quite interesting.
I was trying to install on my personal domain but I continuously get this error on the schema.sql
I read the previous answers and tried the UTF-8 thing, but I can't go on.
BTW I have MySQL 5.1 on my hosting site.
Any suggestion? Thanks in advance !
I was looking around for a good CMS and I saw Concrete5, quite interesting.
I was trying to install on my personal domain but I continuously get this error on the schema.sql
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 'CREATE TABLE AreaGroups ( cID INTEGER(10) UNSIGNED NOT NUL' at line 10] in EXECUTE("CREATE TABLE AreaGroupBlockTypes ( cID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, arHandle VARCHAR(255) NOT NULL, gID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, uID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, btID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, ...
I read the previous answers and tried the UTF-8 thing, but I can't go on.
BTW I have MySQL 5.1 on my hosting site.
Any suggestion? Thanks in advance !
what version did you download? the latest installs file for me.
Actually is 5.4.2.2
Just installed Concrete5 to my own site. I didn't resolve the problem reported but I had to do some workaround to it:
1) Executed the schema.sql from mySql in phpAdmin with copy and paste and it has executed well;
2) Edited the install.php to not check the presence of tables in the mySql db and re-uploaded it in place of the original one;
3) Executed the sample_content.sql;
4) Relaunched the installation
All is working fine, now. It was just a matter of copy/paste/edit files, not so simple but quite feasible. Now working on graphical side - any suggestion for a free good theme?
;-)
1) Executed the schema.sql from mySql in phpAdmin with copy and paste and it has executed well;
2) Edited the install.php to not check the presence of tables in the mySql db and re-uploaded it in place of the original one;
3) Executed the sample_content.sql;
4) Relaunched the installation
All is working fine, now. It was just a matter of copy/paste/edit files, not so simple but quite feasible. Now working on graphical side - any suggestion for a free good theme?
;-)
