Search DEBUG Errors

This is an archive of the phpBB 2.0.x support 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

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.
Night4554
Registered User
Posts: 99
Joined: Sun Apr 07, 2002 3:09 am

Post by Night4554 »

Anyone know the asnwer?
User avatar
Techie-Micheal
Security Consultant
Posts: 19511
Joined: Sun Oct 14, 2001 12:11 am
Location: In your servers

Post by Techie-Micheal »

So, this is a converted board, yes?
Proven Offensive Security Expertise. OSCP - GXPN
Night4554
Registered User
Posts: 99
Joined: Sun Apr 07, 2002 3:09 am

Post by Night4554 »

Yes.
User avatar
Techie-Micheal
Security Consultant
Posts: 19511
Joined: Sun Oct 14, 2001 12:11 am
Location: In your servers

Post by Techie-Micheal »

Sorry, can't help you.
Proven Offensive Security Expertise. OSCP - GXPN
Night4554
Registered User
Posts: 99
Joined: Sun Apr 07, 2002 3:09 am

Post 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.
User avatar
Techie-Micheal
Security Consultant
Posts: 19511
Joined: Sun Oct 14, 2001 12:11 am
Location: In your servers

Post 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.
Proven Offensive Security Expertise. OSCP - GXPN
Locked

Return to “2.0.x Support Forum”