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 Drupal Modules (Moderator: Donald Lobo) »
  • CiviCRM and DRUPAL - not updating database
Pages: [1]

Author Topic: CiviCRM and DRUPAL - not updating database  (Read 3182 times)

Shadow

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 1
CiviCRM and DRUPAL - not updating database
March 30, 2009, 10:01:10 am
Hi all - I am in the middle of a big reconfiguration of an existing site - close to 500 records.  The site was setup by someone before I came on board.

I am currently running DRUPAL 6.10 and CiviCRM 2.1 - I updated the site one month ago.

My main problem (one of many) is that CiviCRM's database is not in sync with the DRUPAL user database. (I moved CiviCRM to a seperate database about one year ago - it was residing in the same database as DRUPAL - it was moved because of the size of the total database - it was over 300 tables at that time).  I have check the configuration and scanned the forums until I am blue in the face and do not see why the CiviCRM database is not updated (the CiviCRM record fields remain blank) when a new DRUPAL contact record is created.  So the record numbers in both databases are different.

Do the field names have to be the same in both DRUPAL and CiviCRM?

What else should I check? I checked the configuration to make sure DRUPAL integration is correct - I think it is - The DRUPAL users' table name is displayed and the code shown was pasted at the end of the settings file (I wasn't sure about where it should be pasted) This has me crazy!  A BIG thanks to anyone who can shed light on this problem.

Shadow

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviCRM and DRUPAL - not updating database
March 30, 2009, 10:39:35 am

civicrm and drupal record numbers will rarely be in sync :) there is a table (civicrm_uf_match) which basically maintains the mapping between a drupal user id and a civicrm contact id

they dont share any fields, so field names do not have to be the same

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Shadow

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 1
Re: CiviCRM and DRUPAL - not updating database
March 30, 2009, 10:57:35 am
Why don't the fields fill in?  Basically there are two profiles - when a new user fills out a DRUPAL user record, shouldn't that info transfer over to CiviCRM or is the name/address and so on fields that are in both profiles and databases are not necessary -?  If that is the case then I should redesign the CiviCRM profile to not include those fields.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviCRM and DRUPAL - not updating database
March 30, 2009, 12:23:23 pm

are you using drupal profiles AND civicrm profiles?

note that the two profiles are distinct and do not share any code or data. If you want to collect data during registration and have it stored in CiviCRM you need to use a CiviCRM Profile

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Shadow

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 1
Re: CiviCRM and DRUPAL - not updating database
March 30, 2009, 12:34:47 pm
Ah!  I thought that a user filled out a DRUPAL user record and that data populated the CiviCRM database... or at least that is how it was set up.  So I just need to add the custom fields to a profile and use the profile in registration.  No need to repeat the other fields.............now that could make more sense.  Will redesign the profile.  Thanks Lobo

Shadow

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • CiviCRM and DRUPAL - not updating database

This forum was archived on 2017-11-26.