I have a really annoying typo right through my Drupal install (db table names, modules...you name it it's right through). Ideally I would like to fix the typo and not recreate the content type/modules etc.
The process I have gone through so far:
Find/replace all instances of the typo in the Database using this Script https://gist.github.com/leewoodman/9544808
I then renamed all the tables where the typo occurred using this:
RENAME TABLE field_data_field_accomodation_ref TO field_data_field_accommodation_ref, field_data_field_offer_accomodation TO field_data_field_offer_accommodation, field_revision_field_accomodation_ref TO field_revision_field_accommodation_ref, field_revision_field_offer_accomodation TO field_revision_field_offer_accommodation;
Then I ran this ruby script to replace all instances of the typo in my files/file/folder structure: https://gist.github.com/dvdsgl/4600317
Then I deleted all caches manually in the DB using:
SELECT CONCAT('TRUNCATE TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ';') AS table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'my-db-name' AND TABLE_NAME LIKE 'cache_%' AND TABLE_TYPE = 'BASE TABLE'
I am pretty confident I fixed all the typos but I then get an entityreference error.
Am I missing another step here somewhere?