Posted on: 10/09/03 01:08am
By: thedude
Hi Gang.
I'm having this funny issue. I'm working on reinstalling the whole GL system from the Old 1.3.7sr1 to 1.3.8 since i have to rebuild my machine from scratch. For some reason it gave me this funny error with the data base. What I was wondering whether this is because of incompatibility with the old MySQL or something else. Never have much issue when I was installing for 1.3.7. Any thought? Please advise. Thanks..
The Dude
Re:GL 1.3.8 issue with mySQL 3.23.53
Posted on: 10/09/03 03:50pm
By: Dirk
And what was the \"funny error message\", please? Did you run the install script to upgrade your database?
bye, Dirk
Re:GL 1.3.8 issue with mySQL 3.23.53
Posted on: 10/13/03 12:00am
By: thedude
Hi Dirk.
Here is the error message..
1064: You have an error in your SQL syntax near '( id int(10) unsigned NOT NULL auto_increment, ipaddress varchar(15) NOT N' at line 2
BTW, which install script are you referring to? I ran whatever the install script that come with the 1.3.8 fresh install...
Also, sorry Dirk. For whatever reason I forgot to paste the error message.
Any thought? Thanks for your help man...
The Dude
Re:GL 1.3.8 issue with mySQL 3.23.53
Posted on: 10/13/03 01:59pm
By: Dirk
[QUOTE BY= thedude] BTW, which install script are you referring to? I ran whatever the install script that come with the 1.3.8 fresh install...[/QUOTE]
You said you were upgrading from 1.3.7 to 1.3.8. To update the database, you will need to run the install script over your 1.3.7 database (with the upgrade database option, obviously).
Did you get the error when you tried to do that? In that case it looks like you did not replace all the 1.3.7 files properly. I'd suggest you drop the database again, make sure you're only using files from 1.3.8, restore your 1.3.7 backup and run the install script over it again.
bye, Dirk
Re:GL 1.3.8 issue with mySQL 3.23.53
Posted on: 10/16/03 08:04pm
By: Anonymous (thedude)
Hi Dirk..
Actually what I meant was that I have to reinstall everything from scratch. So the error that I got is when I'm doing the installation from scratch. Comment? Thanks for your help Dirk..
TD