FUDforum: FUDforum 3.0+ » fud_thread_view pos field and auto

Home » FUDforum Development » FUDforum 3.0+ » fud_thread_view pos field and auto_increment

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

fud_thread_view pos field and auto_increment [message #30907]

Mon, 20 March 2006 15:41

idofud

Messages: 7
Registered: March 2006

Karma:

Junior Member

Hi,
after spending lots of time debugging a problem with a forum, version 2.6.0 (bundle with egroupware)
i notice that on fud_thread_view table , the pos field is auto_increment.

then when you insert, ou delete a new thread on a forum, the table is empty forthe forum
delete from fud_thread_view where forum_id=2 for exmaple
then thread are reselected from fud_thread and inster and the a new pos and page are calcultaed with ceiling function.

and the same goes for the consistency checker.

my problem is that after some time, the page number became greater than 1, leading to for exmaple 4 ou 5 for every thread.

when the table is deleted for a forum, then record are re inserted, the pos column is not specified leading to mysql to auto_increment it.
but then after you 've done it some time, the auto_increment goes up and up, leading to a bad page number.

shouldn't the auto_increment be resetted after sometime?
is it on purpose?

what could cause the page column to all be 4 (for exmaple) instead of 1 (leading to the thread list of a forum being empty)

if i run the consistency checker it will set all page number to 4 because it is based on the pos column, which became gretaer and greater the more you delete a thread.

any hint very welcome,

i keep on correcting it every weeks.
thanks.

Report message to a moderator

[Message index]

		fud_thread_view pos field and auto_increment By: idofud on Mon, 20 March 2006 15:41
		Re: fud_thread_view pos field and auto_increment By: Ilia on Mon, 20 March 2006 16:43
		Re: fud_thread_view pos field and auto_increment By: idofud on Mon, 20 March 2006 21:18
		Re: fud_thread_view pos field and auto_increment By: Ilia on Tue, 21 March 2006 14:25

Previous Topic:	LOCK TABLES
Next Topic:	Problems Upgrading

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 10 03:45:27 GMT 2024

Total time taken to generate the page: 0.04187 seconds