| Reimport Causing Indexing Problems [message #12289] |
Sun, 03 August 2003 00:19  |
master of substance
Messages: 6
Registered: August 2003
Karma: 0
|
Junior Member |
|
|
An upgrade from 2.3.8 to 2.5.2 bombed. (I'll post that error after things are back to working order.) So I uninstalled everything and deleted files and reinstalled 2.3.8 and then imported the datadump taken from just prior to maintenance work.
I see everything from the datadump, but when I start to post a new message I get a SQL error. pg_query(): Query failed: ERROR: Cannot insert a duplicate key into unique index fud23_msg_pkey
I'm using PostgreSQL 7.3.3 I have reindexed the table fud23_msg. I have dropped the constraint on fud23_msg_pkey and recreated the index, but the php code continues to want to reuse one of the message id's.
Any suggestions?
|
|
|
|
| Re: Reimport Causing Indexing Problems [message #12291 is a reply to message #12289] |
Sun, 03 August 2003 01:23  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
The old data import has a bug when dealing with PosgreSQL it does not set the new id for the primary key. Fortunately this problem is easily solved.
For all the forum tables that have an 'id' field do the following:
SELECT MAX(id) FROM TABLE_NAME;
SELECT setval('TABLE_NAME_seq_id', MAX_ID);
FUDforum Core Developer
|
|
|
|
|
|
| Re: Reimport Causing Indexing Problems [message #12301 is a reply to message #12299] |
Sun, 03 August 2003 16:16 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
I am glad that you were able to correct the problem, could you please tell me the nature of the problems you've experienced when you tried to upgrade from 2.3.8 to 2.5.2?
FUDforum Core Developer
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]