Problem with Keys module on WoWRoster 1.7.2

Requests, feedback, and general discussion about WoWRoster
DO NOT post topics about WoWRoster AddOns here!

Problem with Keys module on WoWRoster 1.7.2

Postby XKiller » Thu Jan 04, 2007 6:56 am

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?
XKiller
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Sat Jul 22, 2006 11:52 pm

Problem with Keys module on WoWRoster 1.7.2

Postby zanix » Thu Jan 04, 2007 7:07 am

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
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Problem with Keys module on WoWRoster 1.7.2

Postby XKiller » Thu Jan 04, 2007 7:26 am

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?
XKiller
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Sat Jul 22, 2006 11:52 pm

Problem with Keys module on WoWRoster 1.7.2

Postby zanix » Thu Jan 04, 2007 7:30 am

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
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Problem with Keys module on WoWRoster 1.7.2

Postby PleegWat » Thu Jan 04, 2007 7:58 am

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.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Re: Problem with Keys module on WoWRoster 1.7.2

Postby XKiller » Thu Jan 04, 2007 8:28 am

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 :)
XKiller
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Sat Jul 22, 2006 11:52 pm


Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 1 guest

cron