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) »
  • Issue with 'on behalf of' contribution page
Pages: [1]

Author Topic: Issue with 'on behalf of' contribution page  (Read 2326 times)

Thinkwell

  • I post occasionally
  • **
  • Posts: 37
  • Karma: 0
  • CiviCRM version: 4.2.7
  • CMS version: Wordpress 3.5.1
  • MySQL version: 5.5.29
  • PHP version: 5.2
Issue with 'on behalf of' contribution page
August 05, 2013, 02:47:57 pm
Not sure if this is a bug to be logged, but on a Contribution page I have created, once I enable "Allow individuals to contribute and / or signup for membership on behalf of an organization?" The form loads without any template (plain HTML) and the following error is displayed:

"DB Error: Uknown error"

Any insight?

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Issue with 'on behalf of' contribution page
August 05, 2013, 05:30:20 pm
Check the CiviCRM log to get the details of this error.
Protect your investment in CiviCRM by  becoming a Member!

Thinkwell

  • I post occasionally
  • **
  • Posts: 37
  • Karma: 0
  • CiviCRM version: 4.2.7
  • CMS version: Wordpress 3.5.1
  • MySQL version: 5.5.29
  • PHP version: 5.2
Re: Issue with 'on behalf of' contribution page
August 05, 2013, 06:43:24 pm
Thanks Dave.... A bit over my head on this one (although I am noticing the MySQL 'max_allowed_packet' error which I know needs to be fixed the config file). Just not sure if there's anything else based on this partial copy and paste:

Aug 05 20:58:41  [info] $backTrace = #0 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/CRM/Core/Error.php(196): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#4 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#5 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...", "DB_Error", TRUE)
#6 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-1, NULL, NULL, NULL, "1153 ** Got a packet bigger than 'max_allowed_packet' bytes")
#7 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#9 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#10 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(1055): DB_DataObject->_query("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#11 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/CRM/Core/DAO.php(287): DB_DataObject->insert()
#12 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/CRM/Core/BAO/Cache.php(131): CRM_Core_DAO->save()
#13 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/CRM/Core/BAO/Cache.php(199): CRM_Core_BAO_Cache::setItem((Array:15), "CiviCRM Session", "CiviCRM_CRM_Contribute_Controller_Contribution_8ff3eb924612f25648ede484e6b83d...")
#14 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/CRM/Core/Session.php(539): CRM_Core_BAO_Cache::storeSessionToCache((Array:2), TRUE)
#15 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(295): CRM_Core_Session::storeSessionObjects()
#16 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:15))
#17 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#18 /var/www/vhosts/canoemuseum.ca/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module(436): CRM_Core_Invoke::invoke((Array:3))
#19 [internal function](): civicrm_invoke("contribute", "transact")
#20 /var/www/vhosts/canoemuseum.ca/httpdocs/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#21 /var/www/vhosts/canoemuseum.ca/httpdocs/index.php(21): menu_execute_active_handler()
#22 {main}

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Issue with 'on behalf of' contribution page
August 06, 2013, 12:40:56 pm
Based on this dump, it does look like you need to increase max_allowed_packet size in your MySQL configuration. (The error is occurring after the attempt to insert a row in the civicrm_cache table.) You could try just truncating that table first (it's all temporary data - UNLESS you are using Batch Data Entry and have entered but not saved some transactions).
Protect your investment in CiviCRM by  becoming a Member!

Thinkwell

  • I post occasionally
  • **
  • Posts: 37
  • Karma: 0
  • CiviCRM version: 4.2.7
  • CMS version: Wordpress 3.5.1
  • MySQL version: 5.5.29
  • PHP version: 5.2
Re: Issue with 'on behalf of' contribution page
August 06, 2013, 06:40:06 pm
Many thanks Dave

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Issue with 'on behalf of' contribution page

This forum was archived on 2017-11-26.