Posted on: 10/09/05 12:38pm
By: Anonymous (forge)
I've been having errors since trying to upgrade from 1.3.9 to 1.3.11. Here is what I'm now getting:
After installing, I get success messages and the permissions script tells me all is fine. When I go to the main page, I get a blank page with this message:
An SQL error has occured. Please see error.log for details.
When I check the log file, I get the following message:
Sun Oct 9 11:29:32 2005 - 1054: Unknown column 'archive_flag' in 'where clause'. SQL in question: SELECT tid FROM gl_topics WHERE archive_flag='1'
Someone please help me solve this problem
Unknown column 'archive flag' in 'where clause'
Posted on: 10/09/05 12:47pm
By: Dirk
Did you run the install script (in upgrade mode)? And if so, did you select 1.3.9 as your previous version? It would default to 1.3.10 ...
Better restore your database backup and run the install script again.
bye, Dirk
Unknown column 'archive flag' in 'where clause'
Posted on: 10/09/05 02:25pm
By: Anonymous (forge)
Dirk,
Thanks for the reply. Can you point me in the right direction on how to restore the database. I did a backup inside geeklog before I upgraded, but I don't know how to restore it. I don't see anything about being able to restore it in phpMyadmin or in geeklog itself.
Unknown column 'archive flag' in 'where clause'
Posted on: 10/09/05 02:48pm
By: Dirk
There's a README in your backups directory which explains how to restore backups from the command line.
In phpMyAdmin, go to the "SQL" tab and use the Browse button to upload your backup .sql file.
bye, Dirk