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

I do however wish to add that your efforts to support, update and streamline this mod are acknowledged and applauded. As there are still a significant number of "sheep" out there, if they are going to consume this stuff, it's nice to know someone cares about their welfare. :yes:

fairestcape:

The vast majority of people who install this stuff, do so under the misconception that it is a "silver bullet" that will somehow race them up the rankings at Google...
:yes: It is sad in this day and age people still want to believe in "silver bullets". The phrase "You can lead a horse to water, but you can't make it drink" comes to mind.

On another note:

This thread's purpose is to support "Ultimate SEO URLs". It provides a place for people new to the module as well as experienced users of the module to interact and help each other install, upgrade, and use this module. It also provides a place for people to report any potential bugs they may have found (as well as fixes).

I would ask everyone who reads (or posts) to this thread keep the above stated purpose of this thread in mind. Kindly keep the posts in this thread relevant to the above stated purpose. I encourage people to discuss other topics, but please discuss them in a different thread in a relevant section of the forums.

For those asking for help: keep in mind the people on the Zen Cart forums are not here 24x7 and for the most part give freely of their personal time to help. It may take a couple days for someone to read your message. So be patient when asking for help. I would also re-iterate reading the "Posting Tips" (scroll up when posting / replying) is a good idea. Answering the questions found in the "Posting Tips" will help save time and helps give those reading your post a better picture of what might be causing the problem you are experiencing.

Thank You

1146 Table 'coolcase_coolcases.TABLE_ADMIN_PAGES' doesn't exist
in:
[SELECT page_key FROM TABLE_ADMIN_PAGES WHERE page_key = 'configUltimateSEO']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

What's the fix? I saw it on another thread...

http://www.zen-cart.com/showthread.php?206429-cannot-login-to-admin-1146-error-after-attempt-to-upgrade-SEO-URLS

But you posted into PM.... people post in forums man...

Anyone can help with this fix? My stores dead.. I am bringing 1.3.8a to 1.3.9h.. the easy way

Almost done...... then BOOM!

Please help

Is this bug a DEFINE issue... can I DEFINE this in a global config somewhere? Recreate the table.. I will research your code now.. see if I can finda patch and feedback here... still anythjing would help

Speaking of silver bullets, I don't think that even great content can be counted on for that. So perhaps there truly are no silver bullets.

Okay, just saw the post to keep things strictly relevant to Ultimate SEO Support.

Ok, one step closer

I think issue is you guys are using a zencart 1.5 table referenced in 1.3.9h.. whatever, no problem.. I will download zc 1.5, extract the structure, install with my dbprefix.. then define this in:

seo.php

Will let you know.. no biggie here.. I think am unblocked, but testing still

I extracted the table structure:

CREATE TABLE coolcases_admin_pages (
page_key VARCHAR(32) NOT NULL DEFAULT '',
language_key VARCHAR(255) NOT NULL DEFAULT '',
main_page varchar(64) NOT NULL default '',
page_params varchar(64) NOT NULL default '',
menu_key varchar(32) NOT NULL default '',
display_on_menu char(1) NOT NULL default 'N',
sort_order int(11) NOT NULL default 0,
UNIQUE KEY page_key (page_key)
) ENGINE=MyISAM;

Then defined in:
admin/includes/init_includes/init_seo_config.php

Whitescreen of death now

Looks to me that there is something wrong here... maybe additional missing tables and definitions... Im going to nuke the database... retry............ any ideas?? can you send me the fix??

In thread you say:

There is indeed a bug for 1.3.9h users upgrading the module from a version less than 2.210.

Next thing I'll try is old version? I mean I was using an old version successfully... I just need a working system.. I'm doing this upgrade to get some other module support... tight schedule here

Next test: install -

Ultimate SEO URLs - Version: 2.110 - for ZC v1.3.9

ndickerson:

1146 Table 'coolcase_coolcases.TABLE_ADMIN_PAGES' doesn't exist
in:
[SELECT page_key FROM TABLE_ADMIN_PAGES WHERE page_key = 'configUltimateSEO']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Anyone can help with this fix? My stores dead.. I am bringing 1.3.8a to 1.3.9h.. the easy way
The error message you're getting is caused by your plugin trying to do stuff with v1.5.x tables when they don't exist.
So, if you're really upgrading only to v1.3.9h, then I'm guessing you grabbed a newer version of your plugin when you should have grabbed an older one.

Am sure it`s a known issue per:

http://www.zen-cart.com/showthread.php?206429-cannot-login-to-admin-1146-error-after-attempt-to-upgrade-SEO-URLS&highlight=TABLE_ADMIN_PAGES

It is OK anyway... I am holding on to 1.3.9 series because I have custom codes for the store. So I can get by with the older one.. no worries.. testing now.. haven`t tested yet

Ok guys, I upgraded 1.3.8a using an older version to 1.3.9h successfully with Version: 2.110 - for ZC v1.3.9

I recommend that.. am sure you'll have a stable version soon.. but for the guys like me who on a short timeline to get this upgraded.. this is a solid way

In thread you say:

There is indeed a bug for 1.3.9h users upgrading the module from a version less than 2.210. ...
Correct. To clarify for anyone else reading this thread the only people affected are those running Zen Cart 1.3.9h and UPGRADING from Ultimate SEO < 2.210 to the latest version.

This temporary workaround for those affected is to UNINSTALL the old version and INSTALL the latest version.

I am still looking for anyone who is still running Zen Cart 1.3.9h and is willing to BETA test a patched version. If you are willing, send me a PM and I will send you the BETA. Until I know 100% the 1.3.9h patches work correctly (in more than my test environments) I do not want to release the current BETA code.

I am running Zen Cart 151, and I keep getting these errors even after changing the admin back to admin and installing the Ultimate SEO

Filesystem Error: Unable to access '/home/public_html/adminincludes/extra_datafiles/seo.php'. Please make sure you uploaded the file and your webserver has access to read the file!
Error Filesystem Error: Unable to access '/home/public_html/adminincludes/functions/extra_functions/seo.php'. Please make sure you uploaded the file and your webserver has access to read the file!
Error Filesystem Error: Unable to access '/home/public_html/adminincludes/languages/english/extra_definitions/seo.php'. Please make sure you uploaded the file and your webserver has access to read the file!
Error Ultimate SEO installation failed!

weezee:

I am running Zen Cart 151, and I keep getting these errors even after changing the admin back to admin and installing the Ultimate SEO

Filesystem Error: Unable to access '/home/public_html/adminincludes/extra_datafiles/seo.php'. Please make sure you uploaded the file and your webserver has access to read the file!
Error Ultimate SEO installation failed!
I see a missing "/" in between "/public_html/admin" and "includes". This usually indicates a Zen Cart configuration issue. Take a look in "admin/includes/configure.php" and verify DIR_FS_ADMIN and DIR_FS_CATALOG both end with a "/".

Thanks, that was the problem plus I had to change it back to my admin name.

weezee:

Thanks, that was the problem plus I had to change it back to my admin name.
No problem and thank you for reporting back that the issue was with your Zen Cart configuration.

I see issues with the Zen Cart configuration quite often, especially if Zen Cart is upgraded from 1.3 to 1.5. Many people just keep using the old configure.php files instead of generating new ones... and there are subtle differences between the versions (including 1.5 not requiring the admin configure.php edited when changing the admin folder name).

I also have just had the same problem that ndickerson and others have had.
1146 Table 'database_name.TABLE_ADMIN_PAGES' doesn't exist etc etc
I have deleted the file config.seo.install.php and the store is working again.
But what should i do to get this mod to work?

This is on a fresh 1.39h with no other mods.
Its not an upgrade.
I used the 1.39h folder only, not the 1.5 folders.
I downloaded the latest release.

Also I see some french text in the admin for the mod, is that meant to be there?

Activar las direcciones SEO?
Filtrar palabras cortas
Categories as directories
Restablecer la caché para las direcciones SEO
Enable manufacturers cache?
Introduzca las páginas para permitir la reescritura