Mysql error

[learner]

Hi All,

I don't know if this is the right forum to ask this question but im posting my question in hope to get anwser as its php based and uses mysql for the backend. I'm using phpbb for my site and I upgraded to current version which is 2.0.4 and after that everything is working besides when I post it posts the message but it has error message around the messages... Any help on this matter will be appreciated. Below is the error message.

Could not insert new word matches

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 'want to check if its giving any error or not, word_id, 0

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT I just want to check if its giving any error or not, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('jsut')

Line : 242
File : /www/y/user/htdocs/forum/includes/functions_search.php

[LordShryku]

Well...

a) Which version of MySQL are you using? Older ones don't support subqueries.

b) Insert statements should be formed like: INSERT into table (field1, field2, field3) VALUES ('value1', 'value2', 'value3');

[learner]

Originally posted by LordShryku
Well...

a) Which version of MySQL are you using? Older ones don't support subqueries.

b) Insert statements should be formed like: INSERT into table (field1, field2, field3) VALUES ('value1', 'value2', 'value3');

a) My host is currently using Server version 4.0.12-log for our mySQL server. And they currently support mysiam and bdb table types.

b) for second I have no idea as im using phpbb.com scripts for forum.