Huge error_log caused by sitemap MySQL? WPSEO_Sitemap_Cache_Data
-
Hello, don’t know if I will get a reply but will try. Thanks to anyone who can provide any help.
I just realized error_log is 1GB big, increasing several MB every few minutes. It seems Yoast SEO related, with the sitemaps.
The single line of error is many MB long, listing thousands of files, this is how it starts:
[27-Apr-2016 19:51:12 UTC] Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') USING latin1 ) AS x_0' at line 1 de la base de datos de WordPress para la consulta SELECT CONVERT( CONVERT( 'INSERT INTOwp_options(option_name,option_value,autoload) VALUES (\'_transient_yst_sm_post_1:3Fwqq_5Moef\', \'C:24:\\\"WPSEO_Sitemap_Cache_Data\\\":1393701:{a:2:{s:6:\\\"status\\\";s:2:\\\"ok\\\";s:3:\\\"xml\\\";s:1393650:\\\"<urlset xmlns:xsi=\\\"https://www.w3.org/2001/XMLSchema-instance\\\" xmlns:image=\\\"https://www.google.com/schemas/sitemap-image/1.1\\\" xsi:schemaLocation=\\\"https://www.sitemaps.org/schemas/sitemap/0.9 https://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd\\\" xmlns=\\\"https://www.sitemaps.org/schemas/sitemap/0.9\\\">\\n <url>\\n <loc>https://www.mywebsite.com</loc>\\n <lastmod>2016-04-27T15:39:33+03:00</lastmod>\\n <changefreq>weekly</changefreq>\\n <priority>0.8</priority>\\n </url>\\n <url>\\n <loc>https://www.mywebsite.com/</loc>\\n <lastmod>2008-03-13T21:47:34+03:00</lastmod>\\n <changefreq>weekly</changefreq>\\n <priority>0.6</priority>\\n <image:image>\\nI have MySQL 5.5.48-cll – MySQL Community Server (GPL)
As far as I can tell, sitemaps are generated, but error_log just keeps getting bigger and bigger.I have no idea how to solve this. Searched for similar problem, but don’t find anything like it. Thanks for any help, if possible!
- The topic ‘Huge error_log caused by sitemap MySQL? WPSEO_Sitemap_Cache_Data’ is closed to new replies.
