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

Re: fud_thread_view pos field and auto_increment [message #30926 is a reply to message #30907]

Mon, 20 March 2006 21:18

idofud

Messages: 7
Registered: March 2006

Karma:

Junior Member

thanks for the answer.

but after some insert,delete on thread, the auto_increment give a pos number that the
update fud_thread_view set page=...,pos=..ceiling...
give page=4
with no thread at 1 2 or 3.

is it a normal behavior that page became 4 with no thread on page 1 2 3?

i know what i'm writing semms weird, but on a forum,
every week or two,
the only way ican make the thread list page of a forum (base on fud_thread_view table as far as i understood the code) not being blank, is to drop the table and re run consistency checker.

if i don't, each time i post a new thread or delete one in a forum, all thread on that forum have page=4 -or 5) and are not showing on the page.

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: Sat Nov 30 05:39:15 GMT 2024

Total time taken to generate the page: 0.05160 seconds