To start I have to say I am not at all proficient with 4images. I have version 1.7 and have been hacked twice in the past week. (template is 4waters). Here's what appears at the top of my gallery intro page
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 i.cat_id NOT IN (0) AND c.cat_id = i.cat_id LIMIT 15653, 1
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 NOT IN (0) ORDER BY i.image_date DESC LIMIT 5
Unknown column 'i.user_id' in 'on clause'
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/firthess/public_html/JustColin/includes/db_mysql.php on line 116
Now, what this has done has made it so that no images show on any page and none can be accessed, though the files are all still there.
I tried the database backup and also FTPing a very recent copy of the db_sql file
I know nothing of the technical aspects of these files. I'm not that good at it.
Will loading 1.7.4. heplpor is there an easy fix to the, obviously, altered lines in this file?
Would 1.7.4 wipe out any of my info? I assume it would alter my color settings.
Any help would be appreciated.
Please be gentle and explain it so a 4 year old can understand.
My URL for my Gallery is:
http://www.firthessence.net/JustColin