Page 1 of 1
Table problem with static plugin
Posted: Sat Apr 01, 2006 2:58 am
by BigDee
Gotts a issue with my static pages, cant create any. How do I fix???
INSERT INTO serendipity_staticpages (headline,permalink,pagetitle,articletype,publishstatus,language,content,markup,articleformat,articleformattitle,authorid,parent_id,show_childpages,pre_content,pass,filename,is_startpage,shownavi,showonnavi,timestamp,pageorder) values ('test', '/siteblog/index.php?/pages/pagetitle.html', 'pagetitle', '1', '0', 'en', 'test', '1', '1', 'Blogg:: ', '1', '0', '1', 'test', '', 'none.html', '0', '1', '1', '1143852496', '1')
/ Table 'BLOG.serendipity_staticpages' doesn't exist
If I create new table what are the setting fields???
Thanks
Re: Table problem with static plugin
Posted: Sat Apr 01, 2006 3:01 am
by garvinhicking
How did you install the static page plugin, and which version? Usually that table must have been created automatically by the plugin!
Which SQL DB are you using, which s9y version?
The SQL table layout is within the PHP plugin file, but actually we should investigate why it didn'T get created for you...
Best regards,
Garvin
Static aint Clinging
Posted: Sat Apr 01, 2006 4:26 am
by BigDee
Was using 0.9 when problem started, then I upgraded to the new beta and things got better with other areas of blog except four the static page thingy. Been trying to get it up four sometime now. All is ok except four the static area.
I uploaded the new static file and still says the same thing in newer version. 1.1beta {{{static 3.32}}}
Where is the plugin file easy to get ahold of???
I know how to create new TABLE, but dont know the field settings.
Thanks
Re: Static aint Clinging
Posted: Sat Apr 01, 2006 8:50 pm
by garvinhicking
The first thing you could try is to uninstall the staticpage plugin via the plugin admin. And then re-install the plugin. This should make the plugin try to recreate its table.
If that fails, try to create the table manually:
Code: Select all
CREATE TABLE `serendipity_staticpages` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) default '0',
`articleformattitle` varchar(255) NOT NULL default '',
`articleformat` int(1) default '1',
`markup` int(1) default '1',
`pagetitle` varchar(255) NOT NULL default '',
`permalink` varchar(255) NOT NULL default '',
`is_startpage` int(1) default '0',
`show_childpages` int(1) NOT NULL default '0',
`content` text,
`pre_content` text,
`headline` varchar(255) NOT NULL default '',
`filename` varchar(255) NOT NULL default '',
`pass` varchar(255) NOT NULL default '',
`timestamp` int(10) unsigned default NULL,
`authorid` int(11) default '0',
`pageorder` int(4) default '0',
`articletype` int(4) default '0',
`shownavi` int(4) default '1',
`showonnavi` int(4) default '1',
`publishstatus` int(4) default '1',
`language` varchar(10) default '',
PRIMARY KEY (`id`),
FULLTEXT KEY `staticentry_idx` (`headline`,`content`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
CREATE TABLE `serendipity_staticpages_types` (
`id` int(11) NOT NULL auto_increment,
`description` varchar(100) NOT NULL default '',
`template` varchar(255) NOT NULL default '',
`image` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
INSERT INTO `serendipity_staticpages_types` VALUES (1, 'Article', 'plugin_staticpage.tpl', '');
INSERT INTO `serendipity_staticpages_types` VALUES (2, 'Overview', 'plugin_staticpage_aboutpage.tpl', '');
HTH,
Garvin
Danke schön
Posted: Sun Apr 02, 2006 10:06 pm
by BigDee
All is working ok after using that info, except for the permalink option.
Permalink
Defines permalink for the URL. Needs the absolute HTTP path and needs to end with .htm or .html!
Do I use URL or Server PATH to add to html file???
Sofar its not writing to html file.
Thanks G
Re: Danke schön
Posted: Mon Apr 03, 2006 10:29 am
by garvinhicking
Hi!
About the permalink: You use a URL there like "/serendipity/staticpages/mypersonalpage.html". When you then call
http://yourblog/serendipity/staticpages ... lpage.html, the static page should show up.
Regards,
Garvin
Posted: Mon Apr 03, 2006 1:47 pm
by Linus
Hi!
I've got strange problems with staticpages-plugin here.
If I want to create an new staticpage I select new page then Go...
After all nothing happens. I only get the dropdown-box with new page and no button or an editor which shoul show up...
In staticpage-config all configs are set to yes and I'm using no wysiwyg-editor..
Any ideas why?
Posted: Mon Apr 03, 2006 1:52 pm
by garvinhicking
Linus: Could you show a screenshot?
Which version of the plugin and of s9y are you using? Are you using mod_rewrite? When you look at the HTML output of the page in your browser, does it stop before a closing </html>? Are there any error messages in the hTML? Did you check your Apache/HTTP Error log?
Regards,
Garvin
Posted: Mon Apr 03, 2006 2:19 pm
by Linus
Hi Garvin,
I've checked the apache error.log:
Allowed memory size of 8388608 bytes exhausted (tried to allocate 150 bytes)
Uhhm...
Posted: Mon Apr 03, 2006 2:55 pm
by garvinhicking
Hi!
This error can happen if you have too many plugins copied to your /plugins directory. Either you need to delete some of them, or you have to raise your memory limit, if possible...
Regards,
Garvin
Posted: Mon Apr 03, 2006 3:06 pm
by Linus
Hi!
I've deleted some plugins which I don't need and now it works.
Thanks again Garvin
Groovy
Posted: Tue Apr 04, 2006 5:38 am
by BigDee
Plugin static example url dont help much, plugin upgrades seem to always have one flaw to work around. Used your info url and ok.
{{{
/blog/index.php?/main/blogmain.html }}}
works 
All ok now, thannnnnnks againnnnnnnnnn!