Just EU, nothing more, were all on the one server Emerald Dream in the EU domain

Look in your roster_players table under the field 'clientLocale', and tell me if there are different ones

Sorry for the late reply, I've had to access this from home as the work connection failed on us,

Not as far as I can understand this but within client Locale in the roster_players table I have

clientLocale varchar(4) latin1_swedish_c

and no other entries

Ths help ?

You are looking at the structure, not the data

sorry, new to this, I've exported the client dta from that table to a csv file and have examined it in excell,

Every member in 103 entries is enUS
except for one person who is is frFR


that help ?

definatly...
you need a frFR.php file in your localization folder

Look in the Roster > Languages forum

worked a treat, thank you very much for your time and help :-)

Hello
I have the same problem with frFR.php file

I checked and the A for alliance and H for Horde correction is alright
I uploaded the files from the patch.. no change

Warning: Invalid argument supplied for foreach() in /blablabla/roster/membersinst.php on line 183

in the FRfr file, the instance key translation array incorrectly puts HT instead of DM for the first part of the association list.

(HT is indeed the french shortcut for DireMaul but DM is hard coded elsewhere in the php files).

look for "HT" in the file and replace by "DM", it should work fine.

doesn't work :

the error is in the membersnist file, line 183

foreach ($items as $key => $item)
{
foreach ($items[$key] as $subkey => $subitem)
{
$onechar = substr($subkey, 0, 1);
if (!is_numeric($onechar))
{
++$countk;
list($iname, $thottnum) = explode('|', $subitem);
$selectk .= ", sum(if(items.item_name = '".$iname."', -1, 0)) as $key";
if ($countk == 1)
{
$wherek .= " items.item_name = '".$iname."'";
}
else
{
$wherek .= " or items.item_name = '".$iname."'";
}
}
}
}

My "Keys" were breaking as well, when it reached the only player in the guild with a German WoW.

Tried manually doing the changes - but now it breaks before even showing on player with:

invalid argument supplied for foreach() in /home/subscrib/public_html/guild-succession.com/roster/membersinst.php on line 183

Tried downloading and applying the files in the zip file - and still the same result.

The error is also accompanied by the following 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 = '92' AND () GROUP BY members.name
File: membersinst.php
Line: 206

I've got exactly the same error... tried to re-upload the only character (me) to no avail (See here)

It's the only thing that doesn't work perfectly

Hi, i cant resolved that's plz help me :'(

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 = '30' AND () GROUP BY members.name
File: membersinst.php
Line: 206

Warning: Invalid argument supplied for foreach() in /home/rdc/www/Perso/membersinst.php on line 183

that's here

Grobsnelf wrote:
...
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 = '92' AND () GROUP BY members.name
File: membersinst.php
...
Line: 206

Got the same error. But in my case next character in line to be displayed is supposed to be one of two enUS clients; furthermore this one has a special character as first letter too (Ìvy). The first three deDe characters are displayed.
I replaced the files from "170_keys_fix.zip" => no change

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 = '222' AND () GROUP BY members.name
File: membersinst.php
Line: 206

same thing after FIX