SQL Crash in V9.6
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=27558
Printed Date: 02 April 2026 at 2:16pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL Crash in V9.6
Posted By: marianux
Subject: SQL Crash in V9.6
Date Posted: 10 July 2009 at 5:40pm
|
Hi, i get an SQL Error when i try to resync statistics in forum.
Well, if i log into forum as moderator and i go to a forum page, then i can click on Tools for Moderator and click to resync forum statistics then i get an SQL Error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [MySQL][ODBC 5.1 Driver][mysqld-5.0.45]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY TBLPermissions.Author_ID DESC' at line 1 /forum/functions/functions_common.asp, line 1093 Well, i've found that error is located in function isModerator and when i get the SQL statement i see that it doesnt get any Forum Id.Any idea for fixing the issue
|
Replies:
Posted By: 123Simples
Date Posted: 10 July 2009 at 6:24pm
|
Unless I've missed something there is no resync forum statistics
------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: Nick-V
Date Posted: 10 July 2009 at 6:44pm
| 1) Forum Statistics and 2) Resync Topics and Posts Count both work fine for me. |
Posted By: 123Simples
Date Posted: 10 July 2009 at 7:09pm
I agree - perhaps the user needs to recheck a few things such as Retry and download the files - it may have been a corrupted upload Verify that the database is SQL or mysql ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Nick-V wrote:Posted By: 123Simples
Date Posted: 10 July 2009 at 7:10pm
|
Also to check that their server is running the correct version of drivers
------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: marianux
Date Posted: 10 July 2009 at 7:52pm
|
Hi, database is MySql.
If you log in as an user that is moderator then in forums_topics you can click in Tools for Moderator (well i dont know what is the text in english) and then a menu deploy with some options:
- Topics moderated
- Resync (or Update) statistics of Forum
- Close Forum
When i click in second option i get the error message i have posted in first post.
Its not a problem with drivers but an issue with the parameter that get function ismoderator() for TopicId.
I dont know if i can write SQL statement that fails, but i can tell you that SQL Statement in where section doenst work cause it set topic ID = nothing.
Hope you understand my poor english.
Thanks in advance.
|
Posted By: WebWiz-Bruce
Date Posted: 14 July 2009 at 9:39am
|
This error can not be replicated so more than linkly is a corrupted file in your installation. Try reinstalling 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 |