Print Page | Close Window

v8.02 Admin Error

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20143
Printed Date: 07 April 2026 at 8:12pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: v8.02 Admin Error
Posted By: WebG
Subject: v8.02 Admin Error
Date Posted: 01 June 2006 at 12:59pm
I tried a bulk CLOSE TOPIC admin feature, and received this error:
 

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near ','.
/forum/admin_archive_topics.asp, line 107
 
 
Here's what the SQL statement is that's being executed on that line:
 
UPDATE tblTopic, tblThread SET tblTopic.Locked=1 WHERE (tblTopic.Last_Thread_ID=tblThread.Thread_ID) AND tblThread.Message_date < '20060501 08:01:29' AND (tblTopic.Priority=0);
 
 
Does that look right to you?
 



Replies:
Posted By: WebWiz-Bruce
Date Posted: 01 June 2006 at 10:44pm
This problem effecting SQL Server should be fixed for 8.02, make sure you have replaced all ASP files with those from the latest version.

-------------
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: WebG
Date Posted: 02 June 2006 at 12:15am
Originally posted by -boRg- -boRg- wrote:

This problem effecting SQL Server should be fixed for 8.02, make sure you have replaced all ASP files with those from the latest version.
 
It was a clean install of 8.02.  No other 8.x files were present, and I installed in a new directory.  The only thing in there currently are 8.02 files.
 
Any other suggestions?
 


Posted By: WebWiz-Bruce
Date Posted: 02 June 2006 at 9:32am
I shall look into the problem, that only seems to effect SQL Server.

-------------
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: Mikey
Date Posted: 25 June 2006 at 3:22pm
Afternoon all,
I'm getting this error on V8.03 MSSQL, when batch locking topics.

-boRg- was this errors cause discovered?


-------------
Handyman man?


Posted By: WebWiz-Bruce
Date Posted: 26 June 2006 at 9:53am
This issue is still being looked into.

8.03 was a security release, to meet our 'under 24 hour turnaround' to fix security related issues, and not a planned release so this issue has not been addressed in this version.


-------------
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: Mikey
Date Posted: 26 June 2006 at 1:00pm
Not a problem mate, for now i'll do them by hand. you concentrate on the more important issues 

-------------
Handyman man?


Posted By: WebG
Date Posted: 08 December 2006 at 5:16am
Yes, I'm posting to an extremely old message.
 
But I have a fix!!!!!! for the problem, for those of you who are still experiencing difficulties bulk/batch-closing topics via SQL.
 
The code is supposed to read...
 
UPDATE  tblTopic SET tblTopic.Locked=1 from tblTopic, tblthread WHERE (tblTopic.Last_Thread_ID=tblThread.Thread_ID) AND tblThread.Message_date < 'YYYYMMDD HH:MM:SS' ;


Posted By: Ali Bilgrami
Date Posted: 29 January 2007 at 1:41pm
ok...now i know what it supposed to do...
but what is the change to make in the query? and boRg...any news from your side on this issue?


-------------
Lets!


Posted By: WebWiz-Bruce
Date Posted: 29 January 2007 at 7:43pm
This is already fixed in the latest version.

-------------
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: Ali Bilgrami
Date Posted: 30 January 2007 at 12:36am
i am using the latest version ... 8.05

-------------
Lets!


Posted By: Ali Bilgrami
Date Posted: 30 January 2007 at 12:50am
ok i tried again by downloading and uploading the file again...thought may be my installation was corrupted but still not working

-------------
Lets!


Posted By: WebG
Date Posted: 09 April 2007 at 10:38pm
Originally posted by -boRg- -boRg- wrote:

This is already fixed in the latest version.
 
Not saying that it isn't fixed, but please double-check your version, as I just double-checked the release code and the SQL statement still does not match the one that I have been using that works (as posted earlier in this old thread).   Thanks.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net