 Fotoalbum Error (solved)
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??
Last edited by Moon on Wed 24 Oct, 2007 10:34; edited 1 time in total |
