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
When saving new keywords we get an error saying "unable to load sitemap data".
Thanks
Meta-keywords in the database? Do you mean you are trying to update these via the 'properties' tab?
Yes. I cannot update using the properties tab. I need to update in the database instead.
So via the specific pages 'properties' tab you get "unable to load sitemap data".
Odd. What version of C5 is installed?
Odd. What version of C5 is installed?
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.
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.
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.
If yes, is it writeable?
I am really unsure why it would be trying to get keywords in a sitemap.
Most odd.
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.
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.
