SitemapXML v.2

[jeking]

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.

[a_berezin]

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/si...roducts007.xml - It's not finished.

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

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

[fjbern1943]

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

I see a problem with the http://religious-shop.com/sitemap/si...roducts007.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

[a_berezin]

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...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.

[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?

[a_berezin]

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

[Nick1973]

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.

[a_berezin]

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.

[swguy]

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.

[Nick1973]

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.