Strange Error when rating photo for Album Addon

[SeanGodfrey]

Everything was running fine on my Photo Album addon till I rated a GIF file. Then I got this error:

Could not query recent pics information

DEBUG MODE

SQL Error : 1030 Got error -1 from table handler

SELECT p.pic_id, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_username, p.pic_time, p.pic_cat_id, p.pic_view_count, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments FROM phpbb_album AS p LEFT JOIN phpbb_users AS u ON p.pic_user_id = u.user_id LEFT JOIN phpbb_album_cat AS ct ON p.pic_cat_id = ct.cat_id LEFT JOIN phpbb_album_rate AS r ON p.pic_id = r.rate_pic_id LEFT JOIN phpbb_album_comment AS c ON p.pic_id = c.comment_pic_id WHERE p.pic_cat_id IN (1) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 ) GROUP BY p.pic_id ORDER BY pic_time DESC LIMIT 4

Line : 259
File : /home/belts/public_html/forum/album.php

Now the Photo Album add-on doesn't work.

What could be the problem?

Thanks again,
Sean

[Joachim Müller]

link?

[SeanGodfrey]

The URL:

http://forum.beltmarks.com/album.php

I've ben racking my brain on this one. What happened was this: I didn't click on the stars to rank it, but clicked on the photo, then on the photo page there was a text link to rank. I ranked the photo a 10 then got that message on every album page theirafter.

Thanks again,
Sean

[Joachim Müller]

Rating with "10" doesn't come with coppermine by default. Do you run any third party hacks? Where did you get the coppermine sources from, and what mods did you install?

GauGau

[SeanGodfrey]

I didn't run any 3rd party mods/hacks. The ones I installed on the forum were:

Photo Album Addon
Photo Album Fix for Next Picture
Forum addon for SWF Flash files
Extreme Styles Mod
Calendar mod
Last Visit Date


That's it. All were taken from the Coppermine site on Sourceforge.net

I might have been mistaken on the 10, but I ranked it at the highest rank before it messed up.

[Joachim Müller]

I never heard of the mods you posted, they're not from coppermine downloads page - I'm sure about that. My guess is you have been applying mods from phpBB's board (there is, for example, no such file as album.php in coppermine, and the url you posted suggests you're using some hack from the phpBB community).
Post links to the mods you're refering to.

GauGau

[SeanGodfrey]

Sorry about this. Man, this is what I get for being on a deadline and no sleep in 36 hours. I posted the wrong message on the entirely wrong forum. I thought I was posting this on the phpbb support forum. 

Sorry everyone!
Sean