Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

CMS Page SQL Queries
 
Wilson Sheldon
Member
 
Total Posts:  47
Joined:  2008-06-07
 

Hi everyone,

Can anyone shed some light on InnoDb functionality that causes me to need to login in to the admin area and resave a page after I run simple UPDATE queries on my ‘cms_page’ table? 

For example, I’m fixing a few bad links and img tags on old HTML I’m importing.  This is something I’ve done often over the years, however in InnoDb it seems that with even the same ID , the relation is lost until I resave the CMS page.

What I need is an automated way to rebuild the relationships so I can continue to run my fix scripts?

Also, everytime I view the table, the cardinality changes, is that normal?

Thanks!
Wilson

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top