CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Syncing users to Drupal
Pages: [1]

Author Topic: Syncing users to Drupal  (Read 895 times)

nimzie

  • I post occasionally
  • **
  • Posts: 85
  • Karma: 1
Syncing users to Drupal
October 16, 2008, 10:17:55 am
I am getting this message when I try and sync users:

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

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

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


The issue (I think) is that this should be looking for the users table (a drupal table) in ncspodo_Drupal.users ... How could the system not have this setting correct? Where do I fix it?

I'm working with v1.9 on this one.

Cheers,

Adam

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Syncing users to Drupal
October 16, 2008, 10:28:18 am
civicrm prefixes it's db tables with 'civicrm_' so in fact it looks like civicrm thinks your drupal database is called ncspodo_crm.

And by what you said it sounds like your drupal db is in fact ncspodo_Drupal

check your civicrm.settings.php file and make sure that you've input your CMS database info as the drupal db and your civicrm database info as the civicrm db...

nimzie

  • I post occasionally
  • **
  • Posts: 85
  • Karma: 1
Re: Syncing users to Drupal
October 16, 2008, 11:20:15 am
I think you were right .. At one point, I joined to the 2 DBs and never updated the settings.

Thanks for your help.

Cheers,

Adam
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Syncing users to Drupal

This forum was archived on 2017-11-26.