Microsoft’s Port 25 announced that MindTouch has a beta MSI installer for their Deki Wiki software. So, I decided to install it in Windows Server 2008 Standard Edition and ran into a MySQL problem in my first attempt. Fortunately for me, eagle eye Max noticed the doesn’t have a default value part of the error message and told me that the problem is that the freshly installed copy of MySQL 5.0.51b sets SQL to strict mode that disallows empty fields (no default value). So, I went to C:\Program Files\MySQL\MySQL Server 5.0\my.ini and commented out the line as shown below.
This led to a successful configuration and installation of MySQL tables (see below).
One oddity showed up though. For some reason, MindTouch has Google Analytics code with the key US-68075-16 reporting back. You can strip this out. But, I’m curious why every installation has a Google Analytics code embedded in it (see below).
However, as you can see from the screen cap below, Deki Wiki is indeed running on my virtual machine running Windows Server 2008 Standard Edition now.