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

by **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