Geeklog Forums

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

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

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.

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