Web Wiz Forums - err_mySQL_member

Print Page | Close Window

err_mySQL_member_count 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=18827
Printed Date: 12 April 2026 at 10:15pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: err_mySQL_member_count error

Posted By: Coper
Subject: err_mySQL_member_count error
Date Posted: 21 March 2006 at 2:34pm

mysql version error

Server Error in Forum Application
An error has occured while executing SQL query on database.
Please contact the forum administrator.

Support Error Code:- err_mySQL_member_count
File Name:- default.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[MySQL][ODBC 3.51 Driver][mysqld-4.1.9-max]Invalid use of group function

Replies:

Posted By: WebWiz-Bruce
Date Posted: 21 March 2006 at 2:44pm

Looks like the version of mySQL you are using has an issue with the query being used.

Try changing the SQL query at line 285 of the file default.asp to the following:-

    strSQL = "SELECT Count(" & strDbTable & "Author.Author_ID) AS memberCount " & _
    "FROM " & strDbTable & "Author;"