Multiple php/SQL errors, please help...

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

Multiple php/SQL errors, please help...

Postby Gamble » Fri Aug 11, 2006 4:42 pm

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!
Gamble
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Sat Jul 22, 2006 1:19 pm

Multiple php/SQL errors, please help...

Postby Gamble » Sat Aug 12, 2006 2:19 pm

Noone knows? Noone seen these errors?
:(
Gamble
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Sat Jul 22, 2006 1:19 pm

Multiple php/SQL errors, please help...

Postby Sphinx » Sat Aug 12, 2006 3:17 pm

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....
User avatar
Sphinx
Gimpy Developer
Gimpy Developer
 
Posts: 16
Joined: Wed Jul 05, 2006 2:24 pm

Multiple php/SQL errors, please help...

Postby Gamble » Sat Aug 12, 2006 3:26 pm

Here it is.
Roster - in english. All nicks are in English as well...
Gamble
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Sat Jul 22, 2006 1:19 pm

Multiple php/SQL errors, please help...

Postby Sphinx » Sat Aug 12, 2006 3:36 pm

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...
User avatar
Sphinx
Gimpy Developer
Gimpy Developer
 
Posts: 16
Joined: Wed Jul 05, 2006 2:24 pm

Multiple php/SQL errors, please help...

Postby Gamble » Sat Aug 12, 2006 4:06 pm

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... :(
Gamble
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Sat Jul 22, 2006 1:19 pm

Multiple php/SQL errors, please help...

Postby zanix » Sat Aug 12, 2006 7:17 pm

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
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

Multiple php/SQL errors, please help...

Postby Gamble » Sat Aug 12, 2006 11:15 pm

Ok, and leaving out the SQl error, is there anything that can be done to resolve the PHP error? Thank you in advance.
Gamble
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Sat Jul 22, 2006 1:19 pm

Re: Multiple php/SQL errors, please help...

Postby Tiratore » Fri Nov 17, 2006 7:51 pm

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
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Tue Jul 04, 2006 2:09 pm

Multiple php/SQL errors, please help...

Postby zanix » Fri Nov 17, 2006 8:23 pm

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
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


Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 1 guest

cron