Topic - spilt: Unknown column 'stages.count' in 'having clause'

Posts from previous Beta sessions

Re: Give me all your item parser errors!

Postby Sylna » Mon Feb 18, 2008 7:56 pm

When uploading a CharakterProfiler.lua i get the following error-message. Other users get the same error as well. So i think it is independent from the .lua-file. I always see this error, but the update seems to work well anyway.




Database Error1054: Unknown column 'stages.count' in 'having clause'
SQL:
INSERT INTO `roster_addons_keys_keycache` (`member_id`, `key_name`, `stage`) SELECT '125', `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` = 'deDE' AND `stages`.`faction` = 'A' AND `data`.`member_id` = '125' 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
Sylna
 

Topic - spilt: Unknown column 'stages.count' in 'having clause'

Postby poetter » Mon Feb 18, 2008 8:24 pm

I split this topic. It has nothing to with the item parser, is mentioned in a few other topics and should be solved in the latest svn.
Image
User avatar
poetter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 462
Joined: Sat Jun 30, 2007 9:41 pm
Location: Germany/Hamburg

Re: Topic - spilt: Unknown column 'stages.count' i

Postby tuigii » Mon Feb 18, 2008 10:23 pm

Somehow, stages looks like a nice keyword :wink:

Click search :=> found the 'answer' in a already known subject.
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

Topic - spilt: Unknown column 'stages.count' in 'having clause'

Postby Subxero » Tue Feb 19, 2008 12:25 am

I'm not the only one using a hosting with mysql 4.1.10!
Subxero - Priest 70 Holy - Asphelt Knight Officer - Zul'jin Horde.
User avatar
Subxero
WR.net Artisan
WR.net Artisan
 
Posts: 234
Joined: Thu Jul 06, 2006 4:08 pm
Realm: Zul'jin (PvE) - US


Return to Archived

Who is online

Users browsing this forum: No registered users and 0 guests

cron