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
5
7
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'
8
6
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?
4
7
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?
Should I be applying some of the earlier upgrades?
6
6
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?
5
5
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