Ultimate SEO v3 (and v2.200) [Support Thread]

[Kcm75]

Zencart 1.5.1 and Ultimate SEO v2.200

[lhungil]

Zencart 1.5.1 and Ultimate SEO v2.200

Please upgrade to the latest version of Ultimate URLs (and apply any relevant patches for the latest version from this thread).

After the upgrade reset the cache using the Zen Cart administrative interface.

That said, if the hosting provider's MySQL server is slow (or having issues) you may see some entries like the one posted. In this case changing the settings for the cache may be beneficial.

[Kcm75]

In my test store I upgraded to zencart 1.5.3 and zencart 2.212.

The first litle problem I am having is, that I cannot use the "admin configuration" with my dutch language.
I copied the english file into my dutch folder:
public_html/nieuw_test/admin/includes/languages/dutch/extra_definitions/seo.php

It uses define('SEO_CONFIGURATION_GROUP_TITLE', 'Ultimate SEO'); in the main admin-configuration menu, but when it shows the SEO option, all the texts are blank like below:

[lhungil]

Have you run the installation again after copying the language file?

[Kcm75]

Thanks! That did it :)

Ready for today and testing again tomorrow.

[lhungil]

Awesome!

[Kcm75]

Please upgrade to the latest version of Ultimate URLs (and apply any relevant patches for the latest version from this thread).

After the upgrade reset the cache using the Zen Cart administrative interface.

That said, if the hosting provider's MySQL server is slow (or having issues) you may see some entries like the one posted. In this case changing the settings for the cache may be beneficial.

Still having "duplicate entry" problem. This only occurs when an Admin is adding or edditing a product to the database using the zencart interface AND someone else is browsing the website at the same time. The user browsing the store generates the error and sees in his browser: WARNING: An Error occurred, please refresh the page and try again.

The log file shows:
PHP Fatal error: 1062uplicate entry '4c8c09ec83152a7da27516b6c5234f27-2' for key 'PRIMARY' :: insert into zen_seo_cache

What kind of caching settings could be changed to prevent the error?


One other problem keeps coming back in my log files, but I don't now if this has to do with this plugin.
PHP Warning: mysqli_connect(): (HY000/2013): Lost connection to MySQL server at 'sending authentication information', system error: 32 in /home/picto/public_html/includes/classes/db/mysql/query_factory.php on line 62

[semide]

I have an issue with Ultimate Seo URL's. I have a cart that was fine until this weekend, when we made some changes to some categories. Now, some categories return a blank page:

https://www.b e l m e t r i c .com/index.php?main_page=index&cPath=15_147_1158

Sub-categories and products show up in admin, but links to them fail in the store with a white screen. Searches for model do work ("cm8ss")

Any ideas?

(Z 139h, UltSeo 212)

[lhungil]

... One other problem keeps coming back in my log files, but I don't now if this has to do with this plugin.
PHP Warning: mysqli_connect(): (HY000/2013): Lost connection to MySQL server at 'sending authentication information', system error: 32 in /home/picto/public_html/includes/classes/db/mysql/query_factory.php on line 62

This indicates a problem with the communication between the PHP and MySQL (and you are correct - it is not this plugin - unless something was not merged quite right). Under Zen Cart 1.5.3 common causes are: calls in PHP to functions starting with "mysql_" (do a search of all files), the site being hosted on an overloaded shared server, maintenance on the server hosting the site, other software / hardware issues with the hosting environment.

... The log file shows:
PHP Fatal error: 1062uplicate entry '4c8c09ec83152a7da27516b6c5234f27-2' for key 'PRIMARY' :: insert into zen_seo_cache ...

For more details see this post. Usual cause is a slowly performing database write (with a multi-threaded PHP configuration).

... What kind of caching settings could be changed to prevent the error? ...

Turn off the individual SQL caches (product, category, manufacturers, ez-pages). This way Ultimate URLs will not attempt to keep SQL based caches for those items (so no read / write from seo_cache).

[lhungil]

... Now, some categories return a blank page ... Any ideas? ...

Can you post your .htaccess file (Be kind; Use "code" tags around the contents of the .htaccess file when you post. These can be added by clicking on the # sign while creating / editing a reply.) Can you also post the contents of any "debug" logs (also inside "code" tags)?