2
« on: September 03, 2002, 09:59:11 AM »
habe soeben auf 1.7 upgedated. das entsprechende update skript funktionierte ("update successfull"), aber nun erscheint auf der index.php seite folgender error:
DB Error: Bad SQL Query: SELECT DISTINCT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0, 29, 14, 18, 1, 12, 2, 3, 13, 7, 15, 24, 5, 27, 4, 19, 10, 22, 20, 9, 23, 25, 8, 11, 28, 26, 16, 17) AND c.cat_id = i.cat_id ORDER BY RAND()
You have an error in your SQL syntax near 'RAND()' at line 5
was muss ich tun??
danke!