err_mySQL_get_birthdays

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
stenol Members Profile Find Members Posts Newbie Joined: 21 March 2006 Status: Offline Points: 3	Post Options Post Reply Quote stenol Report Post Thanks(0) Quote Reply Topic: err_mySQL_get_birthdays 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 21 March 2006 at 6:10pm
	What version of mySQL are you using?

stenol Members Profile Find Members Posts Newbie Joined: 21 March 2006 Status: Offline Points: 3	Post Options Post Reply Quote stenol Report Post Thanks(0) Quote Reply Posted: 21 March 2006 at 6:15pm
	My version is 4.0.26

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.

stenol Members Profile Find Members Posts Newbie Joined: 21 March 2006 Status: Offline Points: 3	Post Options Post Reply Quote stenol Report Post Thanks(0) Quote Reply Posted: 21 March 2006 at 6:57pm
	tanks for your help

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

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.