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 Multi-Site functionality »
  • civicrm_navigation.mysql Import error
Pages: [1]

Author Topic: civicrm_navigation.mysql Import error  (Read 1428 times)

jacoblee

  • Guest
civicrm_navigation.mysql Import error
March 29, 2010, 03:34:06 pm
I am trying to import the civicrm_navigation.mysql as per step 3 on the multisite installation for Drupal and I am getting the following error:

SQL query:

-- Initial default state of system preferences INSERT INTO civicrm_preferences(domain_id, contact_id, is_domain, contact_view_options, contact_edit_options, advanced_search_options, user_dashboard_options, address_options, address_format, mailing_format, address_standardization_provider, address_standardization_userid, address_standardization_url, editor_id, mailing_backend, contact_autocomplete_options ) VALUES (@domainID,NULL,1,'123456789101113','12345678910','1234567891011121315161718','1234578','123456891011','{contact.address_name}\n{contact.street_address}\n{contact.supplemental_address_1}\n{contact.supplemental_address_2}\n{contact.city}{, }{contact.state_province}{ }{contact.postal_code}\n{contact.country}','{contact.addressee}\n{contact.street_address}\n{contact.supplemental_address_1}\n{contact.supplemental_address_2}\n{contact.city}{, }{contact.state_province}{ }{contact.postal_code}\n{contact.countr[...]

MySQL said:

#1048 - Column 'domain_id' cannot be null

Any help would be greatly appreciated

jacoblee

  • Guest
Re: civicrm_navigation.mysql Import error
March 31, 2010, 05:25:03 pm
I fixed by re-installing civi in a clean drupal install and taking the civicrm_navigation.mysql from the clean install and importing it into the database with the new SELECT @domainID := id FROM civicrm_domain where name = 'site 2';

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Multi-Site functionality »
  • civicrm_navigation.mysql Import error

This forum was archived on 2017-11-26.