Ultimate SEO .htaccess problem and broken Admin interface

lhungil:

This should be fixed in version 2.205 and newer. Be advised you should read the Official Ultimate SEO 2.200+ thread. I'll try to respond to any questions, comments, and concerns in that thread when I have time.

However if you ever need to remove all the database changes made by "Ultimate SEO" you can take a look at the function uninstall_settings() found in the file 'seo.install.php'.

Before attempting to uninstall the current or any old versions, you are hereby advised to make a backup of your database. There is a small chance running these commands may break your site as they remove all configuration keys containing the word "SEO".

DELETE FROM configuration_group WHERE configuration_group_title LIKE '%SEO%';
DELETE FROM configuration WHERE configuration_key LIKE '%SEO%';
DELETE FROM admin_pages WHERE page_key='configUltimateSEO';
DELETE FROM admin_pages WHERE page_key='UltimateSEO';
DROP TABLE IF EXISTS seo_cache;

> 
> Don't forget you will need to add any "prefix" you have set to the start of the table names.
> 
> Why is this function in the installer? If "Ultimate SEO" detects a required table is missing or needs to be updated (typically because of a version upgrade), it will first uninstall old tables and settings to ensure compatibility with the new version. Once it is done uninstalling old settings and tables, it will proceed to install the new tables and settings. This is also why after installing a new version you **NEED** to always check your settings.

Thank for the delete code! I'm balking in upgrading my main site to 1.5 and going to Ultimate SEO URL because I see an old/failed attempt in my DB (and admin) from several years ago. I would do a fresh 1.5 install and a DB upgrade, and think I'd first have to get rid of the old SEO URL stuff in the DB, either using your code or manually deleting them.