Welcome to Geeklog Saturday, November 27 2021 @ 03:24 am EST

Geeklog Forums

static pages draft_flag and template_flag


Status: offline

1000ideen

Forum User
Full Member
Registered: 04/08/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:
PHP 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: 12/01/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 EST. The time is now 03:24 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