CiviCRM Community Forums (archive)

This is the error i am getting.  Any ideas on how to fix would be appreciated.  This on a WAMP5 install.

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 @option_group_id_act := max(id) from civicrm_option_group wher' at line 5, 1064
Additional Details:
Array
(
    [callback] => Array
        (
            

• => CRM_Core_Error
[1] => handle
        )

    

=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_payment_processor_type
( name, title, description, is_active, is_default, user_name_label, password_label, signature_label, subject_label, class_name, url_site_default, url_api_default, url_recur_default, url_button_default, url_site_test_default, url_api_test_default, url_recur_test_default, url_button_test_default, billing_mode, is_recur, payment_type)
VALUES
( 'PayflowPro', 'PayflowPro', NULL, 1, 0, 'Vendor ID', 'Password', 'Partner (merchant)', 'User', 'Payment_PayflowPro', 'https://Payflowpro.paypal.com', NULL, NULL, NULL, 'https://pilot-Payflowpro.paypal.com', NULL, NULL, NULL, 1, 0, 1),
( 'FirstData', 'FirstData (aka linkpoint)', 'FirstData (aka linkpoint)', 1, 0, 'Store Name', 'Certificate Path', NULL, NULL, 'Payment_FirstData', 'https://secure.linkpt.net', NULL, NULL, NULL, 'https://staging.linkpt.net', NULL, NULL, NULL, 1, NULL, 1);



    SELECT @option_group_id_act := max(id) from civicrm_option_group where name = 'activity_type';

    INSERT INTO civicrm_option_value
        ( `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
        ( @option_group_id_act, 'Print PDF Letter', '23', 'Print PDF Letter', NULL, 1, NULL, 23, 'Print PDF Letter.', 0, 1, 1, NULL, NULL, NULL);