err_mySQL_get_birthdays
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=18836
Printed Date: 12 April 2026 at 10:15pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: err_mySQL_get_birthdays
Posted By: stenol
Subject: err_mySQL_get_birthdays
Date Posted: 21 March 2006 at 5:57pm
|
This error occured when I try to go to forum.
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 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) = 21 ORDER BY tblAuthor.Author_ID DESC' at line |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 21 March 2006 at 6:10pm
| What version of mySQL are you using? |
Posted By: stenol
Date Posted: 21 March 2006 at 6:15pm
|
My version is 4.0.26 |
Posted By: WebWiz-Bruce
Date Posted: 21 March 2006 at 6:50pm
|
That's the problem, you need to be using MySQL 4.1 or above. MySQL 4.1 has been around quite a few years now so most hosts should have this version of version 5 which is also supported. |
Posted By: stenol
Date Posted: 21 March 2006 at 6:57pm
tanks for your help 
|