Error when trying to copy a product

**countingsheep** · 04-27-2006, 08:14 PM

Is it a value that I need to be changing to remedy this error when trying to copy a product?
~~~~~~~~~~

1064 - 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 '. '0.00', '0', '0', '0')' at line 1

insert into products (products_quantity, products_model, products_ship_price, products_image, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('-2', '', '0.0000', 'candlesticklabel.jpg', '25.0000', now(), null. '0.00', '0', '0', '0')
~~~~~~~~~~~

**countingsheep** · 05-04-2006, 09:23 AM

Does anyone have a suggestion?

**ThaPantha** · 07-28-2006, 10:51 AM

Hi countingsheep, @ll,

we're having the same problem. When copying a product we recieve:

1064 - 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 '. '0.10', '0', '3', '1')' at line 1

insert into products (products_quantity, products_model, products_ship_price, products_image, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('99', '999999', '3.3300', 'artikelbild.jpg', '19.1552', now(), null. '0.10', '0', '3', '1')

[TEP STOP]

Since your first message is from Apr. 28th, did you or anyone find a solution yet or has an idea for such?

Thanks in advance.

Stefan