Forum is messed

[Crowndefender]

For some reason my forum is messed up. I spoke to a pro at it and he said its not a PHP error that it could be my database
Is there maintainece going on that could mess it?

Can someone please help?
Thankyou

[Crowndefender]

Il explain in more detail if needed

[Ron]

You could start with what machine you're on, what forum software you're using, what kind of problems you're seeing, maybe a url. It would all be helpful.

[Crowndefender]

www.crowndefenders.com/forum

You would need to register.

Errors:
Post ive already read is showing as unread
Mark all forums read wont work
Threads ive made are coming up as though others posted them and my comment comes second
People are still showing online when they havent been for some time
Some people can post but the rest are getting this message
"You cannot make another post so soon after your last; please try again in a short while."
Even though they havent posted all day etc

[Crowndefender]

Thank you very much for the reply friend

[Crowndefender]

Any luck?

Can someone please help?

[Ron]

Did you recently install a new skin, or do anything out of the ordinary?

Did you recently change your domain name?
Did you go from whatever.com/forums to forum.whatever.com or any change like that at all?

Did you play with the cookie settings in your admin panel?

If I can't figure it out, your better bet might be to look for tech support at http://www.phpbb.com/phpBB/
since they deal with phpBB issues all the time, they might be able to help you more quickly.

Also, you could approve my membership on the forum...

[Ron]

Thanks for approving me.

I see that there are timestamps in the future. This would explain lots of problems that you're having. Perhaps the server you are on was accidentally set to the wrong date for a while? Perhaps you could open a ticket and ask support if that happened on your machine.

Other than that, I don't see anything very strange except that your skin selector doesn't seem to make a difference to what I see. Perhaps your skins are busted...

Good luck.

[Crowndefender]

Seems alot of forums are having this problem.
To do with time on the severs being changed. Thanks for your help

[Ron]

If that is what happened, it can probably be fixed... you''ll need to go through your phpBB posts table and find where the timestamp takes a sudden jump forward and then a sudden jump backward, determine how much time the machine was offset by (was it a day into the future? 12 hours? and then adjust the timestamps on those posts that fall between the two found above by the amount of the offset.

I know it sounds complicated, but it really isn't, but I don't want to go into more details unless this is found to be the actual cause.

Good luck.

[Ron]

Ok, feel free to delete my membership there.

[Crowndefender]

How do i contact my host? I never set the site up. Is Jaguart not my host?

[Ron]

Let's say you found post#123 to be the first affected and 195 to be the last affected, and let's say the timestamp was off by 1 hour (3600 seconds) if it was off by a day, the number would be 86400. (3600seconds * 24hours = 86400)

your sql statement might be something like this to fix it up:

THIS IS ONLY A SUGGESTION. I HAVE NOT TESTED THIS CODE IN YOUR SITUATION, USE AT YOUR OWN RISK. BE SURE TO BACKUP YOUR TABLE, AND THE WHOLE DATABASE, BEFORE TRYING SUCH A FIX.

Update phpbb_posts
set post_time = (post_time - 3600)
where post_id >= 123
and post_id <=195;

Good luck.

[Crowndefender]

Where do i find it to edit it?

And im trying to contact my host.Im guessing thats the problem

[Ron]

Yes, it looks like you're hosted with JaguarPC.