seit mein provider gestern die mysql version auf 5.0.32 gestellt hat, bekomm ich in meinen bildergalerien folgende fehlermeldungen und es werden keine bilder mehr angezeigt
kann mir da bitte möglichst schnell jemand helfen was ich da tun muss? vielen dank!!
since today - my provider make a update from mysql version 4 to 5.0.32 - i get this error in all my galleries. can someone help me! thanks!! ... and sorry for my bad english.
DB Error: Bad SQL Query: SELECT 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 4imagesimages i, 4imagescategories c LEFT JOIN 4imagesusers u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0, 58) AND c.cat_id = i.cat_id LIMIT 164, 1
Unknown column 'i.user_id' in 'on clause'
DB Error: Bad SQL Query: SELECT 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 4imagesimages i, 4imagescategories c LEFT JOIN 4imagesusers u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id NOT IN (0, 58) ORDER BY i.image_date DESC LIMIT 3
Unknown column 'i.user_id' in 'on clause'
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /is/htdocs/xxxxxxxxx/www.hypofun.com/pixgalerie/includes/db_mysql.php on line 116
DB Error: Bad SQL Query: SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_thumb_file, i.image_media_file, i.image_thumb_file, i.image_rating, i.image_votes, i.image_comments, c.cat_name, u.user_name, i.image_downloads, i.image_hits, i.image_potm, i.image_potm_date, i.image_potm_votes FROM 4imagesimages i, 4imagescategories c LEFT JOIN 4imagesusers u ON (u.user_id = i.user_id) WHERE i.image_active = i.image_potm AND c.cat_id = i.cat_id AND i.cat_id IN (0, 37, 69, 73, 79, 22, 14, 72, 55, 32, 18, 38, 65, 82, 83, 81, 25, 43, 23, 20, 68, 17, 44, 47, 50, 15, 71, 46, 80, 33, 40, 64, 42, 78, 12, 62, 67, 7, 13, 26, 16, 70, 45, 27, 34, 41, 63, 60, 77, 19, 24, 35, 6, 59, 54, 76, 28, 21, 36, 57, 53, 29, 61, 30, 56, 49, 8, 66, 48, 9, 31, 52, 10, 51, 11) ORDER BY i.image_potm_date DESC LIMIT 1
Unknown column 'i.user_id' in 'on clause'
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /is/htdocs/xxxxxxxxxxx/www.hypofun.com/pixgalerie/includes/db_mysql.php on line 116