Help on DB issue!!
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=18783
Printed Date: 12 April 2026 at 7:19pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Help on DB issue!!
Posted By: Waterbearer
Subject: Help on DB issue!!
Date Posted: 19 March 2006 at 5:31am
|
Hi, I installed wwf v8.0 (MySQL) on my own PC (OS Win XP Pro, Web server XP's IIS, MySQL 5.0) and it's runnig like charm, but when I managed to install it on my website (OS Win 2003 Server, MySQL 4.0.20)... OMG!! MySQL version is under 4.1 !!  Well... probably there is the problem, not 100% sure though, so I'll keep this post open. When I try to access "pre_approved_topics.asp", I get this message: Server Error An error has occured while executing SQL query on database. Please check that the mySQL version is 4.1 or above. Please contact the forum administrator. Error code:- Microsoft OLE DB Provider for ODBC Drivers [MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]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 'SELECT Topic_ID FROM tblThread WHERE tblThread.Hide=-1)))ORDER When I try to access "active_topics.asp", I get this message: Server Error An error has occured while executing SQL query on database. Please check that the mySQL version is 4.1 or above. Please contact the forum administrator. Error code:- Microsoft OLE DB Provider for ODBC Drivers [MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]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 'SELECT tblPermissions.Forum_ID FROM tblPermissions WHERE (tblP When I try to access "calendar.asp", I get this message: Server Error An error has occured while executing SQL query on database. Please check that the mySQL version is 4.1 or above. Please contact the forum administrator. Error code:- Microsoft OLE DB Provider for ODBC Drivers [MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]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 'SELECT tblPermissions.Forum_ID FROM tblPermissions WHERE (tblP Is just because of the version (MySQL)? or could it be something else? Any help will be appreciated Thanks Anthony |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 20 March 2006 at 10:49am
|
This is because mySQL versions is below 4.1 don't support sub queries. If you use version 4.1 or above you won't get these error any more as 4.1 and above support sub queries which are used in the pages you are getting these errors on. Maybe time your host updated, as mySQL4.1 has been out for about 2 years now and is considered a very stable version on mySQL. |
Posted By: Waterbearer
Date Posted: 21 March 2006 at 2:53am
|
Thanks! My host is upgrading a lot of features the next two weeks, if MySQL is not one of them I'll send a support ticket asking to upgrade to 4.1. best regards Anthony |
Posted By: dpyers
Date Posted: 22 March 2006 at 12:18am
|
Upgrading to 4.1 breaks a lot of (perhaps most) MySQL apps that use older versions. Many hosts are only putting it on new servers and not upgrading older ones.
------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: Waterbearer
Date Posted: 23 March 2006 at 12:46pm
That's not very good news indeed, but I think it all will depend on how many accounts are actually using MySQL as it is something implemented not long ago (previously this host only supported MS SQL and Access DB's). Anyway, I'll try a shot asking for MySQL 4.1  (5.0 should be better as it supports stored queries but I donīt know how stable it really is).Regards  Anthony |
Posted By: WebWiz-Bruce
Date Posted: 23 March 2006 at 1:19pm
|
mySQL 5 is stable, just that allot of hosts don't want to update to it because, again it breaks allot of applications and scripts that run on mySQL 4.1 It seems mySQL is not very backwardly compatible. |
Posted By: dpyers
Date Posted: 24 March 2006 at 12:48am
|
If you're using the hsphere control panel, you also have to wait for a psoft upgrade to use a more advanced version of MySQL. You definately don't want to be an early christian for a psoft upgrade - takes them 3 point releases to fix what they just broke.
-------------
Lead me not into temptation... I know the short cut, follow me. |