SQL/Index.php error

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

Moderators: Ulminia, poetter

SQL/Index.php error

Postby TAGuild » Thu Aug 30, 2007 6:54 am

I get the following error. I have seen very simular errors in other post, but no solution.

Code: Select all
SQL:
SELECT members.name , ISNULL(players.name) AS playerExists , STR_TO_DATE(players.dateupdatedutc,'') AS playerLastUpdated FROM `roster_members` members LEFT JOIN `roster_players` players ON members.name = players.name WHERE members.level >= AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'') <= DATE_SUB(NOW(), INTERVAL HOUR) OR STR_TO_DATE(players.dateupdatedutc,'') >= DATE_ADD(NOW(), INTERVAL 1 YEAR) ) ORDER BY 
File: index.php
Line: 42
Backtrace (most recent call last):
File: C:\Program Files\xampp\htdocs\HOHA\roster\lib\commonfunctions.lib.php
line 248
function called: backtrace
File: C:\Program Files\xampp\htdocs\HOHA\roster\addons\ArmorySynch\index.php
line 42
function called: die_quietly
args: 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 'AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'') <= DATE_SUB' at line 1, Database Error, index.php, 42, SELECT members.name , ISNULL(players.name) AS playerExists , STR_TO_DATE(players.dateupdatedutc,'') AS playerLastUpdated FROM `roster_members` members LEFT JOIN `roster_players` players ON members.name = players.name WHERE members.level >= AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'') <= DATE_SUB(NOW(), INTERVAL HOUR) OR STR_TO_DATE(players.dateupdatedutc,'') >= DATE_ADD(NOW(), INTERVAL 1 YEAR) ) ORDER BY
File: C:\Program Files\xampp\htdocs\HOHA\roster\addon.php
line 77
function called: include_once
args: C:\Program Files\xampp\htdocs\HOHA\roster\addons\ArmorySynch\index.php 
TAGuild
WR.net Apprentice
WR.net Apprentice
 
Posts: 9
Joined: Sat Apr 28, 2007 12:15 am

SQL/Index.php error

Postby TAGuild » Thu Aug 30, 2007 7:03 am

In this post it suggest that the issue may be with SQL version 4.1 and below.
http://www.wowroster.net/Forums/viewtopic/t=3839.html


However, I am using SQL version 5.0.33 and this is the error I am getting.

Anyone else have a reason, idea, anything?
Last edited by TAGuild on Thu Aug 30, 2007 7:04 am, edited 1 time in total.
TAGuild
WR.net Apprentice
WR.net Apprentice
 
Posts: 9
Joined: Sat Apr 28, 2007 12:15 am

SQL/Index.php error

Postby rubio25 » Fri Sep 07, 2007 6:31 am

POSSIBLE WORK-AROUND TO THE SQL ERROR --- Sometimes the variables which are declared in one file will not parse to a different one if the file is included - as to why that happens no idea. It might have to do with xamp - that is where I have seen it happen from time to time.

That leaves the SQL statement blank where the variables need to be filled in and that will than result in an You have an error in your SQL ... message.

As a quick hack around you include them in the file where they are expected.

Try this. open the ArmorySync/conf.php and copy the variables declaration lines basically everything in between:
//Configuration

and the php end sign (?>) don't copy this end sign ---> ?>

open the ArmorySync/index.php and paste the lines under this one :
require_once("config.php");

once you did this you can delete the line: 'require_once("config.php");'
as it is no longer required.

Works for me -
Last edited by rubio25 on Tue Sep 25, 2007 5:02 am, edited 3 times in total.
rubio25
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Tue Jul 11, 2006 11:54 pm


Return to ArmorySync - Depreciated

Who is online

Users browsing this forum: No registered users and 1 guest

cron