CiviCRM Community Forums (archive)

Hi Hamish,

That module hasn't been updated for APIv3, and so is incompatible with Civi 4.3+.  It'll need updating before it works.  Other folks have had the same problem, but unfortunately none with funds to support someone porting it to APIv3   

Hi Hamish,

I believe that the APIv2 is deprecated as of CiviCRM 3.2 - but that they didn't remove it until Civi 4.3.  I can't swear to it though, sorry.

As for pledging toward the project - are you referring to CiviCRM, or to the CiviCRM-Ubercart integration module?

To pledge to CiviCRM:
http://civicrm.org/participate/support-civicrm

If you're looking to fund the update of the Ubercart-CiviCRM module, I'd contact the author of the module, dharmatech: https://drupal.org/user/64968

If Dharmatech isn't interested in updating the module, a) you can post in the professional services forum on this site, and b) you can reply back to this ticket.  I'd have to talk to my coworkers, but I think we'd be willing to do this at a discount as part of our effort to keep the plugin ecosystem strong.

Note that although the v2 api folder was removed in 4.3 there is nothing stopping you from copying the v2 folder into your 4.3 install.

However, from the error you have reported  it's not clear that the absence of the v2 api is the immediate cause of the problem

Same error using 4.2.9 but nothing in the error log this time.

Can someone help me decrypt this?
Next steps?
I'm guessing #6 is the clue?

Hamish

#0 /home/bldsheep/public_html/esa/sites/all/modules/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/bldsheep/public_html/esa/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/bldsheep/public_html/esa/sites/all/modules/civicrm/packages/DB.php(968): PEAR_Error->PEAR_Error("DB Error: syntax error", -2, 16, (Array:2), "SELECT id, name FROM {civicrm_contribution_type} WHERE is_active = 1 [nativec...")
#4 /home/bldsheep/public_html/esa/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-2, 16, (Array:2), "SELECT id, name FROM {civicrm_contribution_type} WHERE is_active = 1 [nativec...")
#5 /home/bldsheep/public_html/esa/sites/all/modules/civicrm/packages/DB/common.php(1903): PEAR->raiseError(NULL, -2, NULL, NULL, "SELECT id, name FROM {civicrm_contribution_type} WHERE is_active = 1 [nativec...", "DB_Error", TRUE)
#6 /home/bldsheep/public_html/esa/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-2, NULL, NULL, NULL, "1064 ** You have an error in your SQL syntax; check the manual that correspon...")
#7 /home/bldsheep/public_html/esa/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home/bldsheep/public_html/esa/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT id, name FROM {civicrm_contribution_type} WHERE is_active = 1")
#9 /home/bldsheep/public_html/esa/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("SELECT id, name FROM {civicrm_contribution_type} WHERE is_active = 1")
#10 /home/bldsheep/public_html/esa/sites/all/modules/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("SELECT id, name FROM {civicrm_contribution_type} WHERE is_active = 1")
#11 /home/bldsheep/public_html/esa/sites/all/modules/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query("SELECT id, name FROM {civicrm_contribution_type} WHERE is_active = 1")
#12 /home/bldsheep/public_html/esa/sites/all/modules/civicrm/CRM/Core/DAO.php(922): CRM_Core_DAO->query("SELECT id, name FROM {civicrm_contribution_type} WHERE is_active = 1", TRUE)
#13 /home/bldsheep/public_html/esa/sites/all/modules/uc_civicrm/uc_civicrm.module(107): CRM_Core_DAO::executeQuery("SELECT id, name FROM {civicrm_contribution_type} WHERE is_active = 1", (Array:0))
#14 [internal function](): uc_civicrm_admin((Array:0), (Array:13))
#15 /home/bldsheep/public_html/esa/includes/form.inc(798): call_user_func_array("uc_civicrm_admin", (Array:2))
#16 /home/bldsheep/public_html/esa/includes/form.inc(339): drupal_retrieve_form("uc_civicrm_admin", (Array:13))
#17 /home/bldsheep/public_html/esa/includes/form.inc(131): drupal_build_form("uc_civicrm_admin", (Array:13))
#18 [internal function](): drupal_get_form("uc_civicrm_admin")
#19 /home/bldsheep/public_html/esa/includes/menu.inc(517): call_user_func_array("drupal_get_form", (Array:1))
#20 /home/bldsheep/public_html/esa/index.php(21): menu_execute_active_handler()
#21 {main}

 {civicrm_contribution_type}  is a drupal convention which civicrm doesnt recognise

Here is the query in the module:

// Get contribution types
  $sql = "SELECT id, name FROM {civicrm_contribution_type} WHERE is_active = 1";
  $dao =& CRM_Core_DAO::executeQuery($sql, array());
  $types = array(0 => "Select a type...");
  while ($dao->fetch()) { $types[$dao->id] = $dao->name; }
Removing the curly brackets has gotten me a step further using 4.2.9.  The page now renders as it should but I haven't tried actually using it yet. I'm nervous about editing code when I seem the only one having the issue.