Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 12:32 pm EDT

Geeklog Forums

static pages draft_flag and template_flag


Status: offline

1000ideen

Forum User
Full Member
Registered: 08/04/03
Posts: 1298
I seem to have a similar problem like here:
http://www.geeklog.net/forum/viewtopic.php?showtopic=91982
http://www.geeklog.net/forum/viewtopic.php?showtopic=91681

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) {
  ["sql"]=>
  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"
  ["ignore_errors"]=>
  int(0)
  ["result"]=>
  bool(false)
}
 


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

Status: offline

Dirk

Site Admin
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
 Quote

All times are EDT. The time is now 12:32 pm.

  • 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