Documents missing after upgrade

[fitzy79]

I have recently migrated our mantis bug tracker to a new machine and upgraded in the process. Everything seemed to go smoothly and our new system is up and running. The only problem is that any old uploads are "available" though contain no data. New uploads are fine! We can upload files and then access them with no problems. We use the database as the file store. The documents are still on the old system and are available and downloadable. Might I have not exported the database correctly??

I used the commands suggested in the manual.

create backup:
mysqldump --opt -u<username> -p<password> <database name> > <backup file>
restore backup:
mysql --force -u<username> -p<password> <database name> < <backup file>

Everything else seemed to be backed up and restored correctly (projects, users, passwords, bug entries ...)

when I use the system utilities on the old machine to move attachments to disk I receive :

Found 0 attachments to be moved.

0 attachments processed, 0 failures

Completed...

This does not seem correct as we have many attachments to bug entries (or am I confused as to what that utility does).


Thank you.

[vboctor]

Were attachments saved to disk or database? If saved to disk, then you need to make sure they are copied to the new machine and that the upload path in the project properties have the upload path point to the location which has both the old and the new attachments.

Regards,
Victor
Mantis for .NET Applications
http://www.futureware.biz/mantisconnect/

[fitzy79]

Hello Victor,

I thought that it was set as database though then found a path in the project properties. I copied the upload directory to the new server so that the paths are identical. It still does not download any data. How can I verify whether the files are in the database or the folder listed by the projects properties. What would be next steps to get mantis to download the files attached prior to the migration ??

I am having the same problems as listed in my earlier post, eventhough, I have the directory and files transferred over to the new server with the exact same path.

Thank you for your help.

[walsh_e]

Hi I'm having a similar problem which php file are the project properties in?

[briveira]

same problem here; it's not enough to update the folder property in config_inc.php

take a look at the database: the mantis_bug_file_table; there is a column "diskfile" with a full path for each uploaded file, so you will need to also update all the values there if the folder is not exactly the same as it was in the old machine

very easy to do with a simple update:

update mantis_bug_file_table
set diskfile=replace(diskfile, '/old/path/','/new/path/')