4images Forum & Community
4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: hyde101 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
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
-
FAQ -> SEARCH->
http://www.4homepages.de/forum/index.php?topic=22668.0
-
Thank you very much, there were so many lines of errors, I didn't know where to begin.
-
the best way, update your galery to 1.7.10
mfg Andi
-
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.