SitemapXML v.2

Hello

Thank you for the form.

Greetings

Hi swguy,

swguy:

I had a strange situation I haven't seen myself before or in this thread: I installed SitemapXML locally and it worked like a charm. Installed it on the client's site and found that tools->Sitemapxml would only display the form to upgrade. Ran the upgrade and got the same results. Deleted SITEMAPXML_* entries from configuration and configuration_groups, went back into admin, same thing.

I fixed it by uncommenting line 14 in ./includes/modules/sitemapxml_install.php and setting it to the current version. Not sure what went wrong to get into this state though.

$current_version = '3.9.5';

Sorry, I missed this post :( You can explain in more detail what is not working for you - I can not understand.

Hello
You know why the sheet below generates an error HTTP 500 server error ?.

Anyone can help me?

No open admin administrator, closed store

config.sitemapxml.php

Best regards

CDGL

Hello,

My Setup: Sitemap.xml version 3.91, Zencart version 1.54

Getting strange results on last sitemapproducts.xml file. I have over 50,000 products in my store. When I rebuild all sitemaps the plugin produces the sitemapproducts.xml, 001, 002 etc. to 006 files without a problem but when it gets to sitemapproducts007.xml It says, under Type, "undefined!!!". Also the sitemap.xml file does not list the sitemapproducts007.xml file. No error logs ???????????

Anybody run into this problem?

Frank

Hi,

fjbern1943:

Hello,

My Setup: Sitemap.xml version 3.91, Zencart version 1.54

Getting strange results on last sitemapproducts.xml file. I have over 50,000 products in my store. When I rebuild all sitemaps the plugin produces the sitemapproducts.xml, 001, 002 etc. to 006 files without a problem but when it gets to sitemapproducts007.xml It says, under Type, "undefined!!!". Also the sitemap.xml file does not list the sitemapproducts007.xml file. No error logs ???????????

Anybody run into this problem?

Frank
Link to your sitemapxml? If you are shy - write in private

Hi,

CDGL:

Hello
You know why the sheet below generates an error HTTP 500 server error ?.

Anyone can help me?

No open admin administrator, closed store

config.sitemapxml.php

Best regards

CDGL
Check the logs in the /logs directory

a_berezin:

Hi,

Link to your sitemapxml? If you are shy - write in private

Sitemap Link - http://religious-shop/sitemap.xml

You will notice that there is no sitemapproducts007.xml listed but it exists but shows error as stated above and is not formatted correctly.

Thanks for your help.

Frank

a_berezin:

Hi,

Check the logs in the /logs directory

Hello

Do not understand in the logs what to do?

In this folder what's wrong?

If someone offers me to address the solution or I can even give credentials to access the store if it's complicated.

I look forward to your reply.

Best regards

CDGL:

Hello

Do not understand in the logs what to do?

In this folder what's wrong?

If someone offers me to address the solution or I can even give credentials to access the store if it's complicated.

I look forward to your reply.

Best regards

@CDGL PM sent.

fjbern1943:

Sitemap Link - http://religious-shop/sitemap.xml

You will notice that there is no sitemapproducts007.xml listed but it exists but shows error as stated above and is not formatted correctly.

Thanks for your help.

Frank
Maybe this url - http://religious-shop.com/sitemap.xml? :)

I see a problem with the http://religious-shop.com/sitemap/sitemapproducts007.xml - It's not finished.

1. How do you run the sitemap script? cron cli?

2. Check the error logs in the /logs directory.

a_berezin:

Maybe this url - http://religious-shop.com/sitemap.xml? :)

I see a problem with the http://religious-shop.com/sitemap/sitemapproducts007.xml - It's not finished.

1. How do you run the sitemap script? cron cli?

2. Check the error logs in the /logs directory.

1. I run the script from admin tools.
2. Here is an error:

[22-Jun-2017 18:51:45 UTC] Request URI: /admin/sitemapxml.php, IP address: 72.78.229.223
#1 mysqli_real_escape_string() called at [/home/religiousshop/public_html/includes/classes/db/mysql/query_factory.php:115]
#2 queryFactory->prepare_input() called at [/home/religiousshop/public_html/includes/classes/db/mysql/query_factory.php:496]
#3 queryFactory->prepareInput() called at [/home/religiousshop/public_html/admin/includes/functions/database.php:108]
#4 zen_db_input() called at [/home/religiousshop/public_html/admin/sitemapxml.php:100]

[22-Jun-2017 18:51:45 UTC] PHP Warning: mysqli_real_escape_string() expects parameter 2 to be string, array given in /home/religiousshop/public_html/includes/classes/db/mysql/query_factory.php on line 115

3.What do you mean that the 007 file is not finished???? I noticed that it is not formatted correctly.

I changed the admin directory from the real one.

I hope the error sheds some light on the problem.

Thanks,

Frank

fjbern1943:

1. I run the script from admin tools.
2. Here is an error:

[22-Jun-2017 18:51:45 UTC] Request URI: /admin/sitemapxml.php, IP address: 72.78.229.223
#1 mysqli_real_escape_string() called at [/home/religiousshop/public_html/includes/classes/db/mysql/query_factory.php:115]
#2 queryFactory->prepare_input() called at [/home/religiousshop/public_html/includes/classes/db/mysql/query_factory.php:496]
#3 queryFactory->prepareInput() called at [/home/religiousshop/public_html/admin/includes/functions/database.php:108]
#4 zen_db_input() called at [/home/religiousshop/public_html/admin/sitemapxml.php:100]

[22-Jun-2017 18:51:45 UTC] PHP Warning: mysqli_real_escape_string() expects parameter 2 to be string, array given in /home/religiousshop/public_html/includes/classes/db/mysql/query_factory.php on line 115

3.What do you mean that the 007 file is not finished???? I noticed that it is not formatted correctly.

I changed the admin directory from the real one.

I hope the error sheds some light on the problem.

Thanks,

Frank

1. Try to start generating sitemap via cron cli, to remove the time limit.

2. Very strange error log. admin/sitemapxml.php:100 does not contain zen_db_input() - https://github.com/AndrewBerezin/zen-cart-sitemap-xml/blob/master/YOUR_Admin/sitemapxml.php Check the date and time the generation was started and the date / time when the error logs were created. They must coincide. Generating sitemap though it is launched from the admin, but it is executed on the front, so in the logs you should search for error messages in the store.

3. When I said that the 0007 file was not finished, I had in mind just this - the file is not finished, it does not have closing tags. This can happen in the event of an unexpected (abnormal) termination of the script. For example, due to time limits, due to lack of memory or other.

I have installed this on 1.5.5e

The install works fine, however in Tools > Sitemap XML I get the following screenshots:

If I click the button to upgrade, it does something but then the screen remains the same asking me to upgrade the database.

Can you help please?

Nick1973:

I have installed this on 1.5.5e

The install works fine, however in Tools > Sitemap XML I get the following screenshots:

If I click the button to upgrade, it does something but then the screen remains the same asking me to upgrade the database.

Can you help please?

PM me access to ftp

a_berezin:

PM me access to ftp

I can't do that as it is not my server, I would have to get permission. Can you not tell me what to do or try?

If not I will have to back the site up and come back to you with FTP to my personal server.

Nick1973:

I can't do that as it is not my server, I would have to get permission. Can you not tell me what to do or try?

If not I will have to back the site up and come back to you with FTP to my personal server.

I do not know these problems.
Try uninstalling the module and deleting all its files. Then download and install the latest version from the github.
More than anything I can not help.

a_berezin:

Hi swguy,

Sorry, I missed this post :( You can explain in more detail what is not working for you - I can not understand.

When I go to admin-tools-sitemap, I don't see the normal form that allows you to run the sitemap - all I get it the upgrade button.
I fixed this issue as noted above. Zen Cart 1.5.5e and 1.5.5a.

swguy:

When I go to admin-tools-sitemap, I don't see the normal form that allows you to run the sitemap - all I get it the upgrade button.
I fixed this issue as noted above. Zen Cart 1.5.5e and 1.5.5a.

Right, well tried downloading the GitHub version, installed it and the same issue occurred. Still seeing the Upgrade button rather than the tools to generate a sitemap. What was your fix SWGUY? If it's in the current version that is for downloading from Zen Cart Modules, then it isn't working for me.

Fix: https://www.zen-cart.com/showthread.php?126810-SitemapXML-v-2&p=1330192#post1330192

swguy:

When I go to admin-tools-sitemap, I don't see the normal form that allows you to run the sitemap - all I get it the upgrade button.
I fixed this issue as noted above. Zen Cart 1.5.5e and 1.5.5a.

I heard you. When I fix it- I will inform you.