Error installing DF wow roster

Dragonfly integration forum

Error installing DF wow roster

Postby Tazochai » Sat Mar 31, 2007 7:17 am

I think I'm missing something. just switched from godaddy to startlogic(very fast :thumleft: ) 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
Tazochai
WR.net Apprentice
WR.net Apprentice
 
Posts: 17
Joined: Mon Aug 07, 2006 9:24 am

Error installing DF wow roster

Postby Anaxent » Sat Mar 31, 2007 8:07 am

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.
User avatar
Anaxent
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 642
Joined: Tue Jul 04, 2006 6:27 am
Location: Phoenix, Az

Error installing DF wow roster

Postby Tazochai » Sat Mar 31, 2007 12:20 pm

couldn't find the file with the charset but then again I'm a noob hehe thanks for helping out Anaxent
Tazochai
WR.net Apprentice
WR.net Apprentice
 
Posts: 17
Joined: Mon Aug 07, 2006 9:24 am

Error installing DF wow roster

Postby Anaxent » Sat Mar 31, 2007 2:58 pm

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');
User avatar
Anaxent
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 642
Joined: Tue Jul 04, 2006 6:27 am
Location: Phoenix, Az

Error installing DF wow roster

Postby Tazochai » Sat Mar 31, 2007 8:15 pm

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
Last edited by Tazochai on Sat Mar 31, 2007 8:16 pm, edited 1 time in total.
Tazochai
WR.net Apprentice
WR.net Apprentice
 
Posts: 17
Joined: Mon Aug 07, 2006 9:24 am

Error installing DF wow roster

Postby Tazochai » Mon Apr 02, 2007 10:01 am

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
Tazochai
WR.net Apprentice
WR.net Apprentice
 
Posts: 17
Joined: Mon Aug 07, 2006 9:24 am


Return to Dragonfly

Who is online

Users browsing this forum: No registered users and 0 guests

cron