CiviCRM Community Forums (archive)

Hi - When I run the cron job to send civimail the cron job is looking for a users table that doesn't exist.  

Somehow when I initially set up drupal/civicrm I ended up with everything in the same database.   So while I have a CRM database called "mydomain_civicrm01", it has no tables in it.  All the tables are in my drupal database "mydomain_drup01".

There is a users table in there called drup_users.   I browsed that and I see that the username/encrypted pass combination that is being sought by the cron job is a match, so I guess I need some way to tell the cron job the proper table location?

Can someone please point me in the direction?

Here's the error with all the private fields masked:

I get :

Sorry. A non-recoverable error has occurred.

DB Error: no such table

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

Return to home page.


Error Details:

Array
(
    [callback] => Array
        (
            

• => CRM_Core_Error
[1] => handle
        )

    

Code: [Select]

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

[/quote]

Thanks so much.  Changing the table name made it work, but I corrected the CIVICRM_UF_DSN setting as well.  All seems well now.