CiviSchool Installation Problem

[Roland-ST]

Hi everybody. I faced problem during installation process according to this manual http://wiki.civicrm.org/confluence/display/CRMDOC/CiviSchool+Installation. Problem relates to step 4.
On this step I've got an error:
DB Error: no such table
Table 'develbmi.users' doesn't exist, 1146
then I loged in PhpMyAdmin and realized that in develbmi DB all tables has prefixes like
mdbmi_users. So in my case table is develbmi.mdbmi_users.

So where I can specify for civicrm that my drupal tables have prefixes

I looked to the civicrm.settings.php but didn't find any option there.

I also tried to synchronize civicrm and drupal users from AdminConsole and I've got the same error.

Thanks for help.

[xcf33]

configure -> global settings -> CMS Integration

[Roland-ST]

Thanks a lot. I don't know why I skipped this option in Admin console 

[Roland-ST]

Lobo,
can you confirm if import script working properly.
(http://URL_OF_YOUR_DRUPAL_SITE/sites/all/modules/civicrm/bin/migrate/import.php?name=LOGINNAME&pass=PASSWORD&key=SITEKEY&file=/PATH_TO_YOUR_DRUPAL_ROOT/sites/all/modules/sfschool/sql/xml/SFSModuleData.xml)

I've installed CiviSchool twice on different hostings. My second try was on pure clean drupal 6.17 and CiviCrm 1.3.5. In both cases I've got the error during import.
    *

      Error Details:

      Array
      (
          [callback] => Array
              (
                 

• => CRM_Core_Error
[1] => handle
              )

         

Code: [Select]

=> -3
          [message] => DB Error: constraint violation
          [mode] => 16
          [debug_info] => INSERT INTO civicrm_uf_field (field_name , is_active , is_view , is_required , weight , help_post , visibility , in_selector , is_searchable , label , field_type ) VALUES ('first_name' ,  1 ,  0 ,  1 ,  1 , '' , 'Public Pages and Listings' ,  0 ,  1 , 'First Name' , 'Individual' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm/civicrm_uf_field`, CONSTRAINT `FK_civicrm_uf_field_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`) ON DELETE CASCADE)]
          [type] => DB_Error
          [user_info] => INSERT INTO civicrm_uf_field (field_name , is_active , is_view , is_required , weight , help_post , visibility , in_selector , is_searchable , label , field_type ) VALUES ('first_name' ,  1 ,  0 ,  1 ,  1 , '' , 'Public Pages and Listings' ,  0 ,  1 , 'First Name' , 'Individual' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm/civicrm_uf_field`, CONSTRAINT `FK_civicrm_uf_field_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`) ON DELETE CASCADE)]
          [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_uf_field (field_name , is_active , is_view , is_required , weight , help_post , visibility , in_selector , is_searchable , label , field_type ) VALUES ('first_name' ,  1 ,  0 ,  1 ,  1 , '' , 'Public Pages and Listings' ,  0 ,  1 , 'First Name' , 'Individual' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm/civicrm_uf_field`, CONSTRAINT `FK_civicrm_uf_field_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`) ON DELETE CASCADE)]"]
      )

Thanks.

[dwgnhm]

I too have gotten the error messages listed in the last post:

Error Details:

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

   

Code: [Select]

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_uf_field (field_name , is_active , is_view , is_required , weight , help_post , visibility , in_selector , is_searchable , label , field_type ) VALUES ('first_name' ,  1 ,  0 ,  1 ,  1 , '' , 'Public Pages and Listings' ,  0 ,  1 , 'First Name' , 'Individual' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`pl730_civicrm/civicrm_uf_field`, CONSTRAINT `FK_civicrm_uf_field_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_field (field_name , is_active , is_view , is_required , weight , help_post , visibility , in_selector , is_searchable , label , field_type ) VALUES ('first_name' ,  1 ,  0 ,  1 ,  1 , '' , 'Public Pages and Listings' ,  0 ,  1 , 'First Name' , 'Individual' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`pl730_civicrm/civicrm_uf_field`, CONSTRAINT `FK_civicrm_uf_field_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_uf_field (field_name , is_active , is_view , is_required , weight , help_post , visibility , in_selector , is_searchable , label , field_type ) VALUES ('first_name' ,  1 ,  0 ,  1 ,  1 , '' , 'Public Pages and Listings' ,  0 ,  1 , 'First Name' , 'Individual' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`pl730_civicrm/civicrm_uf_field`, CONSTRAINT `FK_civicrm_uf_field_uf_group_id` FOREIGN KEY (`uf_group_id`) REFERENCES `civicrm_uf_group` (`id`) ON DELETE CASCADE)]"]
)


in my case, the settings I have in the CMS Integration config of CiviCRM are correct - the Drupal users table name is just users.

I was wondering if there's been any further insights in to this.

Thanx,

David


[Donald Lobo]

seems like the insert statement does not have the right uf_group_id. i'm not very sure why this is happening on your install. Would be great if you can debug the migrate/import.php script and figure out why its not getting the uf_group_id value

ping us on irc if u need help getting started

lobo

[clicknation]

Have been trying to reinstall civiSchool and got same error message. Seems to stop just after it returns "Found name, new_household, civicrm_uf_group". In other words, just as it starts to parse the ProfileFields.

Any suggestions.

[Donald Lobo]

since it found the profile group, it should be using the new household profile group id. can u further dig into it and figure out whats happening and why. u can ping us on irc if u need help making progress

lobo

[clicknation]

Okay, I admit I'm totally confused here. I have experience with Drupal, and a beginning understanding of CiviCRM. I installed everything okay. Used the civischool instructions (the import seems to have failed as noted by others and myself above), but now I can't see how civischool integrates into civiCRM. I can enter contacts into civiCRM, even access the Parent-Teacher conference activity. But I don't see how to get to the household forms.

The idea is to allow parents to sign up for an account, fill in all the forms and releases. But how?

I'm sure that there is just one crucial bit of information I am lacking but am finding the civiCRM documentation opaque.

Can anyone help a newbie out here?

[Donald Lobo]

1. civischool is built on top of civicrm, i..e it uses a lot of the civicrm schema and builds additional UI on top of it

2. I'd consider civischool as an alpha module and/or a developer centric module. U'll need someone who knows php/mysql/drupal/civicrm to help you install and get it running

3. check the blog post series: http://civicrm.org/CiviSchool to get an idea and screenshots of whats been done

4. if you are not a coder or not willing to get into the code, i'd recommend hiring web acess from http://civicrm.org/professional/

5. you can also contact us on irc if u need help making progress, but to a large extent u'll need to help yourself and dig in

lobo

[matthewboh]

I'm getting the same error - let me look into the script and I'll post what I found - unless someone else has already found the problem.

Thanks

[Donald Lobo]

might want to jump on IRC. CiviSchool is still in fairly active constant development (across 3.2 and trunk)

lobo