Page 1 of 1

Search DEBUG Errors

Posted: Wed Feb 05, 2003 1:52 am
by Night4554
Upon attempting to delete a post:

Code: Select all

Could not delete old words from word table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'SELECT word_id FROM bbforums_search_wordmatch WHERE word_id IN ( ' at line 3

DELETE FROM bbforums_search_wordlist WHERE word_id IN ( SELECT word_id FROM bbforums_search_wordmatch WHERE word_id IN ( SELECT word_id FROM bbforums_search_wordmatch WHERE post_id IN (18849) GROUP BY word_id ) GROUP BY word_id HAVING COUNT(word_id) = 1 )

Line : 398
File : /var/www/domains/blenderwars.com/phpBB2/includes/functions_search.php
Upon Attempting to post:

Code: Select all

Could not insert new word

DEBUG MODE

SQL Error : 1062 Duplicate entry 'fix' for key 1

INSERT INTO bbforums_search_wordlist (word_text, word_common) VALUES ('fix', 0)

Line : 201
File : /var/www/domains/blenderwars.com/phpBB2/includes/functions_search.php
phpBB 2.0.4 MySQL DB

http://blenderwars.com/phpBB2/

Took a 2.0.1, took the posts into the 2.0.4, then ran an ezBoard Converter. Updated personal groups. Ran the search_fill file. This seems to be the only thing wrong. Any help would be MUCH appreciated.

Posted: Wed Feb 05, 2003 8:47 pm
by Night4554
Anyone know the asnwer?

Posted: Wed Feb 05, 2003 10:18 pm
by Techie-Micheal
So, this is a converted board, yes?

Posted: Wed Feb 05, 2003 10:24 pm
by Night4554
Yes.

Posted: Wed Feb 05, 2003 10:57 pm
by Techie-Micheal
Sorry, can't help you.

Posted: Wed Feb 05, 2003 11:03 pm
by Night4554
What would you have said if I said no? Just because you don't 'Officially Support' the converters doesn't mean you can't give me an answer or at least think about it for a minute.

Posted: Wed Feb 05, 2003 11:18 pm
by Techie-Micheal
If you had said no, I would have known you were lying.

Okay, I thought about it and here is what I thought: This problem is specifically related to the ezboard conversion. Case closed.