Serendipity Forums

I have find, that when I open an Admin panel (serendipity_admin.php) Serendipity try to create a tables. PostgreSQL has this output every time:

NOTICE: CREATE TABLE will create implicit sequence "serendipity_dma_forum_uploads_uploadid_seq1" for serial column "serendipity_dma_forum_uploads.uploadid"
ERROR: relation "serendipity_dma_forum_uploads" already exists
ERROR: relation "postid" already exists
ERROR: relation "uploadid" already exists
ERROR: relation "realfilename" already exists
ERROR: relation "serendipity_dma_forum_users" already exists
ERROR: relation "authorid" already exists

Admin page work properly, but when I try to install Event Plugin - serendipity_admin.php?serendipity[adminModule]=plugins&serendipity[adminAction]=
addnew&serendipity[type]=event

I take an error:
While trying to retrieve the URL: http://www.emeraldcore.com/review/serendipity_admin.php?
The following error was encountered:
* Zero Sized Reply
and in a PostgreSQL output errors about creating tables repeat 3 times with final error:
LOG: unexpected EOF on client connection

I can't install any event plugin, but installation of Side Bar plugins work fine.
It seems like S9Y run installation script at every opened serendipity_admin.php, and with option "serendipity[type]=event" take an critical error...

Hi!

This table creation does not come from Serendipity itself, but from the "Forum" plugin you seem to have installed. I just looked at it, and its code sadly was buggy and tried to create the table time and again.

I fixed that and committed a change to version 0.13 of the plugin which should be available on spartacus / CVS during the next 48 hours.

However, about you installing plugins - which serendipity version are you using? And for which mirror did you configure the spartacus plugin? Try to use "netmirror.org" as your XML and file mirror!

Best regards,
Garvin

Hello! Thank you for quick answer!
You right, I am use a Forum plugin and Serendipity 1.0, running on PostgreSQL 8.1.
I am use netmirror.org in Spartacus configuration...

PS:
I try to make some tuning (add indexes adn constraints) for DB after install forum plugin, it must bring up some speed for plugin. Maybe it will be userfull...
I do not remember original structure of a tables, and post my current snapshot

ALTER TABLE serendipity_dma_forum_users OWNER TO serend;
-- Index: authorid
-- DROP INDEX authorid;
CREATE INDEX authorid
ON serendipity_dma_forum_users
USING btree
(authorid);


ALTER TABLE serendipity_dma_forum_uploads OWNER TO serend;


-- Index: fki_authorid

-- DROP INDEX fki_authorid;

CREATE INDEX fki_authorid
ON serendipity_dma_forum_uploads
USING btree
(authorid);

-- Index: fki_postid

-- DROP INDEX fki_postid;

CREATE INDEX fki_postid
ON serendipity_dma_forum_uploads
USING btree
(postid);

-- Index: realfilename

-- DROP INDEX realfilename;

CREATE INDEX realfilename
ON serendipity_dma_forum_uploads
USING btree
(realfilename);

-- Index: uploadid

-- DROP INDEX uploadid;

CREATE INDEX uploadid
ON serendipity_dma_forum_uploads
USING btree
(uploadid);


CREATE INDEX announce
ON serendipity_dma_forum_threads
USING btree
(announce);

-- Index: fki_boardid

-- DROP INDEX fki_boardid;

CREATE INDEX fki_boardid
ON serendipity_dma_forum_threads
USING btree
(boardid);

-- Index: lastposttime

-- DROP INDEX lastposttime;

CREATE INDEX lastposttime
ON serendipity_dma_forum_threads
USING btree
(lastposttime);

-- Index: threadid

-- DROP INDEX threadid;

CREATE INDEX threadid
ON serendipity_dma_forum_threads
USING btree
(threadid);

CREATE TABLE serendipity_dma_forum_posts
(
threadid int4 NOT NULL DEFAULT 0,
postid serial NOT NULL,
postdate int4 NOT NULL DEFAULT 0,
title varchar(80) NOT NULL DEFAULT ''::character varying,
message text,
flag int2 NOT NULL DEFAULT 0::smallint,
authorid int4 NOT NULL DEFAULT 0,
authorname varchar(48) NOT NULL DEFAULT ''::character varying,
editcount int4 NOT NULL DEFAULT 0,
CONSTRAINT serendipity_dma_forum_posts_pkey PRIMARY KEY (postid),
CONSTRAINT serendipity_dma_forum_posts_threadid_fkey FOREIGN KEY (threadid)
REFERENCES serendipity_dma_forum_threads (threadid) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE
)
WITH OIDS;
ALTER TABLE serendipity_dma_forum_posts OWNER TO serend;


-- Index: fki_threadid

-- DROP INDEX fki_threadid;

CREATE INDEX fki_threadid
ON serendipity_dma_forum_posts
USING btree
(threadid);

-- Index: postdate

-- DROP INDEX postdate;

CREATE INDEX postdate
ON serendipity_dma_forum_posts
USING btree
(postdate);

-- Index: postid

-- DROP INDEX postid;

CREATE INDEX postid
ON serendipity_dma_forum_posts
USING btree
(postid);