CiviCRM Community Forums (archive)

After a week of trying, I think I've finally got this thing to cooperate; I did a completely manual install, and it looks like it might work...however, I've yet to load the tables.

Here is the problem...I've got both my development and live sites using the same database...live has a joomla db_prefix of "jlive_" and development has a db_prefix of "jdev_".

From what I can see, the SQL will load these tables into civicrm_tablename, but I'd like it to be, for live and dev, jlive_civicrm_tablename and jdev_civicrm_tablename respectively. How can I do this???

I know I could modify the SQL statements to reflect this, but I'm worried that the code doesn't reference joomla's database prefix anywhere, so it won't find the tables...if it doesn't, it really should...I'm sure I'm not the only one who has run into this!

Help, please!

For cosistency's sake, it really should be included in a future release...this is standard in all Joomla components.

Strangely, $mosConfig_dbprefix IS referenced as a global vaiable in configure.php, but is unused...I'm fairly certain that, in other components, this value is fed to the component by using #_tablename in the code...

I see that there is similar functionality in using the "domain" setting, which I suppose will work, but - IMHO - for the sake of consistency, it should use the Joomla standard unless there is some compelling reason not to.

Thanks for your reply...