[trotskid]

Thanks for this mod :up:, but I have an invalid SQL , and also I have instaled "vBAdvanced Module: Random Groups" without problems.. Maybe a conflict with "Latest Picture" (I think is the same module that Niner1000RR is talking about)?

Database error in vBulletin 3.8.2:

Invalid SQL:

     SELECT albumpicture.*, album.*, user.username, user.usergroupid,
  IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid 
  FROM vbalbumpicture AS albumpicture
  LEFT JOIN vbalbum AS album ON(album.albumid = albumpicture.albumid)
  LEFT JOIN vbuser AS user ON(user.userid = album.userid)
  WHERE album.state = 'public' 
  ORDER BY dateline DESC 
  LIMIT 0,;

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 '' at line 8
Error Number  : 1064
Request Date  : Wednesday, April 15th 2009 @ 03:10:46 AM
Error Date    : Wednesday, April 15th 2009 @ 03:10:47 AM
Script        : xxxxxxxxxx
Referrer      : 
IP Address    : xxxxxxx
Username      : xxxxxxx
Classname     : vB_Database
MySQL Version : 5.0.45-log

PS: curious, on my Dynamics works well..