Posted on: 01/02/05 03:18pm
By: enigmah
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,
An SQL error has occured. Please see error.log for details.
Posted on: 01/02/05 03:24pm
By: Dirk
Did you run the install script? The field it's complaining about is new in 1.3.10.
bye, Dirk
An SQL error has occured. Please see error.log for details.
Posted on: 01/02/05 03:37pm
By: enigmah
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.
An SQL error has occured. Please see error.log for details.
Posted on: 02/22/05 03:05pm
By: Anonymous (thechadd)
I get the same error, the database upgrade seemed successful when I ran the script?
An SQL error has occured. Please see error.log for details.
Posted on: 02/22/05 04:03pm
By: Anonymous (thechadd)
nm, I had selected 1.3.10 as current version instead of 1.3.9 so it didn't add the new fields.
cheers!