Hey all!
I just spent half a night tracking down a problem I've been having displaying certain search results. Hopefully this quick fix will save someone a few nerves...
When displaying large numbers of listings on a single page span, listings were sometimes being cut off. This was also resulting in broken tables and html. Came to find out it was being caused by the Search Cache Plugin returning truncated results. Totally thought it was my templates or a Links bug until I found this page:
http://simon.incutio.com/...8/01/mysqlTextLimits
Seem a MySQL TEXT field can only hold about 65,000 characters and the rest is truncated off. To fix this change the "link_results" field type to MEDIUMTEXT instead of TEXT. This will allow the field to hold around 16 million characters instead of 65,000. Plenty of space to hold the largest of results pages.
Jonze
I just spent half a night tracking down a problem I've been having displaying certain search results. Hopefully this quick fix will save someone a few nerves...
When displaying large numbers of listings on a single page span, listings were sometimes being cut off. This was also resulting in broken tables and html. Came to find out it was being caused by the Search Cache Plugin returning truncated results. Totally thought it was my templates or a Links bug until I found this page:
http://simon.incutio.com/...8/01/mysqlTextLimits
Seem a MySQL TEXT field can only hold about 65,000 characters and the rest is truncated off. To fix this change the "link_results" field type to MEDIUMTEXT instead of TEXT. This will allow the field to hold around 16 million characters instead of 65,000. Plenty of space to hold the largest of results pages.
Jonze