CiviCRM Community Forums (archive)

I've got a very odd problem - it's probably somethign to do with protections but I don't understand why one bit works and the other doesn't

I've got some code to create a new organization and a new individual in the contacts tabel

To create the organization, the code is

$params = array(
   'contact_type' => 'Organization',
   'organization_name' => $company,
   $custom_nature_of_business => $natureofbusiness,
   'version' => 3,
);
$result = civicrm_api ('contact', 'create', $params);

and this creates the organization record file

to create the individual, the code is

$params = array(
   'first_name' => $firstname,
   'last_name' => $lastname,
   'contact_type' => 'Individual',
   'current_employer' => $company,
   'email' => $email_address,
   'api.phone.create' => array (
      'phone_type_id' => 1,
      'phone' => $phonenumber,
      'is_primary' => 1,
      'location_type_id' => 3,
   ),
   'version' => 3,
);
$result = civicrm_api( 'contact','create',$params );

and it fails with Array ( [is_error] => 1 [error_message] => DB Error: no such table ) - although it does create a record with the first & last names

If I take out the 'current_employer' the call works.

Finally I get something similar when trying to add them to an event

code is

$params = array(
   'contact_id' => $contact_id,
   'event_id' => $event_id,
   'status_id' => $status_id,
   'role_id' => $booked_attendee,
   'register_date' => $today,
   'source' => $source,
   'version' => 3,
);
$result = civicrm_api( 'participant','create',$params );

and again I get Array ( [is_error] => 1 [error_message] => DB Error: no such table )

The person doing the creation has 'public' access (i.e. the lowest of the low). If I try it with someone who has some additional privs it works. I'm particularly concerned about the 'employer' bit

Hi,

Which version of civi are you using? This error seems a bit weird, and what is even weirder is that the api (when used from php and by default) doesn't take into account the permissions.

Do you have extra modules & hooks?

Anyway, to debug further, you might want to try the api explorer (on your site /civicrm/api/explorer) and try to reproduce your calls and see what you get