Web Wiz Support and Community Forums : MySql version install problems https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 08:17:25 +0000 Wed, 17 Jan 2007 11:47:36 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22412 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[MySql version install problems : My server guy somehow got it working...]]> https://forums.webwiz.net/mysql-version-install-problems_topic22412_post119473.html#119473 Author: greytricky
Subject: 22412
Posted: 17 January 2007 at 11:47am

My server guy somehow got it working now, thanks for your help WW people, much love Wink]]> Wed, 17 Jan 2007 11:47:36 +0000 https://forums.webwiz.net/mysql-version-install-problems_topic22412_post119473.html#119473 <![CDATA[MySql version install problems : Error details:-Microsoft OLE...]]> https://forums.webwiz.net/mysql-version-install-problems_topic22412_post119399.html#119399 Author: angel
Subject: 22412
Posted: 15 January 2007 at 9:48am

Quote Error details:-
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 '(tblAuthor.DOB) = 14 ORDER BYtblAuthor.Author_ID DESC' at line


this tells you the problem the servers mysql version is only 4.0.2 and you need for the forum at least 4.1
]]> Mon, 15 Jan 2007 09:48:49 +0000 https://forums.webwiz.net/mysql-version-install-problems_topic22412_post119399.html#119399 <![CDATA[MySql version install problems : My original forum was running...]]> https://forums.webwiz.net/mysql-version-install-problems_topic22412_post119383.html#119383 Author: greytricky
Subject: 22412
Posted: 14 January 2007 at 9:55pm

My original forum was running on access (7.9 i think) but I had many problems with asp getting jammed up from countless connections I was told MySql would be better for my traffic and stop the crashes, after a mad few weeks of the site crashing I safely closed the forum and started on the migration from access to mysql
 
 
I have ran the 7 to 8 Access update, this went smooth Smile

I then ran the access database through an 'access to my sql convertor' program (MyDbConverterPro) on the server and this seemed to bring across all the fields and data fine Smile

We tried the 'new forum' and somehow got into the admin section but then got the following error on the screen and nothing else as yet


Error details:-
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 '(tblAuthor.DOB) = 14 ORDER BY tblAuthor.Author_ID DESC' at line

Confused
My server support has assisted but can only do so much ... Could I possibly get some help with getting my forum back running again, obviously there is something I have missed and i'm pulling my hair out, lol


(We pre-installed mysql 5 on the server btw)


I am prepared to pay an experienced web-wiz'r who is a pro with MySql & Windows Server to log on and assist with ironing out any errors as this is a busy forum I urgently need for my job :-(

]]> Sun, 14 Jan 2007 21:55:32 +0000 https://forums.webwiz.net/mysql-version-install-problems_topic22412_post119383.html#119383