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 »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Issues with Ubercart-CiviCRM Integration: DB Error: syntax error
Pages: 1 [2]

Author Topic: Issues with Ubercart-CiviCRM Integration: DB Error: syntax error  (Read 8915 times)

Judy Simon

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CiviCRM version: 4.3.5
  • CMS version: drupal 7.23
  • MySQL version: 4.0.4
  • PHP version: 5.3.10
Re: IUbercart-CiviCRM Integration: DB Error: syntax error - PARTIAL FIX
August 20, 2013, 01:36:00 am
I found ONE part of this issue:
in the uc_civicrm.module.php file around line 105-6 the table name needs to be switched: civicrm_contribution_type ==> civicrm_financial_type

changing this got rid of the DB Error as the contribution_type table no longer exists!!!

But in doing this HACK, I'm sure there will be other problems down the line that will need to follow up with this. So if anyone can post the followup issues/fixes I would be most grateful!

Related issue:
On our configuration, we have the main drupal DB tables separate from the civicrm tables for security issues, so that that actual line had to be changed even further to:
FROM {civicrm_financial_type}  ==> FROM civicrm_crm.civicrm_financial_type

If anyone knows where i can set the link to the separate crm DB in the main drupal/ubercart configuration so that ubercart knows to look in the other DB that would be most helpful!!

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Issues with Ubercart-CiviCRM Integration: DB Error: syntax error
August 20, 2013, 02:40:00 am
note that usimg the api rather than direct sql would resolve both the issues you mention (the api is updated to 'mask' db changes from integrators)
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

Pages: 1 [2]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Issues with Ubercart-CiviCRM Integration: DB Error: syntax error

This forum was archived on 2017-11-26.