Got this error on Keys module page:

Code: Select all

Warning: Invalid argument supplied for foreach() in .../roster/membersinst.php on line 183      
   Database Error   
      1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY members.name' at line 1
SQL:
SELECT members.name FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '177' AND () GROUP BY members.name
File: membersinst.php
Line: 206


The error is here:

Code: Select all

'177' AND () GROUP

What should i do to resolve this error?

You have someone that uploaded data with an unknown locale
Currently the only officially supported locales are enUS, deDE, and frFR
Check your database in 'roster_players' - 'clientLocale' and look for locales other than the ones listed

zanix wrote:You have someone that uploaded data with an unknown locale
Currently the only officially supported locales are enUS, deDE, and frFR
Check your database in 'roster_players' - 'clientLocale' and look for locales other than the ones listed

Yeah. There is ruRU locale. I don't know where this player get it, but how can i forbid non supported locales?
And how can i correctly delete player data?

You cannot forbid certain locales...sorry
As for deleting certain players, this is not possible with the current code

Here is what you can do
Go to your roster/localization folder
Copy enUS.php to ruRU.php
In ruRU.php, change all instances of 'enUS' to 'ruRU'
Save

There also may be a ruRU.php file around here in the forums somewhere

Hopefully this will work

The ruRU locale is not created by blizzard and not supported by blizzard. It's a 3rd party commercial language pack for wow (as far as I've heard).

esES is the only official locale we do not support.

PleegWat wrote:The ruRU locale is not created by blizzard and not supported by blizzard. It's a 3rd party commercial language pack for wow (as far as I've heard).

It's non commercial now