I use 1.36 ZencartQuote:
Originally Posted by a_berezin
Printable View
I use 1.36 ZencartQuote:
Originally Posted by a_berezin
Sorry, I can't help you :down:
Can you test this sql:
Code:SELECT @configuration_group_id:=(configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Google XML Sitemap' LIMIT 1;
v 1.3.3 07.02.2007 8:44
1. Code clean and optimization;
2. Don't use set_time_limit() in SAFE MODE;
3. Add sitemapezpages.xml generation;
Quote:
Originally Posted by a_berezin
I have tried installing the SQL patch but it's not working.. Heres the error I get
Is there somthing wromg with the code or somthing I did?Code: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_SITEM
in:
[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:
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, 'Use root directory', 'GOOGLE_SITEMAP_USE_ROOT_DIRECTORY', 'true', 'Use root directory for sitemap files', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (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.
How you install SQL-Path?
Hello, when i create the sitemapproducts.xml file, only the english products are added (product_info&products_id=199&language=en), i have my shop in spanish and in the future i´ll translate in english but for now i need that sitemapproducts.xml only show language=es and not language=en in the product link.
Is this possible?
thanks
Sitemap generate links to products and categories with all installed languages. Links to Default language does not have language parameter.
ok I have this mod installed, but where is the sitemap generated? I was assuming the sitemap XML files in the root directory is what would be populated but they are completly blank. I have run the program and it says sitemap generation started but I dont see any results. Have I done something wrong?
Yes, they must be in root directory. They must have write (0666) permission.
I have ch/mod set to 777 and still the .xml sitemap files are blank, are you suppose to wait for the generation after clicking the generate sitemap? If so, how long?Quote:
Originally Posted by a_berezin
Hi,
ive installed the sitemap mod successfully but when i try to create the sitemap i get this :
it looks to me that the root path its grabbing is incorrect? if so, where do i change it?Code:Google Sitemap Generation v 1.3.3 07.02.2007 8:44 started
ERROR: Google Product Sitemap Generation FAILED!
ERROR: Google Category Sitemap Generation FAILED!
ERROR: Google Category Sitemap Generation FAILED!
ERROR: Google Sitemap Index Generation FAILED!
Total Execution Time 0:1.9688
PHP Warning: fopen(): open_basedir restriction in effect. File(/sitemapproducts.xml) is not within the allowed path(s): (C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk) in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googlesitemap.php on line 151 PHP Warning: fopen(/sitemapproducts.xml): failed to open stream: Operation not permitted in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googlesitemap.php on line 151 PHP Warning: fopen(): open_basedir restriction in effect. File(/sitemapcategories.xml) is not within the allowed path(s): (C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk) in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googlesitemap.php on line 151 PHP Warning: fopen(/sitemapcategories.xml): failed to open stream: Operation not permitted in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googlesitemap.php on line 151 PHP Warning: Invalid argument supplied for foreach() in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googlesitemap.php on line 169 PHP Warning: fopen(): open_basedir restriction in effect. File(/sitemapindex.xml) is not within the allowed path(s): (C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk) in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googlesitemap.php on line 151 PHP Warning: fopen(/sitemapindex.xml): failed to open stream: Operation not permitted in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googlesitemap.php on line 151
thanks
Sorry to add another SQL post to this thread, but I've tried a bunch of methods and it's not worked.
I had a previous version installed, and when i tried to run the googlesitemap.sql, I get this error:
I ran the uninstall.sql and tried again -- same problem.Code:Cannot insert configuration_key "" because it already exists
I should be able to figure this out, but no luck. This was through the Zen Cart Install SQL Patches screen. I'm using Zen Cart 1.3.6.
magicpants,
configuration_key "" already exists?
What sql you install?
aharper78 & PhillipHarrison
I add diagnostic message to googlesitemap.php - display full output file name.
Please download and test it.
looks a near identical error.....Quote:
Google Sitemap Generation v 1.3.3 07.02.2007 8:44 started
Processing file: /sitemapproducts.xml Failed!
ERROR: Google Product Sitemap Generation FAILED!
Processing file: /sitemapcategories.xml Failed!
ERROR: Google Category Sitemap Generation FAILED!
ERROR: Google Category Sitemap Generation FAILED!
Processing file: /sitemapindex.xml Failed!
ERROR: Google Sitemap Index Generation FAILED!
Total Execution Time 0:1.6606
PHP Warning: fopen(): open_basedir restriction in effect. File(/sitemapproducts.xml) is not within the allowed path(s): (C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk) in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googles itemap.php on line 159 PHP Warning: fopen(/sitemapproducts.xml): failed to open stream: Operation not permitted in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googles itemap.php on line 159 PHP Warning: fopen(): open_basedir restriction in effect. File(/sitemapcategories.xml) is not within the allowed path(s): (C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk) in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googles itemap.php on line 159 PHP Warning: fopen(/sitemapcategories.xml): failed to open stream: Operation not permitted in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googles itemap.php on line 159 PHP Warning: Invalid argument supplied for foreach() in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googles itemap.php on line 179 PHP Warning: fopen(): open_basedir restriction in effect. File(/sitemapindex.xml) is not within the allowed path(s): (C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk) in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googles itemap.php on line 159 PHP Warning: fopen(/sitemapindex.xml): failed to open stream: Operation not permitted in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googles itemap.php on line 159
Hi. I just installed latest version of GoogleSitemap Admin v 1.3.3 02-07-07
I observed the new feature to write Google Sitemap xml files to the web root and when I updated the feed via Tools > Google XML Sitemap I observed the four files in webroot sucessfully updated!
QUESTION: Is putting the xml files (and xsl) file into the webroot of the domain now absolutely required by Google?
I ask this as previously I had set-up two separate Google Sitemap feeds: one for the website in webroot, then an additional Google sitemap for the shop one level off webroot (/public_html/shop).
So has things now changed where does Google wants all sitemap info for the entire domain combined into the xml files placed in webroot?
If so, then after auto generating Google Sitemap xml feed with Andrew's mod (with shop info) will I then need to manually edit sitemapindex.xml to add any additional Sitemap info for the rest of my site. If so how do I go about merging these separate feeds. Or do I just name them different. e.g sitemapindex.xml (for shop) and sitemap2index.xml (for rest of the domain)?
Sorry if I sound confused. I guess I should go and read updated docs at Google.
Woody
Are you certain the four xml files are in your webroot (e.g. public_html) and not in your the root of your shop (e.g. /public_html/yourshop/). Andrew's mod now defaults to write to the webroot.Quote:
Originally Posted by aharper78
See admin setting in Config > Google XML Sitemap
Use root directory true
Quote:
GoogleSiteMapAdmin v 1.3.3 (02-07-07) settings as they appear in Zen Cart 1.37
Below are the defaults. Adjust accordingly.
Compress XML File false
Products changefreq weekly
Category priority 0.5
Category changefreq weekly
EZPages changefreq weekly
EZPages priority 0.5
Lastmod tag format date
Products priority 0
Use Google Sitemaps Stylesheet true
Use root directory true
EZPages Header true
EZPages Sidebox true
EZPages Footer true
Hi Andrew, it's just the normal googlesitemap.sql. I did it through zen cart's install sql patches. Here it is:
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, 'Use root directory', 'GOOGLE_SITEMAP_USE_ROOT_DIRECTORY', 'true', 'Use root directory for sitemap files', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(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);
I just setup a fresh new 1.37 test shop and installed latest Google Sitemap Admin 1.33 mod (fresh install) and did not observe any errors patching with googlesitemap.sqlQuote:
Originally Posted by magicpants
The SQL error report should be different when patching with googlesitemap.sql vs. uninstall.sql. If/when there is an error usually you will receive more info than just the single line you offered. Can you provide the additional info?
Or better yet, have you tried patching using phpmyadmin? I have observed too many issues patching with integrated SQL Query Executor (for 1.3x shops). Anymore I just avoid patching via Tools > Install SQL Patches and instead use phpmyadmin.
Woody
Hi magicpants,
You can see, that in the normal googlesitemap.sql is not present any record with configuration_key "".
Quote:
Originally Posted by magicpants
Do you have new update for SQL Path?Quote:
Originally Posted by a_berezin
What do you mean?
Thanks Woodymon and a_berezin!
I used phpmyadmin and it worked fine. Guess I could have tried that from the start -- but I hadn't noticed any difference between the two methods in the past.
kimsonvu, i'm with Andrew: what's this new update to SQL path? I guess I don't have it, I haven't heard about it before.
I suspect kimsonvu may have been confused by a previous post, declaring an issue in the fresh mod install sql file, when there was not one. The issue was in the updater sql file and the simple correction has been posted to this thread.Quote:
Originally Posted by magicpants
And rather than "path" I think he meant "patch" :wink2:
Ok. As I can see, this is a problem with $_SERVER['DOCUMENT_ROOT']. So, I refuse parameter GOOGLE_SITEMAP_USE_ROOT_DIRECTORY and add new parameter - GOOGLE_SITEMAP_XML_FS_DIRECTORY.Quote:
Originally Posted by PhillipHarrison
Please, download and test it.
Quick question. I downloaded the Sitemap package, and I see the googlesitemap.sql update. But then there is a 1.3.3 and a 1.3.2 sql patch, are you supposed to upload all three...or just one or just 2 or???
Current version is 1.3.3. Are you upgrading the mod from a previous version or is it a fresh install? If fresh install only need to apply googlesitemap.sqlQuote:
Originally Posted by Crzipilot
If upgrading the mod, then the sql patch(es) you need to apply depends on which version you are upgrading from.
Or if not sure just run uninstall.sql. Then run googlesitemap.sql
It is very good that Andrew supports his mods with sql updaters and an uninstaller. :thumbsup:
Woody
anyone have any ideas on my problem? :(
Did you download Andrew's new version he kindly updated just for you (see just a few posts above) :wink2: Please download, test and report back.Quote:
Originally Posted by PhillipHarrison
Andrew is just too fast. :thumbsup: I should have stated current mod version is 1.34. All other recommends still apply.Quote:
Originally Posted by Woodymon
So,I have some problem with update SQL file .... and can see anything in config-google site map :wacko: .
If someone know this problem,please help me :D
Also, HAPPY NEW YEAR in ASIAN :smile:
What problem? Be more concrete!Quote:
Originally Posted by kimsonvu
Run uninstall.sql. Then run googlesitemap.sql
Happy New Year. Out with the dog and in with the Ding Hai - Yin Red Fire Pig.
I see this box when load uninstall.sql and googlesitemap.sql .Quote:
Error
SQL query: Documentation
SELECT @configuration_group_id := configuration_group_id
FROM configuration_group
WHERE configuration_group_title = 'Google XML Sitemap'
LIMIT 1 ;
MySQL said: Documentation
#1146 - Table 'handicra_shop.configuration_group' doesn't exist
How you execute sql-patch?
You are using a prefix on your shop's DB tables.Quote:
Originally Posted by kimsonvu
Copy and then paste the SQL code into the form at Tools > Install SQL Patches. But avoid "uploading" the sql file.
Woody
It is very important!!! Do not use upload!!! It incorrectly processes magic_quotes.Quote:
Originally Posted by Woodymon
I am having the same problem. I used the copy and past to install but got the message:Quote:
Originally Posted by a_berezin
1146 Table 'silentth_zc2.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;]
How do I fix this?
Where you "Copy and paste"?
I always use the SQL Query Executor copy and past SQL's in the Admin SQL Patch utility. I have also tried to install with phpmyadmin and get a message the the configuration_group do's not exsist but I can see it in my sql. It is listed as zen_configuration_group. This is got me stumped. I have even tried the uninstall SQL and that didn't work at all.Quote:
Originally Posted by a_berezin
Yes,your problem same as with me!Quote:
Originally Posted by frogster
Ok! Wait some times, I make installer script and resolve your problem.
Thanks berezin will be waiting for the fix.Quote:
Originally Posted by a_berezin
Thanks youQuote:
Originally Posted by a_berezin
Added install_googlesitemap.php for those, who have a problem with SQL-patch.
Copy install_googlesitemap.php to the admin directory and start it.
Ok downloaded the new files ran the install_googlesitemap.php and get a page not found error.Quote:
Originally Posted by a_berezin
When I ran the google site map in the admin I get a error message that looks like this:
[function.fopen]: failed to open stream: No such file or directory in /home/silentth/public_html/googlesitemap.php on line 161
Failed!
ERROR: Google Category Sitemap Generation FAILED!
Processing file: GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapezpages.xml
Warning: fopen(GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapezpages.xml) [function.fopen]: failed to open stream: No such file or directory in /home/silentth/public_html/googlesitemap.php on line 161
Failed!
ERROR: Google Category Sitemap Generation FAILED!
Processing file: GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapindex.xml
Warning: fopen(GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapindex.xml) [function.fopen]: failed to open stream: No such file or directory in /home/silentth/public_html/googlesitemap.php on line 161
Failed!
ERROR: Google Sitemap Index Generation FAILED!
Total Execution Time 0:0.9124
I have all Xml files set to 777. Mind has left the building now.:blush: What have I done wrong? I now it has to be something simple.:blink:
You don't install Google Sitemap. When you run install_googlesitemap.php you must select on Install menu 'Install' or Update and then click on Process button.
I tried the install and it give me a page not found when I click the installQuote:
Originally Posted by a_berezin
it did not install. What know?:bored:
I just looked in the install php do the configure.php files need to be Cmos to writeable before the install will work because all of mine are not?:no:Quote:
Originally Posted by a_berezin
What server you use?
Download and try again.
Our site is on cp-free server the url for our site is silentthunderproducts.comQuote:
Originally Posted by a_berezin
I must have had a bad download because this time it worked like a charm. Thanks so much for you hard work and your time.:smile:Quote:
Originally Posted by a_berezin
Glad to helpe you :smile:
Hi Andrew-
I like your v.135 with the installer. All mods should have such ability! :thumbsup:
Woody
Hi Woody,
All mods should have ZenModsInstaller!!! I now just finish designing it.
From admin/tools/Google XML sitemap, when I attempt to create my sitemap, this is the error I'm receiving:
For the first time, I believe, I was unable to load the sql via the "Install SQL Patches" in the admin. Instead I copied install_googlesitemap.php to the admin, as per the documentation. Could that be where the glitch is? Maybe I missed something there.Quote:
Google Sitemap Generation v 1.3.4 16.02.2007 0:15 started
Save path - "GOOGLE_SITEMAP_XML_FS_DIRECTORY/"
Base URL - "http://www.beadedlily.com/"
Processing file: GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapproducts.xml.gz
Warning: gzopen(GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapproducts.xml.gz) [function.gzopen]: failed to open stream: No such file or directory in /home/example/public_html/shop/googlesitemap.php on line 147
Failed!
ERROR: Google Product Sitemap Generation FAILED!
Processing file: GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapcategories.xml.gz
Warning: gzopen(GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapcategories.xml.gz) [function.gzopen]: failed to open stream: No such file or directory in /home/example/public_html/shop/googlesitemap.php on line 147
Failed!
ERROR: Google Category Sitemap Generation FAILED!
Processing file: GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapezpages.xml.gz
Warning: gzopen(GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapezpages.xml.gz) [function.gzopen]: failed to open stream: No such file or directory in /home/example/public_html/shop/googlesitemap.php on line 147
Failed!
ERROR: Google Category Sitemap Generation FAILED!
Processing file: GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapindex.xml
Warning: fopen(GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapindex.xml) [function.fopen]: failed to open stream: No such file or directory in /home/example/public_html/shop/googlesitemap.php on line 161
Failed!
ERROR: Google Sitemap Index Generation FAILED!
Total Execution Time 0:0.3316
Any idea's on what has occured and how I might go about applying a fix?
Thanks - Tim
I was downloaded last your google site map and tested.It work great.
Thanks your help and your times. :wub:
@meltdown:
I observe you are running v.1.34. I suggest downloading the just released v.1.35 which comes with web-based installer. (install_googlesitemap.php)
Regards to your error above, it appears that GOOGLE_SITEMAP_XML_FS_DIRECTORY is undefined. Are you certain you uploaded all files from the 1.3.4 version release and overwrote all files from any previous version(s)?
As suggested above install the new 1.3.5 and run installer. Before installing you will want to decide where you install your XML files, in your webroot (opublic_html) or shop root.
And then after installing double check admin setting for "Use root directory" in Configuration > Google XML Sitemap
Woody
Quote:
Originally Posted by Woodymon
Thanks for responding, Woody - I thought I was installing the most recent version as I obtained the link from the mod creators signature. Is there another place to get 1.35?
Tim
Nope - My bad - I just went and got it again and sure enough, it's 1.35. I could have sworn...
OK, I'm off to give it a try. Thanks!
I hate to be thick but when you say "run the installer" what exactly does that mean?Quote:
Originally Posted by Woodymon
Also, concerning the prior error message, if I've changed my admin file name for security purposes does this mod have to be changed to reflect that?
I've installed this module and it's generating the sitemaps properly, but I seem to be having problems with the cron job.. first off, Hosting's at Dotster (ugh), so having no success with the cron job at Dotster, I went to webcron.org and set up a cron there. Ohter crons I have there are working, but the one for /store/googlesitemap.php?ping=yes is not. I get this error whenI generate the sitemaps:
ZC version is 1.3.5 -- I'm using the latest download (with the installer), I've installed and uninstalled this a few times over the past few days and have tried more than one download package -- still getting this same error. Anyone know what's causing it? Thanks.Quote:
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 /usr/local/pem/vhosts/4443/webspace/httpdocs/store/googlesitemap.php on line 390 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 /usr/local/pem/vhosts/4443/webspace/httpdocs/store/googlesitemap.php on line 390 Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /usr/local/pem/vhosts/4443/webspace/httpdocs/store/googlesitemap.php:390) in /usr/local/pem/vhosts/4443/webspace/httpdocs/store/includes/functions/sessions.php on line 102 Warning: Cannot modify header information - headers already sent by (output started at /usr/local/pem/vhosts/4443/webspace/httpdocs/store/googlesitemap.php:390) in /usr/local/pem/vhosts/4443/webspace/httpdocs/store/includes/init_includes/init_templates.php on line 78 Google Sitemap Generation v 1.3.4 16.02.2007 0:15 started
Meltdown:
The installer is web based sql patcher = install_googlesitemap.php
(new file and only change to version 1.3.5)
Just access that file via your web browser: e.g.
http://www.yourdomain.com/yourshop/a...glesitemap.php
On second thought... it may be easiest for you to install update_1_3_4.sql, by copying SQL code from that file (using a text editor) and paste into form in your shops admin at Tools > Install SQL patches (copy & paste, don't upload).
Woody
Beautiful! The installer worked like a charm - No errors and fully recognized and accepted by Google.
Woody, thanks for your help!
Andrew, thanks for another great mod!
Tim
No need to configure the mod with your renamed directoryQuote:
Originally Posted by MeltDown
Just be sure to upload the files/directories in the mods admin directory to your renamed admin directory.
And if you run the web-based installer a.k.a. SQL patcher provided in v.1.35 (see example URL in my previous post) be sure to change admin to your renamed admin directory.
Woody
To clarify, there are no differences between 1.34 and 1.35, besides the new patcher file. When running the patcher you will not see 1.35 listed as an upgrade option as there were no SQL changes between v.1.34 and 1.35.Quote:
Originally Posted by Woodymon
If you have 1.34 installed there is no need to upgrade to 1.35, unless you are having problems patching your database. If so you can try patching with the web based patcher that comes with v.1.35
Clear as mud now? :wink2:
Woody
Ignore please.
One additional clarification.Quote:
Originally Posted by Woodymon
With the 1.34 and 1.35 versions you are now provided the flexibility where you want to write your XML files, compared to previous versions of the mod (e.g. to your shop root directory, to your web root or to any other directory).
But the added flexibility can be a bit confusing...
If you want your XML files to live in your shop (catalog) directory, you don't have to do anything besides upload the XML files to your shop directory. Google Sitemap Admin will then write to that directory (DIR_FS_CATALOG = catalog directory = root of your shop).
If you want to write to your webroot directory (e.g. /public_html) you will now, when using v.1.34/1.35, need to manually enter that path info in
Configuration > Google XML Sitemap
For example:
XML directory: /home/your_account/public_html/
(or whatever is the path to your home directory... if not sure you can find this info in your shops configure.php file).
NOTE: The slash at end of public_html is important!
Or as previously stated you can write the XML files to anywhere else on your file system. The main point of this added flexibility is you can now write these "writable" XML files to a directory outside of your web space (e.g. /home/your_account/). A major security advantage!
Hope this helps.
And thanks again Andrew!
Woody
Ok,
I think I downloaded the new version, and installed it...run the sql patches, but I keep getting this error. Not sure why..or what... I had installed this on our test site, and everything went in ook......soooo...
Google Sitemap Generation v 1.3.4 16.02.2007 0:15 started
Save path - "/kunden/homepages/20/d184591110/htdocs/"
Base URL - "https://www.steiffusawarehouse.com/"
Processing file: /kunden/homepages/20/d184591110/htdocs/sitemapproducts.xml OK! Written 489915 bytes
Generated Google Product Sitemap Successfully - https://www.steiffusawarehouse.com/sitemapproducts.xml
Processing file: /kunden/homepages/20/d184591110/htdocs/sitemapcategories.xml OK! Written 30877 bytes
Generated Google Category Sitemap Successfully - https://www.steiffusawarehouse.com/sitemapcategories.xml
Warning: Invalid argument supplied for foreach() in /homepages/20/d184591110/htdocs/googlesitemap.php on line 181
ERROR: Google Category Sitemap Generation FAILED!
Processing file: /kunden/homepages/20/d184591110/htdocs/sitemapindex.xml OK! Written 715 bytes
Generated Google Sitemap Index Successfully - https://www.steiffusawarehouse.com/sitemapindex.xml
Total Execution Time 0:6.3267
Thanks. Ignore this. I shall correct in the next version.
By any chance do you not have a sitemapezpages.xml file uploaded to your htdocs directory?Quote:
Originally Posted by Crzipilot
Andrew and I posted at the same time. Looks like Andrew is on it. I suspect issue with script not testing for existence of the "optional" sitemapezpages.xml file and not bypassing attempt to write to that file if it does not exist. Or something like that.Quote:
Originally Posted by Woodymon
Woody
Well I uploaded the 4 empty .xml files to the root of our store, which now the ez-pages show 0kb...and all the other files, I imagine were created successfully, as they have date in it now. So not sure..
Disable all Google Sitemap EZPages in admin. And delete empty sitemapezpages.xml
I submitted the sitemaps which were generated, and google came back with a few errors on each of them. Basically the errors state that the URL is not allowed at this sitemap location.
I clicked on the URL's, and they were a misc. combination of products or categories in my store. Not sure why they would come up as errors, as basically it says that the page is at a higher level than what the sitemap file is at??? Any clues?
Quote:
Originally Posted by a_berezin
Ok, will try that...
Ok, I disabled in config google xml...the EZ pages and deleted the sitemapezpages.xml file. Turned them all to false. Then went back to tools...and got this...
Google Sitemap Generation v 1.3.4 16.02.2007 0:15 started
Save path - "/kunden/homepages/20/d184591110/htdocs/"
Base URL - "https://www.steiffusawarehouse.com/"
Processing file: /kunden/homepages/20/d184591110/htdocs/sitemapproducts.xml OK! Written 489915 bytes
Generated Google Product Sitemap Successfully - https://www.steiffusawarehouse.com/sitemapproducts.xml
Processing file: /kunden/homepages/20/d184591110/htdocs/sitemapcategories.xml OK! Written 30877 bytes
Generated Google Category Sitemap Successfully - https://www.steiffusawarehouse.com/s...categories.xml
ERROR: Google Category Sitemap Generation FAILED!
Processing file: /kunden/homepages/20/d184591110/htdocs/sitemapindex.xml OK! Written 593 bytes
Generated Google Sitemap Index Successfully - https://www.steiffusawarehouse.com/sitemapindex.xml
Total Execution Time 0:4.8315
Ignore this
Quick question. I uploaded the three sitemaps created. And though still have the errors on the URLS....only one of the files is being listed (main sitemap) as having 2300 URLS submitted...the others do not show submitted urls, on the google sitemap screen. Is this normal?
Btw, I don't see Google XML Sitemap Admin in admin/Config, just in admin/Tools, but it's ok, it works fine.
My question is:
Google sitemaps asks me, when trying to add
sitemapindex.xml
as a mobile sitemap, what markup language I should choose. The 3 options are:
XHTML mobile profile (WAP 2.0)
WML (WAP 1.2)
cHTML (iMode)
I don't understand what these are, any idea what to choose? I have ZC v.1.3.7
Or should I add General Web Sitemap? :smile:
Adding just sitemapindex.xml is enough, right? No need to add the other two .xml files, for categories and products , right? ...
Because you incorrectly have installed the module - you don't install sql.Quote:
Originally Posted by Florin
Why you add sitemapindex.xml as a mobile sitemap? Can be better familiarize with the instructions on Google sitemaps?Quote:
Originally Posted by Florin
CertainlyQuote:
Originally Posted by Florin
YesQuote:
Originally Posted by Florin
You're only supposed to upload the main sitemap. This file references the others, so just leave those on your site but don't upload.Quote:
Originally Posted by Crzipilot
What can I do to fix this?Quote:
Originally Posted by a_berezin
Thanks for the other replies :smile:
Add Italian localization. Thanks to Paolo.
All files are on server.
Ran sql and got errors. Used unistall sql.
Ran install_googlesitemap.php looked OK.
xml directory is default.
xml files are set to 777
Click on step 1 in xml sitemap admin gives me a 404
I cannot proceed?
Using 1.3.7
What could it be?
Ok I uninstalled ALL files. Restored my database to where it was before...
Then re-installed files, used install.....php option
and the same thing happens.
NSTRUCTIONS: STEP 1: Click [HERE] to create / update your site map.
Clicking there brings up my homepage in the pop up window?
:wacko:
I hope I didn't waste anyones time. Somewhere along the line a file was missing.
Hey it happens:yes:
Wow!!!:lamo: :down:
I think I fix it. Please, download and try quick bugfix version.
What bug bro?Quote:
Originally Posted by a_berezin
What do you mean?
Andrew, I think kimsonvu is asking which bug you fix :)Quote:
Originally Posted by a_berezin
readme.txt:
The so stupid typing error, that to me is a shame to tell :blush: :blush: :blush:Code:v 1.3.6a 03.03.2007 10:55
1. Quick bug fix typo in /admin/googlesitemap.php
I uploaded all of the files for the mod, and when I wen to install the SQL patch I got this error.
1146 Table 'hotnbott_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.
If I hit the browser back button and go into the admin, under tools the link for google site map is there, if I try to run the create/update program I get this error:
Save path - "GOOGLE_SITEMAP_XML_FS_DIRECTORY/"
Base URL - "http://nemesis.sslcatacombnetworks.com/"
Processing file: GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapproducts.xml
Warning: fopen(GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapproducts.xml) [function.fopen]: failed to open stream: No such file or directory in /home/hotnbott/public_html/hotsauce/googlesitemap.php on line 161
Failed!
ERROR: Google Product Sitemap Generation FAILED!
Processing file: GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapcategories.xml
Warning: fopen(GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapcategories.xml) [function.fopen]: failed to open stream: No such file or directory in /home/hotnbott/public_html/hotsauce/googlesitemap.php on line 161
Failed!
ERROR: Google Category Sitemap Generation FAILED!
Processing file: GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapezpages.xml
Warning: fopen(GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapezpages.xml) [function.fopen]: failed to open stream: No such file or directory in /home/hotnbott/public_html/hotsauce/googlesitemap.php on line 161
Failed!
ERROR: Google Category Sitemap Generation FAILED!
Processing file: GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapindex.xml
Warning: fopen(GOOGLE_SITEMAP_XML_FS_DIRECTORY/sitemapindex.xml) [function.fopen]: failed to open stream: No such file or directory in /home/hotnbott/public_html/hotsauce/googlesitemap.php on line 161
Failed!
ERROR: Google Sitemap Index Generation FAILED!
Total Execution Time 0:0.1834
Can anyone help?
From readme.txt:
Use install_googlesitemap.php.Quote:
2. Go to Admin->Tools->Install SQL Patches and install googlesitemap.sql
or
Copy install_googlesitemap.php to the admin directory, start it, select Install and press GO button.
The generation fails for zepages if i have ezpage defined but not activated (all button turned red ina dmin).
Is it a well known behaviour?
(running zc 1.3.7)
v 1.3.6a 03.03.2007 10:55
When all ez-pages disabled and any EZPages (Header or Sidebox or Footer) generation enabled, googlesitemap.php generate zero sitemapezpages.xml, that not included in sitemapindex.xml.
I was just wondering.
Yahoo has free sitemaps now too. And I'm pretty sure they accept .xml
So we should be able to submit the same sitemapindex.xml to yahoo?Quote:
I'm going to try it and see if it works:yes:
See what happens.
Yes. And I already talk about this. See http://www.zen-cart.com/forum/showpo...&postcount=137
Even with ez-pages enabled and showing on my site and ezpages sidebox generation enabled, I still get no ezpages in the sitemapindex.xml file and the sitemapezpages.xml file is empty.Quote:
Originally Posted by a_berezin
See it here, http://jilada.com/catalog/googlesitemap.php