I have created a new db named 'sonnys' and created several tables.

I'm trying to query from the 'sonnys' db not the default 'bitnami_joomla' db with this query:SELECT `StoreName`, `StorePhone`, `StoreEmail` FROM `sonnys.tstores`

Thisquery executes properly in ppMySqladmin

When I load the page I get the following error message:
1146 - Table 'bitnami_joomla.sonnys.tstores' doesn't exist SQL=SELECT `StoreName`, `StorePhone`, `StoreEmail` FROM `sonnys.tstores`

When I change the db name in configuration.php I get "jos_" errors.

Is there a way to specify the specific db in the query or do I have to change my configuration.php?

Thanks
Vic

Hello,

If you want to show data from non-Joomla! database, set "Choose source type -> SQL -> Choose DB type" parameter to "External database" value, set "Choose DB type -> DB type" parameter to "MySQL" or to "MySQL (mysqli)" value and enter connection parameters (host, user name, password, db name) in "External database" parameter section.

Regards,
ARI Soft

Great, thanks, that worked! But the page now says 'No data available.' and the query works in phpMyAdmin. Any suggestions?
Vic

Try to set "SQL -> Debug" parameter to "Yes". If it doesn't help to find the reason of the problem, could you provide a link to a page where the problem occurs and a temporary access to your J! backend by email so we can investigate the problem in more details?

Regards,
ARI Soft

I tried that but no luck.

I'm running it on localhost right now, so there's no access. When I uploaded it the net I will write back with access.

Thanks,
Vic