Posted on: 01/10/07 04:32am
By: Anonymous (Smafty)
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)
Re: SQL error upgrading to 1.4.1
Posted on: 01/10/07 08:26am
By: Dirk
Did you remember to run the install script to actually update the database?
bye, Dirk
Re: SQL error upgrading to 1.4.1
Posted on: 01/12/07 03:43pm
By: Anonymous (Nameless)
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 ;>