Search Index issues

[Zherog]

Alright, some updates. I'll not bury the lede - it worked! Thank you so much!

With that, though, a few things:

These tables didn't exist in my database:

Code: Select all

 ALTER TABLE phpbb_3_styles_imageset CONVERT TO CHARACTER SET utf8;
 ALTER TABLE phpbb_3_styles_imageset_data CONVERT TO CHARACTER SET utf8;
 ALTER TABLE phpbb_3_styles_template CONVERT TO CHARACTER SET utf8;
 ALTER TABLE phpbb_3_styles_template_data CONVERT TO CHARACTER SET utf8;
 ALTER TABLE phpbb_3_styles_theme CONVERT TO CHARACTER SET utf8;

No big deal...

These tables did exist, but weren't in your list. I manually added them:

Code: Select all

 ALTER TABLE phpbb_3_config_text CONVERT TO CHARACTER SET utf8;
 ALTER TABLE phpbb_3_ext CONVERT TO CHARACTER SET utf8;
 ALTER TABLE phpbb_3_login_attempts CONVERT TO CHARACTER SET utf8;
 ALTER TABLE phpbb_3_migrations CONVERT TO CHARACTER SET utf8;
 ALTER TABLE phpbb_3_notifications CONVERT TO CHARACTER SET utf8;
 ALTER TABLE phpbb_3_notification_types CONVERT TO CHARACTER SET utf8;
 ALTER TABLE phpbb_3_oauth_accounts CONVERT TO CHARACTER SET utf8;
 ALTER TABLE phpbb_3_oauth_states CONVERT TO CHARACTER SET utf8;
 ALTER TABLE phpbb_3_oauth_tokens CONVERT TO CHARACTER SET utf8;
 ALTER TABLE phpbb_3_teampage CONVERT TO CHARACTER SET utf8;
 ALTER TABLE phpbb_3_user_notifications CONVERT TO CHARACTER SET utf8;

When I ran the ALTER TABLE command on phpbb3_posts via phpMySQLAdmin, it failed with this message:

Error
SQL query:


ALTER TABLE `phpbb_3_posts` ADD FULLTEXT (
`post_text`
)
MySQL said: Documentation

#2013 - Lost connection to MySQL server during query

However, running it from MySQL via ssh was successful.

And finally, my ACP still seems to be in a weird "in-between" state. Going to ACP -> Maintenance -> Search Index still looks the same as the screenshot posted yesterday. That's probably not a big deal, unless we ever needed to change the search index type for some reason. That said, if somebody has ideas on how to "kick" the system so that it comes back to normal, I'm willing to try.

Thank you so very much, robtig! I appreciate the assistance!

[robtig]

glad you figured it out!!

Delete cookies/cache on board as well as clear cache/cookies of your browser as well as clearing the cache of any caching modules you are using.

[robtig]

My guess since cache isnt likely it as that shouldnt be cached that it is a value in the database prob needs changed..... which I do not k now