Author Topic: DB ERROR FOR MINI TOP  (Read 2409 times)

0 Members and 1 Guest are viewing this topic.

Offline __G__

  • Sr. Member
  • ****
  • Posts: 286
    • View Profile
DB ERROR FOR MINI TOP
« 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'

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: DB ERROR FOR MINI TOP
« Reply #1 on: January 08, 2009, 02:11:29 AM »
mini top is not part of 4images itself, please reply to the appropriate topic.

but before you do that, check out "error message" in my signature and search for the topic related to MySQL v5
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)