IntegraMOD

Hope someone has a simple solution to this <img>
A good while back I converted over to Integramod from another PHPBB type portal system.
Ever since I have had issues with some posts pre the move when trying to rebuild the search in the database management in ACP.
This is what I'm getting

Error: Couldn't insert search word data!

[color=#008000]SQL Error ]

I have managed to get rid of quite a few by simply putting [highlight=#ffffbf:fl6732tg]donà¢ÃƒÆ’ƒÂ ¢ÃƒÆ’ ¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€¦Ã‚ ¡ÃƒÆ’‚Ã'[/highlight:fl6732tg] within the search and have then edited the offending post, for some reason though I cant find the above one in the search so have been literary going through the older posts looking for similar.
Is there a better method of resolving this?

PS. I do have another user account but couldnt loggin (Karl-D)

i cant read your code. please repost using the "code" bbcode button

Any ideas ? <img>

it looks to me like your site is trying to insert text in utf-8 format into a latin1 db.

Check the format of your db. for phpBB2 it should be latin1_* , probably latin1_swedish_ci

delete the search_wordlist table and reinstall it

Hya HelterSkelter, I'm still getting the same problem mate, I start rebuilding the search and around 12% it comes up with the error, trouble is when I try to search for it to either delete or edit it tells me no searches matched.
I dropped the search_wordlist then reinstalled it with the code you provided.
I have checked the text and is latin1_swedish_ci as you say

have you downloaded your post text table and done a partial word search?

I believe that either you have a corrupted work in your post text, or your server is running out of memory during the rebuild process. It will use a substantial amount of ram while rebuilding the table.

You might try adding this to your config.php



add it just before this

Hya HelterSkelter yes some of the text in some of the older posts has been corrupted when I originally converted over to Integramod.
I have either deleted or edited quite a lot manually.
What I have been doing is, running the the rebuild search and when an error has come up I have copied the offending text and searched for it on the forum, this generally finds posts containing that corrupted word, so just a case of correcting it by editing the post.

For some strange reason though, the one in the code I posted isn't being found when I do a forum search all I'm getting is "No topics or posts met your search criteria".
Its in a post somewhere as its finding the error for the corrupted text.

I guess Ill just have to keep going through the older posts manually to see if I can find it, I started the board back in 2004 so literally thousands of posts to check lol

Thanks for the help <img>

WOW or is this just a coincidence?
Ill probably get a blasting from my host for using all the ram up now <img>

you should be safe to turn it to 16 megs after you finish rebuilding the search table.

in order to find the post, you may have to export your post_text table and open it in an editor that supports utf-8 like notepad++

you could also backup your db and then try to do a repair on the post text table in phpmyadmin

Thanks HelterSkelter, managed to login to my usual account now <img>
I'm still going through the posts gradually, it currently goes as far as 20% so should be fine about 30% as I'm getting in to the newer posts that arent effected lol

Finally removed all the screwed up text, got to 35% then had no errors and completed. <img>

glad you got it sorted. I know the frustration intimately! <img>

[quote=""HelterSkelter""]glad you got it sorted. I know the frustration intimately!