Where are the attachments gone?

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
spreepiraten
Posts: 6
Joined: 03 Mar 2011, 08:15

Where are the attachments gone?

Post by spreepiraten »

Hi there,

I am running a standard installation of mantis on my server. Now with more and more projects my database ist fully packed with attachements, I used to work with. Fact: I have to clean up. Exporting or saving the database itself is no problem. But these hundreds of attachments are nowhere to be found. I don’t use any special kind of setting for the upload of attachments (DISK, FTP, whatsoever). Via FTP I can’t find a single file, which is self explanatory. But where are these fucking files gone? Is there a SQL line I can drop to download any file in a certain table?

I hope someone understands the deal.

Thanks very much in advance...

Best, Floyd
cas
Posts: 1768
Joined: 11 Mar 2006, 16:08
Contact:

Re: Where are the attachments gone?

Post by cas »

most likley they are stored in the database itself.
You can change to DISK and move them all to disk (there is a facility in the admin section).
spreepiraten
Posts: 6
Joined: 03 Mar 2011, 08:15

Re: Where are the attachments gone?

Post by spreepiraten »

Ups...
Last edited by spreepiraten on 25 Aug 2011, 11:29, edited 1 time in total.
spreepiraten
Posts: 6
Joined: 03 Mar 2011, 08:15

Re: Where are the attachments gone?

Post by spreepiraten »

Thanks cas,

I don’t really know where I can find this section. In the Mantis or in the Database via phpMyAdmin? Where do I have the possibility to setup DISK as storage? Where on the disc will the attachments be stored then? And how do I move my recent files from the database to the specific folder?
Sorry, but I didn’t install the mantis, so I don’t know anything about it. Thanks for your help though.

Best, Floyd
cas
Posts: 1768
Joined: 11 Mar 2006, 16:08
Contact:

Re: Where are the attachments gone?

Post by cas »

Suggest you get into the manual, it is all described.
Also moving attachmenmts from DB to Disk (any place of your choice) has been described many times :mrgreen:
spreepiraten
Posts: 6
Joined: 03 Mar 2011, 08:15

Re: Where are the attachments gone?

Post by spreepiraten »

So you can’t help me in fact. No answers to my specific questions. Just the advice to help out myself. Sorry, this is not, what I expected. Should I google my problem? Come on. I have to work, don’t have time for suggestions like these.

Is there anyone, who is able to tell me, whether I have to setup DISK within Mantis or the database itself.
atrol
Site Admin
Posts: 8575
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Where are the attachments gone?

Post by atrol »

Change file config_inc.php set $g_file_upload_method = DISK
http://docs.mantisbt.org/master-1.2.x/e ... IG.UPLOADS
Follow the given instructions
http://www.mantisbt.org/forums/viewtopi ... 782#p42683
Please use Search before posting and read the Manual
spreepiraten
Posts: 6
Joined: 03 Mar 2011, 08:15

Re: Where are the attachments gone?

Post by spreepiraten »

Thanks very much. Everything worked out well...

Now, when I upload a PDF file I can just see some documents with crypted titles. What can I do to see the original attachments in this folder?
atrol
Site Admin
Posts: 8575
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Where are the attachments gone?

Post by atrol »

spreepiraten wrote:crypted titles
Are you talking about the file names?
Please use Search before posting and read the Manual
spreepiraten
Posts: 6
Joined: 03 Mar 2011, 08:15

Re: Where are the attachments gone?

Post by spreepiraten »

Yes. The files, that I can see currently don’t have any endings (.pdf) and don’t have their filenames anymore. They are now called something like "5b46a9420668ee2c8569bfac6647bcf".
atrol
Site Admin
Posts: 8575
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Where are the attachments gone?

Post by atrol »

You can find the name of the file in database table mantis_bug_file_table.
There is a column "diskfile" containing the full path where the attachemnts are stored and a column "filename" with the original name of the file.
Please use Search before posting and read the Manual
Post Reply