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 

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?

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 -