Connecting to off-site database
Permalink
I'm trying to connect to an off-site database and this connection code:
Loader::db('54.153.*.*','#####','#####','#####',true);
and I keep getting this error:
An exception occurred while executing 'SELECT catalog_id, file_title, is_active FROM catalogs WHERE organization_id_ref = '1'': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'aptuscat_conc1.catalogs' doesn't exist
What's odd about this is that aptuscat_conc1 preflix for this server doesn't exist. How can I get the database to stop adding the prefix? Or is there a way I can structure my query to avoid this?
Loader::db('54.153.*.*','#####','#####','#####',true);
and I keep getting this error:
An exception occurred while executing 'SELECT catalog_id, file_title, is_active FROM catalogs WHERE organization_id_ref = '1'': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'aptuscat_conc1.catalogs' doesn't exist
What's odd about this is that aptuscat_conc1 preflix for this server doesn't exist. How can I get the database to stop adding the prefix? Or is there a way I can structure my query to avoid this?
Is there a way to disable the prefix addition for JUST that one connection?
Is aptuscat_conc1 the name of the database c5 is installed in? (ie not a naming prefix). MySQL reports errors as databasename.tablename.
Yes. But its not the database I'm trying to connect to.
Also, it's not a prefix, that is the database name that it's trying to use but without seeing what you are passing in to the Loader::db can't see if that is correct or not.