Public URL with multiple databases
We have an Odoo (11.0) instance with two databases - one for main usage and another containing historic data. The first one is meant to generate mass mailings, however attached images weren't loading at all from within the e-mails.
After trial and error we found out the cause of this - the image URLs are similar to this http://my-website.com/web/image/# where # is the entry ID on the ir.attachment table. Of course, having multiple databases, when the images are loaded externally without passing any login data, Odoo doesn't know which database has to search the image in, returning an error 404 instead.
As a temporary solution we backed up and deleted the historic database, but I need to know if there's a way to make both DBs coexist while being able to default public calls to the main database.