Author Topic: SQL Error  (Read 4117 times)

0 Members and 1 Guest are viewing this topic.

Offline CRego3D

  • Pre-Newbie
  • Posts: 5
    • View Profile
SQL Error
« on: May 09, 2003, 05:03:48 PM »
After months of use, all of the suddent I am gettign this

Code: [Select]
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


no new images or commets have been upload .. i try to retrieve a backup db, but I get the same .. any idea ?

Offline CRego3D

  • Pre-Newbie
  • Posts: 5
    • View Profile
SQL Error
« Reply #1 on: May 09, 2003, 05:05:22 PM »
"Got error 28 from table handler"

means HD full .. all fixed .. /tmp was full ;)

Offline riceroy

  • Newbie
  • *
  • Posts: 11
    • View Profile
Re: SQL Error
« Reply #2 on: February 13, 2006, 03:41:16 AM »
ok i cleared out old files on my harddrive to make room but the site still says the error 28. what do i do?

Offline TheOracle

  • Hero Member
  • *****
  • Posts: 875
    • View Profile
Re: SQL Error
« Reply #3 on: February 13, 2006, 05:08:49 AM »
Quote

ok i cleared out old files on my harddrive to make room but the site still says the error 28. what do i do?


Did you also restarted your mySQL server ? ;)