tag:help-archives.hannonhill.com,2010-02-09:/discussions/general/16937-error-messages-about-foreign-key-constraint-failsCascade CMS: Discussion 2014-01-07T16:38:19Ztag:help-archives.hannonhill.com,2010-02-09:Comment/308956592014-01-03T14:09:26Z2014-01-03T14:09:26ZError messages about "foreign key constraint fails"<div><p>Hi,</p>
<p>I believe that you are running into <a href=
"https://hannonhill.jira.com/browse/CSI-665">this issue</a> which
was corrected for 7.8. When you have the chance, can you try
applying the 7.8.x upgrade to this instance and let me know if
those messages disappear?</p>
<p>If you prefer not to apply the upgrade at this point, you can
also try the following:</p>
<ul>
<li>Be sure to create a backup of your database (to be safe!)</li>
<li>Execute the following query:
<pre>
<code>delete stats from cxml_assetstats stats inner join cxml_foldercontent fc on stats.assetId=fc.id where fc.isRecycled=1</code>
</pre>
(this query should take care of the issue at the moment, but won't
prevent it from occurring in the future)</li>
</ul>
<p>Let me know if this helps!</p></div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/308956592014-01-07T16:37:04Z2014-01-07T16:37:04ZError messages about "foreign key constraint fails"<div><p>-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1</p>
<p>Thanks for the suggestions. I will try the MySQL "workaround" on
a<br>
test server. We will eventually move to Cascade-7.8, but I am not
sure<br>
how soon.</p></div>leftfoottag:help-archives.hannonhill.com,2010-02-09:Comment/308956592014-01-07T16:38:18Z2014-01-07T16:38:18ZError messages about "foreign key constraint fails"<div><p>OK, sounds good! Just let us know if you have any questions
regarding the upgrade process or the upgrade itself. Take care!</p></div>Tim