Been getting following error since updating the module. Any idea why? I uploaded the file and re-imported the plugin. It doesn't happen all the time though.
Code:
Database error in vBulletin 3.6.1:
Invalid SQL:
SELECT imageid, images.title, images.description, filename, thumbname, originalname, extension, images.catid ,images.userid, images.username, images.title, images.dateline ,filesize, originalfilesize ,width, height, originalwidth, originalheight, images.views, images.posts, images.lastpostdateline, images.lastpostuserid, images.lastpostusername, votenum, votetotal, categories.title AS cattitle
FROM vb_adv_gallery_images AS images
LEFT JOIN vb_adv_gallery_categories AS categories USING (catid)
WHERE Array valid = 1
ORDER BY RAND()
LIMIT 1;
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 'valid = 1
ORDER BY RAND()
Error Number : 1064