On several pages (example from guildbank page) I get the following error:

Code: Select all

Warning: date() [function.date]: Windows does not support dates prior to midnight (00:00:00), January 1, 1970 in ...........\roster\addons\guildbank\gbank.php on line 403

On Keys page I get:

Code: Select all

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

Any solutions? (I did use search, haven't found anything similar...)
Win2k Server, php 5.0.3, mysql 4.1.7

Thank you in advance!

Noone knows? Noone seen these errors?

The second error is a problem with different locales (enUS and deDE?) in your roster?

What roster language are you using? And perhaps you could post a URL to your roster....

Here it is.
Roster - in english. All nicks are in English as well...

Nope

Have a look at the Char Aravorn (and others).
There are not using a enUS-client, i am not sure, are that kyrillic chars?

The key-page and many other things in roster are only working with deDE and enUS...

It's only the honor rank which's in Russian, but nicknames and everything else is in english. Assuming tables SQL is referring to are also in English, I don't see how partial fields in diff. languages can bug the rest...?
But, OK, we'll live without the keys page in worst case.

But what about the php/date error? I've seen several reports of this error on this forum, but no solutions from anyone...

Sphinx means that this character uses a different wow client, one that is not enUS
Look at their character page
http://www.wow-fear.com/roster/char.php?name=Aravorn&server=Shadow%20Moon
The data in their WoW client is definatly not enUS or deDE
This is why all the text doesn't show up and some of the pages (tabs) are broken

The locale looks russian to me
I remember that the russian localization is actually an addon made by some company

If this is so, do the following to fix their charactrer pages:

• Have them disable that addon
• Do a /cp purge all
• Re-scan their character
• Then upload their CP.lua file

Ok, and leaving out the SQl error, is there anything that can be done to resolve the PHP error? Thank you in advance.

zanix wrote:Sphinx means that this character uses a different wow client, one that is not enUS
Look at their character page
http://www.wow-fear.com/roster/char.php?name=Aravorn&server=Shadow%20Moon
The data in their WoW client is definatly not enUS or deDE
This is why all the text doesn't show up and some of the pages (tabs) are broken

The locale looks russian to me
I remember that the russian localization is actually an addon made by some company

If this is so, do the following to fix their charactrer pages:

• Have them disable that addon
• Do a /cp purge all
• Re-scan their character
• Then upload their CP.lua file

Good day!

Yes, we have addon to localizate WoW client - RuWoW

This addon change language locale to ruRU. To fix this problem better make next steps:
1. Copy enEN.php to ruRU.php.
2. In ruRU.php change all enEN to ruRU.

Done. After this WoW Roster will work correct with russian locale. Same way if you have other locales.

But first problem with date - I don't know how to fix yet. I'm working on it now.

Tiratore wrote:

zanix wrote:Sphinx means that this character uses a different wow client, one that is not enUS
Look at their character page
http://www.wow-fear.com/roster/char.php?name=Aravorn&server=Shadow%20Moon
The data in their WoW client is definatly not enUS or deDE
This is why all the text doesn't show up and some of the pages (tabs) are broken

The locale looks russian to me
I remember that the russian localization is actually an addon made by some company

If this is so, do the following to fix their charactrer pages:

• Have them disable that addon
• Do a /cp purge all
• Re-scan their character
• Then upload their CP.lua file

Good day!

Yes, we have addon to localizate WoW client - RuWoW

This addon change language locale to ruRU. To fix this problem better make next steps:
1. Copy enEN.php to ruRU.php.
2. In ruRU.php change all enEN to ruRU.

Done. After this WoW Roster will work correct with russian locale. Same way if you have other locales.

But first problem with date - I don't know how to fix yet. I'm working on it now.

If you do create a Russian locale, or have one made already
Can you please post here
Roster > General Support & Feedback >Languages