I have a persistent problem that I've been through this thread for, but can't find an answer - it's about getting it to work with vBookie.
I get the following error whenever I place a bet, or try and process a bet. The necessary changes are made (deductions, bets processed etc) - although the bet remains open and I get this message.
Please could somebody help? Thank you kindly for your time.
Code:
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT
SUM(bet_amount_won) AS sumbets
FROM vbookie_bets_placed
WHERE bet_settled='Y' AND userid=1
AND dateline > 315532800
GROUP BY userid;
MySQL Error : Unknown column 'dateline' in 'where clause'
Error Number : 1054
Request Date : Saturday, June 9th 2012 @ 09:57:44 PM
Error Date : Saturday, June 9th 2012 @ 09:57:44 PM
Script : http://xxxxxxxxx.co.uk/vbookie.php
Referrer : http://xxxxxxxxx.co.uk/showthread.php?5442-Denmark-v-Holland
IP Address : 94.170.24.192
Username : Si
Classname : vB_Database_MySQLi
MySQL Version : 5.0.91-log