Hi...
I developed a site on my servers with downloadable products and everything tested well. I moved to the new server and now the media files that were associated with the downloads still have the old path in it. How can I can change it to the new?
I know this is an old post however I have just experienced the same thing. I check the Template safe path and it is correct however when a customer purchases a downloadable product the error message received states a different path. It happens to be the path that was on the old server. Is there a setting or cache that has to be set/reset?
Also I noticed that the product ID did not lign up with the product in the database. Here is the message I received after purchasing a downloadable product via PayPal and clicking on the download link in the invoice.
"Media file is not available (ID=68, path=/home/oldhost/vmfiles/in-him.mp3)"
Can someone please advise?
VirtueMart 2.6.14
PHP - 5.3.29
Joomla - Joomla! 2.5.14
Use phpMyAdmin to check the product paths in the database.
As far as I know, just edit your safepath and it should still work.
Milbo, I tried to change the safepath but got an error when I did, so I left it the same as the Global Config server setting for the Temp file with the suffix of vmfiles/ in stead of temp/
Jenkinhill, I looked in the virtumart_medias table and noticed that the path is incorrect in the field "file_url". It states "/home/oldhost/vmfiles/in-him.mp3". I take it that I will have to manually update this field in all the products. Its a variable - varchar(900) - so I guess there is no other place to update it. I will also try to re upload the mp3 file and see if that fixes the path.
Thanks
You must set the safepath to your new correct path. then you must copy the files into your new path of course.
Then it should work, because I rewrote it so, that it just takes the filename and tries it with the new safepath. Could be also interesting to provide a slq here. I could also add a tool for it.
Yes you will have to update the fields in the db. If you have a lot of products you could do it using SQL, or export a copy of the table and do a search and replace for oldhost/newhost then reimport. I alwayus take a backup copy of a db before making any edits.
Yes Milbo I have the files in the location of the new correct path. Any new product I upload works ok as the file_url in the table is updated with the new path. All the existing products still have the old path pre the migration. So I take it that by changing the safepath the products field "file_url" does not get updated. I'll try and remove the path and just leave the filename to see if it works.
Thanks Kelvyn, I don't have that many so a manual change is ok.
Rather than me purchasing the item again so I can test the path change, is there a counter somewhere that is incremented each time I download a paid product? I just want to click on the same invoice link of the same purchase for testing purposes.
I have no idea. I'd guess some d/l plugins could do that, but none of the sites I have worked on are for downloadable products.
In case you are using the virtual shipment plugin of istraxx, I can help you. If you are using another download software you must ask there.