Welcome to Geeklog, Anonymous Friday, June 20 2025 @ 09:58 am EDT
Geeklog Forums
Upgrade fails with SQL error - but error.log emtpy..
Status: offline
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
9
14
Quote
Status: offline
Forum User
Chatty
Registered: 01/14/03
Posts: 37
anyone?

8
9
Quote
Status: offline
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'
13
11
Quote
Status: offline
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?
8
11
Quote
Status: offline
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?

Should I be applying some of the earlier upgrades?
10
12
Quote
Status: offline
Forum User
Moderator
Registered: 01/08/03
Posts: 507
Quote by rav:
Should I be applying some of the earlier upgrades?
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?
8
8
Quote
Status: offline
Forum User
Chatty
Registered: 01/14/03
Posts: 37
Nope. I'll try moving the DB over again.
11
7
Quote
Status: offline
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.

I was able to upgrade some other test sites, but this one just won't upgrade.
11
9
Quote
All times are EDT. The time is now 09:58 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