17
« on: January 08, 2009, 02:04:09 AM »
hi i just moved my site to diffrent host everything working fine but this error is showing on very top and its not loading the mini top mod images do u know what am i doing wrong ??
the error is
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, 54, 175, 29, 173, 158, 143, 63, 27, 163, 147, 197, 157, 199, 153, 166, 1, 146, 36, 47, 49, 24, 19, 152, 10, 176, 141, 25, 64, 144, 38, 31, 52, 14, 198, 194, 155, 45, 200, 201, 177, 11, 162, 65, 20, 203, 32, 156, 40, 46, 145, 178, 164, 66, 33, 9, 202, 179, 159, 67, 142, 13, 3, 34, 180, 39, 55, 68, 170, 4, 181, 69, 160, 204, 2, 35, 182, 92, 161, 41, 5, 37, 183, 70, 59, 6, 44, 71, 184, 28, 48, 168, 23, 72, 50, 185, 165, 7, 73, 186, 56, 8, 61, 74, 17, 187, 57, 75, 18, 188, 53, 76, 21, 189, 58, 77, 154, 190, 60, 78, 191, 22, 79, 192, 30, 81, 51, 193, 80, 62, 82, 151, 83, 42, 84, 43, 85, 169, 86, 171, 174, 87, 88, 195, 89, 196, 90, 205, 91, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140) ORDER BY i.image_rating DESC, i.image_votes DESC
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, 54, 175, 29, 173, 158, 143, 63, 27, 163, 147, 197, 157, 199, 153, 166, 1, 146, 36, 47, 49, 24, 19, 152, 10, 176, 141, 25, 64, 144, 38, 31, 52, 14, 198, 194, 155, 45, 200, 201, 177, 11, 162, 65, 20, 203, 32, 156, 40, 46, 145, 178, 164, 66, 33, 9, 202, 179, 159, 67, 142, 13, 3, 34, 180, 39, 55, 68, 170, 4, 181, 69, 160, 204, 2, 35, 182, 92, 161, 41, 5, 37, 183, 70, 59, 6, 44, 71, 184, 28, 48, 168, 23, 72, 50, 185, 165, 7, 73, 186, 56, 8, 61, 74, 17, 187, 57, 75, 18, 188, 53, 76, 21, 189, 58, 77, 154, 190, 60, 78, 191, 22, 79, 192, 30, 81, 51, 193, 80, 62, 82, 151, 83, 42, 84, 43, 85, 169, 86, 171, 174, 87, 88, 195, 89, 196, 90, 205, 91, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140) ORDER BY i.image_votes DESC, i.image_rating DESC
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, 54, 175, 29, 173, 158, 143, 63, 27, 163, 147, 197, 157, 199, 153, 166, 1, 146, 36, 47, 49, 24, 19, 152, 10, 176, 141, 25, 64, 144, 38, 31, 52, 14, 198, 194, 155, 45, 200, 201, 177, 11, 162, 65, 20, 203, 32, 156, 40, 46, 145, 178, 164, 66, 33, 9, 202, 179, 159, 67, 142, 13, 3, 34, 180, 39, 55, 68, 170, 4, 181, 69, 160, 204, 2, 35, 182, 92, 161, 41, 5, 37, 183, 70, 59, 6, 44, 71, 184, 28, 48, 168, 23, 72, 50, 185, 165, 7, 73, 186, 56, 8, 61, 74, 17, 187, 57, 75, 18, 188, 53, 76, 21, 189, 58, 77, 154, 190, 60, 78, 191, 22, 79, 192, 30, 81, 51, 193, 80, 62, 82, 151, 83, 42, 84, 43, 85, 169, 86, 171, 174, 87, 88, 195, 89, 196, 90, 205, 91, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140) ORDER BY i.image_hits DESC, i.image_name ASC
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, 54, 175, 29, 173, 158, 143, 63, 27, 163, 147, 197, 157, 199, 153, 166, 1, 146, 36, 47, 49, 24, 19, 152, 10, 176, 141, 25, 64, 144, 38, 31, 52, 14, 198, 194, 155, 45, 200, 201, 177, 11, 162, 65, 20, 203, 32, 156, 40, 46, 145, 178, 164, 66, 33, 9, 202, 179, 159, 67, 142, 13, 3, 34, 180, 39, 55, 68, 170, 4, 181, 69, 160, 204, 2, 35, 182, 92, 161, 41, 5, 37, 183, 70, 59, 6, 44, 71, 184, 28, 48, 168, 23, 72, 50, 185, 165, 7, 73, 186, 56, 8, 61, 74, 17, 187, 57, 75, 18, 188, 53, 76, 21, 189, 58, 77, 154, 190, 60, 78, 191, 22, 79, 192, 30, 81, 51, 193, 80, 62, 82, 151, 83, 42, 84, 43, 85, 169, 86, 171, 174, 87, 88, 195, 89, 196, 90, 205, 91, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140) ORDER BY i.image_comments DESC, i.image_name ASC
Unknown column 'i.user_id' in 'on clause'