Good morning,

I'm in the process of moving our site to a new hosting service; when I tested the move, all the securefile uploaded images ceased displaying; I can see them in their proper place in the root/couch/uploads/attachments/ folder, but the links are broken. No code was changed between the current, live host and the new, test host.

Is there a fix for this other than manually re-uploading all the images? I have over 400, so it would be awesome if it could be fixed simply.

Thanks in advance.

[KK]

Hi slink,

I think you can try the following -
use phpMyAdmin on your old installation and from the 'Export' tab create a dump of *only* the 'couch_attachments' table - choose 'SQL' format for the dump file.

You need to export only the 'data' and not the 'structure' as the table is already present in the new installation. To make sure of this, open the sql file in a text editor and remove the 'CREATE TABLE' block if present.

Now on the new installation, import the dump file created above.
I think that should rectify the situation.

Please let us know how it goes.

Thanks.

I'll try that, once I navigate the messy SQL access implementation on my current host - for reasons unknown, they don't use phpMyAdmin, so the backup process is a little arcane.

That worked brilliantly! Thanks, KK!

[KK]

I'm glad it worked