Author Topic: Suddenly started getting DB errors  (Read 3563 times)

0 Members and 1 Guest are viewing this topic.

Offline hyde101

  • Sr. Member
  • ****
  • Posts: 410
  • 34TR.COM (Running 4images)
    • View Profile
    • Nostalgia Istanbul
Suddenly started getting DB errors
« on: July 25, 2011, 09:34:38 PM »
Please take a look at my site. Recently 1and1 deleted my database, and they are claiming I deleted it but they cannot show any proof when or by which IP it was deleted.
Anyway, I restored an earlier version I had from last year, but I had not done any changes to the site during last 3 years anyway, but the site won't take it.

www.34tr.com

Code: [Select]
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, 68, 1, 32, 23, 15, 8, 29, 24, 33, 30, 17, 16, 9, 40, 67, 5, 13, 38, 26, 54, 3, 65, 2, 52, 34, 53, 43, 14, 55, 7, 46, 57, 50, 10, 6, 51, 56, 42, 60, 11, 44, 61, 48, 62, 28, 4, 47, 12, 27, 39, 41, 45, 49, 58, 59, 63, 64, 66) 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, 68, 1, 32, 23, 15, 8, 29, 24, 33, 30, 17, 16, 9, 40, 67, 5, 13, 38, 26, 54, 3, 65, 2, 52, 34, 53, 43, 14, 55, 7, 46, 57, 50, 10, 6, 51, 56, 42, 60, 11, 44, 61, 48, 62, 28, 4, 47, 12, 27, 39, 41, 45, 49, 58, 59, 63, 64, 66) ORDER BY i.image_hits DESC, i.image_hits 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, 68, 1, 32, 23, 15, 8, 29, 24, 33, 30, 17, 16, 9, 40, 67, 5, 13, 38, 26, 54, 3, 65, 2, 52, 34, 53, 43, 14, 55, 7, 46, 57, 50, 10, 6, 51, 56, 42, 60, 11, 44, 61, 48, 62, 28, 4, 47, 12, 27, 39, 41, 45, 49, 58, 59, 63, 64, 66) ORDER BY i.image_comments DESC, i.image_comments 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, 68, 1, 32, 23, 15, 8, 29, 24, 33, 30, 17, 16, 9, 40, 67, 5, 13, 38, 26, 54, 3, 65, 2, 52, 34, 53, 43, 14, 55, 7, 46, 57, 50, 10, 6, 51, 56, 42, 60, 11, 44, 61, 48, 62, 28, 4, 47, 12, 27, 39, 41, 45, 49, 58, 59, 63, 64, 66) ORDER BY i.image_downloads DESC, i.image_downloads ASC
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT DISTINCT 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 ORDER BY RAND()
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT IF(i.image_date >= 1310758246,RAND()+1,1) as random_no, 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, 68, 1, 32, 23, 15, 8, 29, 24, 33, 30, 17, 16, 9, 40, 67, 5, 13, 38, 26, 54, 3, 65, 2, 52, 34, 53, 43, 14, 55, 7, 46, 57, 50, 10, 6, 51, 56, 42, 60, 11, 44, 61, 48, 62, 28, 4, 47, 12, 27, 39, 41, 45, 49, 58, 59, 63, 64, 66) ORDER BY random_no DESC, 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 /xxxx/7/xxxxxxxxx/htdocs/4images/includes/db_mysql.php on line 116

Please Vote for my site: Here

Rembrandt

  • Guest
Re: Suddenly started getting DB errors
« Reply #1 on: July 25, 2011, 09:39:24 PM »

Offline hyde101

  • Sr. Member
  • ****
  • Posts: 410
  • 34TR.COM (Running 4images)
    • View Profile
    • Nostalgia Istanbul
Re: Suddenly started getting DB errors
« Reply #2 on: July 25, 2011, 10:03:48 PM »
Thank you very much, there were so many lines of errors, I didn't know where to begin.

Please Vote for my site: Here

Rembrandt

  • Guest
Re: Suddenly started getting DB errors
« Reply #3 on: July 25, 2011, 10:07:19 PM »
the best way, update your galery to 1.7.10

mfg Andi

Offline hyde101

  • Sr. Member
  • ****
  • Posts: 410
  • 34TR.COM (Running 4images)
    • View Profile
    • Nostalgia Istanbul
Re: Suddenly started getting DB errors
« Reply #4 on: July 25, 2011, 10:09:46 PM »
Thanks, but I have so many modifications, it just is not feasible, unless I go with a plain version.
This is the reason why I could not upgrade in the first place. I would have to modify so many files and I did not keep track of most of them. I tried before with a copy of my existing install, everything is all over the place.

Please Vote for my site: Here