I use the Nextgen Widget to display random images on a sidebar.
Since Update 2.0.x this Display’s an error:
WordPress database 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 ‘) ORDER BY RAND() LIMIT 9’ at line 1]
SELECT pid
FROM wp_ngg_pictures
WHERE exclude
= 0 AND galleryid
IN () ORDER BY RAND() LIMIT 9
You can view this live @ http://www.singen-thueringen.de
nevertheless. the images are displayed…..!!!
http://wordpress.org/plugins/nextgen-gallery/