[ABMAC]

I'm also having trouble getting this mod to work. I would appreciate any help you can offer.

PHP version 4.4.7
MySQL version 4.0.23

Database error in vBulletin 3.6.7:

Invalid SQL:

            SELECT avatar.avatarid, avatar.title, avatar.minimumposts, avatar.avatarpath, avatar.imagecategoryid, avatar.displayorder, count(1)
            FROM user , avatar
            WHERE user.avatarid = avatar.avatarid
            AND avatar.imagecategoryid = 3
            AND minimumposts <= 8681
            GROUP by avatar.avatarid
            UNION
            SELECT avatarid, title, minimumposts, avatarpath, imagecategoryid, displayorder, 0
            FROM avatar
            WHERE avatarid not in (select distinct avatarid from user)
            AND imagecategoryid = 3
            AND minimumposts <= 8681
            ORDER by displayorder, title
            LIMIT 50,10;

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 'select distinct avatarid from user)
            AND imagecateg
Error Number : 1064
Date         : Tuesday, June 5th 2007 @ 04:04:37 PM
Script       : http://megomuseum.com/community/profile.php?do=editavatar&categoryid=3&page=6
Referrer     : http://megomuseum.com/community/profile.php?do=editavatar&categoryid=3&page=5
IP Address   : ***.***.***.***
Username     : ABMAC
Classname    : vb_database