5.4.1 install - getting 1064 error
Permalink
Hi, I tried unsuccessfully to upgrade from 5.4.0.5 to 5.4.1 using the dashboard and the content disappeared.
No biggie, the site was barely started anyway and I strongly suspect it was my fault for not reading the instructions properly, so I decided to do a clean install.
I deleted all the concrete directories and deleted the database completely.
Then I uploaded concrete, recreated the DB and altered the folder permissions for /config, /packages and /files so when I wen to the installation screen I got all the green ticks.
I entered the DB details on the right of the screen and I am getting this message:
* 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 '\'0000-00-00 00:00:00\', uID INTEGER(10) UNSIGNED, atID ' at line 4] in EXECUTE("CREATE TABLE AttributeValues ( avID INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, akID INTEGER(10) UNSIGNED, avDateAdded DATETIME NOT NULL DEFAULT \'0000-00-00 00:00:00\', uID INTEGER(10) UNSIGNED, atID INTEGER(10) UNSIGNED, PRIMARY KEY (avID) );")
Can anyone tell me what I need to do pls.
Thanks
Allison
WHOOPS! Update:
I just changed localhost to Localhost and now it's telling me this:
There are already 9 tables in this database. Concrete must be installed in an empty database.
But I just created the database...
Any ideas?
Thanks
A
No biggie, the site was barely started anyway and I strongly suspect it was my fault for not reading the instructions properly, so I decided to do a clean install.
I deleted all the concrete directories and deleted the database completely.
Then I uploaded concrete, recreated the DB and altered the folder permissions for /config, /packages and /files so when I wen to the installation screen I got all the green ticks.
I entered the DB details on the right of the screen and I am getting this message:
* 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 '\'0000-00-00 00:00:00\', uID INTEGER(10) UNSIGNED, atID ' at line 4] in EXECUTE("CREATE TABLE AttributeValues ( avID INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, akID INTEGER(10) UNSIGNED, avDateAdded DATETIME NOT NULL DEFAULT \'0000-00-00 00:00:00\', uID INTEGER(10) UNSIGNED, atID INTEGER(10) UNSIGNED, PRIMARY KEY (avID) );")
Can anyone tell me what I need to do pls.
Thanks
Allison
WHOOPS! Update:
I just changed localhost to Localhost and now it's telling me this:
There are already 9 tables in this database. Concrete must be installed in an empty database.
But I just created the database...
Any ideas?
Thanks
A
Sign into the database using PhpMyAdmin if available and make sure it did not already create any tables. If it did, select all the tables and "drop" all of them. Then try the install again.
Hi,
Thanks, I just tried that but I am getting the 1064 error again now.
I have repeated the process od dropping the tables but still the same.
Thanks, I just tried that but I am getting the 1064 error again now.
I have repeated the process od dropping the tables but still the same.
Are you on a cpanel or plesk based server? What version of Mysql do you have installed?
Hi, It's CPanel hosting but I don't have the full (WHM??) access, just normal user access to it.
It's weird, I managed to install the old version ok.
Cheers
A
It's weird, I managed to install the old version ok.
Cheers
A
If it's any help you can see the server details here:
http://www.wendybramall.co.uk/serverinfo.php...
Thanks
Al
http://www.wendybramall.co.uk/serverinfo.php...
Thanks
Al
Thank You 1Webco for sorting the install for me.
It seems to be working fine now!
Cheers
Allison
:)
It seems to be working fine now!
Cheers
Allison
:)
I found a similar problem and resolved it to a mis-formatted SQL file.
If the install partially completes, the database will be corrupt. It will have to be dropped/re-created to attempt a subsequent install.
In the Plesk world (and many other shared-hosting environments), MySQL is accessible @ localhost from PHP. Remeber PHP in this case is a server-side-script.
you can see my post / experience here:
http://www.concrete5.org/community/forums/installation/trouble-inst...
If the install partially completes, the database will be corrupt. It will have to be dropped/re-created to attempt a subsequent install.
In the Plesk world (and many other shared-hosting environments), MySQL is accessible @ localhost from PHP. Remeber PHP in this case is a server-side-script.
you can see my post / experience here:
http://www.concrete5.org/community/forums/installation/trouble-inst...
