Welcome to Geeklog, Anonymous Monday, October 03 2022 @ 03:03 pm EDT

Geeklog Forums

SQL error upgrading to 1.4.1


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

Status: offline

Dirk

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

bye, Dirk
 Quote

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

All times are EDT. The time is now 03:03 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