PhpDig.net - View Single Post

Charter · 03-08-2004, 10:35 AM

Hi. If you are using a charset other than ISO-8859-1 or ISO-8859-2 then cleanup_engine.php basically deletes any word that doesn't start with a [0-9a-zßðþ] character. To fix this do the following.

In cleanup_engine.php replace

Code:

//explore keywords to find bad values
$query = "SELECT key_id FROM ".PHPDIG_DB_PREFIX."keywords 
WHERE twoletters REGEXP \"^[^0-9a-zßðþ]\"";

with the following:

Code:

//explore keywords to find bad values
$query = "SELECT key_id FROM ".PHPDIG_DB_PREFIX."keywords 
WHERE twoletters REGEXP \"^[^".$phpdig_words_chars[PHPDIG_ENCODING]."#$]\"";

Remember to remove any "word" wrapping in the above code.

03-08-2004, 10:35 AM	#1
Charter Head Mole Join Date: May 2003 Posts: 2,539	Cleanup Engine Bug and Fix Hi. If you are using a charset other than ISO-8859-1 or ISO-8859-2 then cleanup_engine.php basically deletes any word that doesn't start with a [0-9a-zßðþ] character. To fix this do the following. In cleanup_engine.php replace Code: //explore keywords to find bad values $query = "SELECT key_id FROM ".PHPDIG_DB_PREFIX."keywords WHERE twoletters REGEXP \"^[^0-9a-zßðþ]\""; with the following: Code: //explore keywords to find bad values $query = "SELECT key_id FROM ".PHPDIG_DB_PREFIX."keywords WHERE twoletters REGEXP \"^[^".$phpdig_words_chars[PHPDIG_ENCODING]."#$]\""; Remember to remove any "word" wrapping in the above code. __________________ Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.