Using "longtext" instead of "text" for cache

  • Resolved marclang

    (@marclang)


    9 years, 11 months ago

    I kept having issues with caching my publications. For things like a short sidebar with 5-10 refs it would work, but not for displaying all of them (~200) in a single chunk on my publication page. I finally figured out that the choice of MySQL data type text in the mendeleycache table limits the cache to 64k – which apparently wasn’t enough to hold the HTML of some 200 refs.

    I manually changed this from text to longtext, and now everything works just fine.

    Maybe this should be changed in the next version? Not sure how to auto-upgrade existing tables — I simply changed the initializeDatabase() function to use the longtext data type for the content field, and manually changed the existing table through phpMyAdmin.

    Hope this helps!

    Cheers,

    -m

    https://ww.wp.xz.cn/plugins/mendeleyplugin/

Viewing 1 replies (of 1 total)
  • Plugin Author kochm

    (@kochm)

    9 years, 9 months ago

    Thanks a lot for the feedback! The suggested change will be in the next version of the plugin.

Viewing 1 replies (of 1 total)

The topic ‘Using "longtext" instead of "text" for cache’ is closed to new replies.