The search index could not be updated. The site is misconfigured. Contact an administrator. SQLSTATE[42000]: Syntax error or access violation: 1064 unknown table 'tiki_main_67e2559f7089d' in delete request
You would need to do two steps, firstly change the prefence in tiki_user_preferences for all existing users, then a code modification to make the default option yes.
Personally I feel it should be yes anyway, as this is new behaviour in 1.9
