Error in installing Add On Members List

Posts from previous Beta sessions

Error in installing Add On Members List

Postby dortaran » Wed Sep 26, 2007 9:23 am

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
Last edited by dortaran on Wed Sep 26, 2007 11:37 am, edited 1 time in total.
dortaran
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Fri Jul 21, 2006 9:57 pm
Location: US

Error in installing Add On Members List

Postby zanix » Wed Sep 26, 2007 11:35 am

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;'
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Error in installing Add On Members List

Postby zanix » Wed Sep 26, 2007 11:37 am

Fixed svn[1358]
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Error in installing Add On Members List

Postby dortaran » Wed Sep 26, 2007 10:02 pm

Worked like a charm.

Thanks!
dortaran
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Fri Jul 21, 2006 9:57 pm
Location: US

Error in installing Add On Members List

Postby Ymryl » Wed Sep 26, 2007 11:21 pm

The installation for Armory Synch (v2.6.0.235) works with the original line but fails with the replacement line.
User avatar
Ymryl
WR.net Apprentice
WR.net Apprentice
 
Posts: 38
Joined: Mon Jul 17, 2006 11:45 pm
Location: RI, USA

Error in installing Add On Members List

Postby dortaran » Thu Sep 27, 2007 5:59 am

dortaran
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Fri Jul 21, 2006 9:57 pm
Location: US


Return to Archived

Who is online

Users browsing this forum: No registered users and 1 guest

cron