• Hi, Hoping someone could provide a solution to the following issue – using Google XML Sitemap and every time someone posts or I admin a message I get the following error messages:

    Warning: mysql_affected_rows() [function.mysql-affected-rows]: A link to
    the server could not be established in /data/12/1/117/95/1117910/user/1179538/htdocs/blog/wp-includes/wp-db.php
    on line 183

    Warning: Cannot modify header information – headers already sent by (output started at
    /data/12/1/117/95/1117910/user/1179538/htdocs/blog/wp-includes/wp-db.php:183)
    in
    /data/12/1/117/95/1117910/user/1179538/htdocs/blog/wp-includes/pluggable.php
    on line 275

    Had the guys from Network Solutions troubleshoot and they sent me the following:

    Warning: mysql_affected_rows() [function.mysql-affected-rows]: A link to the server could not be established in /data/12/1/117/95/1117910/user/1179538/htdocs/blog/wp-includes/wp-db.php on line 184
    UPDATE wp_options SET option_value = ‘O:28:\”googlesitemapgeneratorstatus\”:29:{s:10:\”_startTime\”;d:1200888136.2383430004119873046875;s:8:\”_endTime\”;i:0;s:11:\”_hasChanged\”;b:1;s:12:\”_memoryUsage\”;i:6281640;s:9:\”_lastPost\”;i:41;s:9:\”_lastTime\”;d:1200888136.3174870014190673828125;s:8:\”_usedXml\”;b:1;s:11:\”_xmlSuccess\”;b:1;s:8:\”_xmlPath\”;s:62:\”/data/12/1/117/95/1117910/user/1179538/htdocs/blog/sitemap.xml\”;s:7:\”_xmlUrl\”;s:42:\”http://www.homedesign.com/blog/sitemap.xml\”;s:8:\”_usedZip\”;b:1;s:11:\”_zipSuccess\”;b:1;s:8:\”_zipPath\”;s:65:\”/data/12/1/117/95/1117910/user/1179538/htdocs/blog/sitemap.xml.gz\”;s:7:\”_zipUrl\”;s:45:\”http://www.homedesign.com/blog/sitemap.xml.gz\”;s:11:\”_usedGoogle\”;b:1;s:10:\”_googleUrl\”;b:1;s:15:\”_gooogleSuccess\”;b:0;s:16:\”_googleStartTime\”;d:1200888136.330542087554931640625;s:14:\”_googleEndTime\”;i:0;s:10:\”_usedYahoo\”;b:0;s:9:\”_yahooUrl\”;s:0:\”\”;s:13:\”_yahooSuccess\”;b:0;s:15:\”_yahooStartTime\”;i:0;s:13:\”_yahooEndTime\”;i:0;s:8:\”_usedAsk\”;b:0;s:7:\”_askUrl\”;s:0:\”\”;s:11:\”_askSuccess\”;b:0;s:13:\”_askStartTime\”;i:0;s:11:\”_askEndTime\”;i:0;}’ WHERE option_name = ‘sm_status’

    I’m not a hardcore programmer so I can’t really do a deep dive into troubleshooting so any help that can be provided would be greatly appreciated.

    Thanks.

Viewing 1 replies (of 1 total)
  • Hi tsnyc,

    maybe you’re using a plugin which doesn’t use the WordPress API for database access. In this case there is an option named “Enable MySQL standard mode” at the Sitemap plugin options page which uses a workaround for this issue. Note that this way is a bit slower than the default one.

Viewing 1 replies (of 1 total)

The topic ‘Google XML Sitemap Errors’ is closed to new replies.