FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Mo' Betta PostgreSQL errors during install
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Mo' Betta PostgreSQL errors during install [message #11289] Thu, 26 June 2003 00:04 Go to next message
joedaddy is currently offline  joedaddy   United States
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
Re: Mo' Betta PostgreSQL errors during install [message #11290 is a reply to message #11289] Thu, 26 June 2003 01:10 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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
Re: Mo' Betta PostgreSQL errors during install [message #11293 is a reply to message #11289] Thu, 26 June 2003 02:54 Go to previous messageGo to next message
joedaddy is currently offline  joedaddy   United States
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
Re: Mo' Betta PostgreSQL errors during install [message #11303 is a reply to message #11293] Thu, 26 June 2003 12:53 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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
Re: Mo' Betta PostgreSQL errors during install [message #11360 is a reply to message #11289] Thu, 26 June 2003 18:59 Go to previous messageGo to next message
magenta is currently offline  magenta   United States
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...
icon8.gif  Re: Mo' Betta PostgreSQL errors during install [message #11553 is a reply to message #11360] Mon, 07 July 2003 07:41 Go to previous messageGo to next message
lstep is currently offline  lstep   France
Messages: 50
Registered: June 2003
Karma: 0
Member

Same problem here. And I'm aboslutely *sure* I deleted all of the table after each failed installation. I guess the index is being created two times.
Re: Mo' Betta PostgreSQL errors during install [message #11615 is a reply to message #11553] Wed, 09 July 2003 14:33 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Are you also using PostgreSQL 7.2.1?

FUDforum Core Developer
Re: Mo' Betta PostgreSQL errors during install [message #11638 is a reply to message #11615] Wed, 09 July 2003 22:09 Go to previous messageGo to next message
lstep is currently offline  lstep   Israel
Messages: 50
Registered: June 2003
Karma: 0
Member

prottoss wrote on Wed, 09 July 2003 16:33

Are you also using PostgreSQL 7.2.1?


Yes, I'm using PostgreSQL 7.2.1, the official package from the Debian distribution.
Re: Mo' Betta PostgreSQL errors during install [message #11658 is a reply to message #11638] Thu, 10 July 2003 22:22 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Since I cannot replicate the problem with PostgreSQL 7.3 I must assume this is a bug with older PostgreSQL releases.

FUDforum Core Developer
Re: Mo' Betta PostgreSQL errors during install [message #11944 is a reply to message #11289] Wed, 23 July 2003 11:59 Go to previous messageGo to next message
meffist is currently offline  meffist   Poland
Messages: 1
Registered: July 2003
Location: Poland
Karma: 0
Junior Member
Thi's problem with postgresql change fud25_ to fud25 for example.
I think that's work.
R.
Re: Mo' Betta PostgreSQL errors during install [message #11947 is a reply to message #11944] Wed, 23 July 2003 12:54 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Actually the cause of the problem are overly long index names, this is something I've fixed for the upcomming 2.5.1 release.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Stuck on step 2 installation for version 2.3.8
Next Topic: Non registered error
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 07 05:05:15 GMT 2024

Total time taken to generate the page: 0.15149 seconds