[swsche]

Nice Script but i have a SQL_Error after Installation:

Database error in vBulletin 3.7.4:

Invalid SQL:

		SELECT user.*, COUNT(video.videoid) AS videocount
		FROM vb3_video AS video
		LEFT JOIN vb3_user AS user ON(user.userid = video.userid)
		WHERE NOT ISNULL(user.userid)
		GROUP BY video.userid
		ORDER BY videocount DESC
		LIMIT a;

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 'a' at line 7
Error Number  : 1064
Request Date  : Monday, March 9th 2009 @ 03:08:35 PM
Error Date    : Monday, March 9th 2009 @ 03:08:36 PM
Script        : http://www.elvispresley-community.de/video.php
Referrer      : http://www.elvispresley-community.de/index.php
IP Address    : 217.XXX.XXX.XXX:
Username      : Steve
Classname     : vb_database
MySQL Version : 5.0.67-community

Please tell me what i can do. Thanks a lot for your help.