Hi all, have playing around with plaincart to know more about php.
When adding a new field to shop config database, started having syntax problems.
The database is:
CREATE TABLE IF NOT EXISTS `tbl_shop_config` (
`sc_name` varchar(50) NOT NULL DEFAULT '',
`sc_address` varchar(100) NOT NULL DEFAULT '',
`sc_phone` varchar(30) NOT NULL DEFAULT '',
`sc_email` varchar(30) NOT NULL DEFAULT '',
`sc_nif` int(10) NOT NULL DEFAULT '0',
`sc_nibe` int(30) unsigned NOT NULL DEFAULT '0',
`sc_currency` int(10) unsigned NOT NULL DEFAULT '1',
`sc_shipping_cost` decimal(5,2) NOT NULL DEFAULT '0.00',
`sc_order_email` enum('y','n') NOT NULL DEFAULT 'y'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
i just added the field "sc_nibe" and now i get the error: "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 'sc_shipping_cost = 5.00, sc_currency = 1, sc_order_email = 'y'' at line 3"
Tried a lot of things but nothing works. I'm using MySQL v5.0.7
Reaaly would apreciate some help.
Many thanks