[2.0.21] Rebuild Search

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Post Reply

Rating:

Excellent!
58
81%
Very Good
10
14%
Good
3
4%
Fair
0
No votes
Poor
1
1%
 
Total votes: 72

mgutt
Registered User
Posts: 346
Joined: Tue Sep 21, 2004 2:54 pm
Location: Germany, Sankt Augustin
Contact:

Post by mgutt »

under the rebuild site after starting the rebuild there came this message:
SQL requests not achieved

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 ') GROUP BY word_id HAVING COUNT(word_id) = 1' at li

EXPLAIN SELECT word_id FROM phpbb_search_wordmatch WHERE word_id IN () GROUP BY word_id HAVING COUNT(word_id) = 1

Line : 130
File : class_run_stats.php
Forums: Honda || phpBB Categories Hierarchy
Mods: Spamfilter against bot registrations || Seo Urls
mgutt
Registered User
Posts: 346
Joined: Tue Sep 21, 2004 2:54 pm
Location: Germany, Sankt Augustin
Contact:

Post by mgutt »

explanation from ptirhiik:
Report this to the mod author : the first error causing class_run_stat to fail is the word_id list being empty : it has probably deal with this case with ignoring the sql returned error, but that's really not the solution.


not a big error at all, but has to be fixed ;)
Forums: Honda || phpBB Categories Hierarchy
Mods: Spamfilter against bot registrations || Seo Urls
jelv1
Registered User
Posts: 43
Joined: Fri Oct 15, 2004 8:11 am
Location: England

Post by jelv1 »

Excellent tool. I have today found a bug with the handling of synonyms in 2.0.19 (it's treating the entries back to front - see bug here).

Having corrected the function in functions_search.php as shown in the report which this mod uses, rebuilding the indexes using this mod sorted everything out. Magic!
klonducky
Registered User
Posts: 44
Joined: Tue Jul 29, 2003 8:22 am

Post by klonducky »

I get this error when using the searh function :

Could not delete old search id sessions

DEBUG MODE

SQL Error : 145 Table '.\mysite\phpbb_search_results' is marked as crashed and should be repaired

DELETE FROM phpbb_search_results WHERE session_id NOT IN ('7f60e6acc39771d4bf60f02963e6e8f1', '7afbf4a375276f0f696d4ac82d8a26a0', '663588b8784b491b2dc8a999af496cf8', 'e179b6b12529dc5df7a731e7f688b953')

Line : 651
File : search.php

When I run a "repair" on the table the search is working for a few times before it crashes again.

I have been trying the Rebuild Search Mod, but when running it the table crashes again.

Anyone that has any suugestion on a solution ???
klonducky
Registered User
Posts: 44
Joined: Tue Jul 29, 2003 8:22 am

Post by klonducky »

I need some help with this MOD :

When the "next" countdown is done the "Processing" button turns grey and then nothing happens at all (I have wited hours on a few posts pr cycle). The process with the next cycle only start when I push the "Next" button, which is a tough job with nearly 400.000 post i the db.

Can it be a trouble with the javascript ?
chatasos
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos »

Snapdragon wrote:
chatasos wrote:
Snapdragon wrote: Absolutely correct. It recognized the board was disabled, however, it still turned it back on when I cancelled the operation, twice.

Yep, you're right here. :wink:
If you cancel the process, the board gets enabled. It seems i forgot to add something...

Please try the following version:
[url=http:///www.psclub.gr/chatasos/rebuild_search/rebuild_search_2.2.1b.zip]rebuild_search_2.2.1b.zip[/url]

To update from 2.2.1a just overwrite file admin/admin_rebuild_search.php.


Sounds good. Now I see someone running an almost equally sized forum to ours sucessfully ran the rebuild while NOT being disabled... what are (if any) the side effects to having posters continue to post and edit while it's running? Is there a risk of anything going wrong? Should I post a notice not to DELETE any posts during the run?


Besides the extra time needed to index the search tables, there should be no other problems. At least i haven't heard of any.
On the other hand, it's a good practice to disable your board when running mass db queries.

Report Posts 1.2.3c (MODDB) - Report Posts 2.1.5 (ALPHA)
Rebuild Search 2.4.0 (MODDB)
MOD Version Checker 1.2.0 (MODDB)
Mega Mail System 0.9.8 (ALPHA)
Pagination Select List & Input Box (MODDB)
chatasos
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos »

mgutt wrote: under the rebuild site after starting the rebuild there came this message:
SQL requests not achieved

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 ') GROUP BY word_id HAVING COUNT(word_id) = 1' at li

EXPLAIN SELECT word_id FROM phpbb_search_wordmatch WHERE word_id IN () GROUP BY word_id HAVING COUNT(word_id) = 1

Line : 130
File : class_run_stats.php
mgutt wrote: explanation from ptirhiik:
Report this to the mod author : the first error causing class_run_stat to fail is the word_id list being empty : it has probably deal with this case with ignoring the sql returned error, but that's really not the solution.


not a big error at all, but has to be fixed ;)


Hi mgutt,

My mod doesn't include such a query so i guess you must be using another mod (i guess CH? If yes, sorry, but i haven't tried it with it.)
Last edited by chatasos on Wed Jan 25, 2006 10:52 pm, edited 1 time in total.

Report Posts 1.2.3c (MODDB) - Report Posts 2.1.5 (ALPHA)
Rebuild Search 2.4.0 (MODDB)
MOD Version Checker 1.2.0 (MODDB)
Mega Mail System 0.9.8 (ALPHA)
Pagination Select List & Input Box (MODDB)
chatasos
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos »

klonducky wrote: I need some help with this MOD :

When the "next" countdown is done the "Processing" button turns grey and then nothing happens at all (I have wited hours on a few posts pr cycle). The process with the next cycle only start when I push the "Next" button, which is a tough job with nearly 400.000 post i the db.

Can it be a trouble with the javascript ?


Hi klonducky,

Please check that you have js working fine.

Report Posts 1.2.3c (MODDB) - Report Posts 2.1.5 (ALPHA)
Rebuild Search 2.4.0 (MODDB)
MOD Version Checker 1.2.0 (MODDB)
Mega Mail System 0.9.8 (ALPHA)
Pagination Select List & Input Box (MODDB)
klonducky
Registered User
Posts: 44
Joined: Tue Jul 29, 2003 8:22 am

Post by klonducky »

chatasos wrote:
klonducky wrote:I need some help with this MOD :

When the "next" countdown is done the "Processing" button turns grey and then nothing happens at all (I have wited hours on a few posts pr cycle). The process with the next cycle only start when I push the "Next" button, which is a tough job with nearly 400.000 post i the db.

Can it be a trouble with the javascript ?


Hi klonducky,

Please check that you have js working fine.


I have just checked my JS and it seems to be working fine !
chatasos
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos »

klonducky wrote:
chatasos wrote:
klonducky wrote:I need some help with this MOD :

When the "next" countdown is done the "Processing" button turns grey and then nothing happens at all (I have wited hours on a few posts pr cycle). The process with the next cycle only start when I push the "Next" button, which is a tough job with nearly 400.000 post i the db.

Can it be a trouble with the javascript ?


Hi klonducky,

Please check that you have js working fine.


I have just checked my JS and it seems to be working fine !


Do you still get crashes on your db?
What db are you using?

Report Posts 1.2.3c (MODDB) - Report Posts 2.1.5 (ALPHA)
Rebuild Search 2.4.0 (MODDB)
MOD Version Checker 1.2.0 (MODDB)
Mega Mail System 0.9.8 (ALPHA)
Pagination Select List & Input Box (MODDB)
klonducky
Registered User
Posts: 44
Joined: Tue Jul 29, 2003 8:22 am

Post by klonducky »

chatasos wrote:
klonducky wrote:
chatasos wrote:
klonducky wrote:I need some help with this MOD :

When the "next" countdown is done the "Processing" button turns grey and then nothing happens at all (I have wited hours on a few posts pr cycle). The process with the next cycle only start when I push the "Next" button, which is a tough job with nearly 400.000 post i the db.

Can it be a trouble with the javascript ?


Hi klonducky,

Please check that you have js working fine.


I have just checked my JS and it seems to be working fine !


Do you still get crashes on your db?
What db are you using?


No, the db do not crash after I have started the rebuild, but the process is very slow because I have to press the "next" button on very cycle or nothing happens.

The db is a MySQL 5.0.10a-beta-nt.
chatasos
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos »

klonducky wrote: The db is a MySQL 5.0.10a-beta-nt.


Hmmmmm....That makes me worry a little.
If you can make a backup of your db, then you can downgrade it to a more "stable" (4.x) mysql version and give it a try...
Sorry, but I can't think of anything else...

Report Posts 1.2.3c (MODDB) - Report Posts 2.1.5 (ALPHA)
Rebuild Search 2.4.0 (MODDB)
MOD Version Checker 1.2.0 (MODDB)
Mega Mail System 0.9.8 (ALPHA)
Pagination Select List & Input Box (MODDB)
User avatar
pcmerc
Registered User
Posts: 51
Joined: Wed Sep 18, 2002 8:21 am
Contact:

Post by pcmerc »

I'm having some problems with this mod. I have done as the install instructions have said but when I click on the rebuild search in the admin panel I get a blank page.

I'm running phpBB-2.0.19 with the following mods:

attach_mod_241
memberlist_access_1.0.3
sql_backup_v1.0.2

I am seeing this in the error_log

PHP Parse error: parse error, unexpected T_STRING, expecting ',' or ')' in /usr/www/thebandihate/htdocs/forum/includes/functions_search.php on line 81, referer: http://www.thebandihate.com/forum/admin ... 0338303f7e

Any ideas?
jelv1
Registered User
Posts: 43
Joined: Fri Oct 15, 2004 8:11 am
Location: England

Post by jelv1 »

Have you tried correcting the synonyms problem I reported (the line no. you have given relates to that)?

I have now made an Easymod friendly mod for my own purposes to make the changes needed - you could try using that instead of making the change by hand:

Code: Select all

##############################################################
## MOD Title: Correct search synonyms
## MOD Author: jelv1 < N/A > (John Elvin) N/A
## MOD Description: Corrects the indexing and searching for entries in the synonyms file. (see bug #824)
## MOD Version: 1.0.0
## 
## Installation Level: Easy
## Installation Time: 1 minutes
## Files To Edit: includes/functions_search.php
##                search.php
## Included Files: 
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
## Generator: MOD Studio [ ModTemplateTools 1.0.2108.38030 ]
##############################################################
## For security purposes, please check: http://www.phpbb.com/mods/
## for the latest version of this MOD. Although MODs are checked
## before being allowed in the MODs Database there is no guarantee
## that there are no security problems within the MOD. No support
## will be given for MODs not found within the MODs Database which
## can be found at http://www.phpbb.com/mods/
##############################################################
## Author Notes: Where a correctly spelled word has an incorrect synonym in language\lang_english\search_synonyms.txt
## it is indexed by the incorrect spelling. When searching not all variations found in the synonyms file are
## found. This is because interpretation of the two columns in the synonym file is the wrong way round.
## 
## IMPORTANT
## After applying this mod the indexing of existing posts needs to be corrected using the
## Rebuild Search mod here: http://www.phpbb.com/phpBB/viewtopic.php?t=329629
##############################################################
## MOD History:
## 
## 2006-01-26 - Version 1.0.0
## Mod created from previously applied and tested hand patches
## 
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
##############################################################

#
#-----[ OPEN ]------------------------------------------
#
# Correct indexing - incorrect words are indexed as correct equivalent
# 
includes/functions_search.php
#
#-----[ FIND ]------------------------------------------
#
list($replace_synonym, $match_synonym) = split(' ', trim(strtolower($synonym_list[$j])));

#
#-----[ IN-LINE FIND ]------------------------------------------
#
$replace_synonym, $match_synonym

#
#-----[ IN-LINE REPLACE WITH ]------------------------------------------
#
$match_synonym, $replace_synonym

#
#-----[ OPEN ]------------------------------------------
#
# Correct highlighting so that all equivalents are highlighted
# 
search.php
#
#-----[ FIND ]------------------------------------------
#
list($replace_synonym, $match_synonym) = split(' ', trim(strtolower($synonym_array[$k])));

#
#-----[ IN-LINE FIND ]------------------------------------------
#
$replace_synonym, $match_synonym

#
#-----[ IN-LINE REPLACE WITH ]------------------------------------------
#
$match_synonym, $replace_synonym

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
John
User avatar
pcmerc
Registered User
Posts: 51
Joined: Wed Sep 18, 2002 8:21 am
Contact:

Post by pcmerc »

yes, I did that replacement as well.
Post Reply

Return to “[2.0.x] MOD Database Releases”