Not displaying keys...

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

Not displaying keys...

Postby scottelsdon » Thu Sep 14, 2006 2:57 pm

Just EU, nothing more, were all on the one server Emerald Dream in the EU domain
scottelsdon
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Tue Aug 01, 2006 4:14 pm

Not displaying keys...

Postby zanix » Thu Sep 14, 2006 3:45 pm

Look in your roster_players table under the field 'clientLocale', and tell me if there are different ones
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: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Not displaying keys...

Postby scottelsdon » Fri Sep 15, 2006 6:24 pm

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 ?
scottelsdon
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Tue Aug 01, 2006 4:14 pm

Not displaying keys...

Postby zanix » Fri Sep 15, 2006 6:28 pm

You are looking at the structure, not the data
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: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Not displaying keys...

Postby scottelsdon » Fri Sep 15, 2006 7:11 pm

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 ?
scottelsdon
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Tue Aug 01, 2006 4:14 pm

Not displaying keys...

Postby zanix » Fri Sep 15, 2006 7:22 pm

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

Look in the Roster > Languages forum
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: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Not displaying keys...

Postby scottelsdon » Fri Sep 15, 2006 7:35 pm

worked a treat, thank you very much for your time and help :-)
scottelsdon
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Tue Aug 01, 2006 4:14 pm

Not displaying keys...

Postby madmanu » Mon Sep 18, 2006 8:02 pm

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
madmanu
WR.net Apprentice
WR.net Apprentice
 
Posts: 13
Joined: Tue Aug 29, 2006 1:50 pm

Re: Not displaying keys...

Postby sturmy » Mon Sep 18, 2006 11:57 pm

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.
sturmy
WR.net Expert
WR.net Expert
 
Posts: 160
Joined: Wed Aug 16, 2006 9:07 pm

Not displaying keys...

Postby madmanu » Tue Sep 19, 2006 1:48 pm

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."'";
}
}
}
}
madmanu
WR.net Apprentice
WR.net Apprentice
 
Posts: 13
Joined: Tue Aug 29, 2006 1:50 pm

Re: Not displaying keys...

Postby Grobsnelf » Mon Sep 25, 2006 1:04 am

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
Grobsnelf
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Sat Aug 26, 2006 3:07 am

Re: Not displaying keys...

Postby Corwin_Whitehorn » Mon Sep 25, 2006 9:54 pm

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 :scratch:
Last edited by Corwin_Whitehorn on Mon Sep 25, 2006 9:59 pm, edited 1 time in total.
Image
User avatar
Corwin_Whitehorn
WR.net Apprentice
WR.net Apprentice
 
Posts: 10
Joined: Fri Aug 18, 2006 6:18 pm

Re: Not displaying keys...

Postby scotchi » Tue Sep 26, 2006 5:27 am

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
scotchi
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Sun Sep 24, 2006 6:39 am

Re: Not displaying keys...

Postby MrProper » Fri Sep 29, 2006 1:24 pm

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
MrProper
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Fri Jul 07, 2006 8:49 pm

Not displaying keys...

Postby shan_aya » Mon Oct 02, 2006 11:11 pm

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
shan_aya
WR.net Journeyman
WR.net Journeyman
 
Posts: 132
Joined: Fri Aug 11, 2006 12:58 pm

PreviousNext

Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 0 guests

cron