Page 6 of 19

Posted: Fri Jan 06, 2006 5:48 pm
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

Posted: Sat Jan 07, 2006 10:30 am
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 ;)

Posted: Sat Jan 07, 2006 8:15 pm
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!

Posted: Fri Jan 20, 2006 11:21 pm
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 ???

Posted: Mon Jan 23, 2006 10:11 am
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 ?

Posted: Wed Jan 25, 2006 4:32 pm
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.

Posted: Wed Jan 25, 2006 4:36 pm
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.)

Posted: Wed Jan 25, 2006 4:39 pm
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.

Posted: Wed Jan 25, 2006 5:00 pm
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 !

Posted: Wed Jan 25, 2006 8:13 pm
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?

Posted: Wed Jan 25, 2006 9:12 pm
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.

Posted: Wed Jan 25, 2006 10:51 pm
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...

Posted: Fri Feb 03, 2006 7:47 am
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?

Posted: Fri Feb 03, 2006 8:35 am
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

Posted: Fri Feb 03, 2006 8:47 am
by pcmerc
yes, I did that replacement as well.