error looking for picture
Thread Starter
Administrator
Joined: Aug 2004
Posts: 501
From: Hopewell Jct., NY
error looking for picture
I got this when I hit All pictures contributed by sickt7cuda in his profile.
Was looking for his scoop hinged door pics.
General Error
Could not query pics information
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY p.pic_id ORDER BY pic_time DESC LIMIT 12' a
SELECT DISTINCT(p.pic_id), ct.cat_user_id, ct.cat_id, ct.cat_title, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_time, p.pic_view_count, p.pic_lock, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments, MAX(c.comment_id) as new_comment FROM phpbb_album AS p 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 LEFT JOIN phpbb_album_cat AS ct ON p.pic_cat_id = ct.cat_id WHERE p.pic_user_id = 5 AND ct.cat_id IN () GROUP BY p.pic_id ORDER BY pic_time DESC LIMIT 12
Line : 187
File : /home/northeas/.panel/web/bulletin/bb/album_mod/album_memberlist.php
Was looking for his scoop hinged door pics.
General Error
Could not query pics information
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY p.pic_id ORDER BY pic_time DESC LIMIT 12' a
SELECT DISTINCT(p.pic_id), ct.cat_user_id, ct.cat_id, ct.cat_title, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_time, p.pic_view_count, p.pic_lock, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments, MAX(c.comment_id) as new_comment FROM phpbb_album AS p 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 LEFT JOIN phpbb_album_cat AS ct ON p.pic_cat_id = ct.cat_id WHERE p.pic_user_id = 5 AND ct.cat_id IN () GROUP BY p.pic_id ORDER BY pic_time DESC LIMIT 12
Line : 187
File : /home/northeas/.panel/web/bulletin/bb/album_mod/album_memberlist.php
Guest
Posts: n/a
Re: error looking for picture
Originally Posted by Mopower71
SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY p.pic_id ORDER BY pic_time DESC LIMIT 12' a
SELECT DISTINCT(p.pic_id), ct.cat_user_id, ct.cat_id, ct.cat_title, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_time, p.pic_view_count, p.pic_lock, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments, MAX(c.comment_id) as new_comment FROM phpbb_album AS p 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 LEFT JOIN phpbb_album_cat AS ct ON p.pic_cat_id = ct.cat_id WHERE p.pic_user_id = 5 AND ct.cat_id IN () GROUP BY p.pic_id ORDER BY pic_time DESC LIMIT 12
Line : 187
File : /home/northeas/.panel/web/bulletin/bb/album_mod/album_memberlist.php
SELECT DISTINCT(p.pic_id), ct.cat_user_id, ct.cat_id, ct.cat_title, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_time, p.pic_view_count, p.pic_lock, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments, MAX(c.comment_id) as new_comment FROM phpbb_album AS p 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 LEFT JOIN phpbb_album_cat AS ct ON p.pic_cat_id = ct.cat_id WHERE p.pic_user_id = 5 AND ct.cat_id IN () GROUP BY p.pic_id ORDER BY pic_time DESC LIMIT 12
Line : 187
File : /home/northeas/.panel/web/bulletin/bb/album_mod/album_memberlist.php
Sheesh. Some people.
I'll have a look at it later on today. Thanks for letting me know.
Guest
Posts: n/a
LOL!
It's a bug in an add-on for the photo-album.
There's an update to that add-on, I'll see if I can get it installed tonight. Hopefully that'll fix this issue. Otherwise, I'll have to roll up my sleeves and start digging into somebody else's code. That's always fun.
It's a bug in an add-on for the photo-album.
There's an update to that add-on, I'll see if I can get it installed tonight. Hopefully that'll fix this issue. Otherwise, I'll have to roll up my sleeves and start digging into somebody else's code. That's always fun.
Guest
Posts: n/a
Originally Posted by Mopower71
What's odd is it's only with sickt7cuda's. I tried others and they worked fine.
It happens with Tig also. I'm sure there's some more users that it happens with, but I didn't check everybody.
Thread
Thread Starter
Forum
Replies
Last Post
onehellofadart
Problems/Comments/Suggestions
1
Oct 18, 2004 09:23 AM
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
