Originally Posted by
dontknowwhatimdoing
Thanks so much for posting this fix!!
I was starting to get quite frustrated because I couldn't figure out why the Ultimate SEO URLS pages were in SPANISH and not in ENGLISH.
My biggest frustration was that my source files were obviously in english (its just not clear on the site that I was downloading spanish, but I quickly figured that part out)
Anyway, I applied the following fix to get rid of the spanish entries (from your link)
THE FIX
DELETE FROM `configuration_group` WHERE `configuration_group_title` LIKE '%SEO%'; DELETE FROM `configuration` WHERE `configuration_key` LIKE '%SEO%'; DROP TABLE IF EXISTS seo_cache;
Now, if you just stay in the admin panel, SEO URLS will no longer show up. To 'reinstall', all I had to do was click on my site pages/ category listings once (after deleting the Spanish database entries with the SQL query above), then it automatically re-installed SEO urls.
And now, finally my admin panel option states everything in English.
Bookmarks