FUDforum: How To » Reimport Causing Indexing Problems

Home » FUDforum » How To » Reimport Causing Indexing Problems

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

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:

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

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 Sep 19 17:26:47 GMT 2024

Total time taken to generate the page: 0.04706 seconds