https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 19:22:32 +0000 Fri, 24 Mar 2006 00:48:33 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18783 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/help-on-db-issue_topic18783_post102228.html#102228 Author: dpyers
Subject: 18783
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.]]> Fri, 24 Mar 2006 00:48:33 +0000 https://forums.webwiz.net/help-on-db-issue_topic18783_post102228.html#102228 https://forums.webwiz.net/help-on-db-issue_topic18783_post102170.html#102170 Author: WebWiz-Bruce
Subject: 18783
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.
]]> Thu, 23 Mar 2006 13:19:17 +0000 https://forums.webwiz.net/help-on-db-issue_topic18783_post102170.html#102170 https://forums.webwiz.net/help-on-db-issue_topic18783_post102169.html#102169 Author: Waterbearer
Subject: 18783
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
]]> Thu, 23 Mar 2006 12:46:59 +0000 https://forums.webwiz.net/help-on-db-issue_topic18783_post102169.html#102169 https://forums.webwiz.net/help-on-db-issue_topic18783_post101959.html#101959 Author: dpyers
Subject: 18783
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.]]> Wed, 22 Mar 2006 00:18:43 +0000 https://forums.webwiz.net/help-on-db-issue_topic18783_post101959.html#101959 https://forums.webwiz.net/help-on-db-issue_topic18783_post101803.html#101803 Author: Waterbearer
Subject: 18783
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
]]> Tue, 21 Mar 2006 02:53:18 +0000 https://forums.webwiz.net/help-on-db-issue_topic18783_post101803.html#101803 https://forums.webwiz.net/help-on-db-issue_topic18783_post101751.html#101751 Author: WebWiz-Bruce
Subject: 18783
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.
]]> Mon, 20 Mar 2006 10:49:39 +0000 https://forums.webwiz.net/help-on-db-issue_topic18783_post101751.html#101751 https://forums.webwiz.net/help-on-db-issue_topic18783_post101682.html#101682 Author: Waterbearer
Subject: 18783
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][ODBC3.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 theright syntax to use near 'SELECT Topic_ID FROM tblThread WHEREtblThread.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][ODBC3.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 theright syntax to use near 'SELECT tblPermissions.Forum_ID FROMtblPermissions 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][ODBC3.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 theright syntax to use near 'SELECT tblPermissions.Forum_ID FROMtblPermissions WHERE (tblP

Is just because of the version (MySQL)? or could it be something else?

Any help will be appreciated
Thanks
Anthony
]]> Sun, 19 Mar 2006 05:31:48 +0000 https://forums.webwiz.net/help-on-db-issue_topic18783_post101682.html#101682