You're welcome, Masao. (You're so lucky you don't have to do all this updating yet.)
I do come bearing another update, though: this time on the
mod_owned.php file. It's the same problem/solution with the
TYPE=MyISAM as the above, only this one prevents you from enabling affiliates (say, on a brand new fanlisting).
On the
mod_owned.php file, between lines 895-905 in Araneae:
// add table
$afftable = $table . '_affiliates';
$query = "CREATE TABLE `$afftable` (" .
"`affiliateid` int(5) NOT NULL auto_increment, " .
"`url` varchar(255) NOT NULL default '', " .
"`title` varchar(255) NOT NULL default '', " .
"`imagefile` varchar(255) default NULL, " .
"`email` varchar(255) NOT NULL default '', " .
"`added` DATE NOT NULL default '0000-00-00', " .
"PRIMARY KEY( affiliateid ) " .
") TYPE=MyISAM AUTO_INCREMENT=1";
Needs to become:
// add table
$afftable = $table . '_affiliates';
$query = "CREATE TABLE `$afftable` (" .
"`affiliateid` int(5) NOT NULL auto_increment, " .
"`url` varchar(255) NOT NULL default '', " .
"`title` varchar(255) NOT NULL default '', " .
"`imagefile` varchar(255) default NULL, " .
"`email` varchar(255) NOT NULL default '', " .
"`added` DATE NOT NULL default '0000-00-00', " .
"PRIMARY KEY( affiliateid ) " .
") ENGINE=MyISAM AUTO_INCREMENT=1";
I think I'll just look for anymore
TYPE=MyISAM in the files and make a list of where's if I find any, because they will all - no doubt - need to become
ENGINE=MyISAM to be MySQL 5.5 compliant...
PS: I noticed on my last post, I wrote
ENGINE = MYSIAM with spaces and all uppercase, and in this one without. As I now happen to be using both, as of right now, it appears it doesn't matter which one you use; the last one I ripped right from
the MySQL site (so, you know it'd work), and this one I just changed
Type to
Engine since I knew immediately that's what needed to be done and it works fine, too.