DB Error: no such table DrupalDBname.users' doesn't exist, 1146

[lal2017]

When I 'Synchronize Users to Contacts'

I get the following error:

Sorry. A non-recoverable error has occurred.
DB Error: no such table
Database Error Code: Table 'dhilwano_drup04.users' doesn't exist, 1146

• I am using Drupal 6.13 with CiviCRM 3.0 Beta3.
• dhilwano_drup04 is my Drupal DB
• dhilwano_CiviCRM is my CiviCRM DB
• I am using Bluehost for webhosting.

I have triple checked the database connection settings and even tried deleting the civicrm.settings.php file from /public_html/sites/default folder to attempt re-installation 3 times. I originally experienced this problem using CiviCRM 3.0 Alpha so deleted the CiviCRM files and installed Beta 3 instead.

I am setting CiviCRM up to a separate DB (not the same as the drupal one) and have triple checked that the SQL account used has full privileges to both CiviCRM and Drupal DBs.

Code: [Select]

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT uid, mail, name FROM users where mail != '' [nativecode=1146 ** Table 'dhilwano_drup04.users' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT uid, mail, name FROM users where mail != '' [nativecode=1146 ** Table 'dhilwano_drup04.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 uid, mail, name FROM users where mail != '' [nativecode=1146 ** Table 'dhilwano_drup04.users' doesn't exist]"]
)


• I have deleted most of the user accounts leaving only 2 for which I have checked e-mails in drupal users are unique.
• I used a facility in the Bluehost control panel to list the tables in the dhilwano_drup04 DB and in fact there is no 'users' table there. Could this mean there is something wrong with my Drupal install? I only recently set it up (10 weeks ago) using simple scripts deployment available through the Bluehost control panel. So both Drupal 6.13 and CiviCRM 3.0 Beta are fresh out of the box???
• I've very carefully followed the CiviCRM drupal install instructions, so I am at a loss as to where I may have gone wrong???

I am really stuck on this and would really appreciate any help from anyone who could point me in the right direction.

Thanks in advance.
Raj

[/code]

[Donald Lobo]

seems like your drupal tables are prefixed? and the users table is called something else

u can let civicrm know what its called by going to: administer civicrm >> global settings >> drupal integration settings

lobo