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 CiviContribute (Moderator: Donald Lobo) »
  • RESOLVED: Error When Entering a New Contribution
Pages: [1]

Author Topic: RESOLVED: Error When Entering a New Contribution  (Read 2227 times)

digitalzen

  • I post occasionally
  • **
  • Posts: 46
  • Karma: 0
RESOLVED: Error When Entering a New Contribution
October 10, 2012, 12:04:27 am
Hello,

I've encountered a rather peculiar error when I attempt to enter any sort of contribution in CiviCRM. This problem is likely an offshoot/subordinate of the problem I encountered in http://forum.civicrm.org/index.php/topic,25992.msg110518.html#msg110518, as I opted not to take Deephak's advice, and manually repaired my database (which worked well, for the most part).

When I attempt to enter a contribution, CiviCRM throws the following error:

Quote
CiviCRM-001 - An error has occurred.
Sorry but we are not able to provide this at the moment.
One of parameters (value: ) is not of the type Integer

Here's the log (which I'm having a bit of a hard time deciphering):

Code: [Select]
Oct 09 23:40:16  [info] $Fatal Error Details = Array
(
    [message] => One of parameters  (value: ) is not of the type Integer
    [code] =>
)


Oct 09 23:40:16  [info] $backTrace = #0 /home/wa46dems/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(300): CRM_Core_Error::backtrace("backTrace", TRUE)
[color=red]#1 /home/wa46dems/public_html/administrator/components/com_civicrm/civicrm/CRM/Utils/Type.php(324): CRM_Core_Error::fatal("One of parameters  (value: ) is not of the type Integer")
[/color]#2 /home/wa46dems/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(982): CRM_Utils_Type::validate(NULL, "Integer")
#3 /home/wa46dems/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(907): CRM_Core_DAO::composeQuery("SELECT id,name,label,html_type,is_enter_qty,help_pre,help_post,weight,is_disp...", (Array:1), TRUE)
#4 /home/wa46dems/public_html/administrator/components/com_civicrm/civicrm/CRM/Price/BAO/Set.php(502): CRM_Core_DAO::executeQuery("SELECT id,name,label,html_type,is_enter_qty,help_pre,help_post,weight,is_disp...", (Array:1))
#5 /home/wa46dems/public_html/administrator/components/com_civicrm/civicrm/CRM/Contribute/Form/Contribution.php(1141): CRM_Price_BAO_Set::getSetDetail(NULL)
#6 /home/wa46dems/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php(246): CRM_Contribute_Form_Contribution->postProcess()
#7 /home/wa46dems/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Upload.php(151): CRM_Core_Form->mainProcess()
#8 /home/wa46dems/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Upload.php(128): CRM_Core_QuickForm_Action_Upload->realPerform(Object(CRM_Contribute_Form_Contribution), "upload")
#9 /home/wa46dems/public_html/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Upload->perform(Object(CRM_Contribute_Form_Contribution), "upload")
#10 /home/wa46dems/public_html/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contribute_Form_Contribution), "upload")
#11 /home/wa46dems/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php(289): HTML_QuickForm_Page->handle("upload")
#12 /home/wa46dems/public_html/administrator/components/com_civicrm/civicrm/CRM/Contribute/Page/Tab.php(296): CRM_Core_Controller->run()
#13 /home/wa46dems/public_html/administrator/components/com_civicrm/civicrm/CRM/Contribute/Page/Tab.php(353): CRM_Contribute_Page_Tab->edit()
#14 /home/wa46dems/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(228): CRM_Contribute_Page_Tab->run((Array:4), NULL)
#15 /home/wa46dems/public_html/administrator/components/com_civicrm/admin.civicrm.php(87): CRM_Core_Invoke::invoke((Array:4))
#16 /home/wa46dems/public_html/administrator/components/com_civicrm/admin.civicrm.php(40): civicrm_invoke()
#17 /home/wa46dems/public_html/libraries/joomla/application/component/helper.php(383): require_once("/home/wa46dems/public_html/administrator/components/com_civicrm/admin.civicrm...")
#18 /home/wa46dems/public_html/libraries/joomla/application/component/helper.php(351): JComponentHelper::executeComponent("/home/wa46dems/public_html/administrator/components/com_civicrm/admin.civicrm...")
#19 /home/wa46dems/public_html/administrator/includes/application.php(153): JComponentHelper::renderComponent("com_civicrm")
#20 /home/wa46dems/public_html/administrator/index.php(46): JAdministrator->dispatch()
#21 {main}
Judging from the log, this does not appear to be a database or data structure problem, as it has no reference to any of the MySQL tables as in my previous problem. It appears that maybe there's one item triggering a cascade? Unfortunately the error isn't real specific about WHICH field/value it doesn't like. Or maybe I'm barking up the wrong tree?

My system specs are as follows:
  • Joomla 2.5.7
  • CiviCRM 4.2 (upgraded to 4.2.2 in an attempt to troubleshoot, but it didn't seem to help)
  • PHP 5.2.17 (have filed a request for my ISP to upgrade to 5.3 in order to support CiviCRM 4.2.2; database was NOT updated, but the problem existed starting in 4.2)
  • MySQL 5.1.63-cll

As always, any assistance is greatly appreciated... even if you could just point me in the right direction?  ???

Thanks!
Chris
Digital Zen
« Last Edit: October 13, 2012, 01:32:28 pm by digitalzen »

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Error When Entering a New Contribution
October 10, 2012, 12:24:16 am
My guess is that you are missing the default price sets. The sql below is taken from one of my databases & has id's in it for price_set & that is referenced in the price field lines - so you may not be able to simply copy & paste it.

Code: [Select]
INSERT INTO `civicrm_price_set` (`id`, `domain_id`, `name`, `title`, `is_active`, `help_pre`, `help_post`, `javascript`, `extends`, `contribution_type_id`, `is_quick_config`, `is_reserved`) VALUES (10, NULL, 'default_contribution_amount', 'Contribution Amount', 1, NULL, NULL, NULL, '2', NULL, 1, 1);
INSERT INTO `civicrm_price_set` (`id`, `domain_id`, `name`, `title`, `is_active`, `help_pre`, `help_post`, `javascript`, `extends`, `contribution_type_id`, `is_quick_config`, `is_reserved`) VALUES (11, NULL, 'default_membership_type_amount', 'Membership Amount', 1, NULL, NULL, NULL, '3', 2, 1, 1);

INSERT INTO `civicrm_price_field` (`id`, `price_set_id`, `name`, `label`, `html_type`, `is_enter_qty`, `help_pre`, `help_post`, `weight`, `is_display_amounts`, `options_per_line`, `is_active`, `is_required`, `active_on`, `expire_on`, `javascript`, `visibility_id`) VALUES (22, 11, 'membership_amount', 'Membership Amount', 'Radio', 0, NULL, NULL, 1, 0, 1, 1, 0, NULL, NULL, NULL, 1);
INSERT INTO `civicrm_price_field` (`id`, `price_set_id`, `name`, `label`, `html_type`, `is_enter_qty`, `help_pre`, `help_post`, `weight`, `is_display_amounts`, `options_per_line`, `is_active`, `is_required`, `active_on`, `expire_on`, `javascript`, `visibility_id`) VALUES (21, 10, 'contribution_amount', 'Contribution Amount', 'Text', 0, NULL, NULL, 1, 1, 1, 1, 1, NULL, NULL, NULL, 1);

Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

digitalzen

  • I post occasionally
  • **
  • Posts: 46
  • Karma: 0
Re: Error When Entering a New Contribution
October 10, 2012, 09:24:13 am
Hi Eileen,

That makes a lot of sense, and I suspected it might be something along those lines.

Actually, this morning, a better solution to my problem occurred to me: since my database may still have latent problems from my previous issue (see link above), What if I just dump the data out to a gzipped backup, uninstall CiviCRM, drop all my civicrm tables, reinstall clean, and then import my data back into the "healthy" structure?

About the only potential problem I can see is if I have a column in one or more table whose name needs to be changed.

Thoughts?

UPDATE: Maybe my idea wasn't so hot after all. Doesn't seem to be working. I think I'll take a stab at your suggestion, after all, Eileen. Thanks again for the feedback!

Chris
« Last Edit: October 11, 2012, 12:30:14 am by digitalzen »

digitalzen

  • I post occasionally
  • **
  • Posts: 46
  • Karma: 0
RESOLVED Re: Error When Entering a New Contribution
October 13, 2012, 01:31:53 pm
Eileen,

You were SPOT ON! Thank you so much for your help. I got the default rows in and everything is purring along beautifully.

Cheers!

Chris

zkrebs

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 1
Re: RESOLVED: Error When Entering a New Contribution
March 16, 2015, 11:44:39 am
I just experienced this bug on a contribution page that has been updated to CiviCRM 4.5.x

I made a Price Set for my Contribution and switched to that vs. using the built in contribution amounts, and it solved the problem (for now)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • RESOLVED: Error When Entering a New Contribution

This forum was archived on 2017-11-26.