FUDforum: How To » Reimport Causing Indexing Problems

Home » FUDforum » How To » Reimport Causing Indexing Problems

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

Reimport Causing Indexing Problems [message #12289]

Sun, 03 August 2003 00:19

master of substance

Messages: 6
Registered: August 2003

Karma:

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?

Report message to a moderator

[Message index]

		Reimport Causing Indexing Problems By: master of substance on Sun, 03 August 2003 00:19
		Re: Reimport Causing Indexing Problems By: Ilia on Sun, 03 August 2003 01:23
		Re: Reimport Causing Indexing Problems By: master of substance on Sun, 03 August 2003 02:12
		Re: Reimport Causing Indexing Problems By: Ilia on Sun, 03 August 2003 16:16
		Re: Reimport Causing Indexing Problems By: master of substance on Wed, 06 August 2003 17:57
		Re: Reimport Causing Indexing Problems By: Ilia on Wed, 06 August 2003 18:09

Previous Topic:	Confusion over inheritance and permissions
Next Topic:	add forums / groups to FUDForum directly through MySQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 07 18:39:46 GMT 2024

Total time taken to generate the page: 0.05845 seconds