CiviCRM Community Forums (archive)

Since upgrading to 3.4, all of my dashlets return the "DB Error: no such field".

Any suggestions on resolving this?

Sorry, should have included this in my original post.
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
SELECT MAX(id) FROM civicrm_report_instance
WHERE  TRIM(BOTH '/' FROM CONCAT(report_id, '/', name)) = '9_reset_1_section_2_snippet_4' [nativecode=1054 ** Unknown column 'name' in 'where clause']
    [type] => DB_Error
    [user_info] =>
SELECT MAX(id) FROM civicrm_report_instance
WHERE  TRIM(BOTH '/' FROM CONCAT(report_id, '/', name)) = '9_reset_1_section_2_snippet_4' [nativecode=1054 ** Unknown column 'name' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT MAX(id) FROM civicrm_report_instance
WHERE  TRIM(BOTH '/' FROM CONCAT(report_id, '/', name)) = '9_reset_1_section_2_snippet_4' [nativecode=1054 ** Unknown column 'name' in 'where clause']"]
)


I tried that and still get a similar error, posted below.  This report works without error if I run it from the "Reports" menu, weird.
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
SELECT MAX(id) FROM civicrm_report_instance
WHERE  TRIM(BOTH '/' FROM CONCAT(report_id, '/', name)) = '25_reset_1_section_2_snippet_4' [nativecode=1054 ** Unknown column 'name' in 'where clause']
    [type] => DB_Error
    [user_info] =>
SELECT MAX(id) FROM civicrm_report_instance
WHERE  TRIM(BOTH '/' FROM CONCAT(report_id, '/', name)) = '25_reset_1_section_2_snippet_4' [nativecode=1054 ** Unknown column 'name' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT MAX(id) FROM civicrm_report_instance
WHERE  TRIM(BOTH '/' FROM CONCAT(report_id, '/', name)) = '25_reset_1_section_2_snippet_4' [nativecode=1054 ** Unknown column 'name' in 'where clause']"]
)


We are having the same issue, reports run fine from reports menu but dashlet reports the same error.  Removed/readded and still nothing appears to fix the error.  Tried adding "standard" reports as well.