I don't know if anyone here runs phpbb3 on any site, or has recently converted from phpbb2. I have, but the conversion did not run all that smoothly.

When upgrading from phpbb2 to phhbb3 you have to convert the database, there is a tool that does that for you. After the conversion is complete, you have to re-index the posts so that the forum will be searchable. In my case this does not work as the process halts and I get the following error:



Then a number of search words are listed.

This is annoying as it leaves the forum partly unsearchable. Posts created after the conversion have been indexed, but searching for anything older than that is really hit and miss. Anyone knows what to do here?

I realized that for some reason the character set in the database was "latin1_swedish_ci" and when checking with the host they told me the default character set on the server is "utf8." I have tried to change the collation database wide to utf8, but many tables still show as latin1_swedish_ci." Does this have anything to do with it?

I also thought of deleting the listed search words that appear witht the error message, but I haven't gotten around to do it as I am not sure how to delete them from the database.

Help is much appreciated (and can be remunerated, if I am allowed to say that here).

If the collation was originally lastin1_swedish and now utf8 -- you will need to run queries, or go through the database with a tool like phpmyadmin, and change any tables on the old collation to utf8. (In phpmyadmin you can select the table and click edit to change things like this)