Has anyone tryed to port WWF to MySQL?

I would like to run WWF but with MySQL backend instead of my current Access DB, I know there are little differences in the SQL btw Access and MySQL, my questions are:

If I create the MySQL database with all tables and fields will it run? What problems am I expecting by doing so?

If the problems are too many, then it might be worth to rewrite the whole code from scratch with MySQL, that would result in a new forum project altogether.

Thx for any advice.

You will need to re-write almost every file as many files use ADO recordset updates to update the database which help with security with SQL injections.

Many of the SQL quries will also need to be re-writen to support mySQL.

mySQL also doesn't support recordset paging so all files using this will also need to be re-writen.

You will have to write extra security code as well to prevent SQL injections.

I spent some 30 hours on this and gave up as I didn't even scratch the serface.

If you go ahead be prepared to spend a good month or so working on it (full-time), to get it working correctly.

As the license for web wiz forums dosn't allow the code to be redistiributed or re-engineered then you will be better starting from scratch with a completly different code base as this forum would not be able to be used as a code base for such a project.


Edited by -boRg-

Thanks to everyone, specially to boRg (resistance is futile...) great stuff.

Yeah I though as much, my preliminary analizes revealed that indeed MySQL doesn't support recordsert paging, so I had to come with a complete new DB paging routine, fully working now, and that the ammount of work involved to change the code to be MySQL connectable is too much, not to mention the WWF licence issues.

I will indeed start from scratch a new forum project with MySQL backend and I'm considering not adding all features avail in WWF at the beggining it will be an application that will mature with time, but at least people will have a forum system with a reliable, fast and free backend.

MSSQL is way too expenssive and not avail on all hosts, not sure if WWF will work with MSDE 2000.

I'm still busy with other projects at the moment, but will inform you all on the progress of this new MySQL forums.

Thanks.

MySQL does support RecordsetPaging but don´t support all Recordset (ADO) Features .... like .AddNew, or .AddNew you can use, but not update an existing post with .Update. It seems that myODBC lock the record for updates.

 

cya,

/PatrikB

Edited by The WizeGuy