At some point during the night, something happened to my gallery and I'm not entirely sure what, or how to go about fixing it. Here are the errors displayed at the top of the page:
An unexpected error occured. Please try again later.
An unexpected error occured. Please try again later.
An unexpected error occured. Please try again later.
DB Error: Bad SQL Query: SELECT a.cat_id, a.auth_viewcat, a.auth_viewimage, a.auth_download, a.auth_upload, a.auth_directupload, a.auth_vote, a.auth_sendpostcard, a.auth_readcomment, a.auth_postcomment FROM (gal_groupaccess a, gal_groupmatch m) WHERE m.user_id = 1 AND a.group_id = m.group_id AND m.groupmatch_startdate <= 1257694610 AND (groupmatch_enddate > 1257694610 OR groupmatch_enddate = 0)
Table 'web27-monagal.gal_groupaccess' doesn't exist
DB Error: Bad SQL Query: SELECT COUNT(*) as total_images FROM gal_images WHERE image_active = 1 AND cat_id NOT IN (0)
Table 'web27-monagal.gal_images' doesn't exist
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 (gal_images i, gal_categories c) LEFT JOIN gal_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 3
Table 'web27-monagal.gal_images' doesn't exist
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sites/monaj.net/public_html/gallery/includes/db_mysql.php on line 116
- I am running 1.7.6
- I am unable to get into the admin panel with these errors
- I have downloaded the file from data/database/default for reference, but not sure what I have to do with it at the moment.
- I have searched for this error, and most of what I find says to recreate the tables. But the last error makes me think there is more to it than that. And in regards to recreating the tables, how would I go about making it see the content that's already there (i.e. the data for the images that have already been uploaded). The last 'backup' we did was some months ago, which was I believe extremely stupid on our parts, unless the relavent information for that is in the data/database/default sql file.
