Welcome to Geeklog, Anonymous Saturday, March 14 2026 @ 09:43 am EDT
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
15
18
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'
17
16
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?
12
15
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 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?
. 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?
15
16
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?
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?
10
11
Quote
All times are EDT. The time is now 09:43 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
