3 Jan
2012
3 Jan
'12
4:17 p.m.
Hi all,
since I switched from database attachement store to filesystem store I
have some problems.
The first view days everything was ok, but than i restarted the server
and since than:
mysql> select * from xwikiattachment;
+-------------+-------------+------------------------------------------------------------------------------------+----------+---------------------+----------------------------+-------------+-------------+
| XWA_ID | XWA_DOC_ID |
XWA_FILENAME
| XWA_SIZE | XWA_DATE | XWA_AUTHOR |
XWA_VERSION | XWA_COMMENT |
+-------------+-------------+------------------------------------------------------------------------------------+----------+---------------------+----------------------------+-------------+-------------+
| -2139505400 | -1980029764 |
Assertions.pdf
| 0 | 2007-05-17 23:19:13 | XWiki.RobertReiner |
1.1 | |
| -2136668642 | -1260324256 |
groups.png
| 498 | 2009-09-03 17:38:38 | XWiki.Admin |
1.1 | |
| -2096787253 | -152317460 |
XWikiLogo.png
| 1390 | 2009-09-09 02:00:00 | XWiki.Admin |
1.1 | |
| -2083635922 | 1934194131 |
msginfo.png
| 0 | 2008-11-14 16:46:06 | XWiki.AntonKronseder |
1.1 | |
| -2027337590 | -259212042 |
general.png
| 0 | 2010-09-18 03:19:58 | XWiki.Admin |
1.1 | |
| -2003457988 | 151244875 |
xwiki-enterprise-manager-wiki-administrator-1.5.1.xar
| 0 | 2009-02-27 12:24:23 | XWiki.Admin |
1.1 | |
Some files in the storage folder are empty (have size 0) as stated in
XWA_SIZE have in the database.
The ~METADATA.xml file states, that the size is 0.
Are negative IDs OK (e.g. for XWA_ID) ?
Sometimes, when I copy manually the correct file with size > 0 to the
store and when I change the ~METADATA.xml accordingly it works,
sometimes not.
Sometimes when I upload an image with a German name (e.g. Wüste.jpg [is
desert in english]) it is stored and also named desert.jpg.
I guess some information (rdf) inside the jpg (some jpg metadata) knows,
that its name is desert.jpg. Am I guessing right?
I have 312 attachements in our xwiki. Do I have to delete the database
tables (xwikiattach*) and do the attache process again?
Files that xwiki does not know e.g. mytest.abc can be attached. They can
be found in the store and are listed in the view but I can not receive
tha file.
Not by clicking on the attachement link, nor by rightclicking and
choosing "save link as".
BTW in between I had to change the server (hardware) and had to install
a new xwiki. Afterwards I imported the Files (using xar import) and did
a filesystem copy of the store.
All Pages are OK, all attachements are listed, but can not be
downloaded, besides the ones in the original xwiki.xar, which I also
imported.
Any suggestions?
Thanks in advance.
Best regards,
Anton Kronseder