On February 16, 2006 01:21 am, jeremi joslin wrote:
On 2/16/06, Marc Lijour <[email protected]> wrote:
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?
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?
jeremi
-- Blog: http://www.jeremi.info LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724 http://www.xwiki.org skype: jeremi23 -- msn et gtalk : [email protected]