Never mind I fixed it. There are 2 "admin" directories in this site for some reason and I'd uploaded to the wrong one.
Printable View
Never mind I fixed it. There are 2 "admin" directories in this site for some reason and I'd uploaded to the wrong one.
I have searched and tried all the fixes people have mentioned but have just started getting the following error after over a year of perfect opperation.... could be because ive now added more products to my site ... but cant find a fix
[01-Jun-2014 09:53:57 Europe/London] PHP Fatal error: 2008:MySQL client ran out of memory :: select products_type from products where products_id = '5388' in /home/public_html/includes/classes/db/mysql/query_factory.php on line 120
[01-Jun-2014 09:53:57 Europe/London] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total
from sessions
where sesskey = '3a359e814b29dc3a564aeef9d' in /home/public_html/includes/classes/db/mysql/query_factory.php on line 120
plenty of people have mentioned this before and people have said its a host issue etc but i believe this is something else for me as i have a VPS with over 16gb of ram (only 10% used during normal operation) and plently of disk space (only 8% used of my 40gb of space). I have full root access through my cpanel WHM etc and have the php memory_limit set to -1 (have tried all kinds of settings in here no no effect) can anyone give me any pointers incase im missing something
you can only create a sitemap index instead of creating sitemap, sitemap sitemap categories and products, if feasible a single file that incorporates the products and categories. I only have 25 categories and 300 products, I think it's better to have a single google site map.
Possible. It is easy to check - write such a plugin.Quote:
Originally Posted by diamond1
Thanks
Is there something ready, I do not know program.
Sincerely
no.. but if this something you need/want and do not have the skill set to create it yourself you may have to hire an developer to create it for you..Quote:
Originally Posted by diamond1
You can manually do it. Or use a third party service. If you can afford to spend on it's own time.Quote:
Originally Posted by diamond1
Do you know someone who can do it? I do not cost much?
I am using the latest version of SitemapXML. The issue I am having is that sitemapproducts.xml is not generated completely, I have about 18k products, the file ends around 1k. Please any idea on how to resolve this issue? Thanks.
One of two options: either the memory is not enough or time restrictions. In directory cach/logs there are any messages?Quote:
Originally Posted by saderogba
Thanks for your response. I don't see any information in the log or cache folder. In either case please what do you recommend to fix this problem? I am launching daily using this format curl -s 'http://your_domain/index.php?main_page=sitemapxml&rebuild=yes&ping=yes'
I don't use http for this task - only CLI interface. The http-interface has additional restrictions.Quote:
Originally Posted by saderogba
how much memory should this script need to run??
I keep getting php memory errors when producing sitemaps when i have a vps with 4gb of available ram (unsused ram)
php config memory set to -1 so should be able to use all the ram....
[27-Jun-2014 17:34:23 Europe/London] PHP Fatal error: 2008:MySQL client ran out of memory :: select p.products_id, p.master_categories_id
from products p
where p.products_id = '3814' limit 1 in /home/********/public_html/includes/classes/db/mysql/query_factory.php on line 120
[27-Jun-2014 17:34:23 Europe/London] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total
from sessions
where sesskey = 'a21e966c4fea93934404bd9335450509' in /home/******/public_html/includes/classes/db/mysql/query_factory.php on line 120
how ever i can get the sitemaps to produce with no issue if CEON URL plugin is turned off.
It's a MEMORY LEAK ERROR.. has NOTHING to do with your VPS or the amount of memory you have configured.. See the responses in the Ceon URI post on how to address..Quote:
Originally Posted by kitcorsa
Hi Diva,
Thanks for your support :)Quote:
Originally Posted by DivaVocals
Please can you demonstrate how to use the CLI interface via cron? Thank you very much for your help.Code:I don't use http for this task - only CLI interface. The http-interface has additional restrictions.
Exactly as written in the example in the README:Quote:
Originally Posted by saderogba
But you must understand that the format of the command and the file path is specific to each hosting!!! It is therefore necessary to consult with the support of your hoisting.Code:28 03 * * * /usr/local/bin/php -f /home/xxxxxxxxxx/data/www/site.com/cgi-bin/sitemapxml.php rebuild=yes ping=yes
Thanks. The CLI interface works great.
Hi,
Excellent! I am glad that my advice helped.Quote:
Originally Posted by saderogba
Version 5.1
Hey all, I just installed and I get the following...
Attachment 14441
Any help would be great! Thanks.
dxxxxmed.com (replace x's with o's
Have you set the sitemap directory setting from the configuration?Quote:
Originally Posted by doooomed
Admin->Configuration->Sitemap XML->Sitemap Directory
If you have, then check the permissions on those files to make sure they are writable by the server.
Thanks for the reply. I do not have Sitemap XML->Sitemap Directory under config.Quote:
Originally Posted by weif
From Tools->Sitemap XML, what version of Sitemap XML do you have installed?Quote:
Originally Posted by doooomed
No sitemap XML under tools either...Quote:
Originally Posted by weif
It is version 2.1 though
the current version of Sitemap XML is 3.2.12 available from http://www.zen-cart.com/downloads.php?do=file&id=367Quote:
Originally Posted by doooomed
Check that you have the current version and that you installed correctly. You should have this entry in the tools menu and in the configuration menu in ZC 1.5.1
Your output looks like you just don't have the plugin configured, and possibly not completely installed...
After installing in SitemapXML v2 into ZC v1.5.3, there seems to be reference to sitemapindex.xmlbeing sent to ASK and BING but that file doesn't exist. Yahoo and Google are being sent a link to sitemap.xml which does exist
Can someone point me in a direction to find the problem?
================================
Ping
Ping Google
http://www.google.com/webmasters/sit...%2Fsitemap.xml
Sitemap Notification ReceivedPing Yahoo!
Ping Yahoo!
http://search.yahooapis.com/SiteExpl...%2Fsitemap.xml
Ping Ask.com
http://submissions.ask.com/ping?site...inweavers.com/sitemapindex.xml
http://submissions.ask.com/ping?sitemap=http//chainweavers.com/sitemapindex.xml"
Ping Microsoft
http://www.bing.com/webmaster/ping.a...inweavers.com/sitemapindex.xml
My cron job isn't working as expected. I have WordPress as my main page, with a Zen Cart install as a sub page (/store).
My cron job statement is http://www.operationhomebrew.com/sto...=yes\&ping=yes
The email response from the cron job indicates a run down of the main page, not the /store. However, if I run the statement in the address bar of my browser, it runs just fine and gives me the results I would expect.
Any help is much appreciated.
I have the latest version (3.2.12) installed on 1.5.3 Zencart version, but I am not getting any of the sitemap menu items either. I've checked that each file has been uploaded in the proper place, re-uploaded, but still nothing. Any help would be appreciated.Quote:
Originally Posted by weif
readme-sitemapxml.txt:Quote:
Originally Posted by dschmidthawk
Quote:
5.1. If your are running Zen-Cart 1.5.x. Run install-sitemapxml_only_for_zen-cart-1_5_x.sql (If you are running Zen Cart 1.3.9, SKIP THIS STEP!)
5.2. If you are using Admin Profiles contribution you need to set the SitemapXML plugin Admin page permission. Go to Tools -> Admin Settings -> Permissions Button and put a checkmark at SitemapXML plugin.
Ahh, clarity. I changed the table name, performed an insert into the database and all is right with the world. Apologies for the confusion, but the last plugins I installed updated the db as a matter of course so I was not expecting a manual update. Thanks.Quote:
Originally Posted by a_berezin
zen 1.51
I just installed sitemapxml but it doesn't create a sitemap.xml file.
I gete a 404 error in the pop-up that is created when I hit the send button.
what am I missing?
Here's my log error
[21-Dec-2014 07:47:20 America/Phoenix] PHP Warning: stat() [<a href='function.stat'>function.stat</a>]: stat failed for ../extras in /home/.../store/YOURADMIN/includes/classes/archive.php on line 245
[21-Dec-2014 07:47:20 America/Phoenix] PHP Warning: stat() [<a href='function.stat'>function.stat</a>]: stat failed for ../pub in /home/.../store/YOURADMIN/includes/classes/archive.php on line 245
AND THIS ONE
[21-Dec-2014 07:44:46 America/Phoenix] PHP Warning: session_start() [<a href='function.session-start'>function.session-start</a>]: Cannot send session cache limiter - headers already sent (output started at /home/.../store/YOURADMIN/includes/functions/extra_functions/backup_zc.php:41) in /home/.../store/includes/functions/sessions.php on line 113
[21-Dec-2014 07:44:46 America/Phoenix] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/.../store/YOURADMIN/includes/functions/extra_functions/backup_zc.php:41) in /home/.../store/YOURADMIN/includes/init_includes/init_templates.php on line 28
And a few other questions perhaps.
I have not used EZpages, but maybe I need to learn about them, as I would like too utilize the testimonials part of sitemapxml and have no idea how to go about putting it together.
OOPS as you can probably tell, I added a backup utility and those were in the log folder.
So no logs created, no cache created, there was the original sitemap.xml in the sitemap file list, but it was empty. I deleted it, and now nothing appears in the sitemap file list.
How many times do I have to go over the copying of files before I get it right?
Apparantly when I copied the includes/modules/pages/sitemapxml folder I dumped it into another folder in the pages directory.
Now to figure out how to use sitemapxml
respect to a_berezin!
0 problems on my development server and on my live server. running zen v1.5.3.... went down the list and up and going in short period.
thanks!
Hi,
Thank You!:blush:Quote:
Originally Posted by carlwhat
Actually there is no point including pings to ask.com and yahoo anymore. Ask.com no longer accepts submissions, which is why the ping would fail. Ask.com expects to locate your sitemap file via the appropriate information in your robots.txt file. Yahoo no longer accepts pings. It uses Microsoft/Bing now.
Sorry, I did not understand this remark. This is an old well-known information. In sitemapXML these systems not ping a long time.Quote:
Originally Posted by lloyd_borrett
I was responding to an earlier post where the person was asking why those pings weren't working. I should have quoted parts of it.Quote:
Originally Posted by a_berezin
But Sitemap XML still makes references to Ask on its Tools page.
Many thanks for the great plugin Andrew.
Oh! Yes, forgot to remove. (: Thanks, will fix!Quote:
Originally Posted by lloyd_borrett
Hello Andrew,
I receive the following error when I ping - is there something I need to do?
XML Parsing Error: junk after document element
Location: http://www.mothersdayaustralia.net.a...=yes&ping=yes&
Line Number 16, Column 16:</sitemapindex><h3>Ping</h3><h4>Ping Google</h4>http://www.google.com/webmasters/sitemaps/ping?sitemap=http%3A%2F%2Fwww.mothersdayaustralia.net.au%2Fsitemapindex.xml<br /><div style="background-color: #FFFFCC); border: 1px solid #000000; padding: 5px">Sitemap Notification Received<br />
---------------^
thank you,
Mike
G'day,
It seems that Sitemap XML generates entries for categories and manufactures that have no active products and 1 active product.
The problem is that the URL put into the sitemap is never shown by Zen Cart. If there is only 1 product, Zen Cart redirects to the product info page for the product.
My thinking is that it's not good SEO to have URL entries being put into sitemaps that will generate redirects. It might be better if the URLs are only put into the sitemap if there are two or more products and the URL will be displayed. Alternatively, Zen Cart should still show the category listing or manufacturer list pages even if there is zero or one product.
Best regards, Lloyd Borrett.
sitemapXML does not show up in admin->Tool?
my ZC version is 1.5.3
never mind. evidently, i didnot upload properly.
Anybody put this on a ZC154 yet?
Also, when I searched to find this mod, I noticed another mod for adding EZpages to sitemap:
https://www.zen-cart.com/search.php?searchid=3475836
I thought EZpages automatically showed up! Do I need that additional mod to get my EZ stuff to list?
Thanks!
I'm using the plugin successfully under ZC1.5.4. No need for the additional plugin, the current version of sitemapxml (v 3.2.12 19.09.2013 8:06:18) includes an ezpage sitemap.
Most excellent, thanks!
It works fine in 1.5.4, and it also includes ez-pages. I think the mod you mentioned was for older/other versions of this modQuote:
Originally Posted by Feznizzle
Thanks!Quote:
Originally Posted by Design75
I have another question.
SITUATION
I am building two websites. The sites sell different products, but are owned/run by the same company. I need them to look and perform exactly the same. Each will have the same template and all the same mods, only site content will differ (products, etc).
To accomplish this, I am building a master site first: http://justmedicalequipment_DOT_com
Once that site is fully modded and looking right, I will download a copy and upload it to the other domain, import/mirror sql, then go tweak the configure.php files.
QUESTION
Are there any store-unique/domain code changes or database entries made by this mod that I will have to change?
For instance, I just installed Ceon URI. In the htaccess file, the name of my domain has been inserted and I will have to change that on my other domain.
BTW, I will not be turning/using on SE communications until after the template site is on the new domain, then I'll come back and set up Google Webmaster accounts for both and activate the SE notification widget.
Thanks!
Also, I just noticed a folder under /includes/languages/ for Russian, and another under admin. I've had enough problems with Y-a-n-d-e-x disobeying robot.txt and being a resource hog that I have used my htaccess to exclude that bot. Since I will not be selling into Russia, can I safely remove those folders?
Yes, the Russian language folders can be safely removed if your store isn't "speaking" Russian.
Just installed sitemap xml version v 3.2.12 on zencart 1.54. Everything looks ok: appears in config and tools. Here is the problem: When I try to generate the sitemap I immediately get this error: News Box Manager Sitemap
WARNING: An Error occurred, please refresh the page and try again.
Does anybody have a suggestion on how to fix this. If more info is required it will be happily supplied.
When you receive the message WARNING: An Error occurred, please refresh the page and try again., that implies that you've got a debug-log file waiting in your store's /logs folder (ZC 1.5.1 and later; /cache folder for earlier versions) that indicate the source of the error. Since the issue occurred during admin-level processing, make sure to xxx-out your admin folder's name before posting the contents!Quote:
Originally Posted by fjbern1943
It would also help to know which version of the News Box Manager plugin you've got installed.
Hi,
I do not know if it is related to sitemapXML (I do not think so) but I do not know were to ask.
The problme is very simple Google is not oindexing my ezpages.
What could I do?
Were to start from?
Attachment 15418
By the way there are not errors as per google assesment
Attachment 15419
Ciao from Italy
G'day,
There is a spelling mistake on the Sitemap XML configuration page. "Check Dublicates" not "Check Duplicates".
Best regards, Lloyd Borrett.
G'day,
Is there any way to control how the <priority> values are assigned within the XML sitemaps?
It seems the add-on just generates priority values of between 1.0 and 0.1 for each sitemap type. We have no way to say which pages actually are, or aren't, important to us.
Of course the homepage gets priority 1.0.
Obviously on a large site, manually setting the all priority values would be tedious. But being able to set priority values for the important things would be fine, then let the add-on assign priority values for those not set.
It might also make sense to be able to specify a range of priority values allowed for each sitemap type. I think restricting the priority values for each sitemap type along the following lines would be good:
Products: 1.0 to 0.8
Manufacturers: 0.8 to 0.6
Categories: 0.6 to 0.4
Reviews: 0.5 to 0.1
EZPages: 0.4 to 0.1
Testimonials: 0.6 to 0.4
News Articles: 0.6 to 0.4
But just being able to specify this as a config option allows people to have what they want. Or leave it blank and get what's happening now.
Best regards, Lloyd Borrett.
I must have missed something I get a blank page for my site map Using 1.5.4
Quote:
Originally Posted by adb34
That error actually has noting to do with this module. This module is for the Search engines, and the page you are referring to is for the people visiting your site.
A partially white page means you have a Errorlog file in your logs folder.
Good. I will have to dig in my log files and find out what is going on. Thanks for the info.Quote:
Originally Posted by Design75
Hi
I am using v1.5.4 and am failing at getting the sitemapXML.21 to work. I have checked and rechecked the files....and reinstalled.
In admin under tools, I have sitemap but it doesnt say install and just goes to a blank page. There is no sitemap listed under configuration.
I checked the logs -
PHP Warning: mysqli_connect(): Headers and client library minor version mismatch. Headers:50537 Library:50623 in /home/pet/public_html/includes/classes/db/mysql/query_factory.php on line 62
which reads
$this->link = mysqli_connect($zf_host, $zf_user, $zf_password);
Really don't know what to do next.....Thanks
This warning usually indicates your hosting environment has some issues regarding the way PHP / MySQL were compiled. This is NOT Zen Cart or SiteMap XML related and will require attention from the server administrator. Time for a support call to the hosting provider regarding this PHP Warning.Quote:
Originally Posted by christinefred
Back on topic, are there any myDEBUG-adm-* files (admin side PHP error and warning log file)? What is the URL of the "blank page" (if inside the admin, replace the admin folder with "mysecretadmin" when posting)? What is the "blank page" HTTP response code (ex: 200, 404, 500 - use the network tab in firebug or developer tools)? Are there any server error logs?
lhungil,
Thanks for support! :DQuote:
Originally Posted by lhungil
Thanks so much... Went into the debug files and found the missing file. All working now!
What file was missing?Quote:
Originally Posted by christinefred
Greetings All,
Just install latest ver (v 3.2.13 20.08.2015 11:14:48) on ZC 154. All seems to be working, xml files created, except when I enter the index.php?main_page=sitemapxml&inline=yes&token=xxxx parameter in Google Webmaster Sitemap Tester.
BTW, I've substituted the actual domain with your_domain since I am also using a security token.
Example: http://your_domain/index.php?main_pa...yes&token=xxxx
Google Sitemap Tester returns:
Parsing error
We were unable to read your Sitemap. It may contain an entry we are unable to recognize. Please validate your Sitemap before resubmitting.
When I enter manually in Firefox, I receive the following error:
XML Parsing Error: XML or text declaration not at start of entity
Location: http://www.your_domain/index.php?mai...yes&token=xxxx
Line Number 1, Column 2: <?xml version="1.0" encoding="UTF-8"?>
-^
When looking at the page source in Firefox, I notice that the xml file is correct except for the closing tag is incomplete. Not sure if this is the only issue.
</sitemapindex
If I submit and test the sitemap.xmp from the root directly, all is correct with NO errors.
Has anyone else experienced this? Any suggestion?
Thanks :D
I just tried it on mine. The only difference is I am running version:
3.2.12 19.09.2013 8:06:18
So, I looked more closely at the error from FF. It seems that there is a white space before the opening declaration.Quote:
Originally Posted by lruskauff
<?xml version="1.0" encoding="UTF-8"?>
^
If I save the page source and remove the space, then reopen it in FF, no error! The problem is I can't seem to find were in the sitemap code this space is being introduced? The root sitemap.xml doesn't have this issue...
I looked at the function _SitemapXMLHeader() in the sitemapxml.php class where the first lines are:
No white space here, but some how when the $header is returned and sent back to the browser, there is a space???:shocking:PHP Code:function _SitemapXMLHeader() {
$header = '';
$header .= '<?xml version="1.0" encoding="UTF-8"?'.'>' . "\n";
What do you think?:blink:
I would download the previous version and do a quick file compare using win merge or beyond compare. Hopefully it will pop right out.
The latest update is only updated for the author's own commercial product. There is no reason to use this version unless you are using this commercial product. IMHO ist should not even have been added to the code. He did not document it in the readme, and never ever made a comment in this thread.Quote:
Originally Posted by lruskauff
This is not a SitemapXML problem. Check language and all extra files. I wrote a script that is looking for extra spaces in PHP files. It helps to detect bad files. You can download it https://goo.gl/88MtW2/ Unzip, upload to cart root directory and start it - http://your_domain/found_extra_space.phpQuote:
Originally Posted by kwright
Thanks a_berezin,Quote:
Originally Posted by a_berezin
Ran your script and found the following files had space at the end:
template_default/sitemapxml/html_header.php
template_default/common/html_header.php
However, both files have this comment at the bottom, followed by 2 new lines:
<?php // NOTE: Blank line following is intended: ?>
Just for a test, I removed the extra line form both files. Made no difference.
Again, here is the output from the inline=yes parameter: Notice the space before the opening tag.
Here's the content of the root sitemap.xml for comparison:HTML Code:<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="/includes/templates/template_default/css/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/sitemap/0.9/siteindex.xsd"
xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
<!-- generator="Zen-Cart SitemapXML" 3.2.13 20.08.2015 11:14:48 -->
<!-- sitemap.xml created at 2015-09-18 08:12:38 -->
<sitemap>
.
.
.
</sitemapindex>
What file(s) has the fix for the inline=yes that was mentioned in the plugin history?HTML Code:<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="/includes/templates/template_default/css/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/sitemap/0.9/siteindex.xsd"
xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
<!-- generator="Zen-Cart SitemapXML" 3.2.13 20.08.2015 11:14:48 -->
<!-- sitemap.xml created at 2015-09-18 08:12:38 -->
<sitemap>
.
.
.
</sitemapindex>
Thank you!
Hi,
So the problem is more complicated than I had hoped. :(Quote:
Originally Posted by kwright
This is a joke? Of course I do not remember that corrected a few years ago.Quote:
Originally Posted by kwright
Have you checked the error logs? There is nothing?
There are no errors. My guess this is because the file is created successfully, it just fails in the browser & Google sitemap test because it is malformed due to the xml file starting off with a space...Quote:
Originally Posted by a_berezin
You do not hear me. It is not sitemapxml problem, the problem somewhere else. It is necessary to search.Quote:
Originally Posted by kwright
You can check a clean install 1.5.4 with sitemapxml - http://test15.zen-cart.zz/index.php?...yes&token=xxxx
Check the source code of your default page http://your_domain/ - have any white space at the beginning?
Try to disable gzip compression.
Finally got around to troubleshooting this. Turns out, when I added an extra ob_end_clean() to this statement within the sitemapxml.php class, it fixed my issue.Quote:
Originally Posted by a_berezin
Seems as if there was an extra white space getting into the buffer. Maybe on_start() was getting call twice before hitting the first ob_end_clean()?PHP Code:if ($this->inline) {
if ($this->submitFlag) {
ob_end_clean();
ob_end_clean();
$this->_outputSitemapIndex();
} else {
ob_end_flush();
}
}
Anyhow, inline is now working for me! :D
Thank you very much for making this plugin.
I am running ZC v1.5.4 and I just installed this plugin for the first time. I think I did everything correctly, however, the site map on the root is completely blank. There are site maps found for Categories, EZ pages, Products, Manufactures, and the main page. All of these are full of URLs. But the one found at example.com/sitemap.xml is completely blank. Can you please point me in the right direction?
Hi,
1. Check file permissions /sitemap.xmlQuote:
Originally Posted by JoeToys
2. Check error log files in /logs/ directory
Hello everyone,
Just did a clean install of Zen-Cart 1.5.4 and installed Sitemap XML (version 21 and Module version 3.2.13). However, no matter how I set up the includes/classes/sitemapxml.php file..., I can only create a maximum of about 12,500 products in my sitemapproducts.xml file. (I actually have around 30,000 products)
Also my php.ini file seems to have enough memory and execution time..., and also does change anything.Quote:
define('TABLE_SITEMAPXML_TEMP', DB_PREFIX . 'sitemapxml_temp');
define('SITEMAPXML_MAX_ENTRYS', 5000);
define('SITEMAPXML_MAX_SIZE', 10000000); // 10485760
define('SITEMAPXML_CHECK_URL', 'false');
Here is the result I get in my Sitemap File List:Quote:
max_execution_time = 300
max_input_time = 180
memory_limit = 512M
Attachment 15859
Here is the result after forcing a rebuild:
(however I have over 800 categories, not 640, unless not all of the categories are showing up because not all of the products are being listed)
Attachment 15861
Here is the result of my log file:
Any ideas? Anyone?Quote:
[11-Dec-2015 08:52:43 America/Chicago] PHP Fatal error: 2008:MySQL client ran out of memory :: select products_type from products where products_id = '12441' ==> (as called by) /home4/oskopool/public_html/includes/functions/functions_lookups.php on line 522 <== in /home4/oskopool/public_html/includes/classes/db/mysql/query_factory.php on line 155
[11-Dec-2015 08:52:43 America/Chicago] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total
from sessions
where sesskey = '147d0a2b7e06aa68ea26b7ce12d9f9fd' ==> (as called by) /home4/oskopool/public_html/includes/functions/sessions.php on line 66 <== in /home4/oskopool/public_html/includes/classes/db/mysql/query_factory.php on line 155
Thanks all,
Danny
Hi,
I recently ran into this situation on site with 30,000 products. The reason - the query caching. Write to me in private, I'll send you the latest version.Quote:
Originally Posted by danielosko
Thanks Andrew!!!
I appreciate it very much. I PM'd you
Danny
I just want to say thank you for this awesome plugin and all your work here in the forum. I got SitemapXML installed and functioning with all the help here. My biggest problems were an error in my config file and expecting the updates to Cpanel to be immediate - sometimes it takes a few seconds. In the meantime it was throwing errors at me. :smile:
Thank you so much!
Andrew, could you please pm me a copy of the latest version or upload it to the Plugins?Quote:
Originally Posted by a_berezin
Thanks / Frank
Hi Frank,
Upload last version to the Plugins.Quote:
Originally Posted by frank18
Quote:
Originally Posted by a_berezin
Thanks Andrew! Much appreciated.
Hi,
Thanks!Quote:
Originally Posted by Michigan Flower Farm
Happy New Year! :)
I look forward to feedback - bugs, suggestions, comments...Quote:
Originally Posted by frank18
andrew,
i had basically no problems with the install... i had to modify a few things due to my cart and other mods, but so far so good....
HOWEVER, i wanted to point out something that just caused me some problems.... and in my opinion very needlessly...
part of the install process has a file called:
-install-sitemapxml.php
now i suppose you have your reasons why you would want a file to start with a dash, ie '-' perhaps you would care to share them? it causes problems if one is attempting to execute a shell command from the directory where that file is.
frankly, i would rename that file so that it does not begin with a dash.
best.
hi
Because I feel so comfortableQuote:
Originally Posted by carlwhat
You can rename, delete, and do whatever you want with all these files.Quote:
Originally Posted by carlwhat
Hi.
Thanks for this Sitelink but it made me too good work :D
I installed another language in my site and need the English language
not to be seen.
After generating this Sitemap files, I suddenly saw that it sends google also
the english pages which should not be found.
What can I do to hide them ?
Can I change the submitted files in this module ?
Should I do it in Robots.txt ?
Maybe to delete the English language through Admin otherwise the sitemap will always
see the English pages ?
Thanks in advance...
Hi,
What is "Sitelink"?Quote:
Originally Posted by gunni
If English is not necessary - delete it.Quote:
Originally Posted by gunni
Not found??? Or empty?Quote:
Originally Posted by gunni
Thanks for your prompt reply and sorry for the mistake.Quote:
Originally Posted by a_berezin
I meant sitemap of course and meant that I dont want sitemap to find English pages.
So I understand that I can delete English language from admin panel.
What about the files on the server in /language/english ?
I do not want sitemap to submit any English page to google...
Thanks.
hi Guys,
the sitemapXML is not showing up in admin configuration.
I copied the files into the shop but dont know where to find the sql file which i should upload under tools, install sql patches.
I only find an -install-sitemapxml.php file in the admin folder.
i have a freshinstall of zencart v1.5.4 with dbase update from older version.
SitemapXML Version Date v 3.3.2 02.12.2015
Did you complete step 5.1. from the install instructions in the Readme file?Quote:
Originally Posted by aurelius
Code:5.1. If your are running Zen-Cart 1.5.x. Run install-sitemapxml_only_for_zen-cart-1_5_0.sql (If you are running Zen Cart 1.3.9, SKIP THIS STEP!)
Hi, in the case of having a Wordpress blog in a sub-directory (http://store.com/wordpress) will this mod also include those pages in the sitemap?
fixed, not sure what happened.
Hi.
Could not find a solution although people wrote about it.
My problem is about the site map that is shown to the visitors and should help them
to navigate easier in the site.
This sitemap page is in EZ pages but the map there is not updated.
It is shown at http://my_domain/index.php?main_page=site_map
How can I make it auto updated ?
I have ZC 1.5.4 and I installed SitemapXML v 3.3.2 (the latest I think).
@gunni this thread is not for the site_map page. Is for Google Sitemap XML, a different one.
Try using the module improved site map https://www.zen-cart.com/downloads.php?do=file&id=660