serendipity_event_forum PostgreSQL error

[vastneonwolf]

Seems to be a re-occurring theme Cool plug-ins have problems with postgreSQL

The errors aren't the same now. I guess I'd have to remove the DB to get the same errors again.

Code: Select all

Warning: pg_query(): Query failed: ERROR: relation "postid" already exists in /var/vhost/writehand.org/html/include/db/postgres.inc.php on line 207
Error in CREATE INDEX postid ON serendipity_dma_forum_uploads (postid);
ERROR: relation "postid" already exists

dumps the whole DB about 3 or 4 times, then this is the last line.

Code: Select all

INSERT INTO serendipity_dma_forum_threads (boardid, threadid, title, replies, views, flag, announce, notifymails, lastauthorid, lastauthorname, lastpostid, lastposttime) SELECT boardid, threadid, title, replies, views, flag, announce, notifymails, lastauthorid, lastauthorname, lastpostid, lastposttime FROM serendipity_dma_forum_threads_tmp;

[garvinhicking]

Hi!

Those queries are executed when installing the plugins; duplicate index keys shouldn'T matter; this error should have only occured once, right? Because then you should basically be able to ignore it -- can it be that you had the plugin installed previously already and re-installed it?

Or does the error happen everytime?

Regards,
Garvin

[vastneonwolf]

It happens every time.
It seems to be related to the drawing of the admin menu, the error message (and dump of the DB) cut the admin menu in half.

[garvinhicking]

Hi!

Sadly the forum plugin is very complex, and I didn't code it. Maybe you could send a mail to the original author of it, so he might be able to solve it?

Best regards,
Garvin

[vastneonwolf]

Will do

Thanks again Garvin