If your attachment links are broken.

[Wilson Logan]

if you're happy with using SQLite Studio you can rewrite the path of the attachment directly in the attachment.filename field (see attached).

Cheers,

Wilson.

[Wilson Logan]

OK, I have a non-sql solution.


1) Backup your existing database

2) Create a new database (File--> New Database)

3) Create a new Attachments folder with the same path as the old attachments path currently in PGO.

   e.g.  in my database the old path is  C:/Users/Diane/Appdata/Local/PG Offline 4/Attachments/jabiruengines

(I started off using my wifes PC for testing)

  whereas it *should* be C:/Users/evildrome/Appdata/Local/PG Offline 4/Attachments/jabiruengines

You need to create a new folder C:/Users/Diane/Appdata/Local/PG Offline 4/Attachments/jabiruengines and copy all the
attachments which are in 

  C:/Users/evildrome/Appdata/Local/PG Offline 4/Attachments/jabiruengines

to

  C:/Users/Diane/Appdata/Local/PG Offline 4/Attachments/jabiruengines

because when PGO does the export it expects to find them in

  C:/Users/Diane/Appdata/Local/PG Offline 4/Attachments/jabiruengines

(see attachment "pgo-attachment-location-diane-2" for what goes wrong with the export if you skip this step)

4) Do a normal File --> Export to folder.

5) Create a new database (File--> New Database)

6) Import your messages from the archive created in step 4 to the new database (File--> Import from Folder).

Now the attachments have the correct paths.

Or.. you could substitute steps 5) & 6) with

5) Delete all your messages in your group in your original source database.

6) Backup your attachments which are currently in the target path.

7) Delete all the attachments currently in the target path.

8 ) Import your messages from the archive created in step 4 to the old database (File--> Import from Folder).

The import fills the messages and attachments folder and the path is now correct.

Cheers,

Wilson.