Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Blocker
-
Resolution: Cannot Reproduce
-
Affects Version/s: 4.0.5, 4.0.6, 4.0.7
-
Fix Version/s: None
-
Component/s: CiviContribute, CiviPledge, CiviReport, Core CiviCRM, Technical infrastructure
-
Labels:None
Description
Tried all three upgrades with same result. Also I see pledge reporting has changed from one Pledge Summary (that used a Pledge Detail Report template) to 2 reports with separate templates for a Summary and a Detail Report.. Upgrades go fine until trying to rebuild the Dashboard. Is there an update I can run to split the reports first - my 4.0.4 version (that displays report and Dashboard Donation Summaries perfectly), has only the Donor Pledge Summary Report, but the upgrades all expect to support both reports with their separate templates.
This time my backtrace includes civiCRM debug information that I HOPE helps identify what I might try to fix this problem. I can attach files with my civiCRM_Dashboard and civiCRM_Dashboard_Contact table entries if that would help.
C:\wamp\www\sites\all\modules\civicrm\CRM\Core\Error.php, backtrace, 159
, handle,
C:\wamp\www\sites\all\modules\civicrm\packages\PEAR.php, call_user_func, 931
C:\wamp\www\sites\all\modules\civicrm\packages\DB.php, PEAR_Error, 968
C:\wamp\www\sites\all\modules\civicrm\packages\PEAR.php, DB_Error, 564
C:\wamp\www\sites\all\modules\civicrm\packages\DB\common.php, raiseError, 1903
C:\wamp\www\sites\all\modules\civicrm\packages\DB\mysql.php, raiseError, 898
C:\wamp\www\sites\all\modules\civicrm\packages\DB\mysql.php, mysqlRaiseError, 327
C:\wamp\www\sites\all\modules\civicrm\packages\DB\common.php, simpleQuery, 1216
C:\wamp\www\sites\all\modules\civicrm\CRM\Utils\File.php, query, 260
C:\wamp\www\sites\all\modules\civicrm\CRM\Upgrade\Form.php, sourceSQLFile, 154
C:\wamp\www\sites\all\modules\civicrm\CRM\Upgrade\Form.php, source, 286
C:\wamp\www\sites\all\modules\civicrm\CRM\Upgrade\Form.php, processLocales, 302
C:\wamp\www\sites\all\modules\civicrm\CRM\Upgrade\Incremental\php\ThreeFour.php, processSQL, 235
C:\wamp\www\sites\all\modules\civicrm\CRM\Upgrade\Page\Upgrade.php, upgrade_3_4_5, 250
C:\wamp\www\sites\all\modules\civicrm\CRM\Core\Invoke.php, run, 224
C:\wamp\www\sites\all\modules\civicrm\drupal\civicrm.module, invoke, 447
, civicrm_invoke,
C:\wamp\www\includes\menu.inc, call_user_func_array, 503
C:\wamp\www\index.php, menu_execute_active_handler, 21
Sorry. A non-recoverable error has occurred.
DB Error: syntax error
Error Details
Database Error Code: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT @content := msg_html FROM civicrm_msg_template WHERE workflow_id = @workf' at line 2, 1064
Additional Details:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => SELECT @workflow_id := MAX(id) FROM civicrm_option_value WHERE name = 'contribution_online_receipt';
SELECT @content := msg_html FROM civicrm_msg_template WHERE workflow_id = @workflow_id AND is_reserved = 1 LIMIT 1;
UPDATE civicrm_msg_template SET msg_html = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title></title>
</head>
<body>