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

  New Posts New Posts RSS Feed - MySQL: Active Users error
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MySQL: Active Users 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: Active Users error
    Posted: 11 January 2006 at 10:58pm
Hello me again LOL

Another error for you to look into...

MySQL Version, Logged in as Admin...

Originally posted by Error Error wrote:


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 tblPermissions.Forum_ID FROM tblPermissions WHERE (tblP

/wwwv8_test/active_topics.asp, line 273


Smile


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:10am
Thanks again, I'll look into this
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:31pm
The error is coursed by an incorrect mySQL version, you are using version 4.0 which doesn't support sub queries.

For Web Wiz Forums to work you need mySQL 4.1 or mySQL 5, which both support sub queries.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
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 Posted: 13 January 2006 at 10:53pm
Woops, sorry bout that -BoRg-.
I'll ask if my hosts can update this as i'd like to keep testing the MySQL version of V8 as you have said this will be the version requiring the most testing lol Wink
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: 14 January 2006 at 12:04pm
Most hosts usually have mySQL 4.1 at the very least as it has been around for a few years now and is considered a very stable release of mySQL.

I have doen some quick tests with mySQL 5 and it seems that Web Wiz Forums works fine in that version as well.
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.