CiviCRM Community Forums (archive)

Greetings all, I'm trying to get the UpdateMembershipRecord.php script working and am running into the following error:

DB Error: no such table
SELECT u.* FROM jos_users u WHERE LOWER(u.username) = 'admin' AND u.block = 0 [nativecode=1146 ** Table 'civicrmdb.jos_users' doesn't exist]
I am running CiviCRM in a Joomla environment where the CiviCRM has its own database.  The script is looking in the CiviCRM database for the Joomla user table, and of course doesn't find it!

Two questions:
1. Where do I correct the configuration to make the script look in the correct database?
2. Are there any other changes I need to make to the script to accommodate the CMS and CiviCRM data being located in separate databases?

Thanks in advance!

In recent 4.1+ versions, we've switched and are using CMS specific calls (and hence the CMS chooses the DB and query appropriately) for all interactions with the CMS DB.

lobo