We are working on a long-needed update of our website. I thought I would take the opportunity to also follow what many say is best practice and move our Civi db out of a db shared with our Joomla CMS. I have done this on our development site, and so far so good. Except, that when trying to create a new CiviEvent Listing Joomla module, I get this error: "Table '[organization]_dev.civicrm_event' doesn't exist"
It is true that doesn't exist, because it should be looking for [organization]_dev_civi.civicrm_event. The db [organization]_dev is the CMS only. I've reconfirmed that my database settings are correct in civicrm.settings.php in both Administrator and component. I've cleared the Joomla cache.
Any ideas what's going on? Where else can I look?
In searching for possible fixes, I have made the following changes, to no avail:
Added this line in CMS config file (www/dev/configuration.php) under class JConfig:
public $cividb = 'username_dev_civi';
'dbName' => $jConfig->db,
'dbName' => $jConfig->cividb,
In CiviEvent Listing module file (www/dev/modules/mod_civievent/helper.php)
$db = JFactory::getDBO();
$db = 'username_dev_civi';