Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - MySQL version ’Hidden topics’ error
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MySQL version ’Hidden topics’ error
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Mikey View Drop Down
Senior Member
Senior Member

1979

Joined: 06 October 2003
Location: United Kingdom
Status: Offline
Points: 839 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mikey Quote  Post ReplyReply Direct Link To This Post Topic: MySQL version ’Hidden topics’ error
    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.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.

Tongue


Handyman man?
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: 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
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: 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.
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.