Welcome to Geeklog, Anonymous Saturday, November 23 2024 @ 01:57 am EST

Geeklog Forums

Upgrade fails with SQL error - but error.log emtpy..


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
 Quote

Status: offline

rav

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

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'
 Quote

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?
 Quote

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 DCool. 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?

 Quote

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?
 Quote

Status: offline

rav

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

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! Evil

I was able to upgrade some other test sites, but this one just won't upgrade.
 Quote

All times are EST. The time is now 01:57 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content