Error “Data too long for column ‘cached_url'”
-
Loving this plugin! We use it on several sites now.
On one site one of the configured languages is Japanese, including the urls. We are getting a daily error notice like this:
2024/12/16 05:48:58 [error] 110209#110209: *603812 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'cached_url' at row 4 in /path/on/server/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php:446It makes sense. The browser displays the Japanese characters in the URL just fine, like this: https://myexamplesite.com/ja/エホバの証人についての正確な情報/家族生活について/. But under-the-hood they’re being escaped. For example, if I copy/paste that URL you’ll get this:
https://myexamplesite.com/ja/%e3%82%a8%e3%83%9b%e3%83%90%e3%81%ae%e8%a8%bc%e4%ba%ba%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6%e3%81%ae%e6%ad%a3%e7%a2%ba%e3%81%aa%e6%83%85%e5%a0%b1/%e5%ae%b6%e6%97%8f%e7%94%9f%e6%b4%bb%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6/Anything we could do to resolve/prevent these errors?
Thank you!
The topic ‘Error “Data too long for column ‘cached_url'”’ is closed to new replies.
