[stb74]

I am trying to get vbookie to work with DBtech vBCredits II and have set my Cash/Points system to Custom.

When I try and create a new event I get the following error.

Database error in vBulletin 4.0.7:

Invalid SQL:
SELECT user.userid, (0 + (user.credits * 1) + (user.credits_saved * 1)) AS cash FROM vb_user AS user  WHERE cash < 25;

MySQL Error   : Unknown column 'cash' in 'where clause'
Error Number  : 1054
Request Date  : Tuesday, October 12th 2010 @ 11:25:24 PM
Error Date    : Tuesday, October 12th 2010 @ 11:25:24 PM
Script        : http://www.nifootball.co.uk/forum/vbookie.php
Referrer      : http://www.nifootball.co.uk/forum/vbookie.php?t=12560&vbookieeventoptions=0&do=newev  ent
IP Address    : 81.103.140.198
Username      : stb74
Classname     : vB_Database
MySQL Version : 5.0.51a-24+lenny3