Welcome to Geeklog, Anonymous Monday, November 25 2024 @ 06:07 pm EST
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:
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?
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 260array(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?
17
13
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
bye, Dirk
19
15
Quote
All times are EST. The time is now 06:07 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