CiviCRM Community Forums (archive)

I was getting the following error when I attempted to sync Joomla users with contacts (I expect that CiviCRM should create a contact for the 1 Joomla user I added) ...

unrecoverable error
    Sorry. A non-recoverable error has occurred.
    Database Error Code: Table 'xxxx.users' doesn't exist, 1146
Error Details:
Array
(
    [callback] => Array([0] => CRM_Core_Error [1] => handle)
    => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT id, email, username FROM users where email != '' [nativecode=1146 ** Table 'xxxx.users' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT id, email, username FROM users where email != '' [nativecode=1146 ** Table 'xxxx.users' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT id, email, username FROM users where email != '' [nativecode=1146 ** Table 'xxxx.users' doesn't exist]"]
)

I tried the forums and nothing matched except http://forum.civicrm.org/index.php/topic,96.0.html - I checked civicrm.settings.php as Lobo advised and it looks OK for Joomla 1.0.13 ...

define( 'CIVICRM_UF'               , 'Joomla'        );
define( 'CIVICRM_UF_VERSION'       , '1.0' );
define( 'CIVICRM_UF_USERSTABLENAME', 'jos_users' );

I also noticed under Global Settings in Administer CiviCRM there is a link to Joomla Integration settings (new in 2.0) with Joomla version set to "5.3" and Joomla Users Table set to "users". Setting these to "1.0" and "jos_users" fixes the problem.

There are 2 issues: I couldn't find any guidance on the Joomla Integration Settings; and can't the installation script set them correctly (like civicrm.settings.php)?