CubeCart Installation

[sladmin]

Hi again,

This is a different project this time but is pretty important. I have tried to install CubeCart recently and been having problem with it. Actually, the installation went fine. It wasn't until I went into the admin control and panel and started to do anything db related which started to give me error messages.

For example I have just tried to add a sub category and was given this error message:


MySQL Error Occured
1366: Incorrect decimal value: '' for column 'per_ship' at row 1
QUERY = INSERT INTO CubeCart_category (`cat_name`, `cat_father_id`, `cat_image`, `per_ship`, `item_ship`, `item_int_ship`, `per_int_ship`) VALUES ('Sub Category', '0', '', '', '', '', '')


and when I add a product:


MySQL Error Occured
1366: Incorrect decimal value: '' for column 'sale_price' at row 1
QUERY = INSERT INTO CubeCart_inventory (`productCode`, `name`, `cat_id`, `description`, `image`, `price`, `sale_price`, `stock_level`, `useStockLevel`, `digital`, `digitalDir`, `prodWeight`, `taxType`, `showFeatured`) VALUES ('5', 'Test Product', '1', 'Test Product
', '', '0.01', '', '6', '1', '0', '', '6', '2', '0')



Any Ideas I'm really frustrated and this needs to be done very soon :unsure: :sad:

[sladmin]

I just fixed this problem by deleting the database and creating a MySQL 4 instead of a MySQL 5. I have no idea why it did that and obviously CubeCart is not compatible with MySQL 5.

[Ben Collier]

I think cubecart is meant to be compatible- however from my own experience it didn't function well under mySQL 5...

[sladmin]

I think cubecart is meant to be compatible- however from my own experience it didn't function well under mySQL 5...

lol funny :D It didn't work at all under MySQL 5. Glad I have it working now though, was up til 4AM this morning trying to figure out what the problem was.

Ohh well early to bed tonight, ohh wait, I have another site to do. Damn. Better get the caffeine in...