Welcome to Geeklog, Anonymous Thursday, June 20 2024 @ 01:39 am EDT

Geeklog Forums

Upgrade problem


Status: offline

micahmj11

Forum User
Junior
Registered: 10/11/02
Posts: 20
I am trying to upgrade my site from 1.3.11 to 1.4. After I backed up my db and files and uploaded the new files, I ran install.php. I selected upgrade databes in the first step and selected 1.3.11 in the second step. The next screen simply says:

1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( cid int(10) unsigned NOT NULL auto_increment, sid varcha

and I am stuck. Anyone able to help?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Make sure you've uploaded all the new files. Specifically, system/lib-database.php

bye, Dirk
 Quote

Status: offline

micahmj11

Forum User
Junior
Registered: 10/11/02
Posts: 20
Thanks, Dirk. That was apparently part of the problem. I reuploaded they system folder and it must not have all uploaded before. When I ran the install script again, after reinstalling the backup db, the database seems to update (a few new tables have been added), but I now get this message:

1060: Duplicate column name 'status'

What do you think?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
'status' is a new field for the gl_users table. It shouldn't exist in your old database. Can you check that, please? Did you install any hacks/add-ons that may have introduced such a field?

bye, Dirk
 Quote

Status: offline

micahmj11

Forum User
Junior
Registered: 10/11/02
Posts: 20
It does seem that there is a status field in my original users table. I don't know what it is for, but the value for all the records is null. Should I delete it and try the install script again.

EDIT: I went ahead and deleted the field...and it works now. As always, thank you Dirk for your help!
 Quote

All times are EDT. The time is now 01:39 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