Where do I find meta keywords in the database?

Permalink
My client cannot update keywords for the home page and so I need to change them manually in the database. Where could I find this please?

When saving new keywords we get an error saying "unable to load sitemap data".

Thanks

View Replies:
myFullFlavour replied on at Permalink Reply
myFullFlavour
Meta-keywords in the database? Do you mean you are trying to update these via the 'properties' tab?
ringo replied on at Permalink Reply
Yes. I cannot update using the properties tab. I need to update in the database instead.
myFullFlavour replied on at Permalink Reply
myFullFlavour
So via the specific pages 'properties' tab you get "unable to load sitemap data".

Odd. What version of C5 is installed?
ringo replied on at Permalink Reply
Yep. I have posted the error problem in another thread.

I need to do this manually for a client. I wonder what db table it's stored in.

Using the latest version. 5.4.1.1 I think.
madeforspace replied on at Permalink Reply
madeforspace
Do you have a sitemap.xml file?
If yes, is it writeable?
I am really unsure why it would be trying to get keywords in a sitemap.
Most odd.
triplei replied on at Permalink Reply
triplei
Hi Ringo,

Those are attributes tied to the collection object. To access them directly, take a look at the AttributeKeys table to find the id for the meta_description attribute (for me it's id=2). Then take a look at the CollectionAttributeValues table and map the collection ID for the page your wanting to update the value for with the akID (the one for the meta_description) and find the avID (attribute value ID). It looks like the actual content is then stored in the atDefault table.

I'd still recommend tracking down the issue that you're running into instead of database-diving and changing things there since there are most likely some other joins that I'm leaving out here. But hopefully this will get you on the path to put out the fire and then you can track down the actual issue.