well it was not fixed at all i got tried of asking for help so i left for a while thinking when i get back to my forum it would be fixed..then i read post by you saying Issue Resolved but it's not can i still get some help for this pz


There appears to be an error with the Da HiphopLounge database.
You can try to refresh the page by clicking here, if this does not fix the error, you can contact the board administrator by clicking here

Error Returned

mySQL query error: SELECT t.*, f.read_perms, f.use_html, p.*, m.avatar, m.view_avs, m.avatar_size,
m.id as member_id, m.name as member_name, m.mgroup, g.g_id, g.g_dohtml
FROM cdman_topics t
LEFT JOIN cdman_members m ON (t.starter_id=m.id)
LEFT JOIN cdman_groups g ON (g.g_id=m.mgroup)
LEFT JOIN cdman_posts p ON (p.topic_id=t.tid AND p.new_topic=1)
LEFT JOIN cdman_forums f on (f.id=p.forum_id)
WHERE t.forum_id IN (-1,50,51,52,) AND p.forum_id NOT IN(45)
AND t.approved=1 AND (t.moved_to IS NULL or t.moved_to='')
ORDER BY t.pinned DESC, t.start_date DESC
LIMIT 0,50

mySQL error: 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 ') AND p.forum_id NOT IN(45)
AND t.approved=1 AND (t.moved_to IS NULL or ' at line 8
mySQL error code:
Date: Tuesday 06th of March 2007 07:22:52 PM

can someone help me pleaze

it still say the same thang one whole year later....help pz

Hi Staff members

This is not a server problem. It's a wrong user's SQL query. The good query must be: "IN (-1,50,51,52) AND p.forum_id NOT IN(45)"
He had "IN (-1,50,51,52,) AND p.forum_id NOT IN(45)" - which is wrong.
As long as I'm not familiar with IPB/phpBB, anyone advise how to change his forum/portal code please

SELECT t.*, f.read_perms, f.use_html, p.*, m.avatar, m.view_avs, m.avatar_size,
m.id as member_id, m.name as member_name, m.mgroup, g.g_id, g.g_dohtml
FROM cdman_topics t
LEFT JOIN cdman_members m ON (t.starter_id=m.id)
LEFT JOIN cdman_groups g ON (g.g_id=m.mgroup)
LEFT JOIN cdman_posts p ON (p.topic_id=t.tid AND p.new_topic=1)
LEFT JOIN cdman_forums f on (f.id=p.forum_id)
WHERE t.forum_id IN (-1,50,51,52) AND p.forum_id NOT IN(45)
AND t.approved=1 AND (t.moved_to IS NULL or t.moved_to='')
ORDER BY t.pinned DESC, t.start_date DESC
LIMIT 0,50

Support Resolved!

If you have any further questions, feel free to create a new thread.

Thanks for choosing Forumer!