LUA is english and YES old "key" addon renamed WORKS! and Key_BC works!

But new "Key" addon don't get keys from keyrings on upload :/

I pulled the new keys addon SVN yesterday evening.

Result after less then 24 hours : http://www.papy-team.fr/roster/index.ph ... keys&a=g:1

This is a french roster.

Subxero, I'm not seeing this behaviour on my local system. Are the key items in question in your LUA file? Is your keyring shown (and filled, and up to date) in the info addon?

Hi,

I've just installed 1665, frFR defs for Arca and TKs are in my file but not in the svn install_frFR.php file (see previous message for the translation) and there is an encoding problem with the $lang['keys_desc'] and $lang['keybutton'] entries which are iso-8859-15 instead of UTF-8.

Best regards.

Chris.

Fixed svn 1667

Still with problems .. now i get a error message from 1667-1684 SVN (before was no error message but keys don't update)

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

SQL:
INSERT INTO `roster_addons_keys_keycache` (`member_id`, `key_name`, `stage`) SELECT '1', `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` = 'H' AND `data`.`member_id` = '1' 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

PHP Errors
pages/update.php
Notice line 64: Undefined variable: messages

This is a mysql 4 problem. According to the documentation, this statement should work, but apparently it doesn't.

Any ideas are welcome.

I found these:

Yes, this is a mysql 4 compatibility issue.

Mysql documentation mentioning the issue is here, http://dev.mysql.com/doc/refman/5.0/en/select.html
See under "The HAVING clause is applied..."

Basically, in mysql you cannot use in a having clause columns that are not in the select statement. So the query though being SQL standard compliant, doesn't work in Mysql 4.

The only solution I can think of atm is adding a dummy field into 'subscriptions_queue' table so we can add the field into the SELECT clause too. But I'd like something better than that.

Help is wanted on how to address it, while retaining the ability to queue all notifications in a simple query.

Please try 1687

Works now! i can see my keys!

can someone point me in the right direction to get the file to fix this?

Thank You

Go to SVN and download the last. (at top you have a tutorial)

Subxero wrote:Go to SVN and download the last. (at top you have a tutorial)

ok guess I'm lost here, clicked link to WebSVN could not find anything for keys for roster 2

tried SVNergy also and developer areas are not accessible to me.

Sorry for being SVN illiterate but need further guildance

Thanks

Blueleaf wrote:Sorry for being SVN illiterate but need further guildance

Answer moved to http://www.wowroster.net/Forums/viewtop ... html#31933 - question is not related to the current subject.

Thanks Tuigii I was in right place but was looking for it in roster 2, got it installed and fixed the problem. I see there is an admin folder there that is not on my local files, do I need it, seems to work fine without it, or is this somthing new that allows more control?

Thanks a bunch