Web Wiz Support and Community Forums : MySQL version ’Hidden topics’ error https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 18:06:55 +0000 Fri, 13 Jan 2006 13:26:45 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=17856 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[MySQL version ’Hidden topics’ error : I&#039;ve found the problem you...]]> https://forums.webwiz.net/mysql-version-hidden-topics-error_topic17856_post97078.html#97078 Author: WebWiz-Bruce
Subject: 17856
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.
]]> Fri, 13 Jan 2006 13:26:45 +0000 https://forums.webwiz.net/mysql-version-hidden-topics-error_topic17856_post97078.html#97078 <![CDATA[MySQL version ’Hidden topics’ error : Thanks for this, I&#039;ll look...]]> https://forums.webwiz.net/mysql-version-hidden-topics-error_topic17856_post96949.html#96949 Author: WebWiz-Bruce
Subject: 17856
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.
]]> Thu, 12 Jan 2006 11:09:04 +0000 https://forums.webwiz.net/mysql-version-hidden-topics-error_topic17856_post96949.html#96949 <![CDATA[MySQL version ’Hidden topics’ error : Hello again there Mr -BoRg- sir,I&#039;ve...]]> https://forums.webwiz.net/mysql-version-hidden-topics-error_topic17856_post96904.html#96904 Author: Mikey
Subject: 17856
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...

Quote

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51Driver][mysqld-4.0.21-debug]You have an error in your SQL syntax. Checkthe manual that corresponds to your MySQL server version for the rightsyntax to use near 'SELECT Topic_ID FROM tblThread WHEREtblThread.Hide=-1)))ORDER

/wwwv8_test/pre_approved_topics.asp, line 310

This was after a complete clean error free install of the the forum.

Tongue


]]> Wed, 11 Jan 2006 22:44:49 +0000 https://forums.webwiz.net/mysql-version-hidden-topics-error_topic17856_post96904.html#96904