Smafty

Anonymous
Can anyone help me out with this problem? Wed 10 Jan 2007 02:16:39 MST - 1054: Unknown column 'sp_help' in 'field list'. SQL in question: SELECT sp_title,sp_content,sp_hits,sp_date,sp_format,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,sp_help,sp_php,sp_inblock FROM gl_staticpage WHERE (sp_id = 'FTKRadio') AND (perm_anon >= 2) Wed 10 Jan 2007 02:16:47 MST - 1054: Unknown column 'sp_help' in 'field list'. SQL in question: SELECT sp_title,sp_content,sp_hits,sp_date,sp_format,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,sp_help,sp_php,sp_inblock FROM gl_staticpage WHERE (sp_id = 'FTKRadio') AND (perm_anon >= 2) Wed 10 Jan 2007 02:16:50 MST - 1054: Unknown column 'sp_help' in 'field list'. SQL in question: SELECT sp_title,sp_content,sp_hits,sp_date,sp_format,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,sp_help,sp_php,sp_inblock FROM gl_staticpage WHERE (sp_id = '20050406144557132') AND (perm_anon >= 2)

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Did you remember to run the install script to actually update the database?

bye, Dirk

Nameless

Anonymous
Hi! I have the same problem i new installation of GL 1.4.1 on ovh.org. I found losted record there "sp_help" in sql/mysql_tableanddata.php file. I added it handly by PHPAdmin and my site started.
See
sp_centerblock tinyint(1) unsigned NOT NULL default '0',
sp_help varchar(255) default '',
sp_tid varchar(20) NOT NULL default 'none',

Just little resolve for little error ;>