Skip to content

Instantly share code, notes, and snippets.

/WG_story_issue
Created Dec 6, 2012

Embed
What would you like to do?
WebGUI Story date issue
<h2>To restore the original published date to a News item after editing it:</h2>
<ol>
<li>In MySQL, get the original published timestamp by typing:
<pre>select * from asset where assetId='&lt;assetid&gt;';
</pre>
, where <strong>&lt;assetId&gt;</strong> is the actual Id of the asset</li>
<li>Clear out all the excess copies of database entries by finding the Story asset in the Asset Manager, "Changing" the URL by one letter, and then "Changing" it back to the original URL.&nbsp;This will leave you with one entry in each of the three tables that controls the Story's date.</li>
<li>Run the following three (3) queries, substituting the asset's Id and the timestamp you found in Step 1 where indicated:
<pre>UPDATE Story SET revisionDate=&lt;timestamp&gt; WHERE assetId='&lt;assetid&gt;';
UPDATE assetData SET revisionDate=&lt;timestamp&gt; WHERE assetId='&lt;assetid&gt;';
UPDATE assetIndex SET revisionDate=&lt;timestamp&gt; WHERE assetId='&lt;assetid&gt;';
</pre>
</li>
<li>Clear the WebGUI cache.</li>
<li>Clear your browser cache.</li>
<li>Verify that the News item has the correct, original date by viewing it in the individual view template.</li>
</ol>
<p>Good hunting.</p>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.