Getting following error when trying to use the install feature of Meber List.

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 'member_id` int(11) unsigned NOT NULL default '0', `main_id` int(11) u' at line 2
SQL:
CREATE TABLE `roster_addons_memberslist_alts` `member_id` int(11) unsigned NOT NULL default '0', `main_id` int(11) unsigned NOT NULL default '0', `alt_type` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`member_id`) ENGINE=MyISAM DEFAULT CHARSET=utf8;


I did a fresh install of roster_20b_1355.zip , by removing all previous roster directories and deleted the old roster DB.
Running 4.1.22-standard Server MySQL DB

Ah crap

Open lib/install.lib.php
Find

Code: Select all

        $this->sql[] = 'CREATE TABLE `' . $name . '` ' . $query . ' ENGINE=MyISAM DEFAULT CHARSET=utf8;'; 

Replace with

Code: Select all

        $this->sql[] = 'CREATE TABLE `' . $name . '` (' . $query . ') ENGINE=MyISAM DEFAULT CHARSET=utf8;'; 

Fixed svn[1358]

Worked like a charm.

Thanks!

The installation for Armory Synch (v2.6.0.235) works with the original line but fails with the replacement line.

See http://wowroster.net/Forums/viewtopic/t=4335.html

For fix to Armory.