WebGUI Story date issue

WG_story_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>