3
« on: April 23, 2008, 01:18:25 PM »
Hallo,
ich habe in letzter Zeit sehr viele MOD zur Gallery hinzugefügt. Das hat auch super geklappt. Danke nochmal für die tollen Erweiterungsmglichkeiten.
Mir ist aber gerade aufgefallen, wenn ich ein neues Bild hochlade und mich in der member.php ( Bild Upload) befinde, erhalte ich folge Fehlermeldungen
DB Error: Bad SQL Query: SELECT COUNT(*) as user_count_images FROM maritim_images WHERE user_id =
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
DB Error: Bad SQL Query: SELECT COUNT(i.user_id) AS images FROM (maritim_images i, maritim_categories c) LEFT JOIN maritim_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.user_id = AND i.cat_id NOT IN (0)
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.cat_id NOT IN (0)' at line 4
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 (maritim_images i, maritim_categories c) LEFT JOIN maritim_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.user_id = AND i.cat_id NOT IN (0) ORDER BY i.image_date DESC LIMIT 0, 20
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.cat_id NOT IN (0) ORDER BY i.image_date DESC
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/htdocs/w007d931/maritim/includes/db_mysql.php on line 116
Welche Tabellen fehlen mir den in meiner Datenbank? Kann mir das vieleicht jemand in kurzform übersetzen...
Danke gruß Steffen