tag:help-archives.hannonhill.com,2010-02-09:/discussions/how-do-i/55-how-can-i-empty-the-publish-queue-via-sqlCascade CMS: Discussion 2011-05-18T16:56:28Ztag:help-archives.hannonhill.com,2010-02-09:Comment/20809002010-06-25T20:39:13Z2010-06-25T20:39:14ZHow can I empty the publish queue via SQL?<div><p>We have a development instance that has 300 jobs sitting in the
publish queue. I'd like to remove them all at once, but there's a
foreign key relationship with the records in cxml_publishrequest
that I'm not sure how best to overcome. Is there an SQL statement I
can easily use to wipe out the publish queue?</p>
<p>Thanks!</p></div>Lee Clontztag:help-archives.hannonhill.com,2010-02-09:Comment/20809002010-06-25T20:53:39Z2010-06-25T20:53:39ZHow can I empty the publish queue via SQL?<div><p>Hi Lee,</p>
<p>You should be able to clear your publish queue by issuing the
following SQL queries in order:<br></p>
<pre>
<code>delete from cxml_publishrequest_dest;
update cxml_publishrequest set prevId = null, nextid = null;
delete from cxml_publishrequest;</code>
</pre>
<p>These should do the trick. You may wish to take a screen shot of
the publish queue in case you want to place any of those jobs back
in after the queries have been executed.</p></div>Tim