Table problem with static plugin

[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

[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

[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

[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

[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

[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

[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?

[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

[Linus]

Hi Garvin,
I've checked the apache error.log:
Allowed memory size of 8388608 bytes exhausted (tried to allocate 150 bytes)
Uhhm...

[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

[Linus]

Hi!
I've deleted some plugins which I don't need and now it works.
Thanks again Garvin

[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!