SQL Error : 1064 You have an error in your SQL syntax

Posted: Sun Nov 20, 2005 5:00 pm

General Error

Could not retrieve related topics 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 ') LIMIT 0, 5' at line 9

SELECT DISTINCT(t.topic_id) FROM nuke_bbsearch_wordmatch m, nuke_bbposts p, nuke_bbtopics t WHERE t.topic_id <> 52 AND t.topic_status <> 2 AND p.topic_id = t.topic_id AND p.post_id = m.post_id AND p.forum_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9) AND m.title_match = 1 AND m.word_id IN () LIMIT 0, 5

Line : 92
File : /home/lakegfx/public_html/includes/functions_related.php

someone help me plz i upgrade from phpbb forums to 7.6 plat

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

As an FYI, I already explained to Mike that this code m.word_id IN () is the cause. But, He needs help with correcting the query.