CiviCRM Community Forums (archive)

Drupal 7
CiviCRM 4.1.0
Separate DB as Recommended

I am throwing multiple errors in multiple places.  Re-installed, I am sure that the installation was correct.  I pulled the code right from the code snippets as a test and drew the following two errors. home and username removed since forums are reading it as a link

Parse error: syntax error, unexpected T_VARIABLE in php.module(80) : eval()'d code on line 10

SELECT civicrm_contribution.contact_id, SUM( civicrm_contribution.total_amount ) as total_amount FROM civicrm_contribution WHERE civicrm_contribution.receive_date >= '2005-04-20' AND civicrm_contribution.receive_date <= '2006-10-20' AND civicrm_contribution.contribution_type_id = 4 AND civicrm_contribution.cancel_date IS NULL GROUP BY civicrm_contribution.contact_id

I also receive the following error when trying to call fields from views

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'soldie9_cms.civicrm_contribution' doesn't exist

I have installed older versions of CiviCRM in the past in the same fashion without any issues.  Thank you for your help in advance, you guys are always extremely responsive.

I had in a previous version and that kinda is the issue here: even trying to redo the view integration as described by the instructions it throws the undefined function error on step 3 for civicrm_group_get() (line 28).

The issue is that it is calling a table from soldie9_cms instead of soldie9_crm

I reviewed my civicrm.setting.php file and the information is correct.  I also double checked that the user had full access to the DB, which it does.  CiviCrm also works flawlessly except for this function to my knowledge.  What sort of information/code can I provide to further help with diagnosis of the problem?

straight from the examples section.  As said before and call to civicrm is giving me the aforementioned error (I completely reinstalled from scratch and this fixed views but still cannot call with php)


<?php
 
 
 
// Check if CiviCRM is installed here.
 
if (!module_exists('civicrm')) return false;
 
// Initialization call is required to use CiviCRM APIs.
 
civicrm_initialize( );
 
// hack $select
 
$select = "
 
  SELECT civicrm_contribution.contact_id,
 
  SUM( civicrm_contribution.total_amount ) as total_amount
 
  FROM civicrm_contribution
 
  WHERE civicrm_contribution.receive_date >= '2005-04-20'
 
  AND civicrm_contribution.receive_date <= '2006-10-20'
 
  AND civicrm_contribution.contribution_type_id = 4
 
  AND civicrm_contribution.cancel_date IS NULL
 
  GROUP BY civicrm_contribution.contact_id ";
 
$query  = $select;
 
$params = array( );
 
print $query . "\n\n";
 
$dao =& CRM_Core_DAO::executeQuery( $query, $params );
 
while ( $dao->fetch( ) ) {
 
  // Contact API returns contact info
  $cg = array( 'contact_id' => $dao->contact_id );
  $contact = civicrm_contact_get( $cg );
 
  echo "'" . $contact['sort_name'] . "',";
 
  echo "'" . $contact['display_name'] . "',";
 
  echo "'" . $dao->contact_id ."',";
 
  echo "'" . $dao->total_amount . "'<br />\r\n";
 
  }
 
?>

Two more errors I found with my installation (even though this is a fresh one), I am unable to edit any users.  The page loads with no content.  And views is now working with a fresh install but throwing Notices.  I reviewed my installation thoroughly and found no issues with the way the install was performed.  It was done verbatim from the instructions

Firebug found no error.  I attempted the task on other computers as well with no success.  Led me to believe it was something with 1) the server, 2) Drupal, 3) or CiviCRM install.  So I cleared the server and re-installed both civiCRM and Drupal from scratch this time.  Seemed to fix the errors (reloaded all the sql data).  Only problem I have left is the view integration throwing Notices about an Un-defined index of group_type when making the query call to CiviCRM contribute.  Simply it is only calling two field out of Personal Campaign Pages: Amount Raised and Title..

Almost all squared away! 
On a side note: very happy with CiviCRM