MySQL version ’Hidden topics’ 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=17856
Printed Date: 13 April 2026 at 6:06pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: MySQL version ’Hidden topics’ error
Posted By: Mikey
Subject: MySQL version ’Hidden topics’ error
Date Posted: 11 January 2006 at 10:44pm
|
Hello again there Mr -BoRg- sir, I've been giving the forum a right rigarous testing and have come across another error for your attention, Version is the MySQL version, when logged in as admin and clicking the menu item 'Hidden Topics' i receive this error...
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51
Driver][mysqld-4.0.21-debug]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 'SELECT Topic_ID FROM tblThread WHERE
tblThread.Hide=-1)))ORDER
/wwwv8_test/pre_approved_topics.asp, line 310 This was after a complete clean error free install of the the forum.
------------- Handyman man? |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 12 January 2006 at 11:09am
|
Thanks for this, I'll look into it. mySQL does use slightly different syntax, and also the myODBC driver does some very strange things that you have to work around, so I imagine that the mySQL version will be the least stable. If you find anymore in the mySQL version please let me know as I want to get all SQL compatible with mySQL. ------------- 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: WebWiz-Bruce
Date Posted: 13 January 2006 at 1:26pm
|
I've found the problem you are having. From the error message it looks like you are using mySQL 4.0 which does not support sub quires. The mySQL server version of Web Wiz Forums requires mySQL 4.1 or above which does support sub quires. ------------- 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 |