Technote Details :: Creating the cache table after using MX Site Search fails

After applying MX Site Search on a site, it attempts to create a cache table with data from all existing tables that will be indexed. This attempt fails, and an error message stating that MySQL does not have enough memory to perform the operation is displayed.

The MX Site Search code creates a cache table with the content of all the tables you want to search through. During this process it creates several recordsets for each table and then stores them into the cache table. If your table is very large, MySQL does not have enough memory to create the recordset for this table.

The only available solution to this problem is to increase the memory limit for MySQL, in order to allow it to complete the cache table creation.

Login to add a new note