Google SitemapAdmin

[sunny112233]

i install the google sitempa
when comt to tools----google xml sitemap -----click here

can not creat the xml..

help assp......

[tiaz]

Hi, have installed everything but when I try to add the mysql as instructed via copy and paste (not file upload) I just get logged out of my admin. File upload works I have been using it fine, paste doesn't.

I tried to run it instead via phpmyadmin and got:

#1146 - Table 'user_dbname.configuration_group' doesn't exist

Can you advise please?

Thanks

[tiaz]

Just to add Full error message.

When I try to run the install via phpmyadmin I get:

SQL query:

SELECT (
@configuration_group_id := configuration_group_id
)
FROM configuration_group
WHERE configuration_group_title = 'Google XML Sitemap'
LIMIT 1 ;

MySQL said:
#1146 - Table 'user_dbname.configuration_group' doesn't exist

Please advise
Thanks

[kehrli]

For those of you who don't like getting the Google warning,

"All the URLs in your Sitemap have the same priority.":

I have made a little hack that will alter the priority of the first 2 urls in each sitemap. It arbitrarily reduces the priority of the first 2 urls by .1. If your priority is set for .7, then the first 2 urls will have a priority of .6 and the rest will be .7. This will satisfy the google bot and eliminate the warning message.

It is also possible to open up your sitemap files and manually alter a couple of urls. This will also work. But I have mine set up to run daily as an automated task, so do not have this option. So I created a couple of lines of code to handle this for me.

In googlesitemap.php, the following is all original code, except for the part between "// begin kehrli mod:" and "// end kehrli mod". Just find that part of the code and insert the 3 new lines.

      $number++;
      $contentXML .= ' <url>' . "\n";
      $contentXML .= '  <loc>' . utf8_encode($url['loc']) . '</loc>' . "\n";
      if(isset($url['lastmod']) && $url['lastmod'] != '')
        $contentXML .= '  <lastmod>' . $this->LastMod($url['lastmod']) . '</lastmod>' . "\n";
      if(isset($url['changefreq']) && $url['changefreq'] != '')
        $contentXML .= '  <changefreq>' . $url['changefreq'] . '</changefreq>' . "\n";
      if(isset($url['priority']) && $url['priority'] != '')
// begin kehrli mod:
        if($number < 3)
          $contentXML .= '  <priority>' . ($url['priority'] - .1) . '</priority>' . "\n";
        else
// end kehrli mod
          $contentXML .= '  <priority>' . $url['priority'] . '</priority>' . "\n";
      $contentXML .= ' </url>' . "\n";