G'day,
Okay, so I've made a start and have already struck an issue.
My first step has been to setup a MoWeS based development environment on my Acer EeePC netbook. (That is, the cheap and very portable diving computer I run Diving Log 5 and my dive planning software on.) Because then I'll be able to work on it wherever I am.
So I now have: Apache 2.2.11, MySQL 5.5.8, PHP 5.2.17 & phpMyAdmin 3.3.9 running.
This is different to my hosting account which has: Apache 2.2.17, MySQL 5.0.92, PHP 5.2.17 & phpMyAdmin 3.3.10.2. running.
So I created a database and proceeded to load an old dataset from an earlier version of Diving Log 5, for use with my current phpDivingLog 1.9 code. (That is, get a known quantity working before I switch to phpDivingLog 2.x and start development on 3.0.)
On trying to load the dataset via phpMyAdmin, I got the error "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 'TYPE=MyISAM'."
It seems in some of the more recent MySQL 5 setups "TYPE=MyISAM" is no longer supported. (This hasn't been a problem on my hosting account.)
I've worked around the problem by editing the MySQL dump file and replacing "TYPE=MyISAM" with "ENGINE=MyISAM DEFAULT CHARSET=utf8".
It seems that in order to easily support more recent installations of MySQL, plus older installations, the MySQL Dump Export process in Diving Log 5 will need an option to use "ENGINE=MyISAM DEFAULT CHARSET=utf8" instead of "TYPE=MyISAM".
Best Regards, Lloyd Borrett.
