s9y Admin panel - creating a tables at every opened page

[mef]

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...

[garvinhicking]

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

[mef]

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...

[mef]

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);