Problems/Comments/Suggestions Got a problem with this board? Have an idea about how to make it better? Post about it in this forum.

error looking for picture

Old 10-16-2004, 08:39 AM
  #1  
Administrator
Thread Starter
 
Mopower71's Avatar
 
Join Date: Aug 2004
Location: Hopewell Jct., NY
Posts: 501
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
Mopower71 is offline  
Old 10-16-2004, 04:11 PM
  #3  
Senior Member
 
sickt7cuda's Avatar
 
Join Date: Jul 2004
Location: Vernon, New Jersey
Posts: 278
Syntax??? Isn't that a tax on things like cigarettes and alcohol ?
sickt7cuda is offline  
Old 10-16-2004, 04:58 PM
  #5  
Administrator
Thread Starter
 
Mopower71's Avatar
 
Join Date: Aug 2004
Location: Hopewell Jct., NY
Posts: 501
What's odd is it's only with sickt7cuda's. I tried others and they worked fine.
Mopower71 is offline  
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Mopower71
Problems/Comments/Suggestions
2
01-01-2005 10:13 AM
82GT
Problems/Comments/Suggestions
1
10-25-2004 11:43 AM
onehellofadart
Problems/Comments/Suggestions
1
10-18-2004 09:23 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

Thread Tools
Search this Thread
Quick Reply: error looking for picture