Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - SQL Crash in V9.6
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL Crash in V9.6
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
marianux View Drop Down
Newbie
Newbie


Joined: 01 July 2009
Status: Offline
Points: 15 		Post Options Post Options   Thanks (0) Thanks(0)   Quote marianux Quote  Post ReplyReply Direct Link To This Post Topic: SQL Crash in V9.6
    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
Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192 		Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post Posted: 10 July 2009 at 6:24pm
Unless I've missed something there is no resync forum statistics
Visit 123 Simples Web Design
Back to Top
Nick-V View Drop Down
Senior Member
Senior Member


Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Nick-V Quote  Post ReplyReply Direct Link To This Post Posted: 10 July 2009 at 6:44pm
1) Forum Statistics and 2) Resync Topics and Posts Count both work fine for me.
Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192 		Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post Posted: 10 July 2009 at 7:09pm
Originally posted by Nick-V Nick-V wrote:

1) Forum Statistics and 2) Resync Topics and Posts Count both work fine for me.


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
Visit 123 Simples Web Design
Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192 		Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post Posted: 10 July 2009 at 7:10pm
Also to check that their server is running the correct version of drivers
Visit 123 Simples Web Design
Back to Top
marianux View Drop Down
Newbie
Newbie


Joined: 01 July 2009
Status: Offline
Points: 15 		Post Options Post Options   Thanks (0) Thanks(0)   Quote marianux Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.