That is correct. :)
Printable View
That is correct. :)
OK. I'll try that. Thanks!Quote:
Originally Posted by quantum
Disallow: catalog/images/Quote:
Originally Posted by quantum
Use it only if you do not want indexed all yours images. In this case you may forget about images.google.com.
Disallow: catalog/admin/
Don't use it in any case!!!
1. How robots can find out about this directory? Do You have any links in main catalog to admin?
2. If you
and then insert new admin name in robots.txt, thus you will tell by all hackers about a new name of admin area.Quote:
Renaming the "admin" folder makes it much harder for would-be hackers to get into your admin area.
Disallow: catalog/docs/
1. How the robot can find out about this directory? Do You have any links in main catalog to docs?
2. Better way - delete this directory.
As I said in the post where I placed this info, this is if you want to block these files from being accessed and it is an example.Quote:
Originally Posted by a_berezin
Blocking your images from appearing in Google Image search can be a very good thing so no one steals your images to use on their site.
[QUOTE=a_berezin;292705]
Disallow: catalog/admin/
Don't use it in any case!!!
1. How robots can find out about this directory? Do You have any links in main catalog to admin?
QUOTE]
Actually in this case, yes, my client does have a link to from their main site (at their request to make it easier for them) to get to the admin section, so this is needed in the robots.txt file.
Indexing and using is not the same things.Quote:
Originally Posted by quantum
1. Disallow indexing does not forbid use.
2. You may disallow indexing only large images, but it's too does not forbid use.
3. You may use very easy hotlink protect.
4. You may hide real location of the large images by the php script, but you don't protect it for "Save image as...".
5. Use watermark to protect images (better and easy way).
Wow! Congratulations! You say "Welcome!" to hackers. No comments.Quote:
Originally Posted by a_berezin
Even in this case it is not necessary to mention it in robots.txt. Robot can not indexing protected by the password admin.
Not for you.
For normal use, It is not necessary to tell to all world as yours refers to admin.
don't you have something better to do Andrew?
Better than your harmful advices?
I simply explain why it is impossible to do how you advise, because you harm to it.
What for you give advice in what nothing understand in?
Hi,
Sorry if this has been answered already, couldnt find it.
When I install the googlesitemap.sql file I get the following error..
Any ideas why? I am on v. 1.3.0.2 and have IH2 and Froogle Feeder Installed. I have also double checked that all the upload files are in the right place.HTML Code:SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Google XML Sitemap';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
insert into configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) values ('', 'Google XML Sitemap', 'Google XML Sitemap Configuration', '1', '1');
SET @t1=last_insert_id();
UPDATE configuration_group SET sort_order = @t1 WHERE configuration_group_id = @t1;
insert into configuration values ('', 'Compress XML File', 'GOOGLE_SITEMAP_COMPRESS', 'false', 'Compress Google XML Sitemap file', @t1, 3, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),');
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'),')' at line 1
in:
[INSERT INTO zen_configuration values ('', 'Compress XML File', 'GOOGLE_SITEMAP_COMPRESS', 'false', 'Compress Google XML Sitemap file', @t1, 3, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),');]
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.
Cheers!
Please, try this:
Code:SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Google XML Sitemap';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
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 @t1=last_insert_id();
UPDATE configuration_group SET sort_order = @t1 WHERE configuration_group_id = @t1;
insert into configuration values (NULL, 'Compress XML File', 'GOOGLE_SITEMAP_COMPRESS', 'false', 'Compress Google XML Sitemap file', @t1, 3, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
insert into configuration values (NULL, 'Products changefreq', 'GOOGLE_SITEMAP_PROD_CHANGE_FREQ', 'weekly', 'How frequently the Product pages page is likely to change.', @t1, 3, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'always\', \'hourly\', \'daily\', \'weekly\', \'monthly\', \'yearly\', \'never\'),');
insert into configuration values (NULL, 'Category changefreq', 'GOOGLE_SITEMAP_CAT_CHANGE_FREQ', 'weekly', 'How frequently the Category pages page is likely to change.', @t1, 3, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'always\', \'hourly\', \'daily\', \'weekly\', \'monthly\', \'yearly\', \'never\'),');
insert into configuration values (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)', @t1, 3, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'date\', \'full\'),');
insert into configuration values (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.', @t1, 3, NULL, NOW(), NULL, NULL);
insert into configuration values (NULL, 'Products priority', 'GOOGLE_SITEMAP_PROD_CHANGE_PRIOR', '0.5', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', @t1, 3, NULL, NOW(), NULL, NULL);
Worked a treat - Thanks! :)
still looking for this mod. where can i find it?
Hi! Follow up on the problem I reported yesterday. Google robot.txt analysis shows that they have detected the robots.txt file I have created according to the suggestions made earlier. However, web crawl results still didn't change and gave the same error: robots.txt unreachable.
So, in one word, the problem still exists. My first thought at this problem was that because of the fact my store was install under /catalog/ folder instead of root directory, google cannot reach it. Google told me:
This site is not located at the top level for the domain. A robots.txt file is only valid when located in the highest-level directory and applies to all directories within the domain. The robots.txt file that applies to your site (if one exists) is located at http://bridgecampus.com/robots.txt. This page provides information on that file.
Since it didn't work out quiet as expected by you folks, I am raising this again. Is that the possible reason? If so, how to resolve it? Or, am I missing something there.
Thanks so much!
Thank you for the link. :)
WOW! Well I just looked at the robots.txt and it's in the right place, however you seem to have your /catalog in Dasallow. What I would do if I was you is Allow ALL so you can get started being indexed and then Disallow directories as you start getting indexed. Our site http://www.hatnpatch.com is taking 1700 hits a day PLUS somewhere around 300+ per day (looking at the user tracking mod as well as server stats) from Googlebot, Inktomi and others. My robots.txt is set to ALLOW ALL and I used the GoogleSiteMap Contrib to make the .xml for them to index. I would caution you on trying to be 'too cautious' until your site starts clicking for you and fine tune as you go. Some may think this isn't a good way to go, but here's the question:
Would you like to have Google (and others) start indexing you today, or wait for another 2-3 weeks for this to happen?
The answer should be NOW. Here is what I would recommend (if you have not already):
1. Install User Tracking for verification of crawler and bots (visitors too);
2. Install Google SiteMaps, create the .xml file;
3. Signup for Google SiteMaps, complete their requirements; and
4. Ping Google Sitemaps to get it started.
Within 2 days you will start to see them indexing you and then you can 'tighten up' the other stuff later. :yes:
Hope that helps!
Rod
(former keywording and SEO Tech/Consultant)
Quote:
Originally Posted by rod44
Hi! Thanks for the suggestions. I tried to allow all. But still, my robots.txt is not accessible by google. Why is that happening? Can anyone take a better look at my site and give me some suggestions please? My store is installed under /catalog/ folder. Thanks so much!
Are you able to place a screen print up of the page in your Google Sitemaps that shows the error Google is giving you?
Sure! Since I didn't have the store under root directory, I submitted both www.bridgecampus.com and www.bridgecampus.com/catalog/ Both screen prints are attached. Thanks for your help!Quote:
Originally Posted by quantum
http://www.bridgecampus.com/images/1.bmp
http://www.bridgecampus.com/images/2.bmp
http://www.bridgecampus.com/images/4.bmp
http://www.bridgecampus.com/images/3.bmp
Maybe you should place a 'specific' allow and see if that will help. Try adding this:
User-Agent: Googlebot
Allow: /
Also, you still have not said if you have Google SiteMaps installed. Do you? If not, I would add it as it is the BEST way to get the attention of Google and get them to your site. Using the site map, as soon as you update your site you can just update the sitemap with the click of a button in your admin, then ping their server, and it's done. Might be better than getting too caughtup with the robots.txt? I am telling you, the sitemap mod is the best way to go.
One other thing, I use Firefox as a browser and your site comes up with the center page off to the right overlapping all the right boxes.
Hope that helps!
Sorry that I missed your question. But yeah, I do have googlesitemapadmin contribution installed. That's what you are talking about, right? I used to think that the google sitemapadmin was built to utilize google robots that sort of things. It seems I was wrong. They are totally different two routes of getting google notified? I don't see google sitemapadmin produce a lot of traffic for my site though.Quote:
Originally Posted by rod44
Looking at the dates against where it is says the robots.txt file is unreachable, they are old dates.
I am not an expert on Google SiteMaps, but I assume 'Last Calculated' means the date these were last accessed?
If this is the case, then Google may be accessing your site.
Do you have a web stats package with your hosting plan? If so, take a look at it and see what stats show for the GoogleBot. This may give you an indication of whether Google is crawling your site.
Google has your site in its listings (only the home page at this stage), so that would indicate it has at least picked it up.
Well, but looking at what you have posted, it appears that the last 'validation' was about 10 days ago, and correct me if I am wrong, you have changed the robots.txt file since. If you look at the last 2 pages dated the 18th it shows success. Seems that if they WOULD crawl your site again that it would probably work.Quote:
Originally Posted by stargre
I also just noticed in your last two screen prints that it shows that the robots.txt file was succeffully downloaded on November 18th.
That's true and that's also what I am confused about. It seems that they have seen the robots.txt change, but that didn't fix the crawl 'robots.txt unreachable' problem. So, modifying robots.txt might not be the correct resolution?Quote:
Originally Posted by rod44
Robots.txt and sitemaps are independent of eachother, and google actually PREFERS the SiteMap route as it doesn't require them to cralw links. What you will see if you use the User Tracking Mod (if you don't have it, this is an INCREDIBLE TOOL to see how visitors use your site) is 'hits' from BOTS and GoogleBot will be identified. Here are a couple of questions (and answers) to make sure you have everything in place:Quote:
Originally Posted by stargre
1. Are you signed up WITH Google under sitemaps? If so, have you added their 'validation' page?
2. Have you created the sitemap through your admin and verified it is actually in your /catalog/ directory? You need to VIEW it through a browser or download and read in notepad or something to make sure it is right.
3. In the sitemap admin once you have verified the sitemap is there, use the ping button to let them know you are there.
If I sound like I am being elementary, I am not. I just want to see this start working for you so you can see some success with your site.
Good Luck!
No, this is why you need to use the Google SiteMaps and relax. The Googlebot crawls through robots.txt SLOW, and you just have to wait for your 'number to be called' and once the recrawl is completed the page validations should change. This is one of those things you will have to wait a bit to see if it worked. But just so you know, my robots.txt looks like:Quote:
Originally Posted by stargre
# robots.txt for http://www.hatnpatch.com/
User-agent: *
Disallow: /cgi-bin/ # these will soon disappear
Disallow: /logs/ # these will soon disappear
and they are crawling my .html pages off of that. Patience my friend,
Quote:
Originally Posted by rod44
1) Yes, I did signup and verified the site.
2) That's right. All three .xml files are in /catalog/ directory. They can be seen in web browser.
3) I did pinged them several times.
This seems so strange. I wish myself some good luck as well. But, any new ideas? Thanks!
Rod is correct, patience is what you need with the search engines (especially google) for crawling all of your site and indexing your pages.
Those screens are simply a historical view, so what is listed there will not update persay, just dissapear to be replaced with new results when google crawls those pages.
Quote:
Originally Posted by quantum
I hope so. As far as the robots.txt file, since I don't have /cgi-bin/ and /log/ folders under my root directory, I didn't put it in the disallow list. But I don't have much idea about it. Are you suggesting I need to modify it? I just want to allow everything as suggested earlier, so that I can get indexed as soon as possible.
Yeah, you are right, I do need relax! Thanks all of you!
I just added 'Allow: /' to my robots.txt file. Is that all I need do?
It is fine to leave the robots.txt file as is for the moment. I would recommend learning more about this file though at the link I gave a few posts back, so you can then better judge for yourself what the experts tell you on robots.txt files, and what you want to allow and dissallow.
Different servers have different setups (mine also don't have cgi-bin), and you will have different needs for your website as opposed to others. So learning more about this will help you decide what is best for you.
I am not sure on this, but the way you had it previously was sufficient to allow all bots, to all parts of your site.Quote:
Originally Posted by stargre
OK. I'll change it back. And once my site gets some traffic and sales, I will definitely try to learn some details along those lines. Just too anxious to get some sales now.Quote:
Originally Posted by quantum
even after Google starts indexing your pages it may take a while before you start getting high enough traffic to get regular sales coming through (you are in a fairly competitive market). I would recommend setting up Google AdWords in the meantime to fill the gap while you are waiting for your organic rankings to improve.
You should also focus on getting other websites to link back to yours. This will also help increase the amount Google crawls your site, as well as improve your PageRank (this is displayed on the Google Toolbar).
Getting sites to link back to you is not always easy, especially if it is a one way link (i.e. you are not reciprocating), but this is a very important element if you want to improve your rankings with Google.
So, are you talking about shopzilla, google base, that sort of things? Or what other kind of website should I look at? Thanks for the tip.Quote:
Originally Posted by quantum
For the linking side of things, here are some articles that are worth reading to help you better understand link promotion:Quote:
Originally Posted by stargre
http://www.seoreview.com.au/?cat=11
http://www.seoreview.com.au/ (top 10 SEO factors)
It is worth reading through this blog when you have time for more ideas to help promote your site.
All about Sitemaps including Sitemap protocol description and Sitemap FAQ.
Quote:
Sitemap 0.90 is offered under the terms of the Attribution-ShareAlike Creative Commons License and has wide adoption, including support from Google, Yahoo!, and Microsoft.
I have Chemo's SEO URLs installed on a 1.3.5 site. I have this mod installed and all works well accept that the URLs are dynamic vs. SEO Friendly. Does anyone have the site map working so that it generates SEO friendly URLs?
I don't know how work last version "Chemo's SEO URLs". This GoogleSitemapAdmin use standard zen-cart function zen_href_link.
i also have chemo's SEO URL's installed.. running 1.3.6.. and this mod works perfectly fine (SEO friendly URLs)Quote:
Originally Posted by rwoody
view: http://www.getyourgameshere.com/sitemapproducts.xml
Hmmm... mine looks like this:
http://www.mysite.com/index.php?main...oducts_id=5659
</loc>
<lastmod>2006-11-14</lastmod>
<changefreq>weekly</changefreq>
<priority>0.5</priority>
</url>
−
<url>
−
<loc>
http://www.mysite.com/index.php?main...oducts_id=4446
</loc>
<lastmod>2006-11-20</lastmod>
<changefreq>weekly</changefreq>
<priority>0.5</priority>
</url>
−
<url>
−
<loc>
http://www.mysite.com/index.php?main...products_id=61
</loc>
<lastmod>2006-11-13</lastmod>
<changefreq>weekly</changefreq>
<priority>0.5</priority>
</url>
−
<url>
−
<loc>
http://www.mysite.com/index.php?main...products_id=89
</loc>
I wonder what i need to change to show the SEO URLs
out of curiosity.. when did you install the SEO URLs? Before or after an upgrade (if you upgraded). If before.. try reloading the SEO files - one or two may have been replaced in 1.3.5. I know that with 1.3.6 the html_output.php file is changed, so you have to winmerge it
if that doesn't work, reload this contribution *after* reloading the SEO.
not sure where to go with it if it still doesn't work afterwards
what is the latest version for 1.3.6? I will uninstall and reinstall the version I have to 135. Right now I'm still on 1.3.5 - The move is going to be major so I'm working on it this week to go to 1.3.6 - I don't have the version for 136 - What is the version # and could you provide a link?
Thanks
The version I have that notes "v135 specific-files" is 2.103
I'm sorry... I'm a bit slow this am... I "got" it after I posted. I've taken verion 2.103 and done a winmerge for 136 which is the upgrade I'm working on (doing a complete fresh install). I'm getting the redeclare function error in html_output. I know that has come up before and for the life of me I can't find my notes on the fix, so I'm going to go back and search the forums. When I looked at the file, it's pretty evident that in fact the function is declared twice, but I'm going to have take a close look to see how it should be rewritten to get that out in the event I don't find either my notes or the post.
Could you point me in the correct direction on that?
Thanks
I found my notes and change the function to add "original" and it's working now. I'll now go foward with the Google sitemap and install and cross my fingers that the original problem will be solved -
Thanks
That did the trick!!
Thanks - now I can move forward on the 136 upgrade. Hey that solved a bunch of issues all at once.
Thanks again!!
Hi! It's been quite a while since I changed my robots.txt file according to suggestions here. However, I am still seeing the same errors as I referred to earlier: "robots.txt unreachable". What's going on? If it just needs time, then it's been more than two weeks. It should be long enough time. There must be something we are missing here. Maybe something really stupid. Could anyone take a look at the site again and give some suggestions?Quote:
Originally Posted by quantum
My site is www.bridgecampus.com. The zencart contents are under /catalog/ folder.
Thanks a lot!
I reinstalled this mod. Went to Google to set up and they have already indexed all my pages. I knew this anyway, their bots come daily.
My question, if your site is already routinely indexed, does google sitemaps, like this mod will create, weaken some pages priority that are not part of the sitemap? Such as EZ Pages? I mean, over a period of time.
I am wondering where the advantage is, or lack of. Google help seems to imply a sitemap is helpful if you are "not being indexed".
So please forgive me, I still don't get it.
I was install this module and run,but found this problem:
http://www.handicraft-vn.com/shop/googlesitemap.php?
Can somebody guide me to fix this?
Thanks you for help,
My error :( Fixed. Thanks!Quote:
Originally Posted by kimsonvu
Reload it.
Hi,
I saw this problem with webmaster program in google.I dont know how to fix that!
Errors Unsupported file format
Your Sitemap does not appear to be in a supported format. Please ensure it meets our Sitemap guidelines and resubmit.
http://www.google.com/support/webmas...er=34654&hl=en
I've installed the Google Sitemap Admin contribution and it works great! It creates nice sitemaps for mysite, which I have no problems manually importing to Google Sitemaps.
To update the sitemaps I access www.mysite.com/googlesitemaps.php?ping=yes (I think that's the URL). In the documentation (for the contribution) it states that by accessing this URL your sitemaps will be updated and Google will be notified. However, if I log into Goolge Sitemaps after accessing this URL the 'submitted' date of each sitemap does not change!
I've tried this on several occassions and even waiting a couple of hours and even days before checking the status of my sitemaps with Google.
So my questions is...
Is this normal? Surely when you hit the above URL it should 'resubmit' your sitemaps.
Hope that all makes sense!
I don't know why so occurs. When I ping, I receive this mesage from google:
And nothing changed in the status sitemap. :(Quote:
Sitemap Notification Received
Your Sitemap has been successfully added to our list of Sitemaps to crawl. If this is the first time you are notifying Google about this Sitemap, please add it via http://www.google.com/webmasters/sitemaps so you can track its status. Please note that we do not add all submitted URLs to our index, and we cannot make any predictions or guarantees about when or if they will appear.
I think I'm having them same problem! :(
THIS IS HOW YOU ADD THE SITEMAP TO GOOGLE!!!!
1---- Open your Admin (Zen Admin) TOOLS -- GOOGLE XML SITEMAP
2 --- CLICK ON STEP 1 - let the admin do its thing.
3- NOW IF YOU LOG INTO YOUR CPANEL AND LOOK THE ROOT FOLDER
see that there are three folders with an xml extension? dont delete them!
4 ----- Log into google ( you can do this in the admin on the right side of the tools----google xml sitemap area)
5 -- your going to add a sitemap now.
6 --- Click on Add a sitemap and create these files.. (these are the files that are in the root folder that the admin just created for you when you clicked on Step 1)
Http://www.yoursite.com/sitemapcategories.xml
Http://www.yoursite.com/sitemapproducts.xml
Http://www.yoursite.com/sitemapindex.xml
Add each one, three of them. Wait for a few hours and it should be added.
I hope this helps others installing this. I didnt find these instructions anywhere! I wish someone adds it to the download file for the mod.
Good luck!!!!
Oh i forgot --- you can do step 2 of the admin in (PING) google xml area only when you add new products, it should update it for you! I said should. LOL I havent tried it yet.
You can find this instructions on google site.Quote:
Originally Posted by ecommercegirl
I talk that ping does not change status sitemap on google.
6 --- Click on Add a sitemap and create these files.. (these are the files that are in the root folder that the admin just created for you when you clicked on Step 1)
Http://www.yoursite.com/sitemapindex.xml
JUST ADD THIS ONE! NOT ALL THREE
Why not add all 3?
it doesn't hurt to add all three... but if you open up sitemapindex it has references to the other two sitemaps.. so google will crawl them anyway :)
I've added all three.. no errors whatsoever.. so it should be fine
That's what I've done! :)Quote:
Originally Posted by samad64
Also, do you know why Google doesn't update the submitted date of mysite maps when I update them from Zen Cart?
Not sure.. mine seems to work fine. I think Google goes by the "date generated" line in the sitemap itself. i just regenerated it to test it though.. so i'll know in a few days whether or not it was acceptedQuote:
Originally Posted by Alex Clarke
note that i'm running an older version of the contribution.. never updated it as it never broke :). Not sure what version it is though.. anyone know how to tell?
EDIT:
Whoops.. i seemed to have been confused by your question. Date submitted basically means whenever you create it in your Google account and submit it for the first time - revisions are not considered new submissions, so updated sitemaps aren't new submissions. Last Downloaded is what you should go by - if it was downloaded recently you're OK. Mine was last downloaded on 1/16/07, and I think I generated it a few days before hand.. not 100% sure.
samad64, That makes sense. I was just a little confused as to why Google have a 'Resubmit' option for sitemaps. I guess it for people who setup the sitemap name wrong. Who knows.
Either way it looks like my sitemaps are (and have always been) working fine.
Thanks for the help. :)
You must submit only Sitemap Index, which contain reference for all site map files on this site. Certainly you can transfer to Google all hundreds site мар files. But it will be duplication of the information and can be considered as spam. Now Google does not undertake any actions to this, but what will be tomorrow?Quote:
Originally Posted by Alex Clarke
RTFM.
http://www.google.com/support/webmas...654&topic=8496
http://www.google.com/support/webmas...609&topic=8496
Add Google Sitemaps Stylesheet. The stylesheet has been created by Baccou Bonneville and others to display sitemaps XML files in a user-friendly way.
Download.
What i need to do to update this module?Upload all of file or just gss.xml?Quote:
Originally Posted by a_berezin
May be extend sitemap by adding:
1. Products reviews;
2. Info box (same as site_map);
3. EZ-pages;
4. Something else?
I installed GoogleSitemapAdmin, everything went well, or so I thought. The Google XML Sitemap link is in Admin/Configuration, not Admin/Tools. Why is that? And when I look at the .xml files, they are empty? How do I make it update to add my products?
You should have an entry under the 'Configuration' menu, and also under the 'Tools' menu.Quote:
The Google XML Sitemap link is in Admin/Configuration, not Admin/Tools. Why is that? And when I look at the .xml files, they are empty?
The 'Tools' menu entry runs the sitemap generator and pings Google.
Try re-uploading the files in the mod - seems like you may have missed a file/some files, or perhaps put them in the wrong place.
Also make sure you set the permissions on the three feed (.xml) files to 777 (writeable).
Ok, I think it's something with the SQL patch. I re-uploaded everything and still noting in Tools. So I tried re-patching the database, and get this message:
1146 Table 'edgeande_zc2.configuration_group' doesn't exist
in:
Any ideas? Thanks.Quote:
[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.
Can anyone help? I think it's trying to enter it in 'edgeande_zc2.configuration_group' which doesn't exist, but it should be entering it in 'zen_configuration_group' which does exist, but I don't know how to point it there?
Can you post the SQL statement(s) you're trying to run here?
Yes. It's what I found in the SitemapAdmin folder, googlesitemap.sql
Quote:
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, last_modified, date_added, use_function, set_function) VALUES
(NULL, 'Compress XML File', 'GOOGLE_SITEMAP_COMPRESS', 'false', 'Compress Google XML Sitemap file', @configuration_group_id, 3, NULL, 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, 3, NULL, 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, NULL, 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, 3, NULL, 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, NULL, NOW(), NULL, NULL),
(NULL, 'Products priority', 'GOOGLE_SITEMAP_PROD_CHANGE_PRIOR', '0.5', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 3, NULL, NOW(), NULL, NULL);
How are you executing this? phpMyAdmin or Zen Cart?
I tried it in both of them. They both give the same message. btw, I'm using zen 1.3.7.
:( I wanted this to work:cry:
What table prefix do you have set in your configure files?
The prefix is
zen_
in both configure files.
If you run the SQL through admin->tools->install SQL patches it should add the 'zen_' prefix automatically to the table names in the SQL.
If it doesn't, then you can manually add the 'zen_' prefix to the table names in the SQL and try running it through phpMyAdmin.
OK, I added 'zen_' to the table names before I ran the patch. I then ran it through phpmyadmin, and it said " Your SQL query has been executed successfully". But still no Google Sitemap Admin link in Admin>Tools! When I try running the modified SQL through the Zencart Install SQL Patches function, it says:
It's trying to add the prefix double! Yet when I run the SQL patch unmodified, it can't find the tables.Quote:
1146 Table 'edgeande_zc2.zen_zen_configuration' doesn't exist
in:
[DELETE FROM zen_zen_configuration WHERE configuration_group_id = @configuration_group_id;]
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.
... you've already manually put the prefix in the SQL, so you will get it twice if you run the patch through admin ... :smile:Quote:
If you run the SQL through admin->tools->install SQL patches it should add the 'zen_' prefix automatically to the table names in the SQL.
If the patch ran successfully via phpMyAdmin, then you should find the entries in your configuration and configuration_group tables in your database - in other words, the SQL has worked.
Check that you've uploaded all the files in the mod to the right places on your site.
But when I don't enter the prefix manually, it can't find the table. I've tried every possible thing, it seems, and it still doesn't work. I've downloaded & uploaded for the third time, tried numerous modifications to the SQL patch, but still doesn't show up in admin>tools. When I add the 'zen_' prefix to all the configuration areas except the DELETE FROM sections, and run it through the Admin Install SQL Patches, it will process 8 statements but come back with this error:Quote:
Originally Posted by Pixxi
But they DO exist! I can see them in PHPMyAdmin!:no:Quote:
ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table zen_configuration does not exist. CHECK PREFIXES!
You're getting two different things mixed up:
1. The SQL puts the options in the database tables that show up under admin->configuration->google xml sitemap - from what you've said, you've run the SQL successfully via phpMyAdmin.
If the 'Google Sitemap XML' link appears under admin->configuration, then forget the SQL now, that's done.
2. IIRC, the sitemap link in the tools menu is generated from the files being in the correct folders on your server - make sure you have all the files from the mod in the correct folders, especially admin/includes/boxes/extra_boxes/googlesitemap_tools_dhtml.php.
Well, all the files are present, that I can tell. The thing is, what I've gathered from previous posts in the thread, people that had this same problem hadn't installed the SQL patch. That's why I thought it must be that. Also, the link in admin>configuration showed up before I did anything to the DB. I'm totally stumped.
Do you have the 'Admin Levels' or 'Admin Profiles' mod installed?
No. Neither of them.
I did finally generate the sitemap by running googlesitemap.php from cpanel's File Manager. I set up the cron task, too. so maybe I'll just have to do it that way.
LOL! I figured out what my problem was, and it makes me look totally stupid. I have a renamed Zencart admin folder, so the files from GSA Admin folder weren't going in. I copied them over to the renamed Zen admin, and now I have the link in >Tools.
Excellent!
Glad you got things working. :)
Thanks for the contrib, Andrew.
I've been using this for a while, but my shop is in a folder: http://mysite.com/catalog
So, I had to place these files in the folder, rather than the root -- and register with google webmaster tools with the folder included, instead of our normal web address http://mysite.com
I'd prefer to move these files to my root -- any way to solve this?
Download last version 1.3.2 and load sql-patch.
Hi,
I check my Admin->Configuration->Google Sitemap Configuration and setup all parameters but cant see anything in this box.
What happen with that box? :lookaroun
http://www.handicraft-vn.com/gallery...le_sitemap.GIF
Hi,When i run SQL update, i found this :Quote:
Originally Posted by a_berezin
#1146 - Table 'handicra_shop.configuration_group' doesn't exist
I check phpadmin and see just have table name handicraconfiguration_group.How to change your SQL update file to use that table?
Hello,
I got the similar problem (sql error). Here is what I did:
1. copy all files to my store directory. I installed zen cart to .../store folder. I also changed the default admin name to my own name (say, abc). So I copied all files except folder admin to .../store. And then copied all the files under admin to .../store/abc. At this point, google xml sitemap showed under 'tool' menu.
2. use 'tool'--install sql patch-- upload to run googlesitemap.sql. I got error in last statement but when I checked the database table, I saw that the first steps ran successfully. The configuration_group_id is 41 (in configuration_gourp table).
3. Then I run the last statement manually using phpsqladmin. 2 things need to be changed: 1. the table name configuration need to be zen_configuration. 2. wherever you see @configuration_group_id, change it to 41 (the number you got in table configuration_group. yours maybe different). Below is my final version (at the end of the message). Then I just copy and paste it to phpsqladmin and run it. At this point, the menu item showed under 'configuration' menu. Then I was able to create sitemap successfully: http://hipgirlclips.com/store/sitemapproducts.xml
The problem is that google told me it must be in highest level, not under ../store folder. I tried to move, copy the files to the upper level but seems the format changed. I think maybe it's using ASCII instead of Binary mode to copy the file. Any way, I didn't get a chance to search for it yet. Could anybody help? Thanks.
INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
(NULL, 'Compress XML File', 'GOOGLE_SITEMAP_COMPRESS', 'false', 'Compress Google XML Sitemap file', 41, 3, NULL, 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.', 41, 3, NULL, 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.', 41, 3, NULL, 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)', 41, 3, NULL, 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.', 41, 3, NULL, NOW(), NULL, NULL),
(NULL, 'Products priority', 'GOOGLE_SITEMAP_PROD_CHANGE_PRIOR', '0.5', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', 41, 3, NULL, NOW(), NULL, NULL);
Michelle
www.hipgirlclips.com
Hi,
I installed Google SitemapAdmin and tried to run it, but I got:
Warning: set_time_limit(): Cannot set time limit in safe mode in /home/httpd/vhosts/oscarflowermerchant.co.nz/httpdocs/shop/admin/googlesitemap.php on line 35
Google Sitemap Generation v 1.3.2 02.02.2007 15:51 started
Fatal error: Call to undefined function: zen_get_info_page() in /home/httpd/vhosts/oscarflowermerchant.co.nz/httpdocs/shop/admin/googlesitemap.php on line 332
any ideas? I think I am running 1.3.0
sorry, I tried to search the forum to see if this was covered before but I couldn't find anything and no I didn't read through 20 pages of this thread.
What Zen Cart version you really use?
HI,I installed Google Site map and it's work,but in admin-config-google site map i dont see anything to config!Quote:
Originally Posted by a_berezin
How to fix that problem?Do you have YIM or AOL NICK?
Load googlesitemap.sql.Quote:
Originally Posted by kimsonvu
Yes.Quote:
Originally Posted by kimsonvu
When i load that file, i see this problem:Quote:
Originally Posted by a_berezin
Quote:
1146 Table 'handicra_shop.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 can not reproduce this error and so I can't explain this. :(
What version of Zen Cart you use?