2
« on: October 23, 2008, 09:12:58 AM »
Hallo Leute,
Nach einem Umzug auf einen anderen Webspace (Datenbank ex,-import...), bekomme ich nun folgende fehlermeldungen:
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 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0, 14, 3, 12, 18, 22, 26, 2, 28, 33, 20, 35, 19, 13, 40, 16, 31, 34, 29, 21, 4, 36, 37, 32, 17, 5, 23, 38, 24, 25, 6, 30, 27, 7, 8, 9, 10, 11, 15, 39) ORDER BY i.image_rating DESC, i.image_votes DESC
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 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0, 14, 3, 12, 18, 22, 26, 2, 28, 33, 20, 35, 19, 13, 40, 16, 31, 34, 29, 21, 4, 36, 37, 32, 17, 5, 23, 38, 24, 25, 6, 30, 27, 7, 8, 9, 10, 11, 15, 39) ORDER BY i.image_votes DESC, i.image_rating DESC
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 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0, 14, 3, 12, 18, 22, 26, 2, 28, 33, 20, 35, 19, 13, 40, 16, 31, 34, 29, 21, 4, 36, 37, 32, 17, 5, 23, 38, 24, 25, 6, 30, 27, 7, 8, 9, 10, 11, 15, 39) ORDER BY i.image_hits DESC, i.image_name ASC
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 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0, 14, 3, 12, 18, 22, 26, 2, 28, 33, 20, 35, 19, 13, 40, 16, 31, 34, 29, 21, 4, 36, 37, 32, 17, 5, 23, 38, 24, 25, 6, 30, 27, 7, 8, 9, 10, 11, 15, 39) ORDER BY i.image_comments DESC, i.image_name ASC
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 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0, 14, 3, 12, 18, 22, 26, 2, 28, 33, 20, 35, 19, 13, 40, 16, 31, 34, 29, 21, 4, 36, 37, 32, 17, 5, 23, 38, 24, 25, 6, 30, 27, 7, 8, 9, 10, 11, 15, 39) ORDER BY i.image_downloads DESC, i.image_name ASC
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, i.image_gmap_latitude, i.image_gmap_longitude, i.image_gmap_zoom, i.image_gmap_type, i.image_gmap_show, 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 c.cat_id = i.cat_id AND i.cat_id IN (0, 14, 3, 12, 18, 22, 26, 2, 28, 33, 20, 35, 19, 13, 40, 16, 31, 34, 29, 21, 4, 36, 37, 32, 17, 5, 23, 38, 24, 25, 6, 30, 27, 7, 8, 9, 10, 11, 15, 39) ORDER BY i.image_date DESC LIMIT 5
Unknown column 'i.user_id' in 'on clause'
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/web273/html/Galerie/includes/db_mysql.php on line 116
Kann mir vielleicht jemand einen Tipp geben, woran das liegen könnte?
Vielen Dank im vorraus!!!