Posted on: 07/19/03 03:37pm
By: Leita
Hi there - I am upgrading to 1.3.8 from 1.3.7 and am getting this error after I choose the option to \'Upgrade Database\' (1.3.7):
1064: You have an error in your SQL syntax near \'( id int(10) unsigned NOT NULL auto_increment, ipaddress varchar(15) NOT NUL\' at line 1
I opened the error log and it displays ***dummy entry***
I tried to upgrade again and am getting this error:
1060: Duplicate column name \'is_default\'
Can someone help please? Thanks!
Re:1064: You have an error in your SQL syntax near
Posted on: 07/19/03 05:40pm
By: Dirk
[QUOTE BY= Leita]1064: You have an error in your SQL syntax near \'( id int(10) unsigned NOT NULL auto_increment, ipaddress varchar(15) NOT NUL\' at line 1[/QUOTE]
That\'s the update script trying to create the new gl_speedlimit table. Did you forget to update lib-database.php?
[QUOTE BY= Leita]I opened the error log and it displays ***dummy entry***[/QUOTE]
Translation: No errors yet (errors during the install are not recorded in error.log).
[QUOTE BY= Leita]I tried to upgrade again and am getting this error:
1060: Duplicate column name \'is_default\'[/QUOTE]
Yep, you now have a database that is half-way updated. The safest thing to do would be to use your database backup, make sure you\'ve replaced all new files and try again.
bye, Dirk
Re:1064: You have an error in your SQL syntax near
Posted on: 07/19/03 07:50pm
By: Leita
Ahh yes, for some reason, not all the new files uploaded. I kept getting errors when I was uploading.
I am certain all files are uploaded now - with the current date, but I am still getting the 1060 error.
Re:1064: You have an error in your SQL syntax near
Posted on: 07/20/03 03:41am
By: Dirk
[QUOTE BY= Leita]I am certain all files are uploaded now - with the current date, but I am still getting the 1060 error. [/QUOTE]
So did you restore your old database? As I said, your database is half-updated now, so it will choke on it when you try to run the update script.
bye, Dirk
Re:1064: You have an error in your SQL syntax near
Posted on: 07/20/03 03:17pm
By: Leita
Hi there ,)
Yes, I restored my old database and reuploaded everything.