Web Wiz Forums - MySQL: Active Users error

Print Page | Close Window

MySQL: Active Users 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=17857
Printed Date: 13 April 2026 at 4:31pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: MySQL: Active Users error

Posted By: Mikey
Subject: MySQL: Active Users error
Date Posted: 11 January 2006 at 10:58pm

Hello me again LOL

Another error for you to look into...

MySQL Version, Logged in as Admin...

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?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 12 January 2006 at 11:10am

Thanks again, I'll look into this

-------------
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: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.

-------------
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: Mikey
Date 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?

Posted By: WebWiz-Bruce
Date 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.

-------------
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