See <a href="http://chess.eecs.berkeley.edu/chess/faq/49.html">Deleting an attachment</a> about why we don't allow users to delete attachments.


<p>To delete a non-publication attachment, see:
<a href="http://embedded.eecs.berkeley.edu/dopsysadmin/faq/95.html">Deleting a non-publication attachment</a>

<p>To delete a entire publication, go to Options and then under "Power Tools" on the left: Remove a publication.
<br/>On E3S, the link is 
<a href="https://www.e3s-center.org/options/power/remove_pub">https://www.e3s-center.org/options/power/remove_pub</a>
<br/> The Pub ID is the number in the URL.  So, if you
are attempting to delete
<code>http://www.e3s-center.org/pubs/98.html</code>,
then the Pub ID would be <code><b>98</b></code>.

<p>To delete a publication attachment or publication upload:
<ol>
<li>Use the mysql interface:
  <ul>
    <li> <a href="http://chess.eecs.berkeley.edu/mysql"><code>http://chess.eecs.berkeley.edu/mysql</code></a>
or</li>
<li><a href="http://terraswarm.org/mysql"><code>http://terraswarm.org/mysql</code></a> or</li>
    <li><a href="http://trust.eecs.berkeley.edu/mysql"><code>http://trust.eecs.berkeley.edu/mysql</code></a></li>
  </ul>
<br><i>It doesn't matter which URL you use, they both
go to the same place!</i>  Note that you need to be in the webmaster group and possibly and admin for the mysql link to work.

<li>Then browse to the database that corresponds with the site wide workgroup, for example:
<ul>
<li><code>chess_2</code></li>
<li><code>e3s_5</code></li>
<li><code>terraswarm_7</code></li>
<li><code>trust_4</code></li>
</ul>
</li>

<li>To delete a reference to an attachment or upload, find the <code>pubsX</code> table and then delete the record
for the offending file. Deletions are executed by clicking on the red 'X' for the record.
<b>Hint:</b> The most recently added attachments are at
the end of the table, use the <code>&gt;&gt;</code>
button to go to the end of the table.
<br>Hint</b> The <code>ownerid</code> field is the number of the publication that "owns" the link.  For example, if the publication url is <a href="http://www.icyphy.org/pubs/33.html">http://www.icyphy.org/pubs/33.html</a>, then the ownerid with be <code>33</code>, which is the number
to search for.

<li>To delete a publication, go to the <code>pubs</code> table, find the offending publication and delete it.
</ol>