[savraot]

I get Database Errors when I use the vbsoccer Plugins.

Datenbankfehler in vBulletin 4.1.9:

Invalid SQL:

			SELECT (_wr * 0) +
			((_count - _wr - _rr - _rd) * 1) +
			(_rd * 2) +
			(_rr * 3) AS points
			FROM (
				SELECT userid, COUNT(*) AS _count,
				SUM(score_key != bet_score_key) AS _wr,
				SUM(bet_home=points_home AND bet_away=points_away) AS _rr,
				SUM(CAST(bet_home - bet_away AS SIGNED)=(points_home - points_away)
				AND NOT (bet_home = points_home AND bet_away = points_away)) AS _rd
			FROM vb4soccer_user_bet AS b
			INNER JOIN vb4soccer_match AS m ON(m.id=b.match_id)
			WHERE userid=1 AND score_key>0 AND match_is_finished=1
			AND b.dateline > 315532800
			AND m.dateline > 315532800
			GROUP BY userid) AS userpoints;

MySQL-Fehler  : Unknown column 'b.dateline' in 'where clause'
Fehler-Nr.    : 1054
Fehler-Zeit   : Saturday, 24.12.2011 @ 20:02:04
Datum         : Saturday, 24.12.2011 @ 20:02:04
Skript        : http://www.yyy.eu/cron.php?rand=1324753321
Referrer      : http://www.yyy.eu/forum.php
IP-Adresse    : 77.2.186.155
Benutzername  : Unregistriert
Klassenname   : vB_Database
MySQL-Version :

How can I solve this Problem?. I have temporary the two vbsoccer Plugins disabled, but I need this Plugins.