UBB.Developers Forums UBB.threads 6 Bug Reports New board

A forum with 12 threads and 92 posts is noted "New board".
I tried to edit one message and modify it, in the hope to fix the problem, without success.
The data base was created by the perl version (5.08 => 5.1.2)

Do you have the PERL version running off of this same database? If so, is it working ok there? Was the board created by the PHP scripts?

Can't see why this would happen right now. It should only say New Board if there is no Last_Post time. Are you familiar with mysql? Can you check the Bo_Last_Post field for that particular board and see if it has an entry?

- A perl version is running on the same server. it displays the number of threads and posts + new board (I have just relalized that right now)
- The board was created by the perl scripts (since 5.07)
- Bo_Last = 0. There are entries.

( the field name in the w3t_boards table is Bo_last and not Bo_Last_Post)

Probably a glitch in one of the alterate tables scripts I didn't see

My mistake, it shouldn't be Bo_Last_Post, so you are ok there.

Have all of the posts on this board come from the PHP version? For some reason Bo_Last isn't getting updated when a post has been made. Anything special about your board setup? Like do you have dateslip turned off?

There is one other place that might be causing this problem. The only time the Bo_Last field is updated is if the post is approved, meaning full moderation is not turned on. Are you using full moderation on this board? Just need any details you can think of. Any problems with other forums, or just this one?

I think I guess what happened: It's a board where all the posts was created on another one and then moved and since that operation there are no new posts.

-The forum is not moderated-

Edited by Sharif on 11/20/00 02:32 PM (server time).

Ah, that would do it. Right now when you move a post it doesn't update the Bo_Last time.

I'll call you speedy Scream []/w3timages/icons/smile.gif[/]

Too bad the last_post is not updated. We need to perpare some posts in another board with access to nobody before to submit them.
The reason for that is there's not a "publish date". I mean we prepare the posts when "when it makes sense" we submit them. If we can have this publish date field it would be very helpful to keep a board "active" in holidays, since the posts are ready to be displayed []/w3timages/icons/smile.gif[/].

It's not too hard to do the mods. The problem is there are a lot of scripts to change I think and the updates will become tricky

[]/w3timages/icons/smile.gif[/]I do plan on fixing this so it does update the Bo_Last field. It's just one of those things that keeps slipping my mind[]/w3timages/icons/crazy.gif[/]. I'll try to add it in for the next beta release and get it fixed in the PERL version as well.

Great news speedy!
I presume we have just to add Bo_Last = $date in domovethreads.

To answer my needs (moving threads at a given date) I think a cron script will do the job.

You could do that if you wanted your threads that you are moving to have the current time. The problem is, if you use this on old threads, then even though they may have been posted several weeks ago, the Last Post would be set to the current time.

What I will do is query the B_Last_Post from the parent post of the thread that is being moved and update the target board with that date, but only if it's greater than the date that is already there.

Of course there is one more thing to think about. When you move a thread it does keep it's actual posted time. So, if you prepare a post on Wednesday that you won't actually be moving over until Saturday it will still keep Wednesday's date once it is moved. So, if you do this from cron then you might want to add a little query that updates the date of the post to the current date as well.

Hmmm, I'm afraid you're right []/w3timages/icons/wink.gif[/]