|
Joined: May 2000
Posts: 125
Member
|
Member
Joined: May 2000
Posts: 125 |
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)
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
Guru
Joined: May 1999
Posts: 3,039 |
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?
UBB.threads Developer
|
|
|
|
Joined: May 2000
Posts: 125
Member
|
Member
Joined: May 2000
Posts: 125 |
- 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
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
Guru
Joined: May 1999
Posts: 3,039 |
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?
UBB.threads Developer
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
Guru
Joined: May 1999
Posts: 3,039 |
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?
UBB.threads Developer
|
|
|
|
Joined: May 2000
Posts: 125
Member
|
Member
Joined: May 2000
Posts: 125 |
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).
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
Guru
Joined: May 1999
Posts: 3,039 |
Ah, that would do it. Right now when you move a post it doesn't update the Bo_Last time.
UBB.threads Developer
|
|
|
|
Joined: May 2000
Posts: 125
Member
|
Member
Joined: May 2000
Posts: 125 |
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
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
Guru
Joined: May 1999
Posts: 3,039 |
[]/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.
UBB.threads Developer
|
|
|
|
Joined: May 2000
Posts: 125
Member
|
Member
Joined: May 2000
Posts: 125 |
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.
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
Guru
Joined: May 1999
Posts: 3,039 |
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.
UBB.threads Developer
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
Guru
Joined: May 1999
Posts: 3,039 |
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.
UBB.threads Developer
|
|
|
|
Joined: May 2000
Posts: 125
Member
|
Member
Joined: May 2000
Posts: 125 |
Hmmm, I'm afraid you're right []/w3timages/icons/wink.gif[/]
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 1,157
Joined: July 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|