SitemapXML v.2

Renz:

I have the M1 seo url rewriter.
M1 seo url don't work with zen_href_link(). I am not aware of open ways to work with their system.

Hello All,
Since I just added another 8,500 products, (for a total near 30,000 products), it seems as though now the server does not have enough memory for the program to finish running.

Here is the error I get in the sites cache folder:
[11-Feb-2014 05:37:27] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in /home4/oskopool/public_html/includes/classes/sitemapxml.php on line 394

Here is the result in my admin panel:

My php.ini file is already maxed out at 256mb.

Is there any "work around" for this?

Using the latest sitemapXML plugin and Zencart 1.50

Any help is greatly appreciated.

Thanks,
Danny

Hi

danielosko:

Hello All,
Since I just added another 8,500 products, (for a total near 30,000 products), it seems as though now the server does not have enough memory for the program to finish running.

Here is the error I get in the sites cache folder:
[11-Feb-2014 05:37:27] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in /home4/oskopool/public_html/includes/classes/sitemapxml.php on line 394
Try to set Configuration -> SitemapXML -> "Check Dublicates" = false

Hi Andrew,

It is set to false, but there is no difference. The only way HostGator will allow me more memory is if I pay more for VPS hosting.

Any other thoughts?

Thanks,
Danny

Hi Danny,

danielosko:

It is set to false, but there is no difference. The only way HostGator will allow me more memory is if I pay more for VPS hosting.

Any other thoughts?
You can try to play with the parameters SITEMAPXML_MAX_ENTRYS and SITEMAPXML_MAX_SIZE.
They are defined in the file includes\classes\sitemapxml.php (lines 15-16):

define('SITEMAPXML_MAX_ENTRYS', 50000);
define('SITEMAPXML_MAX_SIZE', 10000000);

for example, for starters, you can try the following values:

define('SITEMAPXML_MAX_ENTRYS', 500);
define('SITEMAPXML_MAX_SIZE', 100000);

If it works, then it is to find the optimal value.

I know this is really cheeky, but, I don't understand how to do this. Can anybody help? Please?
Ailla

The Sacred Wheel:

I know this is really cheeky, but, I don't understand how to do this. Can anybody help? Please?
Ailla

what to do?

a_berezin:

what to do?
Hi Andrew
I downloaded the add on, but, don't really understand how to upload it to my site. Please help.
Ailla

Hi Andrew
I've read through the thread and other information about sitemaps. I'm just not clear which files from the add on bundle to put where on my site. Are there any clear, simple instructions anywhere? I tried it once and crashed my site, I got it back though, so not a big problem. I just need someone to help me out, please.
A

Hi,

The Sacred Wheel:

Hi Andrew
I've read through the thread and other information about sitemaps. I'm just not clear which files from the add on bundle to put where on my site. Are there any clear, simple instructions anywhere? I tried it once and crashed my site, I got it back though, so not a big problem. I just need someone to help me out, please.
A
Sorry, but to tell you more than is wrote in the readme.txt I can't.

OK so installed the add on, and now get this....
"SiteMapXML (SITEMAPXML_VERSION)

Categories Sitemap
Can not create file "/home2/thesacre/public_html/SITEMAPXML_DIR_WS/sitemapcategories.xml". You may need to use your webhost control panel/file-manager to change the permissions effectively.

Ezpages Sitemap
Can not create file "/home2/thesacre/public_html/SITEMAPXML_DIR_WS/sitemapezpages.xml". You may need to use your webhost control panel/file-manager to change the permissions effectively.

Mainpage Sitemap
Can not create file "/home2/thesacre/public_html/SITEMAPXML_DIR_WS/sitemapmainpage.xml". You may need to use your webhost control panel/file-manager to change the permissions effectively.

Manufacturers Sitemap
Can not create file "/home2/thesacre/public_html/SITEMAPXML_DIR_WS/sitemapmanufacturers.xml". You may need to use your webhost control panel/file-manager to change the permissions effectively.

Products Sitemap
Can not create file "/home2/thesacre/public_html/SITEMAPXML_DIR_WS/sitemapproducts.xml". You may need to use your webhost control panel/file-manager to change the permissions effectively.

Reviews Sitemap
Can not create file "/home2/thesacre/public_html/SITEMAPXML_DIR_WS/sitemapreviews.xml". You may need to use your webhost control panel/file-manager to change the permissions effectively.

Sitemap Index
URL - http://www.thesacredwheel.com/SITEMAPXML_SITEMAPINDEX.xml
Written 0 items (15 bytes), Filesize: 15 bytes

Total: Execution Time 0:0.1470, DB Queries 28, DB Queries Time 0.045."

I did change permissions to 777. I'm using cPanel and Filezilla. Can you tell me what I'm doing wrong?
Thanks
A

The Sacred Wheel:

OK so installed the add on, and now get this....
"SiteMapXML (SITEMAPXML_VERSION)
You have not installed the add on. Why you don't read readme-sitemapxml.txt?

Sorry, I thought I did, the files are certainly in my root directory. I'm using 1.5.1 so just uploaded the patch rather than copy and paste, would that be the problem?

The Sacred Wheel:

Sorry, I thought I did, the files are certainly in my root directory. I'm using 1.5.1 so just uploaded the patch rather than copy and paste, would that be the problem?

a_berezin:

Why you don't read readme-sitemapxml.txt?

I can't help you.

Andrew,

FOUR TIMES NOW I HAVE MADE THIS POST WITH NO RESPONSE !!!!!! NOT HAPPY ... is there a reason you will not respond? Have I offended you?

Sitemap XML version v 3.2.6 17.06.2012 16:13 on site version v1.3.9h ..... IMAGES are NOT being submitted - anything I should be looking at?? (urls are being submitted but not images).

cheers,
Mike

Hi Andrew
I'm very sorry that you have decided not to help me. I've spent 24 hours on this now, and, still haven't been able to make the add on work. I have read all 145 pages and the readme which comes with the add on. The instructions are obtuse and unclear, and, certainly not written for anyone using cPanel. FYI I'm a physician and therefore not intrinsically stupid, however, I'm the first to admit I have very little technical knowledge.

It is very unfortunate, that the effort you have put into developing the add on, is diluted by its inaccessibility to anyone other than your technically skilled cronies. It might behoove you to share you knowledge with others in order to enable the less skilled to improve their knowledge base and make you use of your offerings.

It defeats me why you are here, if you are only willing to help those who are able to read your technical mutterings.
Regards
Dr A Denesovych

The Sacred Wheel:

Hi Andrew
I'm very sorry that you have decided not to help me. I've spent 24 hours on this now, and, still haven't been able to make the add on work. I have read all 145 pages and the readme which comes with the add on. The instructions are obtuse and unclear, and, certainly not written for anyone using cPanel. FYI I'm a physician and therefore not intrinsically stupid, however, I'm the first to admit I have very little technical knowledge.

It is very unfortunate, that the effort you have put into developing the add on, is diluted by its inaccessibility to anyone other than your technically skilled cronies. It might behoove you to share you knowledge with others in order to enable the less skilled to improve their knowledge base and make you use of your offerings.

It defeats me why you are here, if you are only willing to help those who are able to read your technical mutterings.
Regards
Dr A Denesovych

I have this working on 1.5 and 1.51 sites so I will see if I can help. But I need to know what version of the sitemap addon you are using so I can see if its the same one I used. First, it seems that your post on the results is showing this: SITEMAPXML_DIR_WS. This means that you are missing the defines for this which is actually caused by a file not being uploaded OR put in the wrong place. Second, was this a fresh new install or you tried to upgrade to the latest version?

I know you are using cpanel so maybe that is where things went wrong. To help me see where you went wrong, please tell me the steps you did to install? Such as did you rename your admin folder to yours before uploading? And did you install the SQL file in your admin--tools--sql patches?

To double check if all files were placed correctly, try and navigate in your cpanel to follow the same structure of files for the add-on. I suspect that a file or folder was not placed correctly or is missing. Let me know our results on what you find.

I finally figured out why the Sitemap was getting a memory exceeded error. I had a sub-category id which was the same as its master category id on 1 product out of 26,604 products. That was enough to crash the program. I fixed it and now everything works perfectly.

Danny

Hi Danny,

danielosko:

I finally figured out why the Sitemap was getting a memory exceeded error. I had a sub-category id which was the same as its master category id on 1 product out of 26,604 products. That was enough to crash the program. I fixed it and now everything works perfectly.
Not sure that I understood you correctly. Can tell you more about the situation with ID's? If you can, with examples.

Sure,

Since I have so many products, (over 26,000), I use MS Excel for my data base and convert the files to .CSV files and then upload these files to my php/SQL server. The files I up load are Manufacturers, Categories, Categories Description, Products, Product Descriptions and Products to Categories.

This gives full control of my products and makes mass uploads easier.

So here is an example of my error in excel, which I converted into .CSV and uploaded into the products.sql

Hope this clarifies things a bit.
Danny