SQL error on install of 5.4.1.1

Permalink
I am trying to set up a new site using c5 5.4.1.1 and I get a SQL error:

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, PRIMARY KEY (cID, arHandle, gID, uID, btID) ); CREATE TABLE AreaGroups ( 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, agPermissions VARCHAR(64) NOT NULL, PRIMARY KEY (cID, arHandle, gID, uID) ); CREATE TABLE Areas ( arID INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, cID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, arHandle VARCHAR(255) NOT NULL, arOverrideCollectionPermissions TINYINT(1) NOT NULL DEFAULT 0...

I have tried saving the files schema.sql, no_sample_content.sql, as UTF-8 and taking out the first 2 line returns in the schema.sql. Nothing is working - still getting the error.

Any clues as to what is wrong? I have a dev site set up on another server and it is running fine, I will need to migrate over to this server to go live so i need a running copy of c5 by the end of the week.

envisage
 
droker replied on at Permalink Reply
I haven exactly the same prolem, I have tried all the fixes listed on here to no avail.

I dont have a ' in my site name either.

Any ideas?
envisage replied on at Permalink Reply
envisage
Are you installing on a Windows server? There is a conflict with MySQL on Windows. The table names are in Upper and lower case and windows needs to be all lower case. That is what solved the problem for me.
droker replied on at Permalink Reply
Nope Ubuntu Server 10.04

I can add the schema.sql manually to the database without any problems, but not with the install.php script.

Its really frustrating. I am using Drupal for sites at the moment, but Concrete looks so much easier.

Any other ideas?
envisage replied on at Permalink Reply
envisage
Try setting the "server name" as localhost not IP address of the server...
droker replied on at Permalink Reply
Thats what i have done, I have tried, localhost, 127.0.0.1 and the ip of the server.

I tried Localhost too.

Dean
envisage replied on at Permalink Reply
envisage
I am not familiar with Ubuntu Server set ups...if you haven't checked out this post it my shed some light on your situation:

http://www.concrete5.org/community/forums/installation/ubuntu-insta...

Don't give up on c5 - it is a great product!
droker replied on at Permalink Reply
Yep, I have looked at that.

I already host about 15 other drupal sites on there, and several wordpress ones as well. All of which installed to mysql perfectly on the first attempt

This seems to be a bug of some kind, but i have no idea how to trouble shoot it.

Thank you for the suggestions though.

Anyone else have any ideas?

Thanks
moldmaker replied on at Permalink Reply
Hello

I had same problem. I try new upload by FTP,Change parameter *.sql,*.ini,*.xml upload by asc mode.