Web Wiz Forums - MySql version install problems

Print Page | Close Window

MySql version install problems

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=22412
Printed Date: 08 April 2026 at 8:16am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: MySql version install problems

Posted By: greytricky
Subject: MySql version install problems
Date 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

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

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

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 :-(

Replies:

Posted By: angel
Date Posted: 15 January 2007 at 9:48am

this tells you the problem the servers mysql version is only 4.0.2 and you need for the forum at least 4.1

-------------
soon

Posted By: greytricky
Date Posted: 17 January 2007 at 11:47am

My server guy somehow got it working now, thanks for your help WW people, much love