Web Wiz Forums - WWF Topics Not In Order

tblThread

Thread_ID	Author_ID	Message	Message_date	Show_signature	IP_addr	Hide
948	14	I'm returning to Leeds tomorrow. Anyone fancy a drinkypoo tonight?	02/01/2006 13:37:30	False	*...*	0
16581	24	It would appear so, what we need is to wipe everyones post count so then we'll get the "posting wars" that we had when we were like 14 when everyone would post stuff, just to get the next coloured star!!! That'd be soooo awsome!!! MrOli - Make it happen!	05/01/2006 14:38:34	False	*...*	0
16582	14	Chris it won't happen, because we're not like 14 anymore! nice thought though... The reason I come on is because I spend enough bloody time online, as I'm sure most people do and it takes like two seconds to check what is going down... if everyone else could be bothered, they'd post too.	05/01/2006 23:08:04	False	*...*	0
16586	1	quote: Originally posted by Chris It would appear so, what we need is to wipe everyones post count so then we'll get the "posting wars" that we had when we were like 14 when everyone would post stuff, just to get the next coloured star!!! That'd be soooo awsome!!! MrOli - Make it happen! We were discussing that the other night at The Nags... I've been meaning to upgrade the forum for a while now (because it looks sh*te), but it's going to take a while upgrading the original database. However, I was thinking of just starting from scratch, and leaving this as a reminder, then using the new forum as a new start to the year...and try and bring old HCCS people together again.	09/01/2006 13:34:11	False	*...*	0
16590	1	I'm a full paying member, so it's all good	12/01/2006 13:15:08	False	*...*	0
16636

Replies:

Posted By: dj air
Date Posted: 06 October 2006 at 9:52am

ive just cheked one i have done and also getting errors

http://www.trustedtradesmen.com/forum - www.trustedtradesmen.com/forum .

all the new posts are ok , its the old ones.

Posted By: iSec
Date Posted: 06 October 2006 at 11:08am

Wouldn't this get ordered if you just do a resync on the forum from the admin CP?

-------------
"When it gets dark enough, you can see the stars"
-Charles A. Beard

Posted By: dj air
Date Posted: 06 October 2006 at 11:25am

no i have tried that, i belive th eresync just does the Counts, not the actual topics.

ie counts posts, topics within the forums and updates the counted fields.

Posted By: WebWiz-Bruce
Date Posted: 06 October 2006 at 12:33pm

Posts are order by Message_Date, looking at the database it doesn't look like the posts have the correct dates

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: MortiOli
Date Posted: 07 October 2006 at 11:41am

How do you mean, Borg?

Do you reckon there's any way of fixing them?

Posted By: WebWiz-Bruce
Date Posted: 07 October 2006 at 12:02pm

It looks like when you moved the posts into the database the Message_date field is wrong.

The Message_date field store the time and date the message is posted, if it is incorrect then your posts will be in the wrong order.

The only way to fix this would be to go back to the Sntiz database and try again.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: MortiOli
Date Posted: 10 October 2006 at 9:41am

Unfortunately trying again didn't solve the problem.

I understand you don't support conversions, but if you could point out what's incorrect in the database, and a possible solution to this, I would greatly appreciate it.

I really want to move all my forums to WWF, and this is the last to be converted.

Many thanks.

Posted By: WebWiz-Bruce
Date Posted: 10 October 2006 at 10:45am

Looking at your database table at the top, if I get what you are saying correct, the dates under 'Message_Date' are incorrect.

The posts in the forums are ordered by 'Message_Date' so the first post is the newest date and the last date is the oldest date.

It seems to me that your conversion isn't populating the 'Message_Date' field with the correct date that the post was made, so the posts are not in the correct order.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: MortiOli
Date Posted: 10 October 2006 at 8:25pm

I just checked my Snitz forum, and the dates and times match the database table at the top, so the conversion has moved across everything correctly.

If I understand what you're saying, then the 'last post' should be the 4th post in the table above (as the first 4 posts are in order of date), but it's showing as the last one in the table.

Posted By: WebWiz-Bruce
Date Posted: 11 October 2006 at 12:55pm

I guess then that Snitz doesn't record the correct date and time when the post is made, which would be very odd.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: MortiOli
Date Posted: 11 October 2006 at 8:26pm

I'm not sure if I'm understanding exactly what you mean. I just checked both my WWF database and Snitz database, and the dates / times for the posts in this particular topic, match perfectly.

Is there anyway of running something so WWF reorganises the dates / times so it can read them?