problem with a french roster and witch hunt

Keep track of who updates their character profile and when

Moderator: Carasak

problem with a french roster and witch hunt

Postby sephra » Sat Nov 17, 2007 8:29 am

Hi

when I try to load my witch hunt web page , here is what I got :


You have an error in your SQL syntax near '(p.dateupdatedutc,'%m/%d/%y %H:%i:%s') as MyDate, m.last_online as lastDate, p.n' at line 1

Anybody could help me pliz ?

Thanx a lot , a sorry for my poor english :x
Last edited by sephra on Sat Nov 17, 2007 10:28 am, edited 2 times in total.
sephra
WR.net Apprentice
WR.net Apprentice
 
Posts: 9
Joined: Mon Nov 20, 2006 3:49 am

Re: problem with a french roster and witch hunt

Postby Carasak » Mon Nov 19, 2007 7:34 pm

this error only happens having the roster main language in French or does it also happen when you select english or any other language?
User avatar
Carasak
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Tue Aug 15, 2006 2:33 am
Location: Spain

problem with a french roster and witch hunt

Postby sephra » Mon Nov 19, 2007 8:47 pm

hello :)
Thx for reply .

This probleme is both in Fr langage and Us langage .

Can you help me ?
sephra
WR.net Apprentice
WR.net Apprentice
 
Posts: 9
Joined: Mon Nov 20, 2006 3:49 am

problem with a french roster and witch hunt

Postby Carasak » Mon Nov 19, 2007 8:58 pm

what is the version of your Mysql database?
you need at least version 4.1.1
roster itself has 4.1.x as requirement.
with versions older than that the command
STR_TO_DATE(p.dateupdatedutc,'%m/%d/%y %H:%i:%s') as MyDate
does not work, which is probably the error you are getting
User avatar
Carasak
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Tue Aug 15, 2006 2:33 am
Location: Spain

problem with a french roster and witch hunt

Postby sephra » Mon Nov 19, 2007 9:11 pm

oki .
I've looked in the admin menu of my roster , and it comes that my version of MySql is the 3.23.58 .
So , does it means that this addons will never works on my roster , till I get a better version pf mysql , like the 4.1.1 as you said ?

Sorry again for my english , I hope you unterstand what I mean ^^
sephra
WR.net Apprentice
WR.net Apprentice
 
Posts: 9
Joined: Mon Nov 20, 2006 3:49 am

Re: problem with a french roster and witch hunt

Postby Carasak » Mon Nov 19, 2007 9:15 pm

you can either try to rewrite the code to something compatible with your version of mysql or upgrade your mysql db
User avatar
Carasak
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Tue Aug 15, 2006 2:33 am
Location: Spain

problem with a french roster and witch hunt

Postby sephra » Mon Nov 19, 2007 9:18 pm

ok , I don't know how to rewrite the code , so I will look how to upgrade mysql dB :)

Thx for your help ;)
sephra
WR.net Apprentice
WR.net Apprentice
 
Posts: 9
Joined: Mon Nov 20, 2006 3:49 am

Re: problem with a french roster and witch hunt

Postby Carasak » Tue Nov 20, 2007 9:35 pm

you can try one of he older versions of the addon
http://www.wowroster.net/Downloads/get=98.html
if i remember right the early versions did not have that code.
just check it out
User avatar
Carasak
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Tue Aug 15, 2006 2:33 am
Location: Spain


Return to Witch Hunt

Who is online

Users browsing this forum: No registered users and 0 guests

cron