cannot edit affiliate, running MS SQL Server

[prenneker]

Hello,

I am getting a DB Error when trying to modify an existing affiliate. This occurs in both the Merchant and Affiliate control panels. Here is the error message:

SQL error: The statement has been terminated.; SQL:update pa_affiliates set username='test@test.test', weburl='www.test.com',contactname='Test',payableto ='test',tax_ssn='123-45-6789',company_name='',street='test street',city='test city',state='IN',country='United States',zipcode='11111',phone='555-555-5555',fax='',min_payout='100', parentaffiliateid='',bank_accountname='', bank_name='', bank_account='', bank_code='', bank_swift='', bank_address='', paypal_email='', mb_email='', payout_type='4' where affiliateid=1; File: C:\inetpub\xxxxxxx\affiliate\merchants\AffiliateMa nager.class.php; Line: 290

Please note, we are running on MS SQL Server. Any ideas?

Thanks for your assistance.

Pat Renneker

[mark]

Hello,

this is a bug in the affiliate system. The new patch for the system will be released later today (10/22/2004), so check it out then.

with regards,

mark