FUDforum: FUDforum Installation Issues » Mo' Betta PostgreSQL errors during install

Home » FUDforum » FUDforum Installation Issues » Mo' Betta PostgreSQL errors during install

Show: Today's Messages :: Polls :: Message Navigator

Mo' Betta PostgreSQL errors during install [message #11289]

Thu, 26 June 2003 00:04

joedaddy

Messages: 7
Registered: June 2003

Karma: 0

Junior Member

On step 2 of the installation with 2.5.0RC6 (prottoss, the install.php you created seemed to hang on step one, so I got my admin to update PHP, zlib included, and used the one from the downloads page), I get

Warning: pg_query(): Query failed: ERROR: index named "fud25_group_members_index_group" already exists . in /home/morrisjm/xenotropic.net/boalt/install.php on line 109

and then further down in the page:

Failed to create table "fud_group_members" ("CREATE INDEX fud25_group_members_index_group_leader ON fud25_group_members (group_leader)"), SQL Reason: ERROR: index named "fud25_group_members_index_group" already exists

Although I had a previous (failed) installation of FUDForum, I had just dropped and recreated the database, and so with it all the tables and indices.

This is with PostgreSQL 7.2.1 and PHP 4.3.2

joe

Report message to a moderator

Re: Mo' Betta PostgreSQL errors during install [message #11290 is a reply to message #11289]

Thu, 26 June 2003 01:10

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

After clearing the database were you able to complete the installation process?

FUDforum Core Developer

Report message to a moderator

Re: Mo' Betta PostgreSQL errors during install [message #11293 is a reply to message #11289]

Thu, 26 June 2003 02:54

joedaddy

Messages: 7
Registered: June 2003

Karma: 0

Junior Member

No, I was just letting you know that I don't think the problem was any old cruft. I still can't install because of those errors, and as far as I can tell it's because the install is trying to create that index twice.

joe

Report message to a moderator

Re: Mo' Betta PostgreSQL errors during install [message #11303 is a reply to message #11293]

Thu, 26 June 2003 12:53

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

I absolutely cannot replicate the bug. I've installed a forum and then re-installed another forum on top of it and did not see the errors you are seeing.

I am using PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.1

FUDforum Core Developer

Report message to a moderator

Re: Mo' Betta PostgreSQL errors during install [message #11360 is a reply to message #11289]

Thu, 26 June 2003 18:59

magenta

Messages: 1
Registered: June 2003

Karma: 0

Junior Member

I'm having the exact same problem, also with PostgreSQL 7.2.1 and FUDforum build 20030626. I have never installed FUDforum before, so I'm absolutely positive the tables don't already exist.

Seems to be something wrong with FUDforum and Postgres 7.2.1. I'll try to convince my admin to upgrade to 7.3.1, but I don't think it's very likely to happen anytime soon...

Report message to a moderator