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

[fairestcape]

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.

[lhungil]

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

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.

[lhungil]

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

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


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

http://www.zen-cart.com/showthread.p...grade-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

[ndickerson]

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

[SPH]

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.

[ndickerson]

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

[ndickerson]

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

[ndickerson]

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

[ndickerson]

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