16 Feb
2006
16 Feb
'06
7:29 a.m.
On February 16, 2006 01:21 am, jeremi joslin wrote:
On 2/16/06, Marc Lijour <marc(a)lijour.net>
wrote:
can you just do an
select * from xwikiattachment;
I did this one:
mysql> select * from xwikiattachment where XWA_AUTHOR = 'XWiki.OsnerJoseph';
and the document was not there (see 2nd email in the thread). This was last
time.
After restarting xwiki, here is what I get:
mysql> select * from xwikiattachment where XWA_AUTHOR = 'XWiki.OsnerJoseph';
+-------------+------------+----------------+----------+---------------------+-------------------+-------------+-------------+
| XWA_ID | XWA_DOC_ID | XWA_FILENAME | XWA_SIZE | XWA_DATE |
XWA_AUTHOR | XWA_VERSION | XWA_COMMENT |
+-------------+------------+----------------+----------+---------------------+-------------------+-------------+-------------+
| 493824533 | 1329616320 | 132795189.img | 81721 | 2006-02-10 09:45:26 |
XWiki.OsnerJoseph | 1.1 | |
| -1859509744 | 337185142 | nicky.jpg | 23505 | 2006-02-10 10:01:51 |
XWiki.OsnerJoseph | 1.3 | |
| 1870603601 | 337185142 | osner.jpg | 31151 | 2006-02-10 11:34:43 |
XWiki.OsnerJoseph | 1.3 | |
| -427375445 | 337185142 | hotel3.jpg | 91538 | 2006-02-10 10:18:25 |
XWiki.OsnerJoseph | 1.1 | |
| 1895209951 | 337185142 | joseph.bmp | 800754 | 2006-02-10 11:23:08 |
XWiki.OsnerJoseph | 1.1 | |
| 1612673344 | -593433723 | HatPicture.jpg | 104435 | 2006-02-11 15:23:30 |
XWiki.OsnerJoseph | 1.1 | |
| 444268704 | -593433723 | osner.jpg | 31151 | 2006-02-14 10:03:38 |
XWiki.OsnerJoseph | 1.1 | |
| 652278503 | 1329616320 | jo.jpg | 91538 | 2006-02-14 09:55:37 |
XWiki.OsnerJoseph | 1.1 | |
| -857322110 | -593433723 | jo.jpg | 91538 | 2006-02-14 09:58:20 |
XWiki.OsnerJoseph | 1.1 | |
| 2105339254 | 337185142 | josephos.doc | 0 | 2006-02-15 09:20:14 |
XWiki.OsnerJoseph | 1.1 | |
| 1134896447 | 337185142 | soj.doc | 0 | 2006-02-15 09:16:51 |
XWiki.OsnerJoseph | 1.1 | |
+-------------+------------+----------------+----------+---------------------+-------------------+-------------+-------------+
11 rows in set (0.00 sec)
My 2 rogue documents are back! I still can't delete them, the same error
appears.
I also have a jo.jpg in 2 places with the same version number, humm, is that
correct?
Can I just delete them from this table then? What about the jo.jpg, do I
remove one version?
I'm
not sure, it can be this.
Have you restart your tomcat?
I just tried and nothing changed.
I wonder how it can display an attachment which is not (visible to me) in
the database? jeremi
--
Blog: http://www.jeremi.info
LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724
http://www.xwiki.org
skype: jeremi23 -- msn et gtalk : jeremi23(a)gmail.com