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.
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.