[nhawk]

Originally Posted by cravendale

Hi,

I'm running vB 4.0.6 so I'm also running an older version of Raffles.

When a member entered the Raffle. They get a DB error and this is what I get in email...

Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT * FROM raffle
WHERE startdate <= 1336313626
WHERE enddate > 1336313626
ORDER BY id DESC;

MySQL Error : 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 'WHERE enddate > 1336313626
ORDER BY id DESC' at line 3
Error Number : 1064
Request Date : Sunday, May 6th 2012 @ 09:13:46 AM
Error Date : Sunday, May 6th 2012 @ 09:13:46 AM
Script : http://www.twofoursix/forum/raffles.php?do=main
Referrer : http://www.twofoursix.com/forum/raffles.php
IP Address : 77.101.70.149
Username : superjoe
Classname : vB_Database
MySQL Version :

The member appears in the list of members who entered. How can I resolve this error please?

thanks

Update raffles to the latest version.