Web Wiz Support and Community Forums : Strange Error when posting message. https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 09:44:56 +0000 Tue, 18 Apr 2006 09:10:30 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19337 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Strange Error when posting message. : Sorry I can&#039;t remember without...]]> https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104694.html#104694 Author: WebWiz-Bruce
Subject: 19337
Posted: 18 April 2006 at 9:10am

Sorry I can't remember without going through each and every individual file.]]> Tue, 18 Apr 2006 09:10:30 +0000 https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104694.html#104694 <![CDATA[Strange Error when posting message. : urr - i just found out that delete_post.asp...]]> https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104598.html#104598 Author: Scotty32
Subject: 19337
Posted: 17 April 2006 at 3:23pm

urr - i just found out that delete_post.asp doesnt use the function

could you tell me ALL the pages that use the "order by date" ?

so far i got:
functions_common.asp
delete_post.asp
]]> Mon, 17 Apr 2006 15:23:23 +0000 https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104598.html#104598 <![CDATA[Strange Error when posting message. : The only reason is that the part...]]> https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104519.html#104519 Author: WebWiz-Bruce
Subject: 19337
Posted: 16 April 2006 at 5:50pm

The only reason is that the part in question gets the stats for the topic, which means that it needs to get the details of the first post posted and the last post posted in the topic.

The ID field should be OK, as in theory the newer posts should have a new ID number. The only time it would mess up is if some how the latest post in a topic doesn't have the highest ID number, if a post has been edited or moved from another topic.
]]> Sun, 16 Apr 2006 17:50:20 +0000 https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104519.html#104519 <![CDATA[Strange Error when posting message. : do you mean becose the thread...]]> https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104517.html#104517 Author: Scotty32
Subject: 19337
Posted: 16 April 2006 at 5:39pm

do you mean becose the thread is ordered by date and the "last posted" works of ordering by ID?

i intend to change the thread ordering by ID too - so there should be no problems

am just curious as to why threads are ordered by date rather than id
since (as i stated) problems arise from ordering by date.

as far as am aware the higher the ID, the later it was posted, so i assume its impossible to acctually change the ordering of IDs when posting (eg you cant get a lower ID than any post before you)

but with ordering by date, if the server time messes up, you can get your post before the others in the thread (if it went back in time) or if it goes forward, newer posts will go before the older posts once the server time is corrected (i had this problem so i changed it on my V7)

i personally am not aware of any benefits for ordering by Date, but am assure you have a reason

(again, am not trying to be annoying, just trying to find out why you use Date, if theres a reason i'll keep it otherwise if its just something you've done id rather change it to ID)
]]> Sun, 16 Apr 2006 17:39:20 +0000 https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104517.html#104517 <![CDATA[Strange Error when posting message. : Looking at it again you could...]]> https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104494.html#104494 Author: WebWiz-Bruce
Subject: 19337
Posted: 16 April 2006 at 3:24pm

Looking at it again you could get away with using the ID number, but as you want the order to be from the first posted date to the last posted date, by using the ID number there is some room for problems if for whatever reason the dates of the posts don't exactly match the ID order.]]> Sun, 16 Apr 2006 15:24:26 +0000 https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104494.html#104494 <![CDATA[Strange Error when posting message. : However, the order by needs...]]> https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104491.html#104491 Author: Scotty32
Subject: 19337
Posted: 16 April 2006 at 2:48pm

Quote However, the order by needs to be by Message_date ASC, otherwise yoymay get problems with your forum displaying the incorrect post as thelast post in the forum etc.


but the thread id is the order of them being added - which is what i dont understand

if it goes 1,2,3 and not 1,3,2 - why use date, which i see as less concistant
]]> Sun, 16 Apr 2006 14:48:08 +0000 https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104491.html#104491 <![CDATA[Strange Error when posting message. : The strDBNoLock part is for performance...]]> https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104489.html#104489 Author: WebWiz-Bruce
Subject: 19337
Posted: 16 April 2006 at 2:32pm

The strDBNoLock part is for performance only and just tells the database not to lock the database while the read is taking place (a dababase dirty read)

You can take this out if you like as it will not make much difference.

However, the order by needs to be by Message_date ASC, otherwise yoy may get problems with your forum displaying the incorrect post as the last post in the forum etc.
]]> Sun, 16 Apr 2006 14:32:33 +0000 https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104489.html#104489 <![CDATA[Strange Error when posting message. : ok, just thought id give an updateto...]]> https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104486.html#104486 Author: Scotty32
Subject: 19337
Posted: 16 April 2006 at 1:59pm

ok, just thought id give an update

to try and get it working i started to play with the SQL (eg take out that strDBNoLock thing [what is that??] etc)

and i changed:
"ORDER BY " & strDbTable & "Thread.Message_date ASC;"

to
"ORDER BY " & strDbTable & "Thread.Thread_ID ASC;"
and it begain working with zero errors

i suggested/requested before that you order topics by Thread ID and NOT the thread date, as ive expirenced alot of server time problems where the time would change maybe forward or back a couple of hours, which totally screws with post orders, an older post can be ater a newer post

can you tell me why you order by date? as i see no reason why you dont order by ID
(i dont mean to sound arrogant or anyfin, i genuinely would like to know)

anyway i thought id give the fix if anyone else experinced the probelm
]]> Sun, 16 Apr 2006 13:59:01 +0000 https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104486.html#104486 <![CDATA[Strange Error when posting message. : am conviced it was my failed upgrade,...]]> https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104484.html#104484 Author: Scotty32
Subject: 19337
Posted: 16 April 2006 at 1:43pm

am conviced it was my failed upgrade, then bodged fix

i copied the function for updating the thread stats and put it in its own little page

and it now reports the correct line for the error 

        'Get the start and last post ID's from the database
        strSQL = "SELECT " & strDbTable & "Thread.Thread_ID " & _
        "FROM " & strDbTable & "Thread" & strDBNoLock & " " & _
        "WHERE " & strDbTable & "Thread.Topic_ID = "  & lngTopicID & " " & _
            "AND " & strDbTable & "Thread.Hide = " & strDBFalse & " " & _
        "ORDER BY " & strDbTable & "Thread.Message_date ASC;"
        
        'Set the cursor type property of the record set to Dynamic so we can navigate through the record set
        rsCommon.CursorType = 2
        
        'Set set the lock type of the recordset to adLockReadOnly 
        rsCommon.LockType = 1
        
        'Query the database
        rsCommon.Open strSQL, adoCon


does this help? or is it the database? and not my failed upgrade?
]]> Sun, 16 Apr 2006 13:43:32 +0000 https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104484.html#104484 <![CDATA[Strange Error when posting message. : Looks like a bug with SQL Server...]]> https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104482.html#104482 Author: WebWiz-Bruce
Subject: 19337
Posted: 16 April 2006 at 1:20pm

Looks like a bug with SQL Server 2000 then.

Although the article gives a hotfix for SQL Server, it doesn't say if anything can be changed in the SQL query to remedy this.
]]> Sun, 16 Apr 2006 13:20:08 +0000 https://forums.webwiz.net/strange-error-when-posting-message_topic19337_post104482.html#104482