CiviCRM Community Forums (archive)

This is the error I'm getting.  The SQL itself runs fine when I attempt it using a mysql client, so I'm at a loss regarding what the syntax error might be.

Any help/guidance would be appreciated.

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 '; INSERT INTO civicrm_acl (name, deny, entity_table, entity_id, operatio' at line 1, 1064
Additional Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_component (name, namespace) VALUES ('CiviReport', 'CRM_Report' );

INSERT INTO civicrm_acl
    (name, deny, entity_table, entity_id, operation, object_table, object_id, acl_table, acl_id, is_active)
VALUES
    ('Core ACL', 0, 'civicrm_acl_role', 1, 'All', 'access CiviReport',      NULL, NULL, NULL, 1),
    ('Core ACL', 0, 'civicrm_acl_role', 1, 'All', 'access Report Criteria', NULL, NULL, NULL, 1),
    ('Core ACL', 0, 'civicrm_acl_role', 1, 'All', 'administer Reports',     NULL, NULL, NULL, 1);

[/code]

Digging under the covers, I understand that the upgrade script takes the DB through all the intermediate upgrade steps as part of its procedure.  I've learned the location where the upgrade is failing by matching the SQL listed with the various SQL templates and found that the problem occurs during the upgrade to 2.2.7. 

From this, I learned that there's a long set of SQL that is being executed (~90 lines worth) so I picked this out from the error message and executed it from mysql client.  It runs fine from there.

Will search to see who may have had specific problems with that portion of the upgrade.