1. Important notice about Cloudbleed - if your site uses the Cloudflare CDN, and you intend to follow the Joomla security team's advice to change your site "secret", you MUST READ THIS NOTICE.
  2. Fabrik 3.6 Released Remember to backup and test your backup before proceeding with this update. Please report any problems you might experience with this new version here on the forum. You are safe to upgrade to Joomla! 3.7 and PHP 7.x with this version of Fabrik. View the blog for more details on this release.

Sharing file upload data between two databases

Discussion in 'Standard Support' started by uktran, May 17, 2017.

  1. uktran

    uktran Member

    Level: Professional
    I have two joomla/fabrik installs on the same server. I am trying to grant (read only) access to a table to users in the other database.

    Currently I am using a mysql view to create a mirrored table in the other database, which works okay, except of course that the 'other' users can't download files from the upload element column. (which needs to use download script ideally).

    Would one option might be to add a database connection? I've never used these and vaguely remember being warned against this feature? Is it okay to use for this purpose? Would it break the file paths? Is it read only or editable both way?

    Another option I thought might be using S3 uploads as to use full paths, but I couldn't get this to work with the download script for some reason. Also I have 1000s of records that use the old file system paths in the same column and it's not a simple job to transfer the files to S3 and recreate the links.

    Finally, I thought perhaps a cron to replicate the table data might work and I treat it like native data? However, this would just be a snapshot, which is not ideal. Also I'm not sure if the paths (or linked parths) would work with the download script?
     
    Last edited: May 17, 2017
  2. uktran

    uktran Member

    Level: Professional
    Solved now. Managed to get this working with a simple folder ../ so concat("../otherroot/", table)

    I also got the connection working but user prefilters did not work for some reason so resorted back to the above.
     
    cheesegrits likes this.

Share This Page