Search Debug Errors after ezBoard Conversion

This is an archive of the phpBB 2.0.x convertors forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
Night4554
Registered User
Posts: 99
Joined: Sun Apr 07, 2002 3:09 am

Search Debug Errors after ezBoard Conversion

Post 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.
Locked

Return to “[2.0.x] Convertors”