Author Topic: Got error 28 from table handler?  (Read 3443 times)

0 Members and 1 Guest are viewing this topic.

Offline X13-08

  • Pre-Newbie
  • Posts: 1
    • View Profile
Got error 28 from table handler?
« on: November 25, 2002, 12:05:51 PM »
I have been using 4images for quite some time now with no trouble at all, building my gallery up to 1035 images before it gave up on me today. I had uploaded a few more images, everything was working fine, but hours later when I went to log in on the admin screen this came up:

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 4images_categories c LEFT JOIN 4images_images i ON (i.cat_id = c.cat_id AND i.image_date >= 1037616471 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

Also this error [in brackets would be where my path was]:

Warning: Cannot add header information - headers already sent by (output started at [PATH REMOVED]/includes/db_mysql.php:188) in [PATH REMOVED]/includes/sessions.php on line 79

This information is at the top of both the index.php and admin/index.php, displaying the templates as empty. I imagine the problem is something stupid I have done as I am a php+mysql newbie.

Thanks for your help,
X13-08

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Got error 28 from table handler?
« Reply #1 on: November 25, 2002, 01:14:03 PM »
linux:~ # perror 28
Error code  28:  No space left on device

try to change table prefix_sessions from type HEAP to MyISAM
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi