CiviCRM Community Forums (archive)

When I try to execute any batch  CiviCRM script, I get an SQL error:

    Sorry. A non-recoverable error has occurred.

    DB Error: no such table

    Database Error Code: Table 'amyisrae_drp1.users' doesn't exist, 1146

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            

• => CRM_Core_Error
[1] => handle
        )

    

=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT u.* FROM users u WHERE LOWER(u.name) = 'admin' AND u.pass = '32f6662026f705743141586712fbe492' AND u.status = 1 [nativecode=1146 ** Table 'amyisrae_drp1.users' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT u.* FROM users u WHERE LOWER(u.name) = 'admin' AND u.pass = '32f6662026f705743141586712fbe492' AND u.status = 1 [nativecode=1146 ** Table 'amyisrae_drp1.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 u.* FROM users u WHERE LOWER(u.name) = 'admin' AND u.pass = '32f6662026f705743141586712fbe492' AND u.status = 1 [nativecode=1146 ** Table 'amyisrae_drp1.users' doesn't exist]"]
)


I am using Drupal 6.16 and CiviCRM 3.0.2
Ideas?

Thanks,
Sarah

Drupal and CiviCRM are both in the same database. My Drupal user table is called "drup_users" 

set the drupal users table name in administer civicrm >> global settings >> drupal integration settings

lobo

The checklist is mostly for things you are very likely to have to change.

You are probably among a tiny minority that have a non standard table prefix on drupal. I think that's better having the lone one confused once in a while than everyone scratching their head wondering if they should change it everytime.

X+