Hello,
I moved my suitecrm (7.1.5) to a new host and everything went well except all uploaded documents are corrupted when i download them and try to open. This includes xls, pdf and msg files uploaded to accounts. The files seem to be with correct filesize but will not open. Excel and PDF reader both say that the files are corrupted. Excel does recover some data but not all.
The files open OK on my old host (i have not closed the service yet).
I have no idea what to do about it. Can you guide me in the right direction?
How did you transfer the files to the new host?
Is this in a windows or Linux environment?
I as just thinking , try moving the site files excetp the upload directory. Then only move some files form the upload directory for testing. The file names i believe aare the DB databse ID’s.
Then try to open up that document through suitecrm and download it. See if it is the actual file is corrupted. OR take the file from the uplaod directry and rename it to the proper format and see if it is corrupted. You might have to isolate the issue to see where the problem lies.
Things that stand out to me is you mentioning you switched hosts. So i’m wondering if the files did actually become corrupted on the transfer.
There could be permission issues, DB issues. I would maybe try to migrate the site without all the uploads, and then migrate the DB through the CLI and then test to see where things break. I have a server migration post you could check out that might help. Ive run through so many issues and its usually me overlooking some simple thing.
https://suitecrm.com/forum/installation-upgrade-help/3739-suitecrm-server-migration-how-to
1 Like
I transfered the files using filezilla. I was moving from one Linux server to another.
I’m going to try your suggestions and report back.
Problem solved.
The whole problem was with Filezillla treating files without an extension as ascii files instead of as binary files. I changed the settings in Filezilla and redownloaded files from old host and then uploaded to new host. Everything is working OK now.
Just a suggestion but I think it would be better to tar and gzip before sending the data over. Saves time and you don’t have to deal with having filezilla open. I usually tar it all, then transfer the file directly from on server to another bypassing the use of my own PC. This allows me to run the transfer over however many hours it can take and leave me free to do other things. Anyways just my 2 cents, I’m glad you were able to figure out the problem!
When I did a transfer recently between servers I tar’d up the main directories and excluded the upload directories, then I transfered the upload directories separately.