1
Discussion & Troubleshooting / Re: DB Error: Bad SQL Query \ Supplied Argument is not Valid
« on: November 09, 2009, 04:24:58 PM »
The table prefixes for the gallery in the database are "gal_"
4images code on GitHub Click here to visit GitHub.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
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