1
Discussion & Troubleshooting / SQL Error
« on: May 09, 2003, 05:05:22 PM »
"Got error 28 from table handler"
means HD full .. all fixed .. /tmp was full
means HD full .. all fixed .. /tmp was full

Check the new Tutorial subforum with helpfull guides and tutorials for modifications and tweaks.
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.
DB Error: Bad SQL Query: SELECT c.cat_id, c.cat_name, c.cat_description, c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_viewcat, c.auth_viewimage, c.auth_download, c.auth_upload, c.auth_directupload, c.auth_vote, c.auth_sendpostcard, c.auth_readcomment, c.auth_postcomment, COUNT(i.image_id) AS new_images FROM gallery_categories c LEFT JOIN gallery_images i ON (i.cat_id = c.cat_id AND i.image_date >= 1051627825 AND i.image_active = 1) GROUP BY c.cat_id ORDER BY c.cat_order, c.cat_name ASC
Got error 28 from table handler
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 gallery_images i, gallery_categories c LEFT JOIN gallery_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0, 4, 5, 7, 8, 10, 12, 13, 15, 17, 18, 19, 20, 23, 25, 26) AND c.cat_id = i.cat_id ORDER BY RAND()
Got error 28 from table handler