Welcome to Geeklog, Anonymous Thursday, July 25 2024 @ 05:39 am EDT

Geeklog Forums

static pages draft_flag and template_flag

Status: offline


Forum User
Full Member
Registered: 08/04/03
Posts: 1298
I seem to have a similar problem like here:

This is the error code when updating GL 1.7.0 to 1.7.2.
I just FTPed the new files of 1.7.1, 1.7.1sr1, 1.7.2:
Text Formatted Code
256 - 1054: Unknown column 'template_flag' in 'where clause' @ /www/system/databases/mysql.class.php line 260

array(3) {
  string(346) "SELECT sp_id,sp_title,sp_content,sp_format,created,modified,sp_hits,owner_id, group_id,perm_owner,perm_group,perm_members, perm_anon,sp_php,sp_inblock,sp_help FROM gl_staticpage WHERE (sp_centerblock = 1) AND (draft_flag = 0) AND (template_flag = 0) AND (sp_where = 0) AND ((sp_tid = 'none') OR (sp_tid = 'all')) AND (perm_anon >= 2) ORDER BY sp_id"

Disabling the static pages helps in the way that my site comes up again.

When was the draft_flag and template_flag introduced in MySQL? What can I do now?

Status: offline


Site Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Yeah sorry, I gave you wrong information: There were database changes between those Geeklog versions. Not in Geeklog itself, but in the bundled plugins, specifically the Static Pages plugin. You'll have to use the install script to do the upgrade.

bye, Dirk

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