MYSQL problem afther Upgrade

[Martin Verkerk]

When we try making a productoption change in our ADMIN page, then comes te follow MSQL ERROR.

This happend from afther the upgrade.

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 CubeCart_options_bot (`product`,`option_id`,`value_id`,`option_price`,`option_symbol`) VALUES (127,,0,,'+');

A MSQL check in ADMIN gives everyting is correctly.

Last night I did a successly totall roll back to version 4.3.3 for two shops.

With kind regards

Martin

[Guest JodieR]

When we try making a productoption change in our ADMIN page, then comes te follow MSQL ERROR.

This happend from afther the upgrade.

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 CubeCart_options_bot (`product`,`option_id`,`value_id`,`option_price`,`option_symbol`) VALUES (127,,0,,'+');

A MSQL check in ADMIN gives everyting is correctly.

Last night I did a successly totall roll back to version 4.3.3 for two shops.

With kind regards

Martin

I get this too????

[Guest ddjmagic]

When we try making a productoption change in our ADMIN page, then comes te follow MSQL ERROR.

This happend from afther the upgrade.

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 CubeCart_options_bot (`product`,`option_id`,`value_id`,`option_price`,`option_symbol`) VALUES (127,,0,,'+');

A MSQL check in ADMIN gives everyting is correctly.

Last night I did a successly totall roll back to version 4.3.3 for two shops.

With kind regards

Martin

I get this too????

I am getting this error too, anyone know how to fix it?

[Guest benbailey]

I am getting this error too.

Anybody got any idea how to fix this?

Running

CubeCart 4.3.4

PHP 5.2.10

MySQL 5.0.67

[Guest JodieR]

I am getting this error too.

Anybody got any idea how to fix this?

Running

CubeCart 4.3.4

PHP 5.2.10

MySQL 5.0.67

YES.. I just found it in the bug bits, I haven't done it yet... but am excited!

http://bugs.cubecart.com/view.php?id=1598

[convict]

Well fix is simple in admin/sources/products/index.inc.php

SEARCH FOR

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

REPLACE WITH

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

This returns code back to previous versions one.

[Guest sultzy]

Having exactly the same problem and unfortunately convicts fix isn't helping.

Any ideas?

edit: should maybe note this wasn't an upgrade but a fresh install of cc4

[Guest sultzy]

Ok maybe I was just being impatient or something

The fix does seem to be working after all.

[Robsta]

Submit a support ticket to the helpdesk, best and quickest way to resolve the issue I'm sure.

[Guest phproiwish]

I have tried this fix, cleared the cache of the browser and optimized database and the error still exists, although smaller, any suggestions?

64: 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 's Pal felt applique stocking kit";}}}' WHERE sessId='3b56g81i7rk8cipniqc5u702r2'' at line 1

SQL:

UPDATE CubeCart_sessions SET `basket` = 'a:2:{s:5:"conts";a:1:{s:5:"4836:";a:2:{s:8:"quantity";d:2;s:9:"timestamp";i:1264571330;}}s:8:"invArray";a:1:{i:1;a:2:{s:9:"productId";s:4:"4836";s:4:"name";s:40:"Penguin's Pal felt applique stocking kit";}}}' WHERE sessId='3b56g81i7rk8cipniqc5u702r2';