読者です 読者をやめる 読者になる 読者になる

XAMPPな環境でGeeklog-1.7.2-jp-exteded-1.0をCAPTCHAプラグイン付きでインストールすると落ちる

Geeklog XAMPP PHP MySQL

原因

ログファイルを見るとこうでした↓

$ cat error.log
2011/07/06 4:46:52 - Attempting to install the 'calendarjp' plugin
2011/07/06 4:46:52 - Attempting to create 'Calendarjp Admin' group
2011/07/06 4:46:52 - Attempting to add 'calendarjp' features
2011/07/06 4:46:52 - Adding 'calendarjp.moderate' feature to the 'Calendarjp Admin' group
2011/07/06 4:46:52 - Adding 'calendarjp.edit' feature to the 'Calendarjp Admin' group
2011/07/06 4:46:52 - Adding 'calendarjp.submit' feature to the 'Calendarjp Admin' group
2011/07/06 4:46:52 - Adding 'config.calendarjp.tab_main' feature to the 'Calendarjp Admin' group
2011/07/06 4:46:52 - Adding 'config.calendarjp.tab_permissions' feature to the 'Calendarjp Admin' group
2011/07/06 4:46:52 - Adding 'config.calendarjp.tab_autotag_permissions' feature to the 'Calendarjp Admin' group
2011/07/06 4:46:52 - Attempting to give all users in the Root group access to the 'calendarjp' Admin group
2011/07/06 4:46:52 - Registering 'calendarjp' plugin
2011/07/06 4:46:52 - Successfully installed the 'calendarjp' plugin!
2011/07/06 4:46:52 - Attempting to install the 'captcha' plugin
2011/07/06 4:46:52 - 1064: 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' at line 5. SQL in question:
CREATE TABLE gl_cp_config (
  config_name     varchar(255) NOT NULL default '',
  config_value    varchar(255) NOT NULL default '',
  PRIMARY KEY (config_name)
) TYPE=MyISAM

2011/07/06 4:46:52 - 256 - An SQL error has occurred. Please see error.log for details. @ E:\xampp\apache\htdocs\www.hogehoge.com\private\geeklog\system\databases\mysql.class.php line 260

なんか、TYPE=MyISAMがダメって怒られてます。で怒られた内容でググってみた結果の最初のページによれば、
新しいバージョンではTYPE=MyISAMからENGINE=MyISAMに構文が変わっているようです。

対策

数カ所程度ならばパッチあてようかと思いましたが、

babydaemons@babydaemons-mobile ~
$ find /xampp/apache/htdocs/www.hogehoge.com/ -name '*.php' | xargs grep 'TYPE=MyISAM' /dev/null
/xampp/apache/htdocs/www.hogehoge.com/html/admin/plugins/themedit/install.php:                                           . ") TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/autotags/sql/mysql_install.php:) TYPE=MyISAM
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/captcha/sql/mysql_install.php:) TYPE=MyISAM
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/captcha/sql/mysql_install.php:) TYPE=MyISAM
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/mysql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/mysql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/mysql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/mysql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/mysql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/mysql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM COMMENT='Forum Extra User Profile Information';";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM COMMENT='Forum Extra User Profile Information';";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/links/sql/mysql_updates.php:        ) TYPE=MyISAM",
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/polls/sql/mysql_updates.php:        ) TYPE=MyISAM",
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php:) TYPE=MyISAM ";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.3.4_to_1.3.5.php:) TYPE=MyISAM
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.3.8_to_1.3.9.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.3.9_to_1.3.10.php:                . ") TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.4.1_to_1.5.0.php:) TYPE=MyISAM
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.4.1_to_1.5.0.php:    ) TYPE=MyISAM");
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php:) TYPE=MyISAM
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php:) TYPE=MyISAM
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php:) TYPE=MyISAM

babydaemons@babydaemons-mobile ~
$

53箇所ですか。。。sedで一括置換出来なくも無いけど、MySQLのバージョンを5.5から落とすのが正解だろうなー。


と、思ったけど!

やっぱり、sedで一括置換!
babydaemons@babydaemons-mobile ~
$ cd /xampp/apache/htdocs/www.hogehoge.com/

shingo@shingo-mobile /xampp/apache/htdocs/www.nanakanet.com
$ tar cvzf TYPE=MyISAM.tar.gz `find * -name '*.php' | xargs grep 'TYPE=MyISAM' /dev/null | awk -F: '{ print $1 }'`
html/admin/plugins/themedit/install.php
private/geeklog/plugins/autotags/sql/mysql_install.php
private/geeklog/plugins/captcha/sql/mysql_install.php
private/geeklog/plugins/captcha/sql/mysql_install.php
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php
private/geeklog/plugins/filemgmt/sql/mysql_install.php
private/geeklog/plugins/filemgmt/sql/mysql_install.php
private/geeklog/plugins/filemgmt/sql/mysql_install.php
private/geeklog/plugins/filemgmt/sql/mysql_install.php
private/geeklog/plugins/filemgmt/sql/mysql_install.php
private/geeklog/plugins/filemgmt/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/links/sql/mysql_updates.php
private/geeklog/plugins/polls/sql/mysql_updates.php
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php
private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php
private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php
private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php
private/geeklog/sql/updates/mysql_1.3.4_to_1.3.5.php
private/geeklog/sql/updates/mysql_1.3.8_to_1.3.9.php
private/geeklog/sql/updates/mysql_1.3.9_to_1.3.10.php
private/geeklog/sql/updates/mysql_1.4.1_to_1.5.0.php
private/geeklog/sql/updates/mysql_1.4.1_to_1.5.0.php
private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php
private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php
private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php

shingo@shingo-mobile /xampp/apache/htdocs/www.hogehoge.com
$ ls
html  log  private  TYPE=MyISAM.tar.gz

shingo@shingo-mobile /xampp/apache/htdocs/www.hogehoge.com
$ for f in `find * -name '*.php' | xargs grep 'TYPE=MyISAM' /dev/null | awk -F: '{ print $1 }'`; do sed -e 's/TYPE=MyISAM/ENGINE=MyISAM/' $f > $f.new; mv $f.new $f; done

shingo@shingo-mobile /xampp/apache/htdocs/www.hogehoge.com
$ find * -name '*.php' | xargs grep '=MyISAM' /dev/null
html/admin/plugins/themedit/install.php:                                                  . ") ENGINE=MyISAM";
private/geeklog/plugins/autotags/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/calendar/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/calendar/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/calendar/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/calendarjp/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/calendarjp/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/calendarjp/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/captcha/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/captcha/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/custommenu/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/mysql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/mysql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/mysql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/mysql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/mysql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/mysql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM COMMENT='Forum Extra User Profile Information';";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM COMMENT='Forum Extra User Profile Information';";
private/geeklog/plugins/links/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/links/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/links/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/links/sql/mysql_updates.php:        ) ENGINE=MyISAM",
private/geeklog/plugins/polls/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/polls/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/polls/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/polls/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/polls/sql/mysql_updates.php:        ) ENGINE=MyISAM",
private/geeklog/plugins/spamx/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/staticpages/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php:) ENGINE=MyISAM ";
private/geeklog/sql/updates/mysql_1.3.4_to_1.3.5.php:) ENGINE=MyISAM
private/geeklog/sql/updates/mysql_1.3.8_to_1.3.9.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.3.9_to_1.3.10.php:                . ") ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.4.1_to_1.5.0.php:) ENGINE=MyISAM
private/geeklog/sql/updates/mysql_1.4.1_to_1.5.0.php:    ) ENGINE=MyISAM");
private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php:) ENGINE=MyISAM
private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php:) ENGINE=MyISAM
private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php:) ENGINE=MyISAM

shingo@shingo-mobile /xampp/apache/htdocs/www.hogehoge.com
$

で、取りあえず動いてるっぽい。

まぁ、ヒントもらった先のページでも、The next version of Zen Cart will already incorporate this MYSQL5-specific change.って書いてあったし、一応これで正解なのかも。

まとめ


いやー、Cygwin様様です!w