Google SitemapAdmin

Quote:

---

Originally Posted by Woodymon

Easiest would be to run the uninstall.sql (included the mod zip archive). Then run install.sql again.

If that does not work you can track down the relevant entries in the configuration table in your ZC database via phpymyadmin and delete each manually.

You might want to document your various mod settings before doing this.

And I recommend first backing up ... of course.

Woody

---

Woodymon

Thanks for the help. I couldn't delete the entries using the uninstall.sql file - said it couldn't find the configuration_groups table. So I used phpMyAdmin and (taking a deep breath and closing my eyes, crossing my fingers, stroking my lucky rabbit's foot etc.) deleted the entries in the relevant tables and then used the install patches just to run the install.sql file. I realised that I had previously also run all of the update sql files, hence, presumably, the duplication.

[FONT=Times New Roman]Hi Woodymon[/FONT]
[FONT=Times New Roman]I took your advice, and I keep it, You are 100 % right [/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Thank you for stoping me [/FONT]

Hi

After long long day, I change my directory so I don’t have the /store in it, and I am able to use this mod ( any one like to buy $20.00 site map for a ?0.01) :smile:

Can some one direct me to where I saw what files should be in the Disallow in the Robots.txt

Thanks

Quote:

---

Originally Posted by blag

Woodymon

Thanks for the help. I couldn't delete the entries using the uninstall.sql file - said it couldn't find the configuration_groups table. So I used phpMyAdmin and (taking a deep breath and closing my eyes, crossing my fingers, stroking my lucky rabbit's foot etc.) deleted the entries in the relevant tables and then used the install patches just to run the install.sql file. I realised that I had previously also run all of the update sql files, hence, presumably, the duplication.

---

It is likely you have a prefix (e.g. zen_) on your db tablenames and thus uploading the uninstall.sql through Zen Cart's sqlpatch tool did not work for you. In these cases try pasting the sql code into the sqlpatch tool edit box.

It's strange that you would have duplicate entries (table records) with the exact same parameters (fields) in your related db tables. When running a SQL statement which would duplicate pre-existing records in a table, by default MySQL should report back the record already exists, and not update the table with those particular records.

But if doubt and you are having issues (and you know what you are doing) phpmyadmin is the way to go.

Woody

Quote:

---

Originally Posted by Woodymon

It is likely you have a prefix (e.g. zen_) on your db tablenames and thus uploading the uninstall.sql through Zen Cart's sqlpatch tool did not work for you. In these cases try pasting the sql code into the sqlpatch tool edit box.

It's strange that you would have duplicate entries (table records) with the exact same parameters (fields) in your related db tables. When running a SQL statement which would duplicate pre-existing records in a table, by default MySQL should report back the record already exists, and not update the table with those particular records.

But if doubt and you are having issues (and you know what you are doing) phpmyadmin is the way to go.

Woody

---

Woodymon

I tried using the sqlpatch tool, and that reported errors about missing tables: it even reported the correct database name, prefix and table, but reported the table as missing. In fact as far as I coul tell all was correct, but sql patch wasn't happy about something!!!

I was able to load this mod, but when I click: STEP 1: Click [HERE] to create / update your site map.


I only get a blank popup.

-lindasdd

Can anyone help me with this??

I think I have everything configured right....
I 777'ed the xml files.
Ran the generator:

Quote:

---

Processing file: /home/*****/public_html/sitemapproducts.xml OK! Written 1596 records, 335410 bytes
Generated Google Product Sitemap Successfully - http://www.********.com/sitemapproducts.xml

---

However when I go to look at the file it says:

Quote:

---

Google Sitemap http://www.*********.com/sitemapproducts.xml
Number of sitemaps in this Google sitemap index: 0

---

So it doesnt show any links...

But then I edit the file... And I see the links are there!

:frusty::frusty::frusty::frusty:

What do i do???

Quote:

---

Originally Posted by milobloom

So it doesn't show any links...
But then I edit the file... And I see the links are there!
What do i do???

---

I don't understand what is meant by this. What is "it"? When do you see the file does not "show any links"? How would you not know without opening the file in a text editor? :wacko:

By default the mod should generate four (4) XML files. The index file is:
sitemapindex.xml

And the other three:
sitemapproducts.xml
sitemapcategories.xml
sitemapezpages.xml

(the last file depends on your settings in ZC Admin > Configuration > Google XML Sitemap)

Be sure you have 777 perms on all four files when you are generating them (then recommend turning off write bit when done generating).

The mod should throw an error for each of the four files when you try to generate without the correct perms.

Note, if you did not upload the four xml files from the mod distribution then you have to physically create each xml file (empty file) in a text editor and upload, before the initial sitemap generation.

Hope some of this helps.

Woody

I have the xml files set to 777
I also made the files blank.

I re ran and tried to recreate the xml files.
It says they are fine. even shows the product counts:

http://www.nothingbutcostumes.com/googlesitemap.php

but when i click on the next link ( to see the products )
it doesn't look like they are written to.

http://www.nothingbutcostumes.com/sitemapproducts.xml

Strange....

So whats stranger...

If I go in and edit my
http://www.nothingbutcostumes.com/sitemapproducts.xml

and i see lines like this:

Quote:

---

<url>
<loc>http://www.nothingbutcostumes.com/index.php?main_page=product_info&amp;products_id=7980</loc>
<lastmod>2007-07-05</lastmod>
<changefreq>weekly</changefreq>
<priority>1.00</priority>
</url>
<url>
<loc>http://www.nothingbutcostumes.com/index.php?main_page=product_info&amp;products_id=8334</loc>
<lastmod>2007-06-29</lastmod>
<changefreq>weekly</changefreq>
<priority>0.53</priority>
</url>
<url>
<loc>http://www.nothingbutcostumes.com/index.php?main_page=product_info&amp;products_id=7783</loc>
<lastmod>2007-07-05</lastmod>
<changefreq>weekly</changefreq>
<priority>0.40</priority>
</url>
<url>
<loc>http://www.nothingbutcostumes.com/index.php?main_page=product_info&amp;products_id=975</loc>
<lastmod>2006-07-27</lastmod>
<changefreq>weekly</changefreq>
<priority>0.39</priority>
</url>
<url>
<loc>http://www.nothingbutcostumes.com/index.php?main_page=product_info&amp;products_id=8553</loc>
<lastmod>2007-07-12</lastmod>
<changefreq>weekly</changefreq>
<priority>0.34</priority>
</url>

---

but if i go to:

http://www.nothingbutcostumes.com/sitemapproducts.xml

I dont see any links....

Quote:

---

Originally Posted by milobloom

If I go in and edit my
http://www.nothingbutcostumes.com/sitemapproducts.xml

but if i go to:
http://www.nothingbutcostumes.com/sitemapproducts.xml

I dont see any links....

---

The URL's above are exactly the same. I am totally lost on what you trying to say here.

What do you mean when you say you click on the next link?

Note the generated xml files are not intended for you or anyone else to open/view or navigate in a browser.

They are for Google software to scan. ;-)

Generate the files, ping Google, then log into your Webmasters account the next day to see the results.

I suggest you log into your Google Webmasters account and review the basic help documentation ;-)

Woody

Boy am i confused. Are you not supposed to see the paths for the sitemaps???
When I go to my other site, and click this url:

http://www.allforyourwedding.com/~no...approducts.xml

It comes up with this page with many links on it (1269 i think). As shown here:

Quote:

---

Google Sitemap http://www.allforyourwedding.com/~no...approducts.xml
Number of URLs in this Google Sitemap: 1269

---

When I go to my other site's googlesitemaps - As shown here:

http://www.nothingbutcostumes.com/googlesitemap.php

It says that it generated 1760 records. S per below:

Quote:

---

Processing file: /home/nothingb/public_html/sitemapproducts.xml OK! Written 1760 records, 369850 bytes
Generated Google Product Sitemap Successfully - http://www.nothingbutcostumes.com/sitemapproducts.xml

---

But when I click on the same one as the other site:

http://www.nothingbutcostumes.com/sitemapproducts.xml

I dont see any paths....

Quote:

---

Google Sitemap http://www.nothingbutcostumes.com/sitemapcategories.xml
Number of sitemaps in this Google sitemap index: 0

---

And the strange thing is if I edit

http://www.nothingbutcostumes.com/sitemapproducts.xml

In my ftp editor, I see all the links are in the file. Am I waiting for something to happen before they appear by clicking on: ??

http://www.nothingbutcostumes.com/sitemapproducts.xml

If so then I guess I did everything right... I just thought I would see something there.


Milo

Quote:

---

Originally Posted by milobloom

Boy am i confused. Are you not supposed to see the paths for the sitemaps???

---

Could be you have employed GSM mod in Zen Cart running on a subdomain? So the directory where the xml files are written is not the directory you think they are being written.

I would not recommend posting the FULL paths for publicly accessible/writable directories in a public forum.

Woody

Ok.

If that was the case... Then does it mean my sitemap works?
Well actually I just checked google and it did...
Wanted to see if I can submit it to Yahoo.

Can these submissions be included in the sitemap admin?:

Ask.com:
http://submissions.ask.com/ping?site...ur_sitemap.xml

LiveSearch (aka Live.com, MSN, Microsoft):
only autodiscovery using robots.txt with the following text:
Sitemap: <sitemap_location>
(explained here: http://livesearch.spaces.live.com/bl...138!1299.entry)

When I create the sitemap I get messages telling me that four pages have been successfully created. However, when I try to view the sitemapezpages.xml, I get the following error:

XML Parsing Error: not well-formed
Location: (the URL location)
Line Number 8, Column 49: <loc>http://siteurl.com/page.html?chapter=1&id=1</loc>

It is objecting to the second parameter passed to the page, appearing to get stuck on the second = sign. Is anyone else having this problem? What on earth can I do to fix it?

I am currently getting around this problem by turning off the ez-pages while I create the sitemapindex, then turning them back off again. This prevents them from appearing in the Google sitemap, but at least removes the error which seemed to be stopping Google from crawling the site at all...

Quote:

---

Originally Posted by onlyrey

Can these submissions be included in the sitemap admin?:

Ask.com:
http://submissions.ask.com/ping?site...ur_sitemap.xml

---

exactly what i was about to ask


Also am I might be missing something but

I have set up a cronjob to automatically create the sitemaps every week and i have set the ping=yes, however from looking at the code it only appears to ping google and not yahoo, would it be possible to add Yahoo and Ask to this so they are automatically pinged as well?

Quote:

---

Originally Posted by dbabbage

When I create the sitemap I get messages telling me that four pages have been successfully created. However, when I try to view the sitemapezpages.xml, I get the following error:

---

Note the xml files really are not intended to be "viewed" by your or the public. They are only created for Google to parse.

At any rate, which program are you attempting to open/view the XML file with?

You should be able to open the file in a text editor just fine (e.g. NotePad ++).

One note: I just discovered the module is adding zen_id's to the entries in sitemapezpages.xml

This is NOT good. Best for you to remove them.

So for:

Quote:

---

<loc>http://www.your_domain.com/your_shop/index.php?main_page=page&amp;id=12&amp;chapter=2&amp;zenid=blahblahblah</loc>

---

Change to:

Quote:

---

<loc>http://www.your_domain.com/your_shop/index.php?main_page=page&amp;id=12&amp;chapter=2</loc>

---

Woody

Quote:

---

Originally Posted by Woodymon

One note: I just discovered the module is adding zen_id's to the entries in sitemapezpages.xml

---

Strange. The GSM output I generated late last month contained zen_id's in sitemapezpages.xml. However I just generated updated XML output, and I do not observe zen_id's. So I guess problem solved. But just in case you should check your output BEFORE pinging Google to come parse your GSM xml.

Woody

Quote:

---

Originally Posted by onlyrey

Can these submissions be included in the sitemap admin?:
Ask.com:
LiveSearch

---

The latest version of GSM mod supports Sitemaps 0.9 protocol. So if you have your sitemap listed in robots.txt any service you subscribe to supporting the standard should be able to use the XML feed generated by the GSM mod.

(e.g. Google Sitemaps, Yahoo Site Explorer, etc)

See:

1. http://about.ask.com/en/docs/about/webmasters.shtml#22

2. http://livesearch.spaces.live.com/bl...138!1342.entry

Note MS Live Search sitemap product is now in beta (e.g. sitemap tools, live search portal, etc). You can sign up for beta account. Instructions at above URL.

Note these "sitemap feeds" are independent from "product search feeds". So it is recommended you also sign up and generate feeds for GoogleBase Product Search and MS Live Product Search. (Unlike these services which are free, "Yahoo Product Submit" is a paid CPC service which feeds "Yahoo Shopping"). And there are many other free "shopping search services" you can create custom feeds for.

Woody

Thanks a lot for the latest addition to this excellent mod.

I've just taken the opportunity to relocate my xml files to a sub folder and have discovered that this piece of functionality doesn't appear to work 100&#37;. Although the xml files are generated in the sub folder, the URLs in sitemapindex.xml don't contain the sub folder, i.e they continue to point to sitemaps in the root folder.

This isn't a huge issue as I've just moved them back to root but I thought you'd like to know!.

Quote:

---

Originally Posted by ARRSE

Thanks a lot for the latest addition to this excellent mod.

I've just taken the opportunity to relocate my xml files to a sub folder and have discovered that this piece of functionality doesn't appear to work 100&#37;. Although the xml files are generated in the sub folder, the URLs in sitemapindex.xml don't contain the sub folder, i.e they continue to point to sitemaps in the root folder.

This isn't a huge issue as I've just moved them back to root but I thought you'd like to know!.

---

Andrew whom developed this mod and latest updates is no longer around these parts.

You can change where you write the four xml files in the mods Configuration menu.

The module utilizes paths set in your ZC configure.php files, which indicate the root of your shop (usually different from your webroot).

There should be no reason to move the xml files into a child directory of your shop root, if that is what you have done.

If you are running your shop on a add-on or sub-domain that may be contributing to your issue.

Woody

Woodymon,
Thanks for your reply and I wasn't aware that Andrew had moved on.

The point I was trying to make is that the setting in the Configuration menu doesn't work. Lets say you set it to write to a subdirectory of feed and your main site install is in /www/ on your system.

The module will quite happily create the 4 xml files in /www/feed but when you open /www/feed/sitemapindex.html you will find that it points to http://yoururl.com/sitemapproducts.xml not http://yoururl.com/feed/sitemapproducts.xml, etc.

As I say I have just moved my sitemaps back to my root folder and it is fine. I thought I'd report this issue just in case anyone else was having the same difficulty.

Quote:

---

Originally Posted by ARRSE

Woodymon,
Thanks for your reply and I wasn't aware that Andrew had moved on.

The point I was trying to make is that the setting in the Configuration menu doesn't work. Lets say you set it to write to a subdirectory of feed and your main site install is in /www/ on your system.

The module will quite happily create the 4 xml files in /www/feed but when you open /www/feed/sitemapindex.html you will find that it points to http://yoururl.com/sitemapproducts.xml not http://yoururl.com/feed/sitemapproducts.xml, etc.

As I say I have just moved my sitemaps back to my root folder and it is fine. I thought I'd report this issue just in case anyone else was having the same difficulty.

---

Using the latest mod version I can place the sitemap in whichever directory I please as long as it is in the path of the shop.

You have to use the full absolute path in the configuration
e.g. /home/account_name/public_html/
(the ending forward slash is important)

If your shop is in /home/account_name/public_html/shop/
then you cannot write the feed to
/home/account_name/public_html/feed/
since it is not in the path of your shop.

But you could put the feed into
/home/account_name/public_html/shop/feed/
or
/home/account_name/public_html/shop/
or
/home/account_name/public_html/

See your configure.php file for the proper path.

Hope this makes sense.

Woody

Argh. After a second look I did miss your point and now see what you were stating.

I do not believe previous mod versions had this same issue.

I suspect standard sitemap protocol states you should place your sitemap files in your webroot. Thus this may be the reason why child directories are no longer included in the directory paths to the other three sitemap files within the sitemapindex file. This is confusing and worth investigating. Thanks for the heads up.

At any rate be sure to add the "Sitemap" entry in your robots.txt file
e.g.
Sitemap: http://www.your_domain.com/sitemapindex.xml

Woody

Gulp!

I have just updated to the latest version in the downloads section, and have encountered the following error when I try to open the Google XML Sitemap under the Tools Menu (in Admin):

Quote:

---

Google Sitemap Generation (v 1.3.13 14.08.2007 10:32) started

Save path - "/xxxx/yyyy/public_html/store/"
Base URL - "http://hohose.exphoster.com/store/"


Fatal error: Call to undefined function: zen_get_info_page() in /xxxx/yyyy/public_html/store/admin/googlesitemap.php on line 279

---

(xxxx and yyyy used for security purposes)

I have previously been able to generate the relevant XML files without problems, and I have set the XML files' permissions to '777'

Can anyone please, please be so kind as to give me some guidance as to how to overcome this problem?

error with google and robots.txt file.... this is aggravating.

google states this:

"Network unreachable: robots.txt unreachable "

therefore, it won't index the site.

the problem is that it is listed and indexed correctly:

tampabayuniforms.com/robots.txt

it is clearly there to index the site.

the xml files are also there:

http://tampabayuniforms.com/sitemapindex.xml

and all the listings are congruent (no www. either in the files or the robot files or the listing.)

I give up.

any help is appreciated.

thanks!

Quote:

---

Originally Posted by dbabbage

When I create the sitemap I get messages telling me that four pages have been successfully created. However, when I try to view the sitemapezpages.xml, I get the following error:

XML Parsing Error: not well-formed
Location: (the URL location)
Line Number 8, Column 49: <loc>http://siteurl.com/page.html?chapter=1&id=1</loc>

---

I have figured out why I am getting this error. It is because the plugin is not writing the & characters in the URLs to &amp; in the sitemap. Because I am using SEO urls for all other pages, this is only happening on the EZPages sitemap (since I haven't been able to figure out how to have these re-written by the SEO plugin... any leads on that?)

Anyone know how to fix this?

Zen-Cart 1.3.7.?
3 installs
2 went great on Linux servers
1 only 1/2 works on NT and wamp 5 1.7.2

The googlesitemap.php in the root dir works fine from the command line
http://www.stuff4toys.com/googlesitemap.php?ping=yes
works great.

From the admin I get:

Quote:

---

Google Sitemap Generation (v 1.3.13 14.08.2007 10:32) started

Save path - "e:/www/"
Base URL - "http://www.stuff4toys.com/"


Fatal error: Call to undefined function zen_get_info_page() in E:\www\admin_folder\includes\languages\english\googlesitemap.php on line 298

---

help?
JOhn ><>

Quote:

---

Fatal error: Call to undefined function zen_get_info_page() in E:\www\admin_folder\includes\languages\english\goo glesitemap.php on line 298

---

admin_folder\includes\languages\english\goo glesitemap.php don't use zen_get_info_page() function has no 298 lines.

Reinstall.

Quote:

---

Originally Posted by a_berezin

admin_folder\includes\languages\english\goo glesitemap.php don't use zen_get_info_page() function has no 298 lines.

Reinstall.

---

Hey you are right. Must have been a bad ftp session or something to put the wrong files there. I re-uploaded and PERFECT! :clap:

Thanks for pointing that out.
JOhn ><>

Installed google sitemap locally with a fresh install of zen cart 1.3.7.
I also installed the latest version of Ultimate SEO URLs
http://www.zen-cart.com/index.php?ma...roducts_id=231.

From what I can gather there have been compatibility issues with Chemo's Ultimate URLs and the sitemap generator in the past.

I am wondering however if there is a solution for the new Ultimate SEO and 1.3.7.

Can anyone help me out?

Basically I am getting this for all four of the xml files...
ERROR: Google Product Sitemap Generation FAILED!

All the configuration items are basically set to the default.

thanks in advance

Hi Folks!

It seems that the latest version is generating the sitemaps with an error in one. Google does not like the EZ pages xml page. I'm getting the following error.

The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. A semi colon character was expected.

[FONT=Arial]Any ideas? Thanks...[/FONT] :cry:

Quote:

---

Originally Posted by mafiasam

Installed google sitemap locally with a fresh install of zen cart 1.3.7.
I also installed the latest version of Ultimate SEO URLs
http://www.zen-cart.com/index.php?ma...roducts_id=231.

From what I can gather there have been compatibility issues with Chemo's Ultimate URLs and the sitemap generator in the past.

I am wondering however if there is a solution for the new Ultimate SEO and 1.3.7.

Can anyone help me out?

Basically I am getting this for all four of the xml files...
ERROR: Google Product Sitemap Generation FAILED!

All the configuration items are basically set to the default.

thanks in advance

---

This issue was solved. It was a problem with the permissions of the xml files. On the local machine they were writable but when they were transferred to the server the permissions changed.

I am also having issues with this mod.

I have a fresh install of the latest ZenCart, and the xml files are located in catalog/*.xml.

Initially I received an error, so I changed all the permissions to CMOD 777, as suggested by Andrew in his installation instructions.

I am getting the following error:

Quote:

---

Processing file: http://www.domain.com/subdir/sitemapezpages.xml
Warning: fopen(http://www.domain.com/subdir/sitemapezpages.xml): failed to open stream: HTTP wrapper does not support writeable connections. in /aaa/bbb/c/d/e/domainename/html/subdir/googlesitemap.php on line 203
Failed!
ERROR: Google Category Sitemap Generation FAILED!

---

This is the code in googlesitemap.php:

Code:

---

$filename .= '.xml';
echo 'Processing file: ' . $filename;
if ($fp = fopen($filename, 'w+')){    (line 203)
fwrite($fp, $data, strlen($data));
fclose($fp);
echo ' OK! Written ' . $records . ' records, ' . strlen($data) . ' bytes <br />';
return true;
} else {
echo ' Failed!<br />';
$file_check = file_exists($filename) ? 'true' : 'false';
return false;

---

This error comes up for all the *.xml files.

Any idea's?

Thanks,

Goshawk

Quote:

---

Originally Posted by Goshawk

I am also having issues with this mod.

I have a fresh install of the latest ZenCart, and the xml files are located in catalog/*.xml.

Initially I received an error, so I changed all the permissions to CMOD 777, as suggested by Andrew in his installation instructions.

I am getting the following error:



This is the code in googlesitemap.php:

Code:

---

$filename .= '.xml';
echo 'Processing file: ' . $filename;
if ($fp = fopen($filename, 'w+')){    (line 203)
fwrite($fp, $data, strlen($data));
fclose($fp);
echo ' OK! Written ' . $records . ' records, ' . strlen($data) . ' bytes <br />';
return true;
} else {
echo ' Failed!<br />';
$file_check = file_exists($filename) ? 'true' : 'false';
return false;

---

This error comes up for all the *.xml files.

Any idea's?

Thanks,

Goshawk

---

Still sounds like a file permissions problem to me. I have found that some web hosts don't allow complete CHMOD changes. It may be that you need to go to your cPanel (if your web host has such a thing) and change the permissions from there!

Quote:

---

Originally Posted by Goshawk

I am getting the following error:

Quote:

---

Processing file: http://www.domain.com/subdir/sitemapezpages.xml
Warning: fopen(http://www.domain.com/subdir/sitemapezpages.xml): failed to open stream: HTTP wrapper does not support writeable connections. in /aaa/bbb/c/d/e/domainename/html/subdir/googlesitemap.php on line 203
Failed!
ERROR: Google Category Sitemap Generation FAILED!

---

Any idea's?

---

Only one idea - wrong setting for GOOGLE_SITEMAP_XML_FS_DIRECTORY. You myst set FILE SYSTEM directory! Not 'http://www.domain.com/subdir/', '/aaa/bbb/c/d/e/domainename/html/subdir/'.

Thanks Andrew,

That was the problem, changed the filepath to:
/home/content//html/catalog/ and it is now working.

Goshawk

Hi Andrew,
I added your files to my site, www.tot2teenonline.com . I have a link in the admin now, but when I click the link to create sitemap, I get a blank screen. In addition, Google doesn't seem to be picking up anything but my Home Page which was added priorto your files. Any thoughts as to how to fix the 'create sitemap' issues?

:lamo:

Hey Guys,

I am trying to load in the mod to the 1.3.7 and while try to generate the XML files steps, it throws the following error :

Quote:

---

Warning: main(includes/header.php) [function.main]: failed to open stream: No such file or directory in C:\domains.com\wwwroot\store\googlesitemap.php on line 84

Warning: main(includes/header.php) [function.main]: failed to open stream: No such file or directory in C:\domains.com\wwwroot\store\googlesitemap.php on line 84

Warning: main(includes/header.php) [function.main]: failed to open stream: No such file or directory in C:\domains.com\wwwroot\store\googlesitemap.php on line 84

Fatal error: main() [function.require]: Failed opening required 'includes/header.php' (include_path='.;c:\php4\pear') in C:\domains.com\wwwroot\store\googlesitemap.php on line 84

---

Any ideas?

I had the same issue and have fixed it. What I noticed was that when I opened the unzipped files there was a YOUR_ADMIN file which I uploaded to the appropriate location. That's when I got the errors. What I did not do was upload all the files that were not in that folder. Once I uploaded them to my public_html folder, all worked well. Good Luck!

I am getting the following error. Can any one help.

Warning: filesize() [function.filesize]: stat failed for sitemapezpages.xml in .\googlesitemap.php on line 218

Thanks

MG

The googlesitemap.php file in your main directory causes this warning when run and if you run it in your store administration you will come up with a blank page. This is because the page was set up using older versions of PHP. Pretty soon PHP will not support this function at all. If you get this warning..hehe...which you will:lookaroun...here is what to do.

THE WARNING:

Warning: Call-time pass-by-reference has been deprecated - argument

passed by value; If you would like to pass it by reference, modify the

declaration of fsockopen(). If you would like to enable call-time

pass-by-reference, you can set allow_call_time_pass_reference to true

in your INI file. However, future versions may not support this any

longer. in /your server/htdocs or whatever/folder or folders your PHP file is

in//the PHP file on line whatever

TO FIX THIS:

The & creates a call by reference so maybe try removing these to pass

by value.

EXAMPLE USING googlesitemap.php on line 398:

WAS:

$fsoc = fsockopen($url["host"], $url["port"], &$errno, &$errstr, 30);

SHOULD BE:

$fsoc = fsockopen($url["host"], $url["port"], $errno, $errstr, 30);

When I ran it through admin it now opens the page perfectly with no errors in the server fastcgi log. Hope this helps others.:smartalec:

hehe... May be help, but why you talk about it in this thread?
Google SitemapAdmin does not use fsockopen.

LOL, the code is from googlesitemap.php itself. Yes it DOES use fsockopen. Until I changed the code as stated above the create sitemap page that opens came up as a blank page. After the change the page opened fine showing stats on all the XML sitemaps.:blink:

AND there are no more warnings in the servers fastcgi log.
Using PHP 5.2.4
MySQL 5.0.45

Ok. Google SitemapAdmin from DL-area does not use fsockopen.
May be you talk about another script or use very old version.

You are correct A_Berizin! I am using what I thought was the last version but see that you have taken up the ball on it a renewed it! I will install your newest mod as I see it does more with the SE's now ect;. Veryyy sorry for the misunderstanding and yes it is older versions that use fsockopen. Glad you are using the newest PHP methods.
Best!:smartalec:

MOsr recent DL today: running for the first time, I get this

Fatal error: Call to undefined function: zen_get_info_page() in /home/my directories.........com/admin/googlesitemap.php on line 298

here is line 298:
$link = zen_href_link(zen_get_info_page($products->fields['products_id']), 'products_id=' . $products->fields['products_id'] . $product_url_add, 'NONSSL', false);

any idea why this is a fatal error?

Quote:

---

Originally Posted by Cliffrock

MOsr recent DL today: running for the first time, I get this

Fatal error: Call to undefined function: zen_get_info_page() in /home/my directories.........com/admin/googlesitemap.php on line 298

here is line 298:
$link = zen_href_link(zen_get_info_page($products->fields['products_id']), 'products_id=' . $products->fields['products_id'] . $product_url_add, 'NONSSL', false);

any idea why this is a fatal error?

---

I AM REINSTALLING IN THE MEANTIME..........

Quote:

---

Originally Posted by Cliffrock

MOsr recent DL today: running for the first time, I get this

Fatal error: Call to undefined function: zen_get_info_page() in /home/my directories.........com/admin/googlesitemap.php on line 298

here is line 298:
$link = zen_href_link(zen_get_info_page($products->fields['products_id']), 'products_id=' . $products->fields['products_id'] . $product_url_add, 'NONSSL', false);

any idea why this is a fatal error?

---

Quote:

---

Originally Posted by Cliffrock

I AM REINSTALLING IN THE MEANTIME..........

---

Got it. FIlezilla aint perfect. me neither. Thanks anyway.

Dear developer of this excellent mod,

Just wanna inform you that the included installation sql patch will delete configuration_key with configuration_group_id = 0

The effected keys are

PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX

Deletion of above keys will effect the proper functionality of Zen Cart.

Thanks!
Please execute this sql to restore deleted records:

Code:

---

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, now(), now(), NULL, NULL);

---

Andrew,

Was wondering if you might be able to give me some direction.

I am using your dynamic menu, but would like to style it like the menu here:

http://208.112.70>dot<145/

Pardon the >dot< but this is a testing site. I like this style a lot, and it will work better with my menu categories.

Sorry about the thread hijack... :)

-cj

Hello All..

I'm getting these strange errors when trying to upload my sitemap from the control panel. I have this mod installed in other stores and don't have a prob. Just this one store. Any help would be appreciated.

Here is what comes up when trying to submit...

Warning: file(): URL file-access is disabled in the server configuration in /home/content/a/v/a/avantageserv/html/googlesitemap.php on line 124

Warning: file(http://www.google.com/webmasters/sit...mapindex.xml): failed to open stream: no suitable wrapper could be found in /home/content/a/v/a/avantageserv/html/googlesitemap.php on line 124

Warning: implode(): Bad arguments. in /home/content/a/v/a/avantageserv/html/googlesitemap.php on line 124

URL file-access is disabled in the server configuration

I gathered it was something like that, but how do I correct that? I never had to do anything like that before.
Thanks for responding...
:unsure:

Nothing. You need to manually ping.

I found out that some providers block this function, but that you can edit your php.ini file from false to true for that setting and that helped. Thanks...

I would like to add Manufacturers pages to my sitemap, anyone have any idea how to do this.

Have installed this but when I go to admin>tools>google xml sitemap & click "Here" in step 1 I get a popup window saying:-

Not Found
The requested URL /404/ was not found on this server.

How do I fix this??? :mellow:

I installed the v137 sitemaps.
Installation fine....configuration default.
xml files are on root folder (/httpdocs) chmod to 777
When clicking for file generation i just see that message for ....ever
"Google Sitemap Generation (v 1.3.7 19.03.2007 19:14) started
Save path - "C:/Inetpub/vhosts/MYDOMAIN/httpdocs/eu"
Base URL - "http://www.MYDOMAIN/eu/"

NO ERRORS DISPLAYED
Files are blank and 0 KB

Windows server 2003
ZC 1.3.7
PHP Version: 4.4.7
MySQL 5.0.37


Any ideas?...as many other users have the same issue without a clear answer to that

Quote:

---

Originally Posted by StoryBook

Ok, I guess this will be a newbie question, but I've read everything I can find on this mod, and I can't find my answer...

I have v1.3.12 of this mod, and a pretty fresh install of Zen 1.3.7

The install instructions for the Sitemap mod reference, in step #2, a file called googleanalytics.sql. This file does not exist in the mod package.

Am I missing something???

StoryBook

---

I got the same question myself and I didn't see any answer?

Thanks,
Daniel

Quote:

---

Originally Posted by cozmic

I got the same question myself and I didn't see any answer?

Thanks,
Daniel

---

Hi Daniel,

The reference to Google Analytics in the install instructions is bogus. Just skip that step and all will be well.

Maybe someday someone will update the install info for this mod??? :huh:

Kevin

Quote:

---

Originally Posted by StoryBook

The reference to Google Analytics in the install instructions is bogus. Just skip that step and all will be well.

Maybe someday someone will update the install info for this mod??? :huh:

---

Why would you not do this?

But where do I find this file? It seems to work great even without applying it but I'm curios if I'm missing something here.

Thanks,
Daniel

About what file you talk?

I'm getting the following 500 error when I attempt to create the sitemap in Google XML Sitemap Admin:

Quote:

---

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.


Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

---

I searched this thread for this partucular error without success.

Any suggestions? Thanks

Well I tried it through the zencart/admin admin/tools/install_sql and used the last box to upload a file set the path for install SQL and it would not run gave me a 1064 error say there was a syntax problem? ANY thoughts Rich

Quote:

---

Originally Posted by a_berezin

About what file you talk?

---

I'm talking about googleanalytics.sql which is referred to in the readme.txt

/Daniel

Quote:

---

Originally Posted by pivey

I installed the v137 sitemaps.
Installation fine....configuration default.
xml files are on root folder (/httpdocs) chmod to 777
When clicking for file generation i just see that message for ....ever
"Google Sitemap Generation (v 1.3.7 19.03.2007 19:14) started
Save path - "C:/Inetpub/vhosts/MYDOMAIN/httpdocs/eu"
Base URL - "http://www.MYDOMAIN/eu/"

NO ERRORS DISPLAYED
Files are blank and 0 KB

Windows server 2003
ZC 1.3.7
PHP Version: 4.4.7
MySQL 4.1.22


Any ideas?...as many other users have the same issue without a clear answer to that

---

So...any suggestions?
I saw that other people have the same issue, but i did not find a solution to that (my?) bug

Quote:

---

Originally Posted by cozmic

I'm talking about googleanalytics.sql which is referred to in the readme.txt
/Daniel

---

Reread Kevin answer:

Quote:

---

Originally Posted by StoryBook

Hi Daniel,

The reference to Google Analytics in the install instructions is bogus. Just skip that step and all will be well.

Maybe someday someone will update the install info for this mod??? :huh:

Kevin

---

Quote:

---

Originally Posted by pivey

So...any suggestions?

---

No any suggestions - I don't know anything about Windows server 2003.

Well I got mine to run but its on Linux. I also have a windows server running and I will say to those folks that it really sounds like a permissions problem and thats why its hanging.

www.petestown.com

I also have it running on Linux.... I have a few stores. Sometimes they work and sometimes not. Regardless of 777.... still can't find rhyme nor reason... >shrug<

Permissions have been set proper, however i am not convinced that it is a OS related issue. Had no issues with the previous version of the mod.
The file generation start properly displaying the start, version & path the files will be generated.
It just stays there for ever.

Quote:

---

Originally Posted by pivey

So...any suggestions?
I saw that other people have the same issue, but i did not find a solution to that (my?) bug

---

What does your apache logs say?

Hi Andrew,

Thanks for this contribution. I've recently upgraded to the latest version, but am having an issue with the Base URL of my sitemaps.

The XML directory I'm using is webroot/feeds/ and the sitemaps are successfully generated here. However, the Base URL is set to http://www.mysite.co.uk and not http://www.mysite.co.uk/feeds/.

Do you know a work around for this?

Hi Andrew,

Thanks for your contribution. I downloaded v 1.3.14. Before installing, I would like to clarify few things:

In your readme.txt, you stated

Quote:

---

2. Go to Admin->Tools->Install SQL Patches and install install.sql.
Copying SQL code from googleanalytics.sql file (using a text editor) and paste into form in your shops
admin at Tools > Install SQL patches (copy & paste, don't upload!!!).
or
Copy install_googlesitemap.php to the admin directory, start it, select Install and press GO button.

---

1. Googleanalytics.sql is not included in your download. Where do I get this googleanalytics.sql?
2. You made install.sql fix in the version. I don't see the same fix in your install_googlesitemap.php. Am I missing something here?
3. You have update_1_3_14.sql in the directory. What is this for?

I would like to understand every single steps before I change my db.:cool:

Hi,

Has anyone tried this MOD with the new Zen Cart Ver. 1.3.8 yet?

If so does it work ....

Quote:

---

Originally Posted by Mr_B

Hi,

Has anyone tried this MOD with the new Zen Cart Ver. 1.3.8 yet?

If so does it work ....

---

Yes. It seems to work fine.

I've submitted my XML sitemaps to all 4 of the search engines (that this contribution will ping) and am now waiting to see what the result are.

Hi,
I have installed this mod all all seemed ok, I can generate the sitemaps and I went to google webmaster tools and submitted the product sitemap, again all ok. However, when I use the Ping service in admin, ni th epopup window it says:

Warning: file() [function.file]: URL file-access is disabled in the server configuration in /home/********/public_html/googlesitemap.php on line 124

Warning: implode() [function.implode]: Bad arguments. in /home/*********/public_html/googlesitemap.php on line 124

Another error also references line 130

Any ideas??
Thanks
Pete

Hi Everyone,

I've just installed this mod on a new store 1.3.7. I had to ammend the install.sql file because the tables have the prefix zen_.

I am able to configure google xml sitemap through configuration, but when I click google xml sitemap under TOOLS I get an Internal Server error. Any ideas what could be the problem?

Thanks
Matt

Should I worry about this remark, that appeared after running the sql:

ERROR: cannot insert configuration_key "" because it already exists
Note: 1 statements ingrored. See "upgrade exceptions" table for additional details.

It seems to work properly?

Quote:

---

Originally Posted by MeltDown

I'm getting the following 500 error when I attempt to create the sitemap in Google XML Sitemap Admin:



I searched this thread for this partucular error without success.

Any suggestions? Thanks

---

I've got the same problem. Anyone, anyone?

I have been looking at the code for this mod and see that external links are skipped.:yuck: On MY site I have zencart at the front. I also have a section of the site I call a reference site which is placed inside a folder inside htdocs. The pages there are all html pages and it is a large section of my website. Now the only way I can reference to this area is with ezpages creating a link in the IMPORTANT LINKS section. The reference area has its own index.html page which get people to all the other pages in that area. The problem is that I have to use an external link to get to it even though it is on the same server and in the same domain.:frusty: Converting these pages to ZC style pages would be a MAJOR job taking too much time. I can see in the code to this mod that it is probably not too large an undertaking to modify it to allow external links to be indexed in the ezpages.xml file so that search engines can find it. Already I have installed the ezpages_on_sitemap V1.01 mod which has put the external linked pages on the ZenCart sitemap. This shows that it CAN be done.:smartalec: Does anyone know what code to change to allow the external linked ezpages to be listed and what code to put in to do it? Many of us do not JUST have ZC on our sites and I am sure many are interested in this option.

Site maps are not that hard to make... would take longer to modify the code.

If your not using a 'robot.txt' file, then your losing the full effect of a site map. Of course not all bots follow what's in the file. You can tell the bots where your other folder is with in the robot text file. As for coding it into the mod, it wouldn't be to hard.

If your not sure how to use a robot text file, Google it.
This site below has a nice online tool for making one as well.

http://www.mcanerin.com/EN/search-engine/robots-txt.asp

My host GoDaddy no longer supports
file('http://www.google.com/webmasters/sitemaps/ping?sitemap=' . $google->submit_url));

This is a solution that works for me... for now at least... until I find a better solution... and some more dotdotdots... :smile:

I have this above "if ($submit){"

PHP Code:

---

function ExtractString($str, $start, $end) {
    $str_low = strtolower($str);
    $pos_start = strpos($str_low, $start);
    $pos_end = strpos($str_low, $end, ($pos_start + strlen($start)));
    if ( ($pos_start !== false) && ($pos_end !== false) ) {
        $pos1 = $pos_start + strlen($start);
        $pos2 = $pos_end - $pos1;
        return substr($str, $pos1, $pos2);
    }
} 


---

And this between the "Start Pinging..." and "End Pinging..."

PHP Code:

---

echo '<br />Start Pinging ----------------------------------------------------------------------------------------';
        if(isset($_GET['pinggoogle']) && $_GET['pinggoogle'] == 'yes') {
            echo '<br />Google Ping...<br />';
            echo '<div style="background-color: #FFFFCC; border: 1px solid #000000; padding: 5px">';
            /***************/
            $ch = curl_init("http://www.google.com/webmasters/sitemaps/ping?sitemap=". $google->submit_url);
            curl_setopt($ch, CURLOPT_HEADER, 0);
            curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
            $curl_results = curl_exec($ch);
            curl_close($ch);
            $bodytxt = ExtractString($curl_results, "<h2>", "</h2>");
            echo $bodytxt;
            /***************/
            echo '</div>';
        }
        if(isset($_GET['pingyahoo']) && $_GET['pingyahoo'] == 'yes') {
            echo '<br />Yahoo! Ping...<br />';
            echo '<div style="background-color: #FFFFCC; border: 1px solid #000000;">';
            /***************/
            $ch = curl_init("http://search.yahooapis.com/SiteExplorerService/V1/ping?sitemap=". $google->submit_url);
            curl_setopt($ch, CURLOPT_HEADER, 0);
            curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
            $curl_results = curl_exec($ch);
            curl_close($ch);
            $bodytxt = $curl_results;
            //$bodytxt = ExtractString($curl_results, "<Message>", "</Message>");
            echo $bodytxt;
            /***************/
            echo '</div>';
        }
        if(isset($_GET['pingask']) && $_GET['pingask'] == 'yes') {
            echo '<br />Ask.com Ping...<br />';
            echo '<div style="background-color: #FFFFCC; border: 1px solid #000000;">';
            /***************/
            $ch = curl_init("http://submissions.ask.com/ping?sitemap=". $google->submit_url);
            curl_setopt($ch, CURLOPT_HEADER, 0);
            curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
            $curl_results = curl_exec($ch);
            curl_close($ch);
            $bodytxt = ExtractString($curl_results, "<h1>", "</h1>");
            echo $bodytxt;
            /***************/
            echo '</div>';
        }
        if(isset($_GET['pingms']) && $_GET['pingms'] == 'yes') {
            echo '<br />Microsoft Ping...<br />';
            echo '<div style="background-color: #FFFFCC; border: 1px solid #000000;">';
            /***************/
            $ch = curl_init("http://www.moreover.com/ping?u=". $google->submit_url);
            curl_setopt($ch, CURLOPT_HEADER, 0);
            curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
            $curl_results = curl_exec($ch);
            curl_close($ch);
            $bodytxt = $curl_results;
            echo $bodytxt;
            /***************/
            echo '</div>';
        }
echo '<br />End Pinging ----------------------------------------------------------------------------------------<br />'; 


---

use at your own risk... I take no responsibility nor support any of the above code... blah blah blah... legaleze mumbo jumbo...

The mod worked fine until last week. I now receive the following error when I try to update the sitemap. I would sincerely appreciate any advice on how to fix this problem. I am not "code-savvy" so I do not know what the following error message means.

fopen(DIR_FS_CATALOG/sitemapcategories.xml) [function.fopen]: failed to open stream: No such file or directory in /home/wscheil/public_html/googlesitemap.php on line 240

Quote:

---

Originally Posted by willandjenny

The mod worked fine until last week. I now receive the following error when I try to update the sitemap. I would sincerely appreciate any advice on how to fix this problem. I am not "code-savvy" so I do not know what the following error message means.

fopen(DIR_FS_CATALOG/sitemapcategories.xml) [function.fopen]: failed to open stream: No such file or directory in /home/wscheil/public_html/googlesitemap.php on line 240

---

Check that the sitemap files exist in the correct area and that the proper permissions are applied to them.

Per the readme.txt file included with the mod "If error messages occur, change permissions on the XML files to 777" --> this can be done using an FTP program like FileZilla.

Quote:

---

Originally Posted by smb

Check that the sitemap files exist in the correct area and that the proper permissions are applied to them.

Per the readme.txt file included with the mod "If error messages occur, change permissions on the XML files to 777" --> this can be done using an FTP program like FileZilla.

---

Thank you very much for your help. I did not change the xml file permissions between when it worked and then quit working, but now that the permissions have been reset, the mod now works properly again. I truly appreciate your advice.

Sincerely,

William
:clap:

Greets!

I've installed the mod and all seems fine. BUT, when I click on the button to create the sitemap, the small window pops up but its just white.

I've changed all the the file permissions and and used absolute paths. I've seen many post on this in this thread, but did not find the solution to correct this problem.

I running on Linus, shared hosting, a martini and this is an addon domain.

Any suggestions?

Thanks,
Patrick

What are the best configuration settings to use? There isn't really info on what each stands for etc. Obviously i'd like to get all my products indexed but it just doesn't seem to be happening.

From the readme:

1. Unzip and upload all files to your store directory;
2. Go to Admin->Tools->Install SQL Patches and install install.sql.
Copying SQL code from googleanalytics.sql file (using a text editor) and paste into form in your shops
admin at Tools > Install SQL patches (copy & paste, don't upload!!!).
or
Copy install_googlesitemap.php to the admin directory, start it, select Install and press GO button.3. Go to Admin->Configuration->Google Sitemap Configuration and setup all parameters
4. Go to Admin->Tools>Google XML Sitemap (If error messages occur, change permissions on the XML files to 777);

Confused about what the heck the bolded text is trying to say. Are those optional?

-I completed step one and verified.
-I ran the install.sql in the Admin, it says 8 statements processed and gives a huge list of results.
- I skipped the rest of #2 (the bolded) because it's not clear to me what to do
- I go to #3 and don't change anything
- Set the file permissions to 777 for the four .xml files
- I attempt #4, but get a 298 error:

Call to undefined function: zen_get_info_page() in ...catalog/admin/googlesitemap.php

I do have google analytics installed and working but I'm not sure what that code is for, and how do I "start" the install_googlesitemap.php ?

Help??

What zen-cart version?

1.3.8, I had to roll back to that version so I could use the safebuy mod

1.3.7 (not sure who you were asking :))

Anyone help here?

Oh, and also I didn't run any of the updates in that folder because they weren't documented, do I need to run one of those?

Quote:

---

Originally Posted by Bahnstoermer

Call to undefined function: zen_get_info_page() in ...catalog/admin/googlesitemap.php

---

improperly installed - incorrectly upload files

Really? I guess that sounds viable, I thought I checked and rechecked, but I will do so again.

You mean the manually installed files on my server, not anything from the script right?