| Author |
 Topic Search  Topic Options
|
WebG 
Groupie
Joined: 19 November 2004
Status: Offline
Points: 59
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: v8.02 Admin Error
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?
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
WebG
Groupie
Joined: 19 November 2004
Status: Offline
Points: 59
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 June 2006 at 12:15am |
 -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?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 June 2006 at 9:32am |
|
I shall look into the problem, that only seems to effect SQL Server.
|
|
|
|
Mikey
Senior Member
1979
Joined: 06 October 2003
Location: United Kingdom
Status: Offline
Points: 839
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Mikey
Senior Member
1979
Joined: 06 October 2003
Location: United Kingdom
Status: Offline
Points: 839
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
WebG
Groupie
Joined: 19 November 2004
Status: Offline
Points: 59
|
Post Options
Thanks(0)
Quote Reply
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' ;
|
|
