Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Help on DB issue!!
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Help on DB issue!!
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Waterbearer View Drop Down
Newbie
Newbie
Avatar

Joined: 19 March 2006
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Waterbearer Quote  Post ReplyReply Direct Link To This Post Topic: Help on DB issue!!
    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 !! Confused

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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Waterbearer View Drop Down
Newbie
Newbie
Avatar

Joined: 19 March 2006
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Waterbearer Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Waterbearer View Drop Down
Newbie
Newbie
Avatar

Joined: 19 March 2006
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Waterbearer Quote  Post ReplyReply Direct Link To This Post 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 Smile (5.0 should be better as it supports stored queries but I donīt know how stable it really is).

Regards
Cool Anthony
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
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.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.