I don't understand....
I've an DB error who said :
PHP Code:
Invalid SQL:
INSERT INTO vb411microcart_products
SET categoryid = '1',
name = 'Test product',
type = '1',
status = '1',
code = '',
manufacturer = '',
description = 'Content of test product',
features = 'custom text <span style=\"font-weight: bold;\">bold text</span><span style=\"font-weight: bold;\">Second test</span>
',
price = '130',
discountprice = '10',
specialprice = '20',
renewal = '0',
license = '1',
dlperiod = '365',
demolink = '',
forumlink = 'http://localhost/showthread.php?1-pr%E9sentation-du-dadoo',
bugslink = 'http://localhost/showthread.php?1-pr%E9sentation-du-dadoo',
reviews = '1',
agreement = '0',
frontpage = '1',
flagship = '1',
isbundle = '0',
addons = '',
extras = '0',
promousergroup = '0',
weight = '700',
image = 'admincp0.jpg',
userstocklevel = '1',
stocklevel = '0',
discount_usergroups = '';
MySQL Error : Unknown column 'userstocklevel' in 'field list'
When i look XML product file, i see :
PHP Code:
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."microcart_products` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL,
`categoryid` int(11) NOT NULL,
`type` tinyint(1) NOT NULL default '1',
`status` int(11) NOT NULL default '1',
`code` varchar(100) NOT NULL,
`manufacturer` varchar(100) NOT NULL,
`price` decimal(10,2) NOT NULL default '0.00',
`discountprice` decimal(10,2) NOT NULL default '0.00',
`specialprice` decimal(10,2) NOT NULL default '0.00',
`renewal` decimal(10,2) NOT NULL default '0.00',
`description` mediumtext NOT NULL,
`features` mediumtext NOT NULL,
`forumlink` varchar(50) NOT NULL,
`demolink` varchar(50) NOT NULL,
`bugslink` varchar(150) NOT NULL,
`license` int(11) NOT NULL,
`dlperiod` int(11) NOT NULL,
`addons` varchar(255) NOT NULL,
`extras` int(5) NOT NULL default '0',
`promousergroup` int(11) NOT NULL,
`agreement` tinyint(1) NOT NULL default '0',
`reviews` tinyint(1) NOT NULL default '0',
`isbundle` tinyint(1) NOT NULL default '0',
`frontpage` tinyint(1) NOT NULL default '0',
`flagship` tinyint(1) NOT NULL default '0',
`image` varchar(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `categoryid` (`categoryid`),
KEY `name` (`name`)
) ENGINE=MyISAM
");
It seems followings tables are missing into installation file..
PHP Code:
userstocklevel = '1',
stocklevel = '0',
discount_usergroups = '';