My site was just beginning to look like something. But for some reason (please don't ask) I was exploring the database (with PHPmyadmin), and found a spelling error on one of my CCK fields. In a sudden moment of hybris, I thought that was something I could fix. So I corrected the spelling error everywhere I could find it, only to find out I screwed up my site completely. The old (incorrectly spelled) field name is still there...somewhere...but I just can't find where to find it.
To clarify a bit. It's the "machine readable" field name I'äm talking about. In the administration interface, I still see the old field name when I list all the fields. I searched the whole database for any occurances of the old name, but the only hits I get are in two of the cache tables (cache_content and cache_views), but those are embedded in some kind of "data" fields. I'm not too cunning on databases (yep...makes it even more stupid of me to mess around there, I know...), so I don't know how to edit anything in those fields.
So please. Does anyone know where CCK stores te machine readable field names, so I can update them?
I am of course very grateful for any help on this matter!
Comments
Not sure this is fixable,
Not sure this is fixable, but at minimum you'll need to clear the cache (for d5 see http://drupal.org/node/152983, for d6 it's at admin/settings/performance).
=============
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
I would prefer to change it
I would prefer to change it back to the misspelled version – I think this is only used internally. You might then, if you can’t live with the shame, be able to change it another way, maybe create a new correctly spelled field and copy the data.
If you wish to persist, have you checked the names of tables and table fields? eg. names of tables returned by;-
SHOW TABLES;or titles of columns returned by;-SELECT * FROM ???content_type_???;___________________
Teach a man to fish, and he’ll sit in a boat drinking beer all day.
Millions of thanks!
I cannot describe how grateful I am right now!
Clearing the cache totally did it, and now the site works properly again! And the misspelled field is now correctly spelled everywhere (don't ask me why that was so important in the first place...).
And, of course. Lesson learned. Don't mess with databases unless you know what you're doing... :)
Big thanks again!
Excellent-- you're welcome.
Excellent-- you're welcome. And a valuable lesson it was-- and not too terribly painful, lol.
=============
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.