[douffle]

Originally Posted by pedigree

Hmm, this is a strange now. I do all my development on 5 but I installed 4.1.22 and the query is indeed a valid one. Try this, open includes\functions_vbsfs.php, go to line 71 and change

$sql = "SELECT DATEDIFF(NOW(), '" . $lastseen . "') AS DAYS;";

to

$sql = "SELECT DATEDIFF(NOW(), '" . $lastseen . "') AS DAYS";

Notice the ; removed from before the last "

Can you PM me your exact version of mySQL, PHP and Apache that youre using on the forum that gives you this error, your server locale (US, Japan, French etc) so that I can look at it a bit more

I tried to register on your forum but your NoSpam questions/answers are wrong. 8+8-3 = 13 but not according to your forum

Hi,

There was a typo in the answer setting which has been corrected.
The problem exists on both of my sites, the one using MySQL4 and the one using MySQL5.

The first site, (vbulletinstuff.com), is using MySQL 5.0.45 and PHP 5.2.6.
The server is located in Hong Kong.

The other site, (webmastersden.net) is using MySQL 4.0.27 and PHP 5.2.6.
The server for this site is located in the U.S.A. I can switch it to MySQL 5 but I just haven't gotten around to doing it yet.

I will change the code as you suggest and get back to you with the results.

Thanks.