Posted on: 10/22/03 01:20am
By: rav
An SQL error has occured. Please see error.log for details.
I get the above error message after trying to upgrade a 1.3.7 to 1.3.8.
When I check the log file, it just has that "dummy entry". I double checked the permissions on that file, and they are good (check.php says that all 4 tests past with 0 errors). I also double checked that my DB user can login to the DB (even tried it as root).
Any tips?
Redhat 9
mysql 3.23.54
Apache 2.0.40
Re:Upgrade fails with SQL error - but error.log emtpy..
Posted on: 10/23/03 10:01pm
By: rav
anyone?
Re:Upgrade fails with SQL error - but error.log emtpy..
Posted on: 10/23/03 10:10pm
By: rav
Well I saw dirk reply in another thread about the sql messages not getting logged, and to make a change in the mysql.class.php to turn on displaying of sql messages. After doing that, and trying the upgrade, I get this:
1060: Duplicate column name 'is_default'
Re:Upgrade fails with SQL error - but error.log emtpy..
Posted on: 10/24/03 10:58am
By: DTrumbower
1060: Duplicate column name 'is_default'
You already have 1.3.8 database structure, if you are getting this error. Or at least you have some of the 1.3.8 structure.
Are you sure you didn't already upgrade?
Re:Upgrade fails with SQL error - but error.log emtpy..
Posted on: 10/24/03 07:17pm
By: rav
Hmm...werid. I did a dump of the DB, and moved it over to a new machine, and tried to upgrade it from there. (so I didn't jack up anything on my prod D. The DB should be in a 1.3.7 format. I downloaded the 1.3.8-1sr2 and attempted the upgrade.
Should I be applying some of the earlier upgrades?
Re:Upgrade fails with SQL error - but error.log emtpy..
Posted on: 10/24/03 11:05pm
By: DTrumbower
[QUOTE BY= rav]
Should I be applying some of the earlier upgrades?
[/QUOTE]
No. You by chance didn't run the sql script manually and then run the install script?
Re:Upgrade fails with SQL error - but error.log emtpy..
Posted on: 10/25/03 01:09am
By: rav
Nope. I'll try moving the DB over again.
Re:Upgrade fails with SQL error - but error.log emtpy..
Posted on: 10/25/03 01:25pm
By: rav
I'm am seriously at a loss here. I just can't seem to get around this problem!!! ggrrr!
I was able to upgrade some other test sites, but this one just won't upgrade.