September 8, 2015 at 10:23 pm #23961
Checks to perform in this order:
1) Symbiostock related posts indexes once a day. If you want to force it to index on your processor, edit tools-cron.php and uncomment the:
//$GLOBALS[“ss_runall”] = 1;
line. Then run your processor.
2) WooCommerce caches all related posts queries for 30 days or so. You must then clear transients to see fresh results. Go to WooCommerce > System Status > Tools and clear all transients.
3) Symbiostock’s related posts system utilizes fulltext searches and accordingly requires your postmeta table to be a MyISAM table. If it is any other, including InnoDB, the improved related posts function will not work. To convert your table from InnoDB to MyISAM, you can do this via phpMyAdmin
or via a direct MySQL command:
ALTER TABLE wp_postmeta ENGINE = MyISAM
Where wp_postmeta is the name of your postmeta table (it may be different depending on the prefix you chose during install). It is additionally recommended that you convert all your WordPress tables to MyISAM so that cross table queries work more efficiently. It may be prudent to backup your tables and turn off your site while this conversion occurs to minimize issues. If you do choose to do this, it is at your own risk, though it is a relatively safe conversion (I have done it numerous times without issue). In terms of efficiency, MyISAM is the default MySQL storage type, and all our PLUS servers run on it exclusively. For more information, check this article:
If you do not want to alter the table type, you should disable the Symbiostock powered related posts function and clear your WooCommerce transients.September 8, 2015 at 11:08 pm #23964
HenriParticipantSeptember 8, 2015 at 11:12 pm #23965September 8, 2015 at 11:28 pm #23967
HenriParticipantSeptember 8, 2015 at 11:59 pm #23968
You must be logged in to reply to this topic.