CiviCRM Community Forums (archive)

Hello,

I hope, that I put this post in the correct chapter/topic.

I do work with a multi-site enviroment in combination with Drupal.
Each user belongs to a group and per group there is a civicrm enviroment.
My main site is www.mainsite.com.
This mainsite has it's own private civicrm database / domainid=1.
If somebody enters the system then he will go to hisgroup.mainsite.com.
This subsite has its another civicrm database (shared) with it's own domainid.
Everything is organised in directories and setttings files.

Quering the system works fine but, adding data gives some errors.
I know by now that the problem must come from the session state of drupal and civicrm. But I cann't find the correct php code or call to civicrm to reset the session state.
I have read : http://issues.civicrm.org/jira/browse/CRM-2667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel.
but hat did not help me.
I have tried to use the command : hisgroup.mainsite.com/civicrm/admin?sessionReset=2
That did not help me either.

For information the error code giving by the system is:
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  250 , 'civicrm_contact,250' ,  2751 ,  20080506113336 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm_20_test_ver/civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  250 , 'civicrm_contact,250' ,  2751 ,  20080506113336 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm_20_test_ver/civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  250 , 'civicrm_contact,250' ,  2751 ,  20080506113336 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm_20_test_ver/civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)

What can I read to solve the problem ?
Are there some lines of code that I can add to my drupal module that resets the session ?
The last solution would be very fine.

Thanks a lot,
Martin

Kurund,

I would like to make everything work fluid. The users logs in, and in the code I would like to solve all problems for the user.
If the user starts in mygroup.mainste.com then everything works fine. The problem (as I can see) is the switch between both sites.
www.mainstite.com to mygroup.mainsite.com. Somewhere civi holds something in the session.
Is there any php code , some function that I can call to full reinitialize civicrm ?

Thanks a lot,
Martin