Web Wiz Support and Community Forums : sql error https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 17:46:53 +0000 Mon, 27 Mar 2006 11:28:16 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18927 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[sql error : The version of mySQL you are using,...]]> https://forums.webwiz.net/sql-error_topic18927_post102464.html#102464 Author: WebWiz-Bruce
Subject: 18927
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.
]]> Mon, 27 Mar 2006 11:28:16 +0000 https://forums.webwiz.net/sql-error_topic18927_post102464.html#102464 <![CDATA[sql error : Just ran the mysql install, said...]]> https://forums.webwiz.net/sql-error_topic18927_post102329.html#102329 Author: spanky_n_va
Subject: 18927
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??
]]> Fri, 24 Mar 2006 19:48:05 +0000 https://forums.webwiz.net/sql-error_topic18927_post102329.html#102329