erreur 1064 sur roster 1.7.3

Sync Blizzards' Armory data with WoWRoster (addon depreciated no longer works see ApiSync)

Moderators: Ulminia, poetter

erreur 1064 sur roster 1.7.3

Postby foxcorp » Thu Nov 01, 2007 12:52 am

Bonjour
J'ai voulu installer ArmorySync mais je rencontre l'erreur suivante:

1064: Erreur de syntaxe pr賠de '(players.dateupdatedutc,'%d/%m/%y %H:%i:%s') AS playerLastUpdate' ࠬa ligne 1

SQL:
SELECT members.name , ISNULL(players.name) AS playerExists , STR_TO_DATE(players.dateupdatedutc,'%d/%m/%y %H:%i:%s') AS playerLastUpdated FROM `rosterelu_members` members LEFT JOIN `rosterelu_players` players ON members.name = players.name WHERE members.level >= 10 AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'%d/%m/%y %H:%i:%s') <= DATE_SUB(NOW(), INTERVAL 24 HOUR) OR STR_TO_DATE(players.dateupdatedutc,'%d/%m/%y %H:%i:%s') >= DATE_ADD(NOW(), INTERVAL 1 YEAR) ) ORDER BY members.last_online DESC
File: index.php
Line: 42






Quelqu'un peut il m'aider ?

Merci d'avance
Last edited by foxcorp on Thu Nov 01, 2007 12:53 am, edited 1 time in total.
foxcorp
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Sat Aug 18, 2007 2:48 am

erreur 1064 sur roster 1.7.3

Postby poetter » Thu Nov 01, 2007 4:34 pm

Sorry, my frensh is to bad, but from the error message i would say you are using MySQL < 4.1. Which version of AS are you using? If it is the 253_fixes_5 select mysql_lower_4_1 in your config.php.
Image
User avatar
poetter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 462
Joined: Sat Jun 30, 2007 9:41 pm
Location: Germany/Hamburg

Re: erreur 1064 sur roster 1.7.3

Postby foxcorp » Fri Nov 02, 2007 9:34 pm

ok thanks, i test
foxcorp
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Sat Aug 18, 2007 2:48 am


Return to ArmorySync - Depreciated

Who is online

Users browsing this forum: No registered users and 0 guests

cron