Use last version
Printable View
Use last version
I'm using the latest version. I went and added it in by hand. Tried several times to get an auto-generation of the sitemapezpages.xml, but still no luck.Quote:
Originally Posted by CnA
Test one more your version!Quote:
Originally Posted by a_berezin
I forgot to thank you Andrew for adding gss.xsl to your package. Makes it easy to view/sort the generated xml files.
Upgraded to the latest version of Google Sitemap Generation v 1.3.6a 03.03.2007 (latest version dated 03-21-07).
I have set in Config > Google XML Sitemap
XML Directory = /home/my_account/public_html
I observe success when creating all four sitemap files (all four files in webroot directory and chmod 777).
However when I view the contents of each xml file I see all my data correctly in the products, categories and ez-pages xml files. But when viewing sitemapindex.xml it does not contain data (just XML header info).
When generating feed update I observe:
Google Sitemap Generation v 1.3.6a 03.03.2007 10:55 started
Save path - "/home/your_account/public_html/"
Base URL - "http://www.yourdomain.com/"
(besides the other three correctly processed xml files I also see...)
Processing file: /home/your_account/public_html/sitemapindex.xml OK! Written 345 bytes
Generated Google Sitemap Index Successfully - http://www.yourdomain.com/sitemapindex.xml
* Note that before "updating" the sitemapindex.xml feed file it was originally 0 bytes. Then after I generated feed update the file increasesd to 345 bytes (as previously stated containing XML header info only but no data).
However the xml file should contain data similar to:
<sitemap>
<loc>http://www.yourdomain.com/sitemapcategories.xml</loc>
<lastmod>2007-03-18</lastmod>
</sitemap>
<sitemap>
<loc>http://www.yourdomain.com/sitemapproducts.xml</loc>
<lastmod>2007-03-18</lastmod>
</sitemap>
<sitemap>
<loc>http://www.yourdomain.com/sitemapcategories.xml</loc>
<lastmod>2007-03-18</lastmod>
</sitemap>
Any ideas what's happening? The mod used to work properly (updating sitemapindex.xml) but not since after upgrading to the most current mod version. Thanks for any ideas.
Woody
1146 Table 'mistywat_zc1.configuration_group' doesn't exist
in:
[SELECT @configuration_group_id:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'Google XML Sitemap' LIMIT 1;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I get this error when I try to install the .sql
Any suggestions?
Try this sql code:
Code:SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Google XML Sitemap' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Google XML Sitemap', 'Google XML Sitemap Configuration', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
(NULL, 'Compress XML File', 'GOOGLE_SITEMAP_COMPRESS', 'false', 'Compress Google XML Sitemap file', @configuration_group_id, 1, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Products changefreq', 'GOOGLE_SITEMAP_PROD_CHANGE_FREQ', 'weekly', 'How frequently the Product pages page is likely to change.', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'always\', \'hourly\', \'daily\', \'weekly\', \'monthly\', \'yearly\', \'never\'),'),
(NULL, 'Category changefreq', 'GOOGLE_SITEMAP_CAT_CHANGE_FREQ', 'weekly', 'How frequently the Category pages page is likely to change.', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array(\'always\', \'hourly\', \'daily\', \'weekly\', \'monthly\', \'yearly\', \'never\'),'),
(NULL, 'Lastmod tag format', 'GOOGLE_SITEMAP_LASTMOD_FORMAT', 'date', 'Lastmod tag format:<br />date - Complete date: YYYY-MM-DD (eg 1997-07-16)<br />full - Complete date plus hours, minutes and seconds: YYYY-MM-DDThh:mm:ssTZD (eg 1997-07-16T19:20:30+01:00)', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array(\'date\', \'full\'),'),
(NULL, 'Category priority', 'GOOGLE_SITEMAP_CAT_CHANGE_PRIOR', '0.5', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 3, NOW(), NULL, NULL),
(NULL, 'Products priority', 'GOOGLE_SITEMAP_PROD_CHANGE_PRIOR', '0', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 5, NOW(), NULL, NULL),
(NULL, 'Use Google Sitemaps Stylesheet', 'GOOGLE_SITEMAP_USE_XSL', 'true', 'Google Sitemaps Stylesheet gss.xsl', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'XML directory', 'GOOGLE_SITEMAP_XML_FS_DIRECTORY', '', 'Directory using for saving XML files. Setting it to your root directory. If empty, Google Sitemap use DIR_FS_CATALOG directory.', @configuration_group_id, 7, NOW(), NULL, NULL),
(NULL, 'EZPages Header', 'GOOGLE_SITEMAP_EZPAGES_HEADER', 'true', 'Use EZPages Header links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'EZPages Sidebox', 'GOOGLE_SITEMAP_EZPAGES_SIDEBOX', 'true', 'Use EZPages Sidebox links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'EZPages Footer', 'GOOGLE_SITEMAP_EZPAGES_FOOTER', 'true', 'Use EZPages Footer links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'EZPages changefreq', 'GOOGLE_SITEMAP_EZPAGES_CHANGE_FREQ', 'weekly', 'How frequently the EZPages pages page is likely to change.', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array(\'always\', \'hourly\', \'daily\', \'weekly\', \'monthly\', \'yearly\', \'never\'),'),
(NULL, 'EZPages priority', 'GOOGLE_SITEMAP_EZPAGES_CHANGE_PRIOR', '0.5', 'The default priority of the EZPages URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 3, NOW(), NULL, NULL);
Woody!
I can't understand what was happing.:no:
Woody!
Check up, the function dir is accessible to you.
Anyone else employ the latest GoogleSitemapAdmin mod on Zen Cart 1.37 and observe an incorrectly generated sitemapindex.xml ???
This has my head spinning too.
Maybe an issue with writing to the webroot path. Will change path back to generate xml files in shoproot and see if that makes any diff.
Woody
Yep. I confirmed that on my system the latest version of mod has problem generating correct sitemapindex.xml file when the path (in Config > Google XML Sitemap) is set to the webroot (/home/account/public_html/). But sitemapindex.xml is correctly generated when path points to the the shoproot.
(this does not matter for the other three xml files).
Does not Google want the sitemap xml files to be in the webroot (public_html)?
The moral of this story is to manually view and check your xml sitemap file content immediately after generating, otherwise you won't know is what might be missing.
Just an idea. Would be useful if the pop-up window, reporting successful xml file generation/update, could also display count of products, categories, or ez-pages processed. Or in case of the sitemap index, include count of xml files processed and written into the sitemapindex.xml file.
This would provide a general heads-up if anything might be wrong. Just an idea.
Thanks again Andrew.
Woody
OK!Quote:
Originally Posted by Woodymon
v 1.3.7 19.03.2007 19:14
1. Add records count statistic
WOW! That was quick! Thanks Andrew.Quote:
Originally Posted by a_berezin
Those count numbers are helpful.
And after installing new version sitemapindex.xml is once again correctly generated in /public_html/
Its like magic! :wink2:
Woody
I added the sql you suggested and it worked like magic until I tried to view my products and got this error.
XML Parsing Error: not well-formed
Location: http://annsceramics.com/sitemapproducts.xml
Line Number 5672, Column 33: <loc>http://annsceramics.com/8-frame-p-827.html</loc>
--------------------------------^
Any suggestions?
Nevermind...I'm a ditz. Just corrected the product name and everything went smoothly. Thank you so much for this:)
Quote:
Originally Posted by Peaches
Hi folks.... having trouble here. Any help appreciated. Unlike the other fellow, install went fine. But when I try generate a sitemap, here is the outcome...
Google Sitemap Generation (v 1.3.7 19.03.2007 19:14) started
Save path - "http://www.ironbikeworx.com/zc/gsm/"
Base URL - "http://www.ironbikeworx.com/"
Processing file: http://www.ironbikeworx.com/zc/gsm/sitemapproducts.xml
Warning: fopen(http://www.ironbikeworx.com/zc/gsm/sitemapproducts.xml) [function.fopen]: failed to open stream: HTTP wrapper does not support writeable connections. in /home/ironbikeworx/www/www/zc/googlesitemap.php on line 161
Failed!
ERROR: Google Product Sitemap Generation FAILED!
Processing file: http://www.ironbikeworx.com/zc/gsm/s...categories.xml
Warning: fopen(http://www.ironbikeworx.com/zc/gsm/s...categories.xml) [function.fopen]: failed to open stream: HTTP wrapper does not support writeable connections. in /home/ironbikeworx/www/www/zc/googlesitemap.php on line 161
Failed!
ERROR: Google Category Sitemap Generation FAILED!
Processing file: http://www.ironbikeworx.com/zc/gsm/sitemapezpages.xml
Warning: fopen(http://www.ironbikeworx.com/zc/gsm/sitemapezpages.xml) [function.fopen]: failed to open stream: HTTP wrapper does not support writeable connections. in /home/ironbikeworx/www/www/zc/googlesitemap.php on line 161
Failed!
ERROR: Google Category Sitemap Generation FAILED!
Processing file: http://www.ironbikeworx.com/zc/gsm/sitemapindex.xml
Warning: fopen(http://www.ironbikeworx.com/zc/gsm/sitemapindex.xml) [function.fopen]: failed to open stream: HTTP wrapper does not support writeable connections. in /home/ironbikeworx/www/www/zc/googlesitemap.php on line 161
Failed!
ERROR: Google Sitemap Index Generation FAILED!
Total Execution Time 0:0.0225
Do each of these four files already exist in your /zc/gsm/ directory?Quote:
Originally Posted by bhunted
And does each have write permissions enabled? (cmod777)
Woody
Directory using for saving XML files. Setting it to your root directory. If empty, Google Sitemap use DIR_FS_CATALOG directory.Quote:
Originally Posted by bhunted
I think it is necessary to refuse this parameter.
To follow-up on Andrew's post above, if you want to store the mod's XML files in your webroot directory (that;s where I have mine) you may want to try setting in admin (Config >Google XML Sitemap):
XML directory /home/your_account/public_html/
(replace your_account above with your account name on your server. See your Zen Cart configure.php file for the correct path.)
Woody
Hi gang and thanks for responding. What I ended up doing was just leaving it blank and all went to the root. Go figure. Again, many thanks for your help...
:clap:
Andrew-
When you state the mod defaults to writing the "root", do you mean the account root, or the web root, or the shop root?
Woody
In my case, it was the store root...
Why is my ezpages not being generated for google.
Google Sitemap Generation (v 1.3.7 19.03.2007 19:14) started
Save path - "/usr/local/4admin/apache/vhosts/haredo.com/httpdocs/"
Base URL - "http://www.haredo.com/"
Processing file: /usr/local/4admin/apache/vhosts/haredo.com/httpdocs/sitemapproducts.xml OK! Written 225 records, 44411 bytes
Generated Google Product Sitemap Successfully - http://www.haredo.com/sitemapproducts.xml
Processing file: /usr/local/4admin/apache/vhosts/haredo.com/httpdocs/sitemapcategories.xml OK! Written 20 records, 3984 bytes
Generated Google Category Sitemap Successfully - http://www.haredo.com/sitemapcategories.xml
Processing file: /usr/local/4admin/apache/vhosts/haredo.com/httpdocs/sitemapezpages.xml OK! Written 0 records, 0 bytes
Generated Google EZPages Sitemap Successfully - http://www.haredo.com/sitemapezpages.xml
Processing file: /usr/local/4admin/apache/vhosts/haredo.com/httpdocs/sitemapindex.xml OK! Written 2 records, 567 bytes
Generated Google Sitemap Index Successfully - http://www.haredo.com/sitemapindex.xml
If you have not already submitted the sitemap index to Google click this link Google Ping
Total Execution Time 0:0.131
http://www.haredo.com
What ez-pages you have?
18 of them,Quote:
Originally Posted by a_berezin
they are set up as a jclicker.
Meaning a slide show, step by step process to view my hair accessory styles.
At them external or internal link URL?
External Link URL:Quote:
Originally Posted by a_berezin
includes/templates/haredo/ezpages/bunwithrelease/index.html
Quote:
Originally Posted by haredo
It is the answer
Thank you for the answer.
So a External Link does not intergrate with the google sitemap.
Certainly. What relation the external links can have to a site map?
v 1.3.8 28.04.2007 17:14
1. Support new sitemaps.org namespace 0.9.
Andrew..thanks so much...
Marco from Italy
Where i can download?Quote:
Originally Posted by a_berezin
Does version Google Sitemap Admin 1.3.8 work ok with Zen-cart 1.2.6? I was able to install it ok and run it, but I get an error that there are no tables. My site of course does not have ezpages either. What should I do about ezpages? It doesn't show the get to the PING google part from the pop-up window. But I can click the ping link within the store's google admin section just fine.
Google's webmaster tools is saying that the sitemapproducts.xml file is ok and the sitemapcategores.xml file is ok too.
I did install it successfully on 4 of my other 12 zen-cart sites. I have many that are still 1.2.6. Most of my sites are still zen-cart 1.3.5 however.
Not sure if I missed a post with a fix for the problem where no entires are created in sitemapindex.xml, but I was able to fix it with a mod to googlesitemap.php. The zen site is setup in a sub-directory, which seems to be the problem. Again, not sure if this is something that has been fixed, but here is a patch that worked for me, note that I did not test this with a site that puts the zen cart site in the root of the website, so this may cause unwanted behavior for those sites and this should only be tried on a site that is located in a sub-directory.
--------------
$fsfilename = rtrim($this->savepath, '/') . '/' . $filename;
echo 'Looking for: ' . $filename . " in : " . $fsfilename . "<br />";
if (!filesize($fsfilename)) continue;
$content .= ' <sitemap>' . "\n";
$content .= ' <loc>' . $this->base_url . basename($filename) . '</loc>' . "\n";
$content .= ' <lastmod>' . $this->LastMod(filemtime($fsfilename)) . '</lastmod>' . "\n";
$content .= ' </sitemap>' . "\n";
$records_count++;
-------------
http://www.zen-cart.com/index.php?ma...roducts_id=544Quote:
Originally Posted by kimsonvu
-or-
http://zen-cart.spb.ru/index.php?mai...=contributions
Please bookmark.
If you don't have ezpages, why you want to build sitemap for them?Quote:
Originally Posted by dlaitila
some one can solve the bug on indexing ezpages???
Thanks
Marco
I have been trying to install google site map. I was able to sucessefully install it on another site on the same server. It functions fine on that site. The site im having problems with it doesn't show up under tools.
I looked at the sql database on the site that works. Its listed under the "configuration_group_title". It doesn't appear there on the site thats not functioning correctly. I tried to manually creat it, don't know if i did it correct, but I was able to get it in the sql database. It still doesn't show up under tools. I have even reloaded all files! Using 1.3.7- Can someone help me?
Thank You
What a bug????Quote:
Originally Posted by monak83
First , do not give out URL's to your administrative areas including phpmyadmin!Quote:
Originally Posted by garyclemens
Second, what errors are you observing when you installed the SQL patch?
Did you have previous version installed before installing new version?
Try patch uninstall.sql.
Then install.sql
Avoid "uploading" in Tools > Install SQL Patches.
Instead paste in the SQL.
Report any errors, obfuscating private data (including admin directory name).
Woody
After you update the site map admin>tools>Google XML sitemap and notice the 4 files in the root directory have updated.
What is the process to view the sitemap index to see what google has indexed?
Log into your Google Webmasters account.Quote:
Originally Posted by haredo
In Zen Cart admin > Tools > Google XML Sitemap
Andrew provided a nice blue box with a link to do just that ;-)
Woody
Woody,
Yes, I went to google, but I would like to look at the sitemap google generated.
Can i view the files on the sitemapindex???
www.haredo.com/sitemapindex.xml
Woody, thank you for the advice.Quote:
Originally Posted by haredo
Went through my notes and I upated to 1.3.8 yesterday
There might be a small bug so I reinstalled 1.3.7 and now I can view products and categories to notice changes.
v 1.3.9 02.05.2007 4:57
1. gss.xls - Support new sitemaps.org namespace 0.9.
2. Remove duplicated links.
Google doee not generate the sitemap. You do. That is, this is what the mod does ;-)Quote:
Originally Posted by haredo
You can view the sitemap files you generate and store on YOUR server, as any other text type file, via a text editor. or via an an XML viewer, or in your browser.
Currently you have generated three sitemap files.
1. http://www.haredo.com/sitemapindex.xml
2. http://www.haredo.com/sitemapcategories.xml
3. http://www.haredo.com/sitemapproducts.xml
The index file just points to the other two, where your products and category pages are indexed.
Since Andrew included "Google Sitemaps Stylesheets" into the mod, you should be able to directly view those files in your browser.
Hope this helps,
Woody
Just installed this mod and it's working great. Just wondering why I can't find the default static html files like shipping info and privacy pages anywhere in the generated xml files.
Should I add these manually (seperate xml file?) or is there no need to include these in the Google sitemap? I just think it's strange since the ez-pages are included. Did I miss something?
Another question.
Found out that there was an update (1.3.8) while I installed 1.3.7. Decided to upgrade by overwriting the 'old' files with the new. Couldn't find any differences in the new sql code so I didn't reinstall the sql part.
Files are generated fine but somehow the xml files show up empty when opened in a browser. Tried several browsers, clear caches and even restarted but the xml files remain blank when opened in a browser. When opened using ftp and a texteditor there's no problem, everything looks fine.
I'm sure the browser displayed fine under 1.3.7. Could this be a minor hick up in a stylesheet somewhere?
All this links to static pages I defined in EZ-pages and use only EZ-pages box (don't use Information box). It's more flexybility. So, I don't need to build sitemap for old static pages.Quote:
Originally Posted by davale
Yes, you can manually add a seperate xml file.Quote:
Originally Posted by davale
Ok apparently I need to shoot the seeing eye dog because neither of us could find this problem or figure it out even after reading all 35 pages of this thread. Everything installed right (the third time anyway) and it SEEMS that everything worked right right up until I go to create the sitemap and I get this error:
Google Sitemap Generation (v 1.3.9 02.05.2007 4:57) started
Save path - "/www/htdocs/"
Base URL - "http://www.got-its.com/"
Processing file: /www/htdocs/sitemapproducts.xml OK! Written 319 records, 65755 bytes
Generated Google Product Sitemap Successfully - http://www.got-its.com/sitemapproducts.xml
Processing file: /www/htdocs/sitemapcategories.xml OK! Written 30 records, 6212 bytes
Generated Google Category Sitemap Successfully - http://www.got-its.com/sitemapcategories.xml
Processing file: /www/htdocs/sitemapezpages.xml OK! Written 3 records, 844 bytes
Generated Google EZPages Sitemap Successfully - http://www.got-its.com/sitemapezpages.xml
Warning: filesize(): Stat failed for sitemapezpages.xml (errno=2 - No such file or directory) in /usr/local/etc/httpd/htdocs/zencart/googlesitemap.php on line 220
Warning: filesize(): Stat failed for sitemapcategories.xml (errno=2 - No such file or directory) in /usr/local/etc/httpd/htdocs/zencart/googlesitemap.php on line 220
Warning: filesize(): Stat failed for sitemapproducts.xml (errno=2 - No such file or directory) in /usr/local/etc/httpd/htdocs/zencart/googlesitemap.php on line 220
Processing file: /www/htdocs/sitemapindex.xml OK! Written 0 records, 372 bytes
Generated Google Sitemap Index Successfully - http://www.got-its.com/sitemapindex.xml
If you have not already submitted the sitemap index to Google click this link Google Ping
Total Execution Time 0:0.8737
It appears that everything but the sitemapindex file created correctly, just to make sure I opened it up and this is all it had in there:
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="gss.xsl"?>
<sitemapindex xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9
http://www.sitemaps.org/schemas/site.../siteindex.xsd"
xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
</sitemapindex>
The other three files have what appears to be the correct info in them so it has to be just a little glitch somewhere.
I am using GoogleSitemap ver 1.3.9 and ZC ver 1.3.7
Will be fixed in the following version.
v 1.3.10 18.05.2007 12:12
1. Add ez-pages multilanguage support;
2. Fixed filesize error.
Andrew, you are the man. You spit out versions faster than a vegetarian cat in a bird shop lol.
You Rock Andrew, worked like a charm. Thanks
Hey guys i am getting this error message when i try and set it up.
Heres my setupQuote:
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 /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php on line 412
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 /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php on line 412
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php:412) in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/includes/functions/sessions.php on line 108
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php:412) in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/includes/functions/sessions.php on line 108
Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php:412) in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/includes/init_includes/init_templates.php on line 78
Google Sitemap Generation (v 1.3.10 18.05.2007 12:12) started
Save path - "/var/www/vhosts/mrhumbucker.co.nz/httpdocs/"
Base URL - "http://www.mrhumbucker.co.nz/"
Warning: strtotime() [function.strtotime]: Called with an empty time parameter. in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php on line 263
Warning: strtotime() [function.strtotime]: Called with an empty time parameter. in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php on line 263
Warning: strtotime() [function.strtotime]: Called with an empty time parameter. in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php on line 263
Warning: strtotime() [function.strtotime]: Called with an empty time parameter. in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php on line 263
Processing file: /var/www/vhosts/mrhumbucker.co.nz/httpdocs/sitemapproducts.xml OK! Written 1431 records, 291196 bytes
Generated Google Product Sitemap Successfully - http://www.mrhumbucker.co.nz/sitemapproducts.xml
Warning: strtotime() [function.strtotime]: Called with an empty time parameter. in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php on line 287
Processing file: /var/www/vhosts/mrhumbucker.co.nz/httpdocs/sitemapcategories.xml OK! Written 136 records, 26878 bytes
Generated Google Category Sitemap Successfully - http://www.mrhumbucker.co.nz/sitemapcategories.xml
ERROR: Google Category Sitemap Generation FAILED!
Processing file: /var/www/vhosts/mrhumbucker.co.nz/httpdocs/sitemapindex.xml OK! Written 2 records, 608 bytes
Generated Google Sitemap Index Successfully - http://www.mrhumbucker.co.nz/sitemapindex.xml
Total Execution Time 0:1.2570
Database: MySQL 5.0.27 PHP Version: 5.0.4 (Zend: 2.0.4-dev)
HTTP Server: Apache/2.0.52 (CentOS)
Zen Cart v1.3.7
Cheers
O! Yes, forgotten about it :blush:
Fixed
v 1.3.11 19.05.2007 2:52
1. Remove non used functions.
Privet Andrey
One problem
Only one xml generated for me : sitemapproducts.xml
All other hase size 0 Kb. they empty...
and popup window where I see
Google Sitemap Generation (v 1.3.11 19.05.2007 2:52) started
Processing file: /shop/sitemapproducts.xml OK! Written 564 records, 109216 bytes
Generated Google Product Sitemap Successfully - http://shop.skyhorse.cz/sitemapproducts.xml
1054 Unknown column 'c.parent_id' in 'on clause'
in:
[SELECT c.categories_id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM categories c, categories_description cd LEFT JOIN categories_description cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='2' WHERE c.categories_id='452' AND cd.categories_id='452' AND cd.language_id='2' LIMIT 1]
Im use SEO mode... and meibe something wrong...but I need SEO
please help
Im sorry - cant edit my post
Im use MySQL 5 and Ultimate_SEO_URLs_v2.103 hase some error for working with vs 5
Here is solutions
file seo.url.php
code
$sql = "SELECT c.categories_id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName
FROM ".TABLE_CATEGORIES." c,
".TABLE_CATEGORIES_DESCRIPTION." cd
must be
$sql = "SELECT c.categories_id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName
FROM (".TABLE_CATEGORIES." c,
".TABLE_CATEGORIES_DESCRIPTION." cd)
information from here
http://www.zencart.cz/modules/newbb/...#forumpost6922
Privet maxus!
It not my error. Probably it is an error from seo module. I don't use this SEO modules.
When I goto create the file this is what I'm getting
Google Sitemap Generation (v 1.3.11 19.05.2007 2:52) started
Save path - "/home/wccomput/public_html/"
Base URL - "http://wccomputers.sashbox.net/"
Processing file: /home/wccomput/public_html/sitemapproducts.xml OK! Written 1700 records, 349474 bytes
Generated Google Product Sitemap Successfully - http://wccomputers.sashbox.net/sitemapproducts.xml
Fatal error: Maximum execution time of 30 seconds exceeded in /home/wccomput/public_html/googlesitemap.php on line 347
Anyone have any ideas whats wrong? I've followed all the instructions.
Thanks
Hi,
Just wondering, how long does this sitemap generation usually take?
This is my first time using this.
So far, this is all I get:
----------------------------------------------------------------------------------
Google Sitemap Generation (v 1.3.11 19.05.2007 2:52) started
Save path - "/var/www/html/"
Base URL - "http://www.alphalion.com/"
----------------------------------------------------------------------------------
It's been a good 30 minutes or so.
I have about 3500 products.
Thanks
OK,
This mod isn't working on that site (see previous post).
However, I installed it on a sub-domain and it is working fine there.
I get no error message or any other indication of a problem, other than the fact that no sitemaps are generated, on my primary domain.
Any help with this would be appreciated.
Thanks
I have Google site map gernerator contribution installed in several of my stores. They all work great, except one store that I have located in a 2nd level directory. (www.mydomain/store).
i tried different methods to trick google to work with the generated sitmapindex.xml. Nothing succeeded.
Has anyone else encoutered this? Any input?
Thank you,
Sam
When trying to install this mod i get this error:
who can help?Quote:
1064 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 'true', 'false'),'), (NULL, 'Products changefreq', 'GOOGLE_SITEMAP_PROD_CHANGE_FR' at line 1
in:
[INSERT INTO zenconfiguration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Compress XML File', 'GOOGLE_SITEMAP_COMPRESS', 'false', 'Compress Google XML Sitemap file', @configuration_group_id, 1, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Products changefreq', 'GOOGLE_SITEMAP_PROD_CHANGE_FREQ', 'weekly', 'How frequently the Product pages page is likely to change.', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array('always', 'hourly', 'daily', 'weekly', 'monthly', 'yearly', 'never'),'), (NULL, 'Category changefreq', 'GOOGLE_SITEMAP_CAT_CHANGE_FREQ', 'weekly', 'How frequently the Category pages page is likely to change.', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array('always', 'hourly', 'daily', 'weekly', 'monthly', 'yearly', 'never'),'), (NULL, 'Lastmod tag format', 'GOOGLE_SITEMAP_LASTMOD_FORMAT', 'date', 'Lastmod tag format:
date - Complete date: YYYY-MM-DD (eg 1997-07-16)
full - Complete date plus hours, minutes and seconds: YYYY-MM-DDThh:mm:ssTZD (eg 1997-07-16T19:20:30+01:00)', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array('date', 'full'),'), (NULL, 'Category priority', 'GOOGLE_SITEMAP_CAT_CHANGE_PRIOR', '0.5', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 3, NOW(), NULL, NULL), (NULL, 'Products priority', 'GOOGLE_SITEMAP_PROD_CHANGE_PRIOR', '0', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 5, NOW(), NULL, NULL), (NULL, 'Use Google Sitemaps Stylesheet', 'GOOGLE_SITEMAP_USE_XSL', 'true', 'Google Sitemaps Stylesheet gss.xsl', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'XML directory', 'GOOGLE_SITEMAP_XML_FS_DIRECTORY', '', 'Directory using for saving XML files. Setting it to your root directory. If empty, Google Sitemap use DIR_FS_CATALOG directory.', @configuration_group_id, 7, NOW(), NULL, NULL), (NULL, 'EZPages Header', 'GOOGLE_SITEMAP_EZPAGES_HEADER', 'true', 'Use EZPages Header links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'EZPages Sidebox', 'GOOGLE_SITEMAP_EZPAGES_SIDEBOX', 'true', 'Use EZPages Sidebox links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'EZPages Footer', 'GOOGLE_SITEMAP_EZPAGES_FOOTER', 'true', 'Use EZPages Footer links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'EZPages changefreq', 'GOOGLE_SITEMAP_EZPAGES_CHANGE_FREQ', 'weekly', 'How frequently the EZPages pages page is likely to change.', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array('always', 'hourly', 'daily', 'weekly', 'monthly', 'yearly', 'never'),'), (NULL, 'EZPages priority', 'GOOGLE_SITEMAP_EZPAGES_CHANGE_PRIOR', '0.5', 'The default priority of the EZPages URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 3, NOW(), NULL, NULL);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Where might I find the latest version and it is compatible with 1.3.7?
Quote:
Originally Posted by enderandrew
http://www.zen-cart.com/index.php?ma...roducts_id=544
Thank you for a great contribution.
I downloaded the latest version from
http://www.zen-cart.com/index.php?ma...roducts_id=544
I almost got it working for me (google gave me sitemap status OK). I used install_googlesitemap.php to install. However I still have the following issues.
1. I can see Admin->Configuration->Google XML Sitemap but I cannot
see Admin->Tools->Google however I am able to generate sitemap files by
typing www.mysite.com\googlesitemap.php in the browser.
2. I changed permissions to 777 for sitemap*.xml files but when I click
on the link after the sitemap files have been generated i get:
"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.
The system cannot locate the object specified."
3. From security perspective is it safe to leave googlesitemap.php in the URL that anyone can execute from the browser?
4. Can i use the same sitemap files and load them into Yahoo, MSN etc.?
Your suggestions are appreciated.
There is no admin > Tools > Google! It'sQuote:
Originally Posted by ericny
Admin->Tools->Google XML Sitemap
Well, that's because you're not supposed to see it! It's not for human eyes - you need to go to http://www.google.com/webmasters/tools/sitemaps as per the instructions, and make the account and verify your site.Quote:
Originally Posted by ericny
Don't see why not - all it does is generate the map. The worst that could happen is that if you have a HUGE store and someone kept clicking it, it might put the server under a bit of load. But then they could do that by clicking "all products" a lot, too!Quote:
Originally Posted by ericny
Forget about MSN, it accounts for <3% of anything. As for Yahoo, I thought it only understood urllist.txt lists, however it seems that it is now supports xml sitemaps.Quote:
Originally Posted by ericny
I was able to get it to work and submit to Google.
Thank you everyone.
It looks like yahoo now understands sitemap.xml. It can be submitted at the following link
[FONT=Helv]https://siteexplorer.search.yahoo.com/submit
[/FONT]
Check up presence of a file gss.xsl in root directory.Quote:
Originally Posted by ericny
Again speak that itself do not know. Specially for human eyes the table of styles gss.xsl was added.Quote:
Originally Posted by kelvyn
Yes. I already spoke about it almost year back. See http://www.zen-cart.com/forum/showpo...&postcount=137Quote:
Originally Posted by ericny
Ok, I add link to the Yahoo! Ping service. Wait when will be updated download area.Quote:
Originally Posted by ericny
I do not have gss.xsl in my root directory. Where can I get one? What is it supposed to contain?Quote:
Originally Posted by a_berezin
If it is a generic file can someone e-mail it to me please?
gss.xsl is a part of Google SitemapAdmin contribution.
WORKS! Thank you :)Quote:
Originally Posted by a_berezin
v. 1.3.12 21.06.2007
1. Add links to Yahoo!.
Thanks for the update. The Udate SQL is generating the following error:Quote:
Originally Posted by a_berezin
MySQL said:
#1064 - 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 '' at line 8
Sorry. Don't use update_1_3_12.sql patch!!!! :blush:
Andrew, thanks for the response. Which file is generated for Yahoo site explorer? Currently I am using a urllist.txt that I manually create from your google froogle mod but I'd like the option to automate the generation of Yahoo site explorer. Can you please give some info on how this is suppose to work with Yahoo site explorer?Quote:
Originally Posted by a_berezin
Thanks!
Yahoo SiteExplorer uses exactly the same files as Google - it's all standardised. You don't need urllist.txt any moreQuote:
Originally Posted by BlessIsaacola
See this blog entry for details
Thanks Kelvyn! So do I replace my urllist.txt with sitemapindex.xml?Quote:
Originally Posted by kelvyn
I'd suggest following that blog post, becuase what you need to do is see how to put the sitemapindex into robots.txt for a start, and also you'll need to make a login for Yahoo so you can add and track how your site is being spidered - pretty much the same as Google Webmasters does.Quote:
Originally Posted by BlessIsaacola
Actually, I already have the information for Google, Yahoo and MSN in my robot.txt.Quote:
Originally Posted by kelvyn
Google Sitemap requires an index sitemap to use to identify the list and Yahoo explorer also requires a file if you're using site explorer. I was basically asking a simple question of which file to put in accounts I have been using with Yahoo for months.
Google is smart enough to read my sitemapindex.xml and go from there to grab the category, product and ezpages xml file. I am not sure how Yahoo Explorer works which is why I was asking.
The robot.txt instruction is different from how Yahoo Site Explorer and Google Sitemap works. Although, both methods are after the same information, it never hurts to give different ways for search engine to find information.
Then if your robots.txt looks something like this, and you have a site AND feed setup, authenticated and listed here, then all is good!Quote:
Originally Posted by BlessIsaacola
Code:User-agent: *
Disallow: /catalog/
Disallow: /advanced_search.html
Disallow: /checkout_shipping.html
Disallow: /login.html
Disallow: /order/
Disallow: /shopping_cart.html
Disallow: /tell_a_friend/
Disallow: /unsubscribe.html
Disallow: /write_review/
SITEMAP: http://www.mystore.com/catalog/sitemapindex.xml
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
Greetings
I have had Google Sitemap up and functioning [on 2 sites] for several weeks, THANKS for a great product!!!
- Today I installed the Admin Patch and the XSS patch on [BOTH SERVERS]. bulklights.com AND liberty-flag.com.
- I changed the admin folder on [BOTH SERVERS] and made the appropriate config.php changes.
The bulklights.com Sitemap works GREAT!
The liberty-flag.com Sitemap opens the popup window and times out with a resulting -
and nothing more. I renamed the old sitemapindex.xml and the other .xml files and tried running it again to no availe.Quote:
Google Sitemap Generation (v 1.3.11 19.05.2007 2:52) started
Save path - "/home/content/l/i/b/libflag/html/"
Base URL - "http://www.liberty-flag.com/"
The only other difference between the two sites is that on liberty-flag.com I tried toying with EZ-Pages. I created a page then deleted it.
Any other ideas or clues needed?
Thanks for your help
JOhn ><>
When I run from the ie command line I get!Quote:
Originally Posted by LibertyFlag
http://www.liberty-flag.com/googlesitemap.php
JOhn ><>Quote:
Google Sitemap Generation (v 1.3.11 19.05.2007 2:52) started
Save path - "/home/content/l/i/b/libflag/html/"
Base URL - "http://www.liberty-flag.com/"
Processing file: /home/content/l/i/b/libflag/html/sitemapproducts.xml OK! Written 2440 records, 492156 bytes
Generated Google Product Sitemap Successfully - http://www.liberty-flag.com/sitemapproducts.xml
Processing file: /home/content/l/i/b/libflag/html/sitemapcategories.xml OK! Written 456 records, 87576 bytes
Generated Google Category Sitemap Successfully - http://www.liberty-flag.com/sitemapcategories.xml
ERROR: Google Category Sitemap Generation FAILED!
Processing file: /home/content/l/i/b/libflag/html/sitemapindex.xml OK! Written 2 records, 606 bytes
Generated Google Sitemap Index Successfully - http://www.liberty-flag.com/sitemapindex.xml
Total Execution Time 1:0.7201
Looks like everything is working fine, using Google Sitemap Generation (v 1.3.7 )Quote:
Originally Posted by pivey
No errors,
I have a question regarding the actual sitemap listing at Google:
since my path is set to the following:
Save path - "/home/"directory"/public_html/"
Base URL - "http://domain.com/" I have had to setup my google webmaster to also reflect this instead of http://WWW.domain.com
all sitemaps paths come up WITHOUT the https://www.domain.com but instead display http://domain.com
will this cause a problem with site ranking or crawlers? how do i change this so that the site BASE URL shows up with http://www.domain.com.
Wolf
Kelvyn,
I am currently using google sitemap 1.3.7 and would like to update to 1.3.12(or the latest). since I already have 1.3.7 installed can I just overwrite the files. I also noticed that in the 1.3.12 file system there are update squl files (2,3 and4). If I was to update do I also install these patches the same way as the install.sql (cut and past)?
Wolf
I got this error trying to install Google Sitemaps.
Fatal error: Call to undefined function zen_get_info_page() in /home/public_html/admin/googlesitemap.php on line 259
This happens when I click on the Google Sitemap link under
Tools.
Hi all,
I tried to install the 1.3.12 version of this mod to my 1.3.7 zen cart and after installing the install.sql patch in my admin, I got this error '8 statements processed. Cannot insert configuration_key "" because it already exists. 1 statements ignored'.
Any help appreciated !
Thanks !
Shirley :)
Shirster, I had the same problem. Uninstall and then re-insert the SQL statements through phpMyAdmin. It went through for me fine and it works - except I get this error when I generate the XML files:Quote:
Originally Posted by shirster
ERROR: Google Category Sitemap Generation FAILED!
The files seem to work okay - though I don't know if it is only writing some of them. And, I don't know if that error is connected to your problem - but try inserting through phpMyAdmin and see how it works for you.
I have instelled this excellent mod, and AFAIK the installation was a success, once I but I find that I seem to have some things duplicated in my Admin>Configuration>Google XML Sitemap. Here is the list of 'variables'
Compress XML File
Products changefreq
Category changefreq
Category priority
EZPages changefreq
EZPages priority
EZPages changefreq
EZPages priority
Lastmod tag format
Products priority
Use Google Sitemaps Stylesheet
Use Google Sitemaps Stylesheet
XML directory
XML directory
EZPages Header
EZPages Sidebox
EZPages Footer
EZPages Header
EZPages Sidebox
EZPages Footer
I don't suppose the duplication really matters, and I don't know whether this question has been asked before, but for the sake of tidiness, could anyone please instruct me as to how I might eliminate this problem?
I have a few questions:
1) Is this the right one: http://www.zen-cart.com/index.php?ma...roducts_id=544
2) Will this work with the Ultiamte URL addon?(Using both find_path and mod_rewrite)
3) Assuming both of those are yesses do I need to install all of the SQL patches, or just the install one?
Please, does anyone know if this will work with the Ultimate URL addon?
Hi
I purchase a site map for my whole sites and install it, I need to uninstall the site map mod I got from here.
How do I install it? And there is any file was override I need to modify or change while doing this uninstalls?
Thank you
Are you certain you created sitemapcategories.xml and set proper write permissions on the file before attempting to generate the feed?Quote:
Originally Posted by magicpants
Woody
Easiest would be to run the uninstall.sql (included the mod zip archive). Then run install.sql again.Quote:
Originally Posted by blag
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
Uninstall with uninstall.sql that comes with the mod. Then remove the mod files you uploaded. No core Zen Cart files are altered when installing this mod.Quote:
Originally Posted by motti
Note the Google Sitemap module for Zen Cart which we are referring to in this thread and other sitemaps are different animals. This mod just uploads your info to Google so Google has more info on what to crawl on your site (and also generates helpful webmaster related suggestions about your sites on your domain).
The sitemap application you purchased likely just generates a sitemap file for your entire domain which then you post a link on your sites pages. It likely has no overlap with Google Sitemap.
Can you provide a URL to the program you purchased?
Note Zen Cart also comes with it's own built-in sitemap functionality, which you can also disable but I don't recommend.
It's all just spider food!
Good luck.
Woody
Hi
This is the link http://www.xml-sitemaps.com/
Let me know what you think, i will wait on the un install
Thank you and Night
This is off-topic for this thread. With that said I just don't see the big advantage.Quote:
Originally Posted by motti
Besides generating a sitemap for and pinging Google, the product does the same for Yahoo and Ask. It is inexpensive and you do get free support and only pay a little more for installation.
But it is not Zen Cart specific and it is unclear if some or all of your shop product pages, category pages and other shop pages will be included in the various feeds generated.
Woody