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

Zencart 1.5.1 and Ultimate SEO v2.200

Kcm75:

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.

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:

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

Thanks! That did it :)

Ready for today and testing again tomorrow.

Awesome!

lhungil:

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: 1062:Duplicate 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

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)

Kcm75:

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

Kcm75:

... The log file shows:
PHP Fatal error: 1062:Duplicate 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).

Kcm75:

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

semide:

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

Thx for the info lhungil. I seems like most of the problems could be at my hosting provider :(

Kcm75:

Thx for the info lhungil. I seems like most of the problems could be at my hosting provider :(
Perhaps... But if I was seeing that message alot, I would probably just disable those caches (not the global cache) in version 2.212 of this module. While the individual caches save a few SQL Queries and calculations, on most hosts I have seen a negligible performance effect.

One site on my server has started this as well. Server is not overfull but running php 5.3 still since too many customers have not upgraded yet. Any hints to what I could look at server wise that could create this problem?

Hi
I'm testing ultimate seo, all looks well, but I have a question: Is it possible to change the contact_us, specials, etc... to my own language ?
Thanks

Installed Ultimate SEO 2.212 Final to Zen-Cart 1.5.1 with no errors. Configured, enabled, reset cache, uploaded .htaccess, but nothing happened. Still old urls with existing products. Please advice. Thank you.

mesnitu:

Hi
I'm testing ultimate seo, all looks well, but I have a question: Is it possible to change the contact_us, specials, etc... to my own language ?
Thanks
Not at this time with Ultimate URLs as those are the physical names of the Zen Cart "pages". Ultimate URLs at this time only supports "rewrite" mode, where the URL still contains everything necessary (without a database query) for translating to an internal Zen Cart URL. The physical page names such as "contact_us", "specials", etc are required by Zen Cart to know what "page" to show to a website visitor.

One "could" alter the behavior (I would not recommend it at this time) by:

• Altering the href_link() function in Ultimate URLs to change the names returned.
• Altering the ".htaccess" file to understand how to handle the changed names.

ksivv:

Installed Ultimate SEO 2.212 Final to Zen-Cart 1.5.1 with no errors. Configured, enabled, reset cache, uploaded .htaccess, but nothing happened. Still old urls with existing products. Please advice. Thank you.
So the module is enabled and the "installer" reported success during step 5 of the installation instructions? (Click on any link in the admin interface ...)

If the above is true and you are seeing the stock Zen Cart product URLs, the usual causes are: a skipped / forgotten core file modification, some files did not upload correctly, or the setting for "Enter pages to allow rewrite" is not quite right.

Have you added any custom product types to Zen Cart? Are there any "debug logs"? Have you tried walking through the entire installation process a second time?

Thank you for response. Just tried to reinstall - same result - success, but nothing happened. Didn't added anything, just plain products using EP. No debug log since EP product upload (24 hours ago).

thanks !
I'm using the ceon, and I already have a lot of links spread in the net, categories, etc... But I'm about to use the bookx modules for books, and until now the only, the ultimate seo was the only one that handled the new product type product info automatically .... but having a contact_us etc in English... it doesn't make much sense for my language....
So I was looking for a way to make this transition without being penalize in the search engines, and having all those not found pages in the site.... but I guess, it's going to be difficult.

ok , Thanks

mesnitu:

thanks !
I'm using the ceon, and I already have a lot of links spread in the net, categories, etc... But I'm about to use the bookx modules for books, and until now the only, the ultimate seo was the only one that handled the new product type product info automatically .... but having a contact_us etc in English... it doesn't make much sense for my language....
So I was looking for a way to make this transition without being penalize in the search engines, and having all those not found pages in the site.... but I guess, it's going to be difficult.

ok , Thanks

As is the case with all plugins, one should check the applicable forum thread to resolve an issue. I don't want to discuss the issue further in this thread, but if I understnd correctly it is possible to accomplish what you are trying to do without the loss that is your other concern.