We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 36830
    • 140 Posts
    For some reason, my getRelated snippet is not working on every page that uses it, even though the pages all use the same template. Even some pages that have nearly identical related pages within the same resource folder aren't returning any related documents... Scanning my error log I found this error recurring on the pages that use this snippet: "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'" -- seems like a clue... But how would i go about troubleshooting this? Thanks for any insight.
      • 28042 ☆ A M B ☆
      • 24,524 Posts
      Check your MODX System Settings for 'modx_charset', then make sure that your database is using the same charset and collation.

      http://bobsguides.com/convert-db-utf8.html
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org