Tax Database Error

Store Builder Questions
1

hello everyone. when i try to update tax info i get Database error: Incorrect integer value: ‘’ for column ‘rate_id’ at row 1 (1366)

Invalid query: INSERT INTO cscart_tax_rates (rate_id, rate_value, rate_type, destination_id, tax_id) VALUES (‘’, ‘’, ‘F’, ‘1’, ‘1’)



Anyone else experience this? If so is there a resolution to it?



Thanks

2

Anyone Know!

3

[quote name=‘VarwigDude’]Anyone Know![/QUOTE]



It would help if you tell us how this error occurs. Looking at the SQL, you are trying to put a null value into rate_id which the error is telling you isn’t allowed.



What were you doing to get the error? Updating taxes for all products?

4

Yes. When i try and update the tax rates. i can save the front part just fine. I studied the sql and manually edited the mysql to get it. but you know you still want to be able to fix this issue w/o figuring out how the sql is being updated.

5

Dear All,



I recieved the same error message.



You must change sql-mode to sql-mode=“” in my.ini (mysql)



Best Regards,