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

I put :

pcre.backtrack_limit = 15000000
pcre.recursion_limit = 15000000

in my php.ini and the installation completed.

Interesting how useless was the discussion with my host (hostgator). Despite showing the error message they insisted they couldn't help me for security reasons. I think I will look for another one.

mecms:

I put :

pcre.backtrack_limit = 15000000
pcre.recursion_limit = 15000000

in my php.ini and the installation completed.

Interesting how useless was the discussion with my host (hostgator). Despite showing the error message they insisted they couldn't help me for security reasons. I think I will look for another one.

my experience tells me hostgator is not a very good host.... so not surprising....

this guy @barco57 says he hosts 1000s of ZC sites, is pretty active on the board and the ZC community. you might want to give them a shot at:

https://geekhost.ca/hosting.html

i have zero affiliation with them, and receive no financial benefit.

best.

mecms:

Hello, I'm trying to install Ultimate SEO URL on Zencart 1.5.5e and PHP 5.6

Is this possible? In my case:

1. I couldn't use the recommended method "Plugin Manager" as I couldn't find where to download it.
   I searched hard. Where do you get "Plugin Manager" from?

2. I couldn't use the alternate manual method either as I get this error:

"An error occurred while replacing / updating content in '/<base_dir>/myshop/<admin_dir>/categories.php'. Backtrack Limit exceeded. This usually indicates an overly conservative pcre.backtrack_limit configured on your server (or restricted by mod_security). Either change the setting or manually merge the required changes."

pcre.backtrack_limit is set to one million
my provider won't change the settings of mod_security

3. the last resort method (compare/merge) it's quite impractical (meaning too difficult for me) as the files provided with Ultimate SEO URL are for zencart 1.5.4 while I have 1.5.5e

Could somebody either:

• tell me where to get "Plugin Manager"
• tell me a trick to bypass mod_security restrictions
• send a 1.5.5e version of the files to modify so I can manage to compare and find the relevant differences?

By the way is lhungil still working on this project?

EDIT ... after posting I saw the other responses which may have better answers but will leave this here in case it is useful

I have this plugin working fine on 1.5.5f - I am not suggesting this will fix your issue however for mod_security issues I contacted my host and asked them to correct any mod_security issues - my .htaccess file now has the following entry inserted by my host - maybe try this and see if it works for you. You could also do a Google search for mod_security issues and you may find other code to use on your .htaccess

cheers,
Mike

p.s. in case you are not familiar with modifying the .htaccess file: to find your .htaccess file go to cPanel >> file manager >> public html >> click on .htaccess file and select download on the tool bar across the top. Open the file in edit with notepad or something similar >> insert that code (I don't think it matters where but close to the top is good, I think) >> save and then go to file manager and select 'upload' from the tool bar and follow the prompts >>> the file will load without the 'dot', so just as htaccess and not as .htaccess >>> this is CRITICAL >> click on your existing .htaccess file >> click 'rename' on the toolbar above >> rename that file as .htaccess_old >> then rename the new file by putting the dot in front of it.
You now have the modified file as the active file and the unmodified file is saved as a safeguard in case you need to reinstate it (using the rename process)

@carlwhat thank you for the suggestion, I'm taking a look at it... I was already unhappy with hostgator for many other reasons but let's not go off topic... at first look yours is more expensive but I guess I was getting what I paid for.

@shags38 thank you, I had already tried to turn off the mod_security via directives in the .htaccess in all possible ways I've found searching on the web but it had no effect - I guess my host disabled the option to alter mod_security settings as they also refused to discuss it with me.
Thanks also for the details on how to edit a file... I am a Linux user, I do ssh to the remote host and edit files with vi, I find it quite more practical :-)

By the way, @carlwhat, will your suggested host allow me to do ssh, rsync, and maybe also to install mc (midnight commander) ?

Thank you all!

Is there a way to change the product ID to model/sku/item number?

For an example:

The Item/Sku Number is for the item is: 12010970

from galaxyhomedecor.com/give-thanks-pumpkin-decoration-p-1490

to

galaxyhomedecor.com/give-thanks-pumpkin-decoration-p-12010970

@mecms ssh is closed down in a PCI compliant environment.

barco57:

@mecms ssh is closed down in a PCI compliant environment.

really? can you point to the specific part of the PCI-DSS standard that explicitly states ssh is not allowed?

perhaps you do not allow it; but as a host, can you get onto your server with ssh? (that is a rhetorical question...) how is your account any more PCI compliant than a client's account?

frankly i find it hard to imagine that the PCI-DSS standard has explicitly disallowed ssh... but i have been wrong before.

Hi.
Every time I try to install it, in a v1.5.5f, the admin panel shows me this error:
WARNING: An Error occurred, please refresh the page and try again.

I'm working on PHP 7.0

Any suggestions?

Thanks for your help. Greetings.

Look in the site's /logs directory for file(s) named myDEBUG-adm-*.log. One of them will tell you what the error is all about.

You can post the contents of the log file back here, within a "CODE" tag (the big # in the menu-bar when you're writing a post). Since this occurs in your admin, be sure to xxx-out any reference to your admin folder's name.

Thanks, lat9 and grace spor your tips, I have changed the name of the admin folder ;-)

The log shows me this:

[18-Oct-2018 23:34:04 UTC] Request URI: /admin/index.php, IP address: xxxxxxxxxx
#1  include_once() called at [/home/yo/public_html/admin/includes/classes/plugin.php:292]
#2  plugin->__construct() called at [/home/yo/public_html/admin/includes/init_includes/init_usu_install.php:6]
#3  require(/home/yo/public_html/admin/includes/init_includes/init_usu_install.php) called at [/home/yo/public_html/includes/autoload_func.php:48]
#4  require(/home/yo/public_html/includes/autoload_func.php) called at [/home/yo/public_html/admin/includes/application_top.php:171]
#5  require(/home/yo/public_html/admin/includes/application_top.php) called at [/home/yo/public_html/admin/index.php:10]

[18-Oct-2018 23:34:04 UTC] PHP Warning:  include_once(/home/yo/public_html/admin/includes/languages/spanish/modules/plugin/plugin.php): failed to open stream: No such file or directory in /home/yo/public_html/admin/includes/classes/plugin.php on line 292
[18-Oct-2018 23:34:04 UTC] Request URI: /admin/index.php, IP address: xxxxxxxxxxx#1  include_once() called at [/home/yo/public_html/admin/includes/classes/plugin.php:292]
#2  plugin->__construct() called at [/home/yo/public_html/admin/includes/init_includes/init_usu_install.php:6]
#3  require(/home/yo/public_html/admin/includes/init_includes/init_usu_install.php) called at [/home/yo/public_html/includes/autoload_func.php:48]
#4  require(/home/yo/public_html/includes/autoload_func.php) called at [/home/yo/public_html/admin/includes/application_top.php:171]
#5  require(/home/yo/public_html/admin/includes/application_top.php) called at [/home/yo/public_html/admin/index.php:10]

[18-Oct-2018 23:34:04 UTC] PHP Warning:  include_once(): Failed opening '/home/yo/public_html/admin/includes/languages/spanish/modules/plugin/plugin.php' for inclusion (include_path='.:/opt/cpanel/ea-php70/root/usr/share/pear') in /home/yo/public_html/admin/includes/classes/plugin.php on line 292
[18-Oct-2018 23:34:04 UTC] Request URI: /admin/index.php, IP address: xxxxxxxxxxxxxxx
#1  trigger_error() called at [/home/yo/public_html/includes/classes/db/mysql/query_factory.php:171]
#2  queryFactory->show_error() called at [/home/yo/public_html/includes/classes/db/mysql/query_factory.php:143]
#3  queryFactory->set_error() called at [/home/yo/public_html/includes/classes/db/mysql/query_factory.php:270]
#4  queryFactory->Execute() called at [/home/yo/public_html/admin/includes/classes/usu_plugin.php:144]
#5  usu_plugin->handleDatabaseChanges() called at [/home/yo/public_html/admin/includes/classes/plugin.php:336]
#6  plugin->install() called at [/home/yo/public_html/admin/includes/classes/usu_plugin.php:474]
#7  usu_plugin->install() called at [/home/yo/public_html/admin/includes/init_includes/init_usu_install.php:7]
#8  require(/home/yo/public_html/admin/includes/init_includes/init_usu_install.php) called at [/home/yo/public_html/includes/autoload_func.php:48]
#9  require(/home/yo/public_html/includes/autoload_func.php) called at [/home/yo/public_html/admin/includes/application_top.php:171]
#10 require(/home/yo/public_html/admin/includes/application_top.php) called at [/home/yo/public_html/admin/index.php:10]

[18-Oct-2018 23:34:04 UTC] PHP Fatal error:  1067:Invalid default value for 'cache_date' :: CREATE TABLE `zengl_usu_cache` ( `cache_id` VARCHAR(32) NOT NULL default '', `cache_language_id` TINYINT(1) NOT NULL default '0', `cache_name` VARCHAR(255) NOT NULL default '', `cache_data` MEDIUMBLOB NOT NULL, `cache_global` TINYINT(1) NOT NULL default '1', `cache_gzip` TINYINT(1) NOT NULL default '1', `cache_method` VARCHAR(20) NOT NULL default 'RETURN', `cache_date` DATETIME NOT NULL default '0000-00-00 00:00:00', `cache_expires` DATETIME NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`cache_id`,`cache_language_id`), KEY `cache_id` (`cache_id`), KEY `cache_language_id` (`cache_language_id`), KEY `cache_global` (`cache_global`) ) ==> (as called by) /home/yo/public_html/admin/includes/classes/usu_plugin.php on line 144 <== in /home/yo/public_html/includes/classes/db/mysql/query_factory.php on line 171

Any ideas on how to fix it?

Thank you ;-)

Yikes, the plugin's initialization script is setting those datetime fields to an invalid date. You'll need to edit the file /admin/includes/classes/usu_plugin.php, finding the following code-fragment starting at line 123:

	public function handleDatabaseChanges($install = true) {
		global $db, $messageStack;

		$success = true;
		if($install) {
			if(!$this->dbTableExists(TABLE_USU_CACHE)) {
				$db->Execute(
					'CREATE TABLE `' . TABLE_USU_CACHE . '` ( ' .
						'`cache_id` VARCHAR(32) NOT NULL default \'\', ' .
						'`cache_language_id` TINYINT(1) NOT NULL default \'0\', ' .
						'`cache_name` VARCHAR(255) NOT NULL default \'\', ' .
						'`cache_data` MEDIUMBLOB NOT NULL, ' .
						'`cache_global` TINYINT(1) NOT NULL default \'1\', ' .
						'`cache_gzip` TINYINT(1) NOT NULL default \'1\', ' .
						'`cache_method` VARCHAR(20) NOT NULL default \'RETURN\', ' .
						'`cache_date` DATETIME NOT NULL default \'[B]0000-00-00[/B] 00:00:00\', ' .
						'`cache_expires` DATETIME NOT NULL default \'[B]0000-00-00[/B] 00:00:00\', ' .
						'PRIMARY KEY (`cache_id`,`cache_language_id`), ' .
						'KEY `cache_id` (`cache_id`), ' .
						'KEY `cache_language_id` (`cache_language_id`), ' .
						'KEY `cache_global` (`cache_global`) ' .
					')'
				);
			}

and changing the highlighted sections as shown below:

	public function handleDatabaseChanges($install = true) {
		global $db, $messageStack;

		$success = true;
		if($install) {
			if(!$this->dbTableExists(TABLE_USU_CACHE)) {
				$db->Execute(
					'CREATE TABLE `' . TABLE_USU_CACHE . '` ( ' .
						'`cache_id` VARCHAR(32) NOT NULL default \'\', ' .
						'`cache_language_id` TINYINT(1) NOT NULL default \'0\', ' .
						'`cache_name` VARCHAR(255) NOT NULL default \'\', ' .
						'`cache_data` MEDIUMBLOB NOT NULL, ' .
						'`cache_global` TINYINT(1) NOT NULL default \'1\', ' .
						'`cache_gzip` TINYINT(1) NOT NULL default \'1\', ' .
						'`cache_method` VARCHAR(20) NOT NULL default \'RETURN\', ' .
						'`cache_date` DATETIME NOT NULL default \'[B]0001-01-01[/B] 00:00:00\', ' .
						'`cache_expires` DATETIME NOT NULL default \'[B]0001-01-01[/B] 00:00:00\', ' .
						'PRIMARY KEY (`cache_id`,`cache_language_id`), ' .
						'KEY `cache_id` (`cache_id`), ' .
						'KEY `cache_language_id` (`cache_language_id`), ' .
						'KEY `cache_global` (`cache_global`) ' .
					')'
				);
			}

I'll get an update going ...

Hi, lat 9

Perfect, now the admin has returned, but I do not see "Ultimate SEO" in "Configuration".

What could I have done wrong? How to make it appear to configure it?

Thank you very much for your help, I really need it :blush:

Thank you

I'd follow the steps in the USU readme to 'uninstall' (backing up files and database first) and then re-install. That MySQL error on the database table-addition has "confused" USU's installation procedure.

Hi, lat 9

I have uninstalled the module and reinstalled it.

It does not give me any errors, but nothing is shown in "Configuration" of the administration panel.

I have checked the logs and none has been created.

Any ideas?

Thank you very much, really, I am totally lost.

Are you familiar with how to use your webhost's phpMyAdmin database tool? If so, I'll post some instructions through which you can "gather" some information to help identify the source of the issue.

Hi, lat 9

I have worked something, very little, but I can access without problems.

I am very thankfull for your help.

OK, let's see what's in the configuration by running a couple of queries.

Log into your site's phpMyAdmin, click the SQL tab, enter the following query and press Go. Note that this assumes that your DB_PREFIX (defined in the configure.php files) is set to ''; if it's set to something else, e.g. 'zen_', then enter **zen_**configuration:

SELECT * FROM configuration WHERE configuration_key LIKE 'USU_%' OR configuration_key LIKE 'SEO_%';

Post-back those results. Then click the SQL tab again, enter the following query and press Go. Same assumption as above; if your DB_PREFIX is not an empty string, e.g. 'zen_', use **zen_**admin_pages:

SELECT * FROM admin_pages WHERE page_key = 'configUltimateSEO';

Post-back those results, too.

I'm, essentially, trying to determine where your site is in the USU installation process so that I can get you back on-track.

Hi, lat 9

Let's see if I'm doing it right ... I've made the query:

SELECT * FROM prefix_configuration WHERE configuration_key LIKE 'USU_%' OR configuration_key LIKE 'SEO_%';

And the consultation:

SELECT * FROM prefix_admin_pages WHERE page_key = 'configUltimateSEO';

Understanding that "prefix" is the prefix of my BBDD.

I do not know if I've done it well, but both times it shows me 0 values ...

:-(

Did you replace USU's installation files after you uninstalled?

The plugin currently (:censored:) uses an installation method that removes its installation files after completion. That's something I'll be changing in any future update.

Hi, lat 9

In Admin> includes> auto_loaders The file "config.usu_onetime.php" is missing
In Admin> includes> init_includes The file "init_usu_install.php" is not there

Should be?

;-(