I think I'm missing something. just switched from godaddy to startlogic(very fast ) anyway when I try to install it comes up with

Code: Select all

CMS Warning line 75: On /admin.php?op=modules&install=WoWRosterDF While executing query "CREATE TABLE cms_wowrosterdf_roster_account ( `account_id` smallint(6) NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `hash` varchar(32) NOT NULL default '', PRIMARY KEY (`account_id`)) TYPE=MyISAM DEFAULT CHARSET=utf8" the following error occured: 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 'DEFAULT CHARSET=utf8' at line 5 In: /home/thesocie/public_html/includes/classes/installer.php on line: 61

damn think I know why now.. looks like mysql is to old
MySQL Version 4.0.16 (client: 4.0.16)

can anyone confirm

Im sorry to make you do all this work but open the install file for wowrosterdf and remove the 'DEFAULT CHARSET=utf8' from every create table. If this does not work out let me know. and also check your pm from me pls.

couldn't find the file with the charset but then again I'm a noob hehe thanks for helping out Anaxent

ok did you get the wowrosterdf download from our download section here? The sql insert for accounts is not what you posted.

This is /modules/WoWRosterDF/install.php line 20 - 28

Code: Select all

# --------------------------------------------------------
   ### Account

   //$installer->add_query('DROP', $this_prefix.'account');
   $installer->add_query('CREATE', $this_prefix.'account', "
   `account_id` smallint(6) NOT NULL auto_increment,
   `name` varchar(30) NOT NULL default '',
   `hash` varchar(32) NOT NULL default '',
   PRIMARY KEY  (`account_id`)", $this_prefix.'account');


Ok thanks I was looking in the right place then but not sure what I have to remove. sorry bout this I think I require some more hand holding.


Edit: to answer your other question. I always get the roster package from you good folks

very sorry to continue to bother you but I can't seem to find anything in /modules/WoWRosterDF/install.php line 20 - 28 to fix this issue. If I am sol I can live with that.. just trying to get my old guild setup again