1054: Unknown column 'stages.count' in 'having clause'

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

Moderators: Ulminia, poetter

1054: Unknown column 'stages.count' in 'having clause'

Postby kivasfajo » Thu Mar 06, 2008 3:14 am

I get the same error when doing armorysync

SQL:
INSERT INTO `roster_addons_keys_keycache` (`member_id`, `key_name`, `stage`) SELECT '42', `stages`.`key_name`, `stages`.`stage` FROM (SELECT `locale`,`faction`,`key_name`,`stage`,`type`,`value`,`count` FROM `roster_addons_keys_stages`) AS stages, `roster_items` AS data WHERE `stages`.`locale` = 'enUS' AND `stages`.`faction` = 'A' AND `data`.`member_id` = '42' AND (`stages`.`type` = 'In' AND `data`.`item_name` = `stages`.`value` OR `stages`.`type` = 'Ii' AND `data`.`item_id` LIKE CONCAT(`stages`.`value`, ':%')) GROUP BY `stages`.`key_name`, `stages`.`stage`, `stages`.`count` HAVING SUM(`data`.`item_quantity`) >= `stages`.`count`;
File: lib/dbal/mysql.php
Line: 235


Guild Name: Looney Toons
Server: The Scryers
Region: US
Last edited by kivasfajo on Thu Mar 06, 2008 3:16 am, edited 1 time in total.
kivasfajo
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Mon Oct 08, 2007 7:56 am

1054: Unknown column 'stages.count' in 'having clause'

Postby zanix » Thu Mar 06, 2008 3:29 am

Keys addon error
Upgrade Roster to the newest svn revision, or de-activate it
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: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: 1054: Unknown column 'stages.count' in 'having clause'

Postby kivasfajo » Thu Mar 06, 2008 4:28 am

Thanks will do. didnt know there was a new svn.

DT
kivasfajo
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Mon Oct 08, 2007 7:56 am

1054: Unknown column 'stages.count' in 'having clause'

Postby zanix » Thu Mar 06, 2008 5:39 am

There is, we just haven't made a build for download for the forum post yet
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: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US


Return to ArmorySync - Depreciated

Who is online

Users browsing this forum: No registered users and 0 guests

cron