Fehler nach Server-Umzug

[Fryz]

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!!!

[kai]

Schau mal im FAQ:
http://www.4homepages.de/forum/index.php?topic=18780.0

[Fryz]

Danke für die schnelle Antwort!
Leider hat das nicht viel geholfen. Es sind zwar nun 2 Fehlermeldungen weniger, hab aber immer noch folgende:

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'

[Nicky]

hi Fryz,

das heist das du nicht alle erledigt hast..
such am besten in ALLEN php dateien nach

Code: [Select]

FROM ".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." cund ersetze es mit

Code: [Select]

FROM (".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)

[Fryz]

Klasse! Danke dir. Die "mini_top.php" war schuld daran

[Nicky]

immerwieder gerne