MySQL Error 1064 when adding product options

[melemel]

I'm using Cubecart 4.3.4, havent updated recently or made any changes to anything. This is first time i have tried to add options..

I get this error after trying to add product options:

MySQL Error Occurred

Error Message:

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,,'+')' at line 1

SQL:

INSERT INTO shop_CubeCart_options_bot (`product`,`option_id`,`value_id`,`option_price`,`option_symbol`) VALUES (40,,0,,'+');

So I can't add options . How can i fix this?

[melemel]

To others who may have this problem - it was solved by changing the existing file inside admin/sources/products/index.inc.php file.

HOW TO FIX:

Find line 329 on admin/sources/products/index.inc.php :

$value = explode('{|}', $option);

Replace with:

$value = explode('|', $option);