Welcome to Geeklog, Anonymous Thursday, November 28 2024 @ 08:55 pm EST
Geeklog Forums
gl_staticpage
Mark
Anonymous
I'm just updrading from 1.3.9 to 1.3.10 and get the following error.
1146: Table 'geeklog.gl_staticpage' doesn't exist
There are no staticpage entries in the database. I could recreate the entry but I don't know what fields to use.
What do I need to do to create the missing entry?
1146: Table 'geeklog.gl_staticpage' doesn't exist
There are no staticpage entries in the database. I could recreate the entry but I don't know what fields to use.
What do I need to do to create the missing entry?
4
4
Quote
Status: offline
mthomas
Forum User
Full Member
Registered: 04/18/04
Posts: 148
Assuming you are using the default gl_ beginning to your tables... Run this Code on you SQL db. Or manually add using below as you template.
Code is from GeeKlog 1.3.10 (should be the same as 1.3.9x)
sp_id varchar(40) NOT NULL default '',
sp_uid mediumint(8) NOT NULL default '1',
sp_title varchar(128) NOT NULL default '',
sp_content text NOT NULL,
sp_hits mediumint(8) unsigned NOT NULL default '0',
sp_date datetime NOT NULL default '0000-00-00 00:00:00',
sp_format varchar(20) NOT NULL default '',
sp_onmenu tinyint(1) unsigned NOT NULL default '0',
sp_label varchar(64) default NULL,
group_id mediumint(8) unsigned NOT NULL default '1',
owner_id mediumint(8) unsigned NOT NULL default '1',
perm_owner tinyint(1) unsigned NOT NULL default '3',
perm_group tinyint(1) unsigned NOT NULL default '2',
perm_members tinyint(1) unsigned NOT NULL default '2',
perm_anon tinyint(1) unsigned NOT NULL default '2',
sp_centerblock tinyint(1) unsigned NOT NULL default '0',
sp_tid varchar(20) NOT NULL default 'none',
sp_where tinyint(1) unsigned NOT NULL default '1',
sp_php tinyint(1) unsigned NOT NULL default '0',
sp_nf tinyint(1) unsigned default '0',
sp_inblock tinyint(1) unsigned default '1',
PRIMARY KEY (sp_id),
KEY staticpage_sp_uid (sp_uid),
KEY staticpage_sp_date (sp_date),
KEY staticpage_sp_onmenu (sp_onmenu),
KEY staticpage_sp_centerblock (sp_centerblock),
KEY staticpage_sp_tid (sp_tid),
KEY staticpage_sp_where (sp_where)
) TYPE=MyISAM
Code is from GeeKlog 1.3.10 (should be the same as 1.3.9x)
Text Formatted Code
CREATE TABLE gl_staticpage (sp_id varchar(40) NOT NULL default '',
sp_uid mediumint(8) NOT NULL default '1',
sp_title varchar(128) NOT NULL default '',
sp_content text NOT NULL,
sp_hits mediumint(8) unsigned NOT NULL default '0',
sp_date datetime NOT NULL default '0000-00-00 00:00:00',
sp_format varchar(20) NOT NULL default '',
sp_onmenu tinyint(1) unsigned NOT NULL default '0',
sp_label varchar(64) default NULL,
group_id mediumint(8) unsigned NOT NULL default '1',
owner_id mediumint(8) unsigned NOT NULL default '1',
perm_owner tinyint(1) unsigned NOT NULL default '3',
perm_group tinyint(1) unsigned NOT NULL default '2',
perm_members tinyint(1) unsigned NOT NULL default '2',
perm_anon tinyint(1) unsigned NOT NULL default '2',
sp_centerblock tinyint(1) unsigned NOT NULL default '0',
sp_tid varchar(20) NOT NULL default 'none',
sp_where tinyint(1) unsigned NOT NULL default '1',
sp_php tinyint(1) unsigned NOT NULL default '0',
sp_nf tinyint(1) unsigned default '0',
sp_inblock tinyint(1) unsigned default '1',
PRIMARY KEY (sp_id),
KEY staticpage_sp_uid (sp_uid),
KEY staticpage_sp_date (sp_date),
KEY staticpage_sp_onmenu (sp_onmenu),
KEY staticpage_sp_centerblock (sp_centerblock),
KEY staticpage_sp_tid (sp_tid),
KEY staticpage_sp_where (sp_where)
) TYPE=MyISAM
5
6
Quote
All times are EST. The time is now 08:55 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