Answers.Body: <p>The issue is - </p>
  
  <p>you don't have a payment processor type - Moneris</p>
  
  <p>value missing in this SQL : SELECT id FROM civicrm_payment_processor_type where name = 'Moneris'</p>
  
  <p>try to setup a payment processor type first - that should fix the issue </p>
  
  <p>which mean you need to install the payment processor "Moneris" first to fix the issue </p>
  
  <p>thanks - I guess this helps !!!</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-07-26T16:51:12.003Z
Answers.Text: this is the error I'm getting when I try to install the Moneris payment processor. And the error seems to specify that the extension has no entity_id specified. Which seems odd. I'll look at the code myself to add an entity_id.
Answers.UserDisplayName: Ross
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-07-28T12:51:58.583Z
Answers.Text: This got me on the right track after all! Seems all it needed was an empty entry named 'Moneris' which I did manually in the DB. Wasn't in any documentation or readme, but whatever.
Answers.UserDisplayName: Ross
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-07-26T13:56:55.867Z
Answers.LastActivityDate: 2016-07-26T13:56:55.867Z
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Body: <p>Trying to add an extension, I get the following error:</p>
  
  <pre><code>Database Error Code: Column 'entity_id' cannot be null, 1048
  Additional Details:
  Array
  (
      [callback] =&gt; Array
      (
          [0] =&gt; CRM_Core_Error
          [1] =&gt; handle
      )
  
  [code] =&gt; -3
  [message] =&gt; DB Error: constraint violation
  [mode] =&gt; 16
  [debug_info] =&gt; INSERT INTO civicrm_managed (module, name, entity_type, entity_id) VALUES ('ca.civicrm.moneris','Moneris','PaymentProcessorType',(SELECT id FROM civicrm_payment_processor_type where name = 'Moneris')) [nativecode=1048 ** Column 'entity_id' cannot be null]
  [type] =&gt; DB_Error
  [user_info] =&gt; INSERT INTO civicrm_managed (module, name, entity_type, entity_id) VALUES ('ca.civicrm.moneris','Moneris','PaymentProcessorType',(SELECT id FROM civicrm_payment_processor_type where name = 'Moneris')) [nativecode=1048 ** Column 'entity_id' cannot be null]
  [to_string] =&gt; [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_managed (module, name, entity_type, entity_id) VALUES ('ca.civicrm.moneris','Moneris','PaymentProcessorType',(SELECT id FROM civicrm_payment_processor_type where name = 'Moneris')) [nativecode=1048 ** Column 'entity_id' cannot be null]"]
  )
  </code></pre>
  
  <p>Is my extension out of date, or is this fixable?</p>
  
  <p>~ross</p>
  
Tags: <wordpress><extension><payment-processor><error><moneris>
Title: Cannot install extension
ThreadText: # Cannot install extension
  
  (Asked by: username_0 on 2016-07-26)
  
  Trying to add an extension, I get the following error:
  
  ```
  Database Error Code: Column 'entity_id' cannot be null, 1048
  Additional Details:
  Array
  (
      [callback] => Array
      (
          [0] => CRM_Core_Error
          [1] => handle
      )
  
  [code] => -3
  [message] => DB Error: constraint violation
  [mode] => 16
  [debug_info] => INSERT INTO civicrm_managed (module, name, entity_type, entity_id) VALUES ('ca.civicrm.moneris','Moneris','PaymentProcessorType',(SELECT id FROM civicrm_payment_processor_type where name = 'Moneris')) [nativecode=1048 ** Column 'entity_id' cannot be null]
  [type] => DB_Error
  [user_info] => INSERT INTO civicrm_managed (module, name, entity_type, entity_id) VALUES ('ca.civicrm.moneris','Moneris','PaymentProcessorType',(SELECT id FROM civicrm_payment_processor_type where name = 'Moneris')) [nativecode=1048 ** Column 'entity_id' cannot be null]
  [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_managed (module, name, entity_type, entity_id) VALUES ('ca.civicrm.moneris','Moneris','PaymentProcessorType',(SELECT id FROM civicrm_payment_processor_type where name = 'Moneris')) [nativecode=1048 ** Column 'entity_id' cannot be null]"]
  )
  
  ```
  
  Is my extension out of date, or is this fixable?
  
  ~username_0
  
  **Tags:** wordpress, extension, payment-processor, error, moneris
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-07-26. Score: 1
  
  The issue is -
  
  you don't have a payment processor type - Moneris
  
  value missing in this SQL : SELECT id FROM civicrm\_payment\_processor\_type where name = 'Moneris'
  
  try to setup a payment processor type first - that should fix the issue
  
  which mean you need to install the payment processor "Moneris" first to fix the issue
  
  thanks - I guess this helps !!!
  
  > **Comments:**
  > **username_0**: this is the error I'm getting when I try to install the Moneris payment processor. And the error seems to specify that the extension has no entity_id specified. Which seems odd. I'll look at the code myself to add an entity_id.  
  > **username_0**: This got me on the right track after all! Seems all it needed was an empty entry named 'Moneris' which I did manually in the DB. Wasn't in any documentation or readme, but whatever.  
  
  ---
  
  