Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 07:50 am EST
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)
9
9
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
Just little resolve for little error ;>
See
sp_centerblock tinyint(1) unsigned NOT NULL default '0',
sp_help varchar(255) default '',
sp_tid varchar(20) NOT NULL default 'none',
sp_help varchar(255) default '',
sp_tid varchar(20) NOT NULL default 'none',
Just little resolve for little error ;>
10
7
Quote
All times are EST. The time is now 07:50 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