|
I’m having problems reading some of the threads. I keep getting the following error on some threads.
“MySQL ERROR:
Error Number: 1242
Description: Subquery returns more than 1 row
Query: SELECT p.post_id, p.forum_id, p.author_id, p.ip_address, p.body, p.parse_smileys, p.post_date AS date, p.post_edit_date AS edit_date, p.post_edit_author AS edit_author_id, em.screen_name AS edit_author, m.group_id, m.screen_name AS author, m.join_date, m.total_forum_topics, m.total_forum_posts, m.location,m.occupation, m.email, m.accept_user_email, m.url, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, (select url_title from exp_weblog_titles where weblog_id=11 and author_id=m.member_id) as portfolio, f.forum_display_edit_date FROM (exp_forum_posts p, exp_members m, exp_forums f) LEFT JOIN exp_members em ON p.post_edit_author = em.member_id WHERE p.author_id = m.member_id AND f.forum_id = p.forum_id AND p.topic_id = ‘9964’ ORDER BY date asc LIMIT 0, 10”
What does this mean? Is it a problem on my side? Thanks.
Example thread: http://area.autodesk.com/for...nk-3ds-max-and-photoshop/
E. K. Anna Hennequet [FA]
|
