I was told to post this issue here...

I get this error popup (screen shot) and after closing the following PHP errors show up under "ArmorySync Error Infos"

Code: Select all

Line   Time   File   Class   Function   Info   Status
      addons/armorysync/inc/armorysync.class.php         Notice line 299: Undefined index: gemTooltip   
      addons/armorysync/inc/armorysync.class.php         Warning line 299: array_keys() [<a href='function.array-keys'>function.array-keys</a>]: The first argument should be an array   

The armorysync notice is uninteresting to this issue. its fixed btw in thenext commit. The sql problem should be related to keys.

It looks like this is a MySQL 4.x restriction that was lifted in 5.0, related to my use of the HAVING clause. I'll ponder about a workaround.

<technobabble>
The column `stages`.`count` is used in the HAVING clause, but not in the SELECT clause. This is only allowed in mysql 5.0+. Adding it to the SELECT clause leads to another SQL error because there's no column to insert into.
</technobabble>

Suggestions appreciated.