Welcome to Geeklog, Anonymous Saturday, November 30 2024 @ 11:58 pm EST

Geeklog Forums

An SQL error has occured. Please see error.log for details.


Status: offline

enigmah

Forum User
Chatty
Registered: 07/22/02
Posts: 50
Have just upgraded from 1.3.9sr1 to 1.3.11

Everything works ok except the index.php page, error reads:


1054: Unknown column 'expire' in 'field list'. SQL in question: SELECT sid,tid,title,expire,statuscode FROM gl_stories WHERE (expire
This is the second site I have upgraded, the first one works fine. Any thoughts?

Thanks,
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Did you run the install script? The field it's complaining about is new in 1.3.10.

bye, Dirk
 Quote

Status: offline

enigmah

Forum User
Chatty
Registered: 07/22/02
Posts: 50
It is really strange. I upgraded both sites from 1.3.9.sr1 to 1.3.11. The last worked when I used 1.3.10 as current version in step 2. It does not work with the second site. Now I run the step 2 again with 1.3.9 as current version and it works. Thanks, Dirk.

Oh, I think I know the answer. 1.3.9.sr1 got a bit of both 1.3.9 and 1.3.10, so i have to upgrade the database twice for both version for it to work.
 Quote

thechadd

Anonymous
I get the same error, the database upgrade seemed successful when I ran the script?
 Quote

thechadd

Anonymous
nm, I had selected 1.3.10 as current version instead of 1.3.9 so it didn't add the new fields.

cheers!
 Quote

All times are EST. The time is now 11:58 pm.

  • 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