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 »
  • Fatal error when entering info for affiliates
Pages: [1]

Author Topic: Fatal error when entering info for affiliates  (Read 3216 times)

bcobin

  • I post frequently
  • ***
  • Posts: 337
  • Karma: 9
    • InterCreative Media
  • CiviCRM version: 4.3.3
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.9
  • PHP version: 5.3
Fatal error when entering info for affiliates
July 01, 2013, 09:04:08 pm
Using Drupal Domain Access - D 7.22 Civi 4.3.4

When accessing the setup data for the affiliate sites, I get the "Sorry we are not able to provide this at the moment" followed by the error below. There's no problem with the base site when accessing the setup data.

This is a database that's been upgraded from D6, 3.4.7 to D 7.22 Civi 4.3.4 BTW, but everything seems OK.

Looks like I'm dead in the water here - any ideas? Thanks much...

•   Notice: Undefined index: contact_id in CRM_Contact_Form_Domain->setDefaultValues() (line 101 of /home/[site]/public_html/sites/all/modules/civicrm/CRM/Contact/Form/Domain.php).
   •   Notice: Undefined index: contact_id in CRM_Contact_Form_Domain->setDefaultValues() (line 117 of /home/[site]/public_html/sites/all/modules/civicrm/CRM/Contact/Form/Domain.php).
   •   Notice: Undefined index: args in CRM_Core_Error::formatBacktrace() (line 601 of /home/[site]/public_html/sites/all/modules/civicrm/CRM/Core/Error.php).
   •   Warning: Invalid argument supplied for foreach() in CRM_Core_Error::formatBacktrace() (line 601 of /home/[site]/public_html/sites/all/modules/civicrm/CRM/Core/Error.php).
« Last Edit: July 01, 2013, 09:55:38 pm by bcobin »

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Fatal error when entering info for affiliates
July 02, 2013, 03:01:21 am
from first look this looks like you have enotice turned on & devel settings to give a backtrace on e-notice OR query logging turned on

but those are fairly unusual settings. Does your watchdog / civicrm.log have any more data about the actual error?
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

bcobin

  • I post frequently
  • ***
  • Posts: 337
  • Karma: 9
    • InterCreative Media
  • CiviCRM version: 4.3.3
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.9
  • PHP version: 5.3
Re: Fatal error when entering info for affiliates
July 04, 2013, 06:35:03 am
No - no further information.

But digging into this further, it looks like a problem with the civicrm_menu table.

I have an earlier multisite deployment that's behaving normally here (this problem is with a new installation) and the older civicrm_menu table shows the different domains.

On the new installation, the civicrm_menu table shows only one entry - and that's for domain 2. There is no entry for domain 1. Domain 1 is an upgraded database (from 3.4.7) that otherwise seems fine and shows the proper, previously-entered information on the configuration pages.

I've had to halt further work on the site until this can be resolved and I'm happy (if that's the right word) to pay to get things working - anybody?

Thanks much for any assistance here - greatly appreciated! And to those in the US... Happy Independence Day! Looking forward to liberating myself from this particular bug...

Note: Possibly related to http://forum.civicrm.org/index.php/topic,28975.15.html which also has to do with known issues regarding multisite and menus.
« Last Edit: July 04, 2013, 06:40:03 am by bcobin »

bcobin

  • I post frequently
  • ***
  • Posts: 337
  • Karma: 9
    • InterCreative Media
  • CiviCRM version: 4.3.3
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.9
  • PHP version: 5.3
Re: Fatal error when entering info for affiliates
July 05, 2013, 07:52:20 am
I tried entering the SQL command from #5 at http://forum.civicrm.org/index.php/topic,28975.msg125499.html#msg125499 - on a database copy - no effect.

So I'm dead in the water here. Again, I'm willing to pay to get this resolved. Any help greatly appreciated... thanks!
« Last Edit: July 05, 2013, 07:57:11 am by bcobin »

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Fatal error when entering info for affiliates
July 06, 2013, 01:41:29 am
When you have problems with civicrm_menu check if you have entries in civicrm_navigation for that domain - if not you should
1) edit sql/civicrm_navigation.sql so that @domain = x where x is your domain id - this is near the top
2) import this edited sql (once per domain)
3) go to url civicrm/menu/rebuild
4) do drush cc civicrm

if you do have entries the sql in the other post will add missing ones
then do steps 3&4 above
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Fatal error when entering info for affiliates
July 06, 2013, 01:56:38 am
It also seems you HAVE TO create the setting for extension directory in the database - copy it from another domain. Other settings you seem to be able to manage in more traditional ways (I think there used to be a ticket about this but it went stale and got closed)
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Fatal error when entering info for affiliates
July 06, 2013, 02:28:34 am
OK so as of 4.3 it seems you need to add (manually at this stage) a contact id for each domain & link it to the domain. This is a schema change in 4.3
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

bcobin

  • I post frequently
  • ***
  • Posts: 337
  • Karma: 9
    • InterCreative Media
  • CiviCRM version: 4.3.3
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.9
  • PHP version: 5.3
Re: Fatal error when entering info for affiliates
July 29, 2013, 10:56:51 am
OK - I have a domain I'm adding. I've set up the corresponding structure in CiviCRM. Its domain ID is 4.

I now add an Organization; its ID is 42091.

By "linking," I assume you mean that the ID and the domain number have to match.

However, when I go into PHPMyAdmin to change the ID, I get a foreign key constraint error, the foreign key being civicrm_address. There is already an entry for 4.

If I try to change the civicrm_domain ID to 42091 so that it matches, I get another FK constraint failure with civicrm_dashboard_domain_id.

Gosh, this is really nasty - it looks like I'm dead in the water again. Any ideas? Thanks much...

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Fatal error when entering info for affiliates
July 29, 2013, 01:40:35 pm
No, in the civicrm_domain table there is a column for a contact id which you have to fill in (in the database)
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

bcobin

  • I post frequently
  • ***
  • Posts: 337
  • Karma: 9
    • InterCreative Media
  • CiviCRM version: 4.3.3
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.9
  • PHP version: 5.3
Re: Fatal error when entering info for affiliates
July 29, 2013, 01:57:36 pm
Got it! Thanks so much, Eileen - you're a lifesaver. Now, back to work - thanks to you... cheers!

bcobin

  • I post frequently
  • ***
  • Posts: 337
  • Karma: 9
    • InterCreative Media
  • CiviCRM version: 4.3.3
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.9
  • PHP version: 5.3
Re: Fatal error when entering info for affiliates
August 02, 2013, 08:40:22 am
OK - so I tried creating the Organization first (so I could get the ID) and then inserted the domain, edited the contact_id of the domain to match and imported the navigation sql for the new domain.

I had already created the group; I turned on Multisite settings and assigned the domain to the appropriate group.

Now, when I go to edit the Organization Address and Contact info on the new domain, the default domain information appears and if I try to edit it, I get a fatal:

DB Error: already exists.

What am I doing wrong? And how do I get out of this? Thanks again... in advance... *sigh*




bcobin

  • I post frequently
  • ***
  • Posts: 337
  • Karma: 9
    • InterCreative Media
  • CiviCRM version: 4.3.3
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.9
  • PHP version: 5.3
Re: Fatal error when entering info for affiliates
August 02, 2013, 09:25:40 am
Duh - Organization name can't be the same as an already existing organization. If I modify the Organization name, it's OK.

Nothing to do with multisite, really (it has to do with duplicate contacts), but the whole new user/domain attachment thing is kinda wonky, IMO.

Anyway - that's that - onwards!

Laryn

  • I post frequently
  • ***
  • Posts: 192
  • Karma: 4
    • CEDC
  • CiviCRM version: 4.6.x
  • CMS version: Drupal 7
Re: Fatal error when entering info for affiliates
April 29, 2014, 07:12:43 am
Quote from: Eileen on July 29, 2013, 01:40:35 pm
No, in the civicrm_domain table there is a column for a contact id which you have to fill in (in the database)

Thank you, Eileen -- this helped me get past an issue that I haven't been able to figure out for some time on a multisite... *Almost* everything was working. :)
CEDC...social justice by design

*Get support on the new CiviCRM help site. /laryn

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Multi-Site functionality »
  • Fatal error when entering info for affiliates

This forum was archived on 2017-11-26.