Web Wiz Forums - sql error

Print Page | Close Window

sql 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=18927
Printed Date: 12 April 2026 at 5:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: sql error

Posted By: spanky_n_va
Subject: sql error
Date Posted: 24 March 2006 at 7:48pm

Just ran the mysql install, said it completed successfully and i looked and all tables are there, but i get this error when i try to go to the main forum page:

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_get_birthdays
File Name:- default.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[MySQL][ODBC 3.51 Driver][mysqld-4.0.24-max-log]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 '(tblAuthor.DOB) = 24 ORDER BY tblAuthor.Author_ID DESC' at line

any thoughts on fixin this??

Replies:

Posted By: WebWiz-Bruce
Date Posted: 27 March 2006 at 11:28am

The version of mySQL you are using, looks like, from the error message, is version 4.0.24

You need to use mySQL version 4.1 or above to run the mySQL version of Web Wiz Forums.