https://www.icyphoenix.com/viewtopic.php?f=35&t=4189&p=28411#p28411
-----------------------------------
keany
Wed 14 May, 2008 17:17

Error When Opening Portal Cause Of Fap
-----------------------------------
When i try to open portal some times give me this error and i cant opening it only if i disable from acp album box ..or i can wait some hours to open  :?:  :?: 

This is the error that give !!!


[b]Could not query recent pics information

DEBUG MODE

SQL Error : 5 Out of memory (Needed 4194276 bytes)

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_2album AS p LEFT JOIN ip_2users AS u ON p.pic_user_id = u.user_id LEFT JOIN ip_2album_cat AS ct ON p.pic_cat_id = ct.cat_id LEFT JOIN ip_2album_rate AS r ON p.pic_id = r.rate_pic_id LEFT JOIN ip_2album_comment AS c ON p.pic_id = c.comment_pic_id WHERE p.pic_cat_id IN (0,2,3,4,9,11,12,13,14,15,16,17,5,6,7,8,1,10) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 ) GROUP BY p.pic_id ORDER BY RAND() LIMIT 4

Line : 210
File : blocks_imp_album.php[/b]



If anyone can tell me what can i do .


