5
« on: September 28, 2006, 06:30:58 PM »
Hallo Zusammen,
Ich wollte meine Umgebung von 1.70 auf 1.73 aktualisieren. Dazu habe ich mir mein PC mit den neusten XAMPP aufgesetzt.
Apache 2.2.3
MySQL 5.0.24a
PHP 5.1.6 & PHP 4.4.4
phpMyAdmin 2.8.2.4
FileZilla FTP Server 0.9.18
OpenSSL 0.9.8c
Leider erscheint beim Aufrufen der Gallerie diese Meldung:
B 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, 28, 12, 24, 1, 18) AND c.cat_id = i.cat_id ORDER BY RAND()
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, 22, 39, 40, 29, 11, 27, 21, 26, 34, 30, 2, 20, 16, 17, 3, 31, 38, 23, 36, 15, 10, 32, 25, 35, 14, 33, 19, 13, 37, 5, 41, 8, 42, 9, 43, 6, 7, 4) ORDER BY i.image_date DESC LIMIT 8
Unknown column 'i.user_id' in 'on clause'
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\Webserver\htdocs\4images\includes\db_mysql.php on line 117
Frage:
Wo wird diese "i." und "u." resp. den Select Befehlt zusammen gebaut? Denn in der Tabelle sind nur cat.id, user.id, image_name etc. vorhanden.
Für Tips und Tricks danke ich bestens im Voraus.
Gruss
Theking6