Hola buenas noches, he instalado la galeria 4images 1.7.1 en mi web, y a la hora de visualizar las imagenes en la pantalla principal de la galeria no sale nada; solo sale la categoria que tengo creada; hasta ahi creo que bien; cuando pulso en la categoria no me sale la foto que tengo subida al servidor, me dice que tengo una foto pero no me la muestra y en la parte superior de la pagina aparece este error a ver si alguien me pudiese ayudar por si tuviese que modificar algo :s :
"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 i.cat_id NOT IN (0) AND c.cat_id = i.cat_id LIMIT 0, 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 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 NOT IN (0) 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 /web/htdocs/www.
mipagina.com/home/4images/includes/db_mysql.php on line 116"
Muchas gracias y espero que a alguien le pasara algo parecido y lo haya solucionado.
