I do this repair on my 4images 1.7.4 and only on index.php have error and the new images is not vieved.
Error Code:
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, 164, 96, 12, 93, 95, 46, 147, 74, 129, 143, 118, 11, 110, 139, 160, 1, 29, 48, 92, 13, 119, 161, 144, 142, 75, 128, 43, 146, 148, 165, 2, 151, 30, 28, 14, 91, 145, 10, 162, 76, 120, 79, 3, 49, 123, 41, 171, 149, 31, 4, 106, 15, 90, 125, 32, 50, 86, 77, 170, 80, 114, 44, 152, 89, 5, 17, 70, 112, 172, 177, 26, 78, 94, 55, 84, 88, 18, 108, 82, 25, 6, 155, 56, 85, 19, 87, 166, 158, 16, 7, 104, 57, 37, 20, 103, 83, 54, 8, 127, 58, 168, 38, 21, 141, 81, 9, 154, 150, 53, 22, 51, 167, 27, 45, 130, 109, 23, 173, 102, 122, 153, 126, 169, 59, 24, 111, 40, 174, 115, 105, 107, 178, 113, 39, 156, 176, 159, 60, 140, 157, 61, 101, 62, 63, 64, 65, 66, 67, 124, 68, 69, 71, 72, 73) ORDER BY i.image_date DESC LIMIT 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 ') LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.i' at line 2
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /includes/db_mysql.php on line 116
Okay, i do some rest of repair and i got :
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, 164, 96, 12, 93, 95, 46, 147, 74, 129, 143, 118, 11, 110, 139, 160, 1, 29, 48, 92, 13, 119, 161, 144, 142, 75, 128, 43, 146, 148, 165, 2, 151, 30, 28, 14, 91, 145, 10, 162, 76, 120, 79, 3, 49, 123, 41, 171, 149, 31, 4, 106, 15, 90, 125, 32, 50, 86, 77, 170, 80, 114, 44, 152, 89, 5, 17, 70, 112, 172, 177, 26, 78, 94, 55, 84, 88, 18, 108, 82, 25, 6, 155, 56, 85, 19, 87, 166, 158, 16, 7, 104, 57, 37, 20, 103, 83, 54, 8, 127, 58, 168, 38, 21, 141, 81, 9, 154, 150, 53, 22, 51, 167, 27, 45, 130, 109, 23, 173, 102, 122, 153, 126, 169, 59, 24, 111, 40, 174, 115, 105, 107, 178, 113, 39, 156, 176, 159, 60, 140, 157, 61, 101, 62, 63, 64, 65, 66, 67, 124, 68, 69, 71, 72, 73) ORDER BY i.image_date DESC LIMIT 20 Unknown column 'i.user_id' in 'on clause'