Icy Phoenix

Hi all,

I've been running my forum without big problems for 1.5 months now but somehow today I get an error on my home page.

Could not query recent pics information

DEBUG MODE

SQL Error : 1030 Got error -1 from storage engine

SELECT p.*, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments FROM ip_8025album AS p LEFT JOIN ip_8025users AS u ON p.pic_user_id = u.user_id LEFT JOIN ip_8025album_cat AS ct ON p.pic_cat_id = ct.cat_id LEFT JOIN ip_8025album_rate AS r ON p.pic_id = r.rate_pic_id LEFT JOIN ip_8025album_comment AS c ON p.pic_id = c.comment_pic_id WHERE p.pic_cat_id IN (0,2,3,4,5,6,7,8,9,10,11,12,13,14,15,1) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 ) GROUP BY p.pic_id ORDER BY RAND() LIMIT 3

Line : 208
File : blocks_imp_album.php

I can see my homepage when I disable the albumblock in cms but when I enable the album all I see is this error.

Also when I press on the album link in the forum menu I get this error, different then the above one:

Could not query recent pics information

DEBUG MODE

SQL Error : 1030 Got error -1 from storage engine

SELECT p.*, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments FROM ip_8025album AS p LEFT JOIN ip_8025users AS u ON p.pic_user_id = u.user_id LEFT JOIN ip_8025album_cat AS ct ON p.pic_cat_id = ct.cat_id LEFT JOIN ip_8025album_rate AS r ON p.pic_id = r.rate_pic_id LEFT JOIN ip_8025album_comment AS c ON p.pic_id = c.comment_pic_id WHERE ( p.pic_approval = 1 OR ct.cat_approval = 0 ) GROUP BY p.pic_id ORDER BY pic_time DESC LIMIT 4

Line : 1394
File : album_hierarchy_sql.php

Can anyone help me??

Version you use?

The newest version Icy Phoenix 1.1.0.15b

Try to optimize and repaair the tables. delete all cache and re-compile

novice programmer wrote: [View Post]

Try to optimize and repaair the tables. delete all cache and re-compile

I deleted all cach an recompile that didn't work, but I dont know were to optimize and repair the tables?

Optimize and repair with a db manager different from the icy db manager.
Recompile after that.

Its crazy but somehow without doing anything it works again, maybe it whas something on the side of my hosting?
Thanks anyway for the help