https://www.icyphoenix.com/viewtopic.php?f=35&t=2976
-----------------------------------
Moon
Mon 22 Oct, 2007 14:14

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??


-----------------------------------
novice programmer
Mon 22 Oct, 2007 18:03

Re: Fotoalbum Error
-----------------------------------
Version you use?


-----------------------------------
Moon
Mon 22 Oct, 2007 19:30

Re: Fotoalbum Error
-----------------------------------
The newest version Icy Phoenix 1.1.0.15b  :wink:


-----------------------------------
novice programmer
Mon 22 Oct, 2007 22:45

Re: Fotoalbum Error
-----------------------------------
Try to optimize and repaair the tables. delete all cache and re-compile


-----------------------------------
Moon
Tue 23 Oct, 2007 10:35

Re: Fotoalbum Error
-----------------------------------
[quote user="novice programmer" post="20672"]Try to optimize and repaair the tables. delete all cache and re-compile[/quote]

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


-----------------------------------
novice programmer
Tue 23 Oct, 2007 16:23

Re: Fotoalbum Error
-----------------------------------
Optimize and repair with a db manager different from the icy db manager.
Recompile after that.


-----------------------------------
Moon
Wed 24 Oct, 2007 10:34

Re: Fotoalbum Error
-----------------------------------
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  :D  :D