Error in installer for armorysync_2.6.0.235_315.zip

Sync Blizzards' Armory data with WoWRoster (addon depreciated no longer works see ApiSync)

Moderators: Ulminia, poetter

Error in installer for armorysync_2.6.0.235_315.zip

Postby dortaran » Wed Sep 26, 2007 9:48 pm

When trying to use installer for wow armory I get :

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 '( `job_id' at line 1
SQL:
CREATE TABLE `roster_addons_armorysync_jobs` (( `job_id` int(11) unsigned NOT NULL auto_increment, `starttimeutc` datetime NOT NULL, PRIMARY KEY (`job_id`) )) ENGINE=MyISAM DEFAULT CHARSET=utf8;

I have roster_20b_1355.zip installed.
Running MySQL 4.1.22-standard
Using armorysync_2.6.0.235_315.zip
dortaran
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Fri Jul 21, 2006 9:57 pm
Location: US

Error in installer for armorysync_2.6.0.235_315.zip

Postby poetter » Wed Sep 26, 2007 10:46 pm

OK, the Bracket around the definition are dups. which version of roster are you running?

For quick help, goto install.def.php in /inc search for create_table and remove the brackets in the second argument of that method. there are three calls to create_table.
Image
User avatar
poetter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 462
Joined: Sat Jun 30, 2007 9:41 pm
Location: Germany/Hamburg

Error in installer for armorysync_2.6.0.235_315.zip

Postby poetter » Thu Sep 27, 2007 12:11 am

OK, zanix put the bracket into install.def.php. That was some hours after i went to bed.

However, see the fix above. With the next release of roster i will change that, too.
Image
User avatar
poetter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 462
Joined: Sat Jun 30, 2007 9:41 pm
Location: Germany/Hamburg

Error in installer for armorysync_2.6.0.235_315.zip

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

I see 4 calls for create_table. 3 grouped together and one on the if statement for version of updates.

So update all 4 or just the 3 grouped together.
dortaran
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Fri Jul 21, 2006 9:57 pm
Location: US

Error in installer for armorysync_2.6.0.235_315.zip

Postby poetter » Thu Sep 27, 2007 6:03 am

Do them all and uninstall und install again
Image
User avatar
poetter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 462
Joined: Sat Jun 30, 2007 9:41 pm
Location: Germany/Hamburg

Error in installer for armorysync_2.6.0.235_315.zip

Postby dortaran » Thu Sep 27, 2007 6:27 am

I changed all 4.

Now getting error :

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 ''' at line 1
SQL:
UPDATE `roster_players` SET `guild_id` = '0' WHERE `member_id` IN (1,13,21,27,36,55)';

When trying to run the update against wow armory for memberlist
Last edited by dortaran on Thu Sep 27, 2007 6:31 am, edited 2 times in total.
dortaran
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Fri Jul 21, 2006 9:57 pm
Location: US

Error in installer for armorysync_2.6.0.235_315.zip

Postby poetter » Thu Sep 27, 2007 6:32 am

please post the whole error message. seems to be a problem with update.lib.php. There is a single quote at the end that should not be there.
Image
User avatar
poetter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 462
Joined: Sat Jun 30, 2007 9:41 pm
Location: Germany/Hamburg

Error in installer for armorysync_2.6.0.235_315.zip

Postby dortaran » Thu Sep 27, 2007 6:52 am

So I tried it once more and it worked..so...maybe something glitchy on my server.

The next part I found was after updating all char info from wowarmory when you click on a char from the memberlist I get this(below). If the char was updated by using the upload function(Character Profiler) it doesn't get that issue. So sounds like a armory data capture issue rather than a roster 2.0 issue.

Any Ideas?

array(
'General' => array(
'Name' => 'Blackflight Arrow Projectile',
'ItemId' => '28056:0:0:0:0:0:0:0',
'ItemColor' => 'ffffff',
'Icon' => 'inv_misc_ammo_arrow_01',
'Slot' => '',
'Parent' => 'equip',
'Tooltip' => 'Blackflight Arrow Projectile<br> ArrowAdds 32 damage per second<br>Requires Level 65<br><br>Source: Vendor',
'Locale' => 'enUS'
),
'Attributes' => array(
'Quality' => array(
'Id' => 2,
'Name' => 'common'
),
'Quantity' => 1,
'WeaponSlot' => ' ArrowAdds 32 damage per second',
'Requires' => array(
0 => 'Requires Level 65'
)
)
);Source: Vendor
--------------------------------------------------------------------------------
Blackflight Arrow Projectile
ArrowAdds 32 damage per second
Requires Level 65

Source: Vendor
--------------------------------------------------------------------------------



array(
'Attributes' => array(
'Enchantment' => '+50 Armor',
'Quality' => array(
'Id' => 4,
'Name' => 'rare'
),
'Quantity' => 1,
'BindType' => 'Soulbound',
'ArmorSlot' => 'Back',
'Requires' => array(
0 => 'Requires Level 68'
)
),
'General' => array(
'Name' => 'Cloak of the Inciter ',
'ItemId' => '27892:884:0:0:0:0:0:1195743698',
'ItemColor' => '0070dd',
'Icon' => 'inv_misc_cape_08',
'Slot' => 'Back',
'Parent' => 'equip',
'Tooltip' => 'Cloak of the Inciter <br>Soulbound<br>Back<br>76 Armor<br>+15 Stamina<br>+50 Armor<br>Requires Level 68<br>Equip: Improves hit rating by 16<br>Equip: Improves critical strike rating by 18<br>Equip: Increases attack power by 30.<br><br>Source: Shadow Labyrinth<br>Boss: Blackheart the Inciter<br>Drop Rate: Low (15% - 24%)',
'Locale' => 'enUS'
),
'Effects' => array(
'Equip' => array(
0 => 'Equip: Improves hit rating by 16',
1 => 'Equip: Improves critical strike rating by 18',
2 => 'Equip: Increases attack power by 30.'
)
)
);
dortaran
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Fri Jul 21, 2006 9:57 pm
Location: US

Error in installer for armorysync_2.6.0.235_315.zip

Postby poetter » Thu Sep 27, 2007 6:56 am

Oh yes. Klick me

and closed
Last edited by poetter on Thu Sep 27, 2007 6:57 am, edited 1 time in total.
Image
User avatar
poetter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 462
Joined: Sat Jun 30, 2007 9:41 pm
Location: Germany/Hamburg


Return to ArmorySync - Depreciated

Who is online

Users browsing this forum: No registered users and 1 guest