Welcome to Geeklog Tuesday, October 26 2021 @ 08:38 am EDT

Geeklog Forums

Unknown column 'archive flag' in 'where clause'


forge

Anonymous
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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

forge

Anonymous
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.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

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