1
Français / Re: probleme de ligne
« on: April 13, 2006, 05:37:06 PM »
je ne sais pas qu'elle version de Mysql j'utilise, mais je pense que je vais tt deinstaller! merci pour ton aie!
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
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.username FROM madfrflash_images i, madfrflash_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0, 146, 117, 100, 46, 17, 4, 145, 10, 34, 57, 139, 1, 118, 102, 132, 36, 69, 101, 2, 6, 19, 120, 95, 93, 11, 26, 104, 70, 105, 83, 96, 94, 97, 99, 98, 137, 115, 135, 136, 138, 151) AND c.cat_id = i.cat_id LIMIT 28, 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.username FROM madfrflash_images i, madfrflash_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id = 130 AND c.cat_id = i.cat_id ORDER BY image_name ASC LIMIT 0, 9
Unknown column 'i.user_id' in 'on clause'
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/free.fr/e/6/madonna.france/madfrflash/includes/db_mysql.php on line 116
Mais alors là !!! pourquoi faire simple alors qu'on peut faire compliqué ?
plusieurs topics en parlent comme : ici ou encore ici....
dans le fichier includes/constants.php , modifie la valeur de la variable SHOW_RANDOM_CAT_IMAGE de 0 à 1