Access denied for user 'allen712_saccapp'@'localhost' (using password: YES)
Access denied for user 'apache'@'localhost' (using password: NO)
insert into client
( id,
acctno,
company,
shortname,
addr,
city,
pcode,
phone,
fax,
loginmessage_subject,
loginmessage_body,
startmessage,
endmessage,
contact1,
contact2,
contact3,
contact1phone,
contact2phone,
contact3phone,
email1,
email2,
email3,
email1_notify,
email2_notify,
email3_notify,
credit_hold,
credit_limit,
zone,
extra_waybills,
waybills_perpage,
online_invoicing_email,
online_invoicing_userid1,
online_invoicing_userid2,
online_invoicing_userid3,
language,
taxgroup,
terms,
fs_ovrd,
invoice_lines,
invoiceoption_1,
invoiceoption_2,
invoiceoption_3,
invoiceoption_4,
invoiceoption_5,
invoiceoption_6,
invoiceoption_7,
invoiceoption_8,
invoiceoption_9,
invoiceoption_rb1,
invoiceoption_rb2,
invoiceoption_rb3,
invoiceoption_rb4,
invoiceoption_rb5,
invoiceoption_rb6,
invoiceoption_rb7,
invoiceoption_rb8,
invoiceoption_rb9,
price_ovrd_quotes,
price_ovrd_nocharge_weight,
price_ovrd_nocharge_pieces1,
price_ovrd_nocharge_pieces2,
price_ovrd_nocharge_pieces3,
price_ovrd_nocharge_pieces4,
price_ovrd_nocharge_pieces5,
price_ovrd_nocharge_pieces6,
price_ovrd_nocharge_pieces7,
price_ovrd_nocharge_pieces8,
price_ovrd_nocharge_pieces9,
price_ovrd_nocharge_pieces10,
price_ovrd_nocharge_pieces11,
price_ovrd_nocharge_pieces12,
price_ovrd_nocharge_volume,
price_ovrd_apply_overwt,
price_ovrd_apply_overpcs,
price_ovrd_apply_overvol,
price_ovrd_extra_weight,
price_ovrd_extra_pieces1,
price_ovrd_extra_pieces2,
price_ovrd_extra_pieces3,
price_ovrd_extra_pieces4,
price_ovrd_extra_pieces5,
price_ovrd_extra_pieces6,
price_ovrd_extra_pieces7,
price_ovrd_extra_pieces8,
price_ovrd_extra_pieces9,
price_ovrd_extra_pieces10,
price_ovrd_extra_pieces11,
price_ovrd_extra_pieces12,
price_ovrd_extra_volume,
price_ovrd_del_fee,
price_ovrd_apply_delfee,
price_ovrd_volume_discount,
price_ovrd_volume_threshold,
price_ovrd_vol_disc_prior,
price_ovrd_apply_volume_discount,
price_ovrd_cb1,
price_ovrd_cb2,
price_ovrd_cb3,
price_ovrd_svc1,
price_ovrd_svc2,
price_ovrd_svc3,
price_ovrd_svc4,
price_ovrd_svc5,
price_ovrd_wpv_method,
price_minimum_svc1,
price_minimum_svc2,
price_minimum_svc3,
price_minimum_svc4,
price_minimum_svc5,
price_minimum_svc6,
pymt_method,
console_fmt,
report_fmt,
category,
location,
billing_freq,
billing_code,
billto_company,
billto_addr,
billto_city,
billto_pcode,
billto_phone,
billto_fax,
billto_apcontact,
billto_apcontact_email,
notes
)
values
( '1',
'CCC001',
'Courier Connex Corp.',
'CourierConnex',
'Suite 102, 54 Flecher Blvd.',
'Stouffville ON',
'L4A 7X4',
'905-640-1011',
'905-640-0076',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'contact@courier-connex.com',
'',
'',
'Y',
'N',
'N',
'N',
'',
'',
'0',
'2',
'',
'',
'',
'',
'',
'1',
'1',
'',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'1',
'1',
'1',
'',
'1',
'',
'',
'0',
'1',
'',
'',
'',
'',
'',
'',
'',
'',
'1',
'',
'',
'',
'',
'',
'',
'1',
'1',
'1',
'0',
'0',
'1',
'1',
'',
'',
'',
'',
'',
'',
'',
'',
''
)
insert into client
( id,
acctno,
company,
shortname,
addr,
city,
pcode,
phone,
fax,
loginmessage_subject,
loginmessage_body,
startmessage,
endmessage,
contact1,
contact2,
contact3,
contact1phone,
contact2phone,
contact3phone,
email1,
email2,
email3,
email1_notify,
email2_notify,
email3_notify,
credit_hold,
credit_limit,
zone,
extra_waybills,
waybills_perpage,
online_invoicing_email,
online_invoicing_userid1,
online_invoicing_userid2,
online_invoicing_userid3,
language,
taxgroup,
terms,
fs_ovrd,
invoice_lines,
invoiceoption_1,
invoiceoption_2,
invoiceoption_3,
invoiceoption_4,
invoiceoption_5,
invoiceoption_6,
invoiceoption_7,
invoiceoption_8,
invoiceoption_9,
invoiceoption_rb1,
invoiceoption_rb2,
invoiceoption_rb3,
invoiceoption_rb4,
invoiceoption_rb5,
invoiceoption_rb6,
invoiceoption_rb7,
invoiceoption_rb8,
invoiceoption_rb9,
price_ovrd_quotes,
price_ovrd_nocharge_weight,
price_ovrd_nocharge_pieces1,
price_ovrd_nocharge_pieces2,
price_ovrd_nocharge_pieces3,
price_ovrd_nocharge_pieces4,
price_ovrd_nocharge_pieces5,
price_ovrd_nocharge_pieces6,
price_ovrd_nocharge_pieces7,
price_ovrd_nocharge_pieces8,
price_ovrd_nocharge_pieces9,
price_ovrd_nocharge_pieces10,
price_ovrd_nocharge_pieces11,
price_ovrd_nocharge_pieces12,
price_ovrd_nocharge_volume,
price_ovrd_apply_overwt,
price_ovrd_apply_overpcs,
price_ovrd_apply_overvol,
price_ovrd_extra_weight,
price_ovrd_extra_pieces1,
price_ovrd_extra_pieces2,
price_ovrd_extra_pieces3,
price_ovrd_extra_pieces4,
price_ovrd_extra_pieces5,
price_ovrd_extra_pieces6,
price_ovrd_extra_pieces7,
price_ovrd_extra_pieces8,
price_ovrd_extra_pieces9,
price_ovrd_extra_pieces10,
price_ovrd_extra_pieces11,
price_ovrd_extra_pieces12,
price_ovrd_extra_volume,
price_ovrd_del_fee,
price_ovrd_apply_delfee,
price_ovrd_volume_discount,
price_ovrd_volume_threshold,
price_ovrd_vol_disc_prior,
price_ovrd_apply_volume_discount,
price_ovrd_cb1,
price_ovrd_cb2,
price_ovrd_cb3,
price_ovrd_svc1,
price_ovrd_svc2,
price_ovrd_svc3,
price_ovrd_svc4,
price_ovrd_svc5,
price_ovrd_wpv_method,
price_minimum_svc1,
price_minimum_svc2,
price_minimum_svc3,
price_minimum_svc4,
price_minimum_svc5,
price_minimum_svc6,
pymt_method,
console_fmt,
report_fmt,
category,
location,
billing_freq,
billing_code,
billto_company,
billto_addr,
billto_city,
billto_pcode,
billto_phone,
billto_fax,
billto_apcontact,
billto_apcontact_email,
notes
)
values
( '1',
'CCC001',
'Courier Connex Corp.',
'CourierConnex',
'Suite 102, 54 Flecher Blvd.',
'Stouffville ON',
'L4A 7X4',
'905-640-1011',
'905-640-0076',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'contact@courier-connex.com',
'',
'',
'Y',
'N',
'N',
'N',
'',
'',
'0',
'2',
'',
'',
'',
'',
'',
'1',
'1',
'',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'1',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'1',
'1',
'1',
'',
'1',
'',
'',
'0',
'1',
'',
'',
'',
'',
'',
'',
'',
'',
'1',
'',
'',
'',
'',
'',
'',
'1',
'1',
'1',
'0',
'0',
'1',
'1',
'',
'',
'',
'',
'',
'',
'',
'',
''
)