Status: offline

rav

Forum User
Chatty
Registered: 01/14/03
Posts: 37
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

Status: offline

rav

Forum User
Chatty
Registered: 01/14/03
Posts: 37
anyone?

Status: offline

rav

Forum User
Chatty
Registered: 01/14/03
Posts: 37
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'

Status: offline

DTrumbower

Forum User
Moderator
Registered: 01/08/03
Posts: 507
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?

Status: offline

rav

Forum User
Chatty
Registered: 01/14/03
Posts: 37
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?


Status: offline

DTrumbower

Forum User
Moderator
Registered: 01/08/03
Posts: 507
Quote by rav:
Should I be applying some of the earlier upgrades?



No. You by chance didn't run the sql script manually and then run the install script?

Status: offline

rav

Forum User
Chatty
Registered: 01/14/03
Posts: 37
Nope. I'll try moving the DB over again.

Status: offline

rav

Forum User
Chatty
Registered: 01/14/03
Posts: 37
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.