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 CiviMember (Moderator: Deepak Srivastava) »
  • Intermittent error: One of parameters (value: ) is not of the type Integer
Pages: [1]

Author Topic: Intermittent error: One of parameters (value: ) is not of the type Integer  (Read 961 times)

JoeMurray

  • Administrator
  • Ask me questions
  • *****
  • Posts: 578
  • Karma: 24
    • JMA Consulting
  • CiviCRM version: 4.4 and 4.5 (as of Nov 2014)
  • CMS version: Drupal, WordPress, Joomla
  • MySQL version: MySQL 5.5, 5.6, MariaDB 10.0 (as of Nov 2014)
Intermittent error: One of parameters (value: ) is not of the type Integer
July 28, 2010, 07:45:39 am
I've been having trouble with an intermittent error that comes up when people attempt to buy a membership.

I instrumented the code to log information that might be useful in troubleshooting. I've reproduced its output below. Also copied below is the output of show create table for the relevant custom table. It appears to me that the only Integers that might be at issue are a couple of yes/no fields that are not included in the profile but are in the table, national_board_director_58 or chapter_executive_62. They have a DEFAULT NULL in the table definition, however. Feedback or further things I could do to help track the cause of this down would be appreciated.

Jul 27 11:15:26  [info] $DOC intermittent error instrumentation: $membershipParams = Array
(
    [qfKey] => ee092a19837bf661804d13d91686f86a
    [email-5] => alexmargi@hotmail.com
    [selectMembership] => 2
    [amount] =>
    [amount_other] =>
    [organization_name] =>
    [first_name] => Christine
    [middle_name] =>
    [last_name] => Rocheleau
    [street_address-Primary] => 6516 Louis-Hemon
    [city-Primary] => Montreal
    [postal_code-Primary] => H2G 2K9
    [country-Primary] => 1039
    [state_province-Primary] => 1110
    [current_employer] => Homme a la camera/ 7e film productions inc.
    [home_URL] =>
    [job_title] => DOP
    [phone-1-1] =>
    [phone-2-1] => 514 432-2056
    [phone-4-2] => 514 432-2056
    [custom_54] => Quebec
    [custom_56] => 1
    [custom_66] => 0
    [custom_67] => Array
        (
        )

    [custom_68] =>
    [custom_69] =>
    [custom_70] =>
    [custom_71] =>
    [custom_72] =>
    [custom_73] =>
    [custom_74] =>
    [custom_65] =>
    [billing_first_name] => Christine
    [billing_middle_name] =>
    [billing_last_name] => Rocheleau
    [billing_street_address-5] => 6516 Louis-Hemon
    [billing_city-5] => Montreal
    [billing_state_province_id-5] => 1110
    [billing_postal_code-5] => H2G 2K9
    [billing_country_id-5] => 1039
    [credit_card_number] => Obsfucated before logging
    [cvv2] => Obsfucated before logging
    [credit_card_exp_date] => Obsfucated before logging
    [credit_card_type] => Visa
    [MAX_FILE_SIZE] => 8388608
    [billing_state_province-5] => QC
    [billing_country-5] => CA
    [year] => Obsfucated before logging
    [month] => Obsfucated before logging
    [ip_address] => 72.11.164.111
    [currencyID] => CAD
    [payment_action] => Sale
    [invoiceID] => 19fc6a7286c06bb986d4e541fed4c2da
    [amount_level] =>
    [is_pay_later] =>
    [description] => Online Contribution: Memberships - Valid from July - December 2010
    [accountingCode] =>
    [email] => alexmargi@hotmail.com
    [street_address] => 6516 Louis-Hemon
    [city] => Montreal
    [state_province] => QC
    [postal_code] => H2G 2K9
    [country] => CA
    [cms_contactID] => 11115
)


Jul 27 11:15:26  [info] $DOC intermittent error instrumentation: $contactID = 11115

Jul 27 11:15:26  [info] $DOC intermittent error instrumentation: $premiumParams = Array
(
    [qfKey] => ee092a19837bf661804d13d91686f86a
    [email-5] => alexmargi@hotmail.com
    [selectMembership] => 2
    [amount] =>
    [amount_other] =>
    [organization_name] =>
    [first_name] => Alex
    [middle_name] =>
    [last_name] => Margineanu
    [street_address-Primary] => 6516 Louis-Hemon
    [city-Primary] => Montreal
    [postal_code-Primary] => H2G 2K9
    [country-Primary] => 1039
    [state_province-Primary] => 1110
    [current_employer] => Homme a la camera/ 7e film productions inc.
    [home_URL] =>
    [job_title] => DOP
    [phone-1-1] =>
    [phone-2-1] => 514 432-2056
    [phone-4-2] => 514 432-2056
    [custom_54] => Quebec
    [custom_56] => 1
    [custom_66] => 0
    [custom_67] => Array
        (
        )

    [custom_68] =>
    [custom_69] =>
    [custom_70] =>
    [custom_71] =>
    [custom_72] =>
    [custom_73] =>
    [custom_74] =>
    [custom_65] =>
    [billing_first_name] => Christine
    [billing_middle_name] =>
    [billing_last_name] => Rocheleau
    [billing_street_address-5] => 6516 Louis-Hemon
    [billing_city-5] => Montreal
    [billing_state_province_id-5] => 1110
    [billing_postal_code-5] => H2G 2K9
    [billing_country_id-5] => 1039
    [credit_card_number] => Obsfucated before logging
    [cvv2] => Obsfucated before logging
    [credit_card_exp_date] => Obsfucated before logging
    [credit_card_type] => Visa
    [MAX_FILE_SIZE] => 8388608
    [billing_state_province-5] => QC
    [billing_country-5] => CA
    [year] => Obsfucated before logging
    [month] => Obsfucated before logging
    [ip_address] => 72.11.164.111
    [currencyID] => CAD
    [payment_action] => Sale
    [invoiceID] => 19fc6a7286c06bb986d4e541fed4c2da
    [amount_level] =>
    [is_pay_later] =>
    [description] => Online Contribution: Memberships - Valid from July - December 2010
    [accountingCode] =>
)


Jul 27 11:15:26  [info] $DOC intermittent error instrumentation: $_SERVER[HTTP_USER_AGENT] = Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10_4_11; fr) AppleWebKit/531.21.8 (KHTML, like Gecko) Version/4.0.4 Safari/531.21.10

Jul 27 11:15:26  [info] $Fatal Error Details = Array
(
    [message] => One of parameters  (value: ) is not of the type Integer
   
Code: [Select]
=>
)


Jul 27 11:15:26  [info] $backTrace = /home/cd6/htdocs/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 264, CRM_Core_Error, ::, Array
/home/cd6/htdocs/sites/all/modules/civicrm/CRM/Utils/Type.php, fatal, 257, CRM_Core_Error, ::, Array
/home/cd6/htdocs/sites/all/modules/civicrm/CRM/Core/DAO.php, validate, 919, CRM_Utils_Type, ::, Array
/home/cd6/htdocs/sites/all/modules/civicrm/CRM/Core/DAO.php, composeQuery, 858, CRM_Core_DAO, ::, Array
/home/cd6/htdocs/sites/all/modules/civicrm/CRM/Core/BAO/CustomValueTable.php, executeQuery, 224, CRM_Core_DAO, ::, Array
/home/cd6/htdocs/sites/all/modules/civicrm/CRM/Core/BAO/CustomValueTable.php, create, 322, CRM_Core_BAO_CustomValueTable, ->, Array
/home/cd6/htdocs/sites/all/modules/civicrm/CRM/Core/BAO/CustomValueTable.php, store, 335, CRM_Core_BAO_CustomValueTable, ->, Array
/home/cd6/htdocs/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php, postProcess, 1052, CRM_Core_BAO_CustomValueTable, ->, Array
/home/cd6/docorg.ca/files/civicrm/custom_php/CRM/Contribute/Form/Contribution/Confirm.php, postProcessMembership, 537, CRM_Member_BAO_Membership, ->, Array
/home/cd6/htdocs/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 250, CRM_Contribute_Form_Contribution_Confirm, ->, Array
/home/cd6/htdocs/sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 167, CRM_Core_Form, ->, Array
/home/cd6/htdocs/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 64, CRM_Core_StateMachine, ->, Array
/home/cd6/htdocs/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203, CRM_Core_QuickForm_Action_Next, ->, Array
/home/cd6/htdocs/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103, HTML_QuickForm_Controller, ->, Array
/home/cd6/htdocs/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 263, HTML_QuickForm_Page, ->, Array
/home/cd6/htdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 210, CRM_Core_Controller, ->, Array
/home/cd6/htdocs/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 350, CRM_Core_Invoke, ::, Array
, civicrm_invoke, , , , Array
/home/cd6/htdocs/includes/menu.inc, call_user_func_array, 348, , , Array
/home/cd6/htdocs/index.php, menu_execute_active_handler, 18, , , Array

Reviewing the values of the params doesn't make it clear what the types are for each one. Here is the definition of the relevant custom table:

CREATE TABLE `civicrm_value_membership_information__new_10` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Default MySQL primary key',
 `entity_id` int(10) unsigned NOT NULL COMMENT 'Table that this extends',
 `chapter_54` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `membership_number_55` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `please_mail_me_a_complementary_c_56` tinyint(4) DEFAULT '1',
 `gst_exempt_57` tinyint(4) DEFAULT NULL,
 `national_board_director_58` tinyint(4) DEFAULT NULL,
 `national_board_position_59` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `ad_hoc_committee_name_60` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `national_committees_61` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `chapter_executive_62` tinyint(4) DEFAULT NULL,
 `chapter_committees_63` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `chapter_executive_position_64` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `membership_order_comments_65` text COLLATE utf8_unicode_ci,
 `doc_volunteer_66` tinyint(4) DEFAULT NULL,
 `if_yes_please_indicate_your_pref_67` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `other_volunteer_interests_68` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `first_name__2nd_person__69` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `last_name__2nd_person__70` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `email__2nd_person__71` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `first_name__3rd_person__72` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `last_name__3rd_person__73` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `email__3rd_person__74` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `national_committee_postion_75` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `chapter_committee_position_76` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `unique_entity_id` (`entity_id`),
 KEY `INDEX_chapter_54` (`chapter_54`),
 KEY `INDEX_please_mail_me_a_complementary_c_56` (`please_mail_me_a_complementary_c_56`),
 KEY `INDEX_national_board_director_58` (`national_board_director_58`),
 KEY `INDEX_national_committees_61` (`national_committees_61`),
 CONSTRAINT `FK_civicrm_value_membership_informa_ba81d1ad04b02f9c` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_membership` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5958 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Co-author of Using CiviCRM https://www.packtpub.com/using-civicrm/book

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Intermittent error: One of parameters (value: ) is not of the type Integer
July 28, 2010, 11:51:26 am
Joe - you should dump the values of the $query and $params variables just prior to line 224 in CustomValueTables.php. That should give u a good idea of what the query looks like and what params are being passed.
Protect your investment in CiviCRM by  becoming a Member!

JoeMurray

  • Administrator
  • Ask me questions
  • *****
  • Posts: 578
  • Karma: 24
    • JMA Consulting
  • CiviCRM version: 4.4 and 4.5 (as of Nov 2014)
  • CMS version: Drupal, WordPress, Joomla
  • MySQL version: MySQL 5.5, 5.6, MariaDB 10.0 (as of Nov 2014)
Re: Intermittent error: One of parameters (value: ) is not of the type Integer
August 05, 2010, 12:07:42 pm
Thx. Will do.
Co-author of Using CiviCRM https://www.packtpub.com/using-civicrm/book
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Intermittent error: One of parameters (value: ) is not of the type Integer

This forum was archived on 2017-11-26.