CiviCRM Community Forums (archive)

It is a site that has been updated since CiviCRM 2 and is not 3.4 so it has seen a number of updates.
It seems to be this part of the query "WHERE  status_id =  AND is_test=0"


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 'AND is_test=0' at line 3, 1064
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] =>
SELECT sum( amount ) as pledge_amount, count( id ) as pledge_count
FROM   civicrm_pledge
WHERE  status_id =  AND is_test=0
 [nativecode=1064 ** 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 'AND is_test=0' at line 3]
    [type] => DB_Error
    [user_info] =>
SELECT sum( amount ) as pledge_amount, count( id ) as pledge_count
FROM   civicrm_pledge
WHERE  status_id =  AND is_test=0
 [nativecode=1064 ** 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 'AND is_test=0' at line 3]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT sum( amount ) as pledge_amount, count( id ) as pledge_count
FROM   civicrm_pledge
WHERE  status_id =  AND is_test=0
 [nativecode=1064 ** 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 'AND is_test=0' at line 3]"]
)


Since reports, new pledges etc all work I wonder if I should patch that query to default to 3?

Thanks for the warning about 3 

Right I would not want to hard code it just not sure how it can be gone.  Reports work, new pledges work etc.

nice call!

<code>INSERT INTO `civicrm_option_value` (`id`, `option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `domain_id`, `visibility_id`)
VALUES
   (233, 11, 'Overdue', '6', 'Overdue', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL, NULL);

</code>

The row was missing 'name' and 'filter'