We have assigned to all our level 4 login clients a professional discount of 20%. Everyone is who registers first get a level 2 login. Then when they qualify for the pro discount, we change their login level to 4 and assign a percentage discount of 20%. Just today, we noticed that when we tried to do this for a client we got the following error message:

[red]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 lclPercentDiscount=20,clientAdminNotes="clEmail='theresaburden@gmail com'.clAct1 at line 1[/red]

Current version is Ecommerce Plus PHP v7.0.2

As far as I know, we have not attempted to perform this action since updating to 7.0.2. and I have no idea whether that is causing the problem.

Any help I can get to resolve this issue is most appreciated.

Thanks Vince. I will update to 7.0.3. and let you know if that worked.

Vince,

I updated the store to 7.0.3 and that took care of the problem.

Thanks again.