Static page plugin with 0.9

[Guest]

I got an error everytime I want to create a new static page:
Table 'blog.serendipity_staticpages' doesn't exist

Please advise.

[jhermanns]

have you fetched the newest version of the staticpage-plugin? if not, download this and unpack the contents into the plugins/ directory on your webserver.

[Guest]

Yes I believed so as I used Spartacus to install. These were the steps that I took.
- installed Serendipidity version 0.9
- configured and tested with couple of postings, just to make sure
- installed Event plugins:
a) Spartacus
b) Static Pages under Backend: Editor (Author: Marco Rinck, Garvin Hicking, David Rolston, Falk Doering; version: 3.12)
c) Static Pages under Backend: Features (Author: Marco Rinck, Garvin Hicking, David Rolston, Falk Doering; version: 3.12)

Then I am able to click on 'Static Pages' link under 'Entries' of the Admin interface.

- I clicked on the Go! button to create 'New Entry'
- But I will get these when I clicked on the 'Save' button:
ERROR:
INSERT INTO serendipity_staticpages (headline,permalink,pagetitle,articletype,publishstatus,content,markup,articleformat,articleformattitle,authorid,parent_id,show_childpages,pre_content,pass,filename,is_startpage,shownavi,showonnavi,timestamp,pageorder) values ('Headline text', '/pages/pagetitle.html', 'pagetitle', '1', '0', 'Content text', '1', '1', 'example.com :: ', '1', '0', '0', 'Pre-content text', '', 'none.html', '0', '1', '1', '1131260783', '1')

/ Table 'blog.serendipity_staticpages' doesn't exist

Under my blog database, I can see that I only have the 'serendipity_staticpages_types' table:

Code: Select all

mysql> show tables;
+-------------------------------+
| Tables_in_blog            |
+-------------------------------+
| serendipity_access            |
| serendipity_authorgroups      |
| serendipity_authors           |
| serendipity_category          |
| serendipity_comments          |
| serendipity_config            |
| serendipity_entries           |
| serendipity_entrycat          |
| serendipity_entryproperties   |
| serendipity_exits             |
| serendipity_groupconfig       |
| serendipity_groups            |
| serendipity_images            |
| serendipity_permalinks        |
| serendipity_plugincategories  |
| serendipity_pluginlist        |
| serendipity_plugins           |
| serendipity_references        |
| serendipity_referrers         |
| serendipity_staticpages_types |
| serendipity_suppress          |
+-------------------------------+
21 rows in set (0.00 sec)

mysql> select * from serendipity_staticpages_types;
+----+-------------+---------------------------------+-------+
| id | description | template                        | image |
+----+-------------+---------------------------------+-------+
|  1 | Article     | plugin_staticpage.tpl           |       |
|  2 | Aboutpage   | plugin_staticpage_aboutpage.tpl |       |
|  3 | Article     | plugin_staticpage.tpl           |       |
|  4 | Aboutpage   | plugin_staticpage_aboutpage.tpl |       |
+----+-------------+---------------------------------+-------+
4 rows in set (0.00 sec)

mysql>

Please advise.[/i]

[Col. Kurtz]

did you install the plugin twice? one time should be enough. its the same plugin, its just listed in different categories I think.

[Guest]

Well OK. But if the required table was *created*, the 2nd attempt to recreate it will definitely break the script or trigger an error msg.

But just to satisfy everybody, I deleted the whole installation, installed again, reconfigured everything and the *same error msg pops up*. While waiting for Falk to comment, I decided to create the required table by hand:

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)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

I am not sure if the primary key and others are correct or otherwise. But for now, the plugin works.

[garvinhicking]

You are right, our create table statement in the staticpage plugin since a f ew days was broken. It has now been fixed. I'm awfully sorry for your problems.

Regards,
Garvin