CMS Made Simple Forums

Upgraded to 1.9.4.1 from 1.6.7.

The upgrade met all of the upgrade requirements during the upgrade wizard. However, now the site will not show and the browser just grinds away and never showing anything. No errors or nothing.

However, we do notice a high MySQL loads now (MySQL 5.1.37) and with the ongoing cms_module_search_index inserts into the database.

17000 natio9_cm localhost natio9_cms 0 Query DELETE FROM cms_module_search_index WHERE item_id NOT IN (SELECT id FROM cms_module_search

17038 natio9_cm localhost natio9_cms 0 Query INSERT INTO cms_module_search_index (item_id, word, count) VALUES (282169,'programs',2)

17040 root localhost test 0 Query show full processlist

17045 natio9_cm localhost natio9_cms 0 Query INSERT INTO cms_module_search_index (item_id, word, count) VALUES (282180,'???????',1)

17190 natio9_cm localhost natio9_cms 0 Query INSERT INTO cms_module_search_index (item_id, word, count) VALUES (282182,'???',3)

Any ideas on how to resolve this issue?

Thanks!

I ended up restoring the previous backup to get the site back up. However, I still noticed that CMS Made Simple is posting a lot of search inserts into the MySQL database.

What is the best way to manage the constant indexing and inserts into MySQL from the Search module. I did not see any parameters in the Search module other than uninstalling it to stop it.