when I installed the component v.2.1.9 trial I get some errors about the database sql, so I have created the tables with phpmyadmin manually. I created all the tables except the table iprice_item, I get #1064 - You have an error in your SQL syntax;
the _iprice_item is the only one table that I cannot create, this is the code:
CREATE TABLE IF NOT EXISTS `#_iprice_item` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`secid` INT(11),
`catid` INT(11) NOT NULL,
`alias` varchar(255),
`name` varchar(255) NOT NULL,
`shortdesc` varchar(255),
`item_type` tinyint(1) default 0,
`cost` decimal(15,4) NOT NULL default 0,
`primecost` decimal(15,4) default 0,
`showcount` TINYINT(1) NOT NULL default 1,
`radiogroup` INT(5) unsigned NOT NULL default 1,
`discid` int(11),
`enable_file` tinyint(1) unsigned default '0',
`unit` varchar(50),
`avail` INT(9) default '0',
`manufacturer` varchar(100),
`destfilename` varchar(255),
`defqty` float,
`capacity` float,
`image` varchar(255),
`weight` float,
`hits` int(11) default '0',
`rating` tinyint(1) default '0',
`ratingtotal` int(11) default '0',
`ratingcount` int(11) default '0',
`created` date default '0000-00-00',
`featured` tinyint(1) default 0,
`userdiscid1` int(11) default '0',
`userdiscid2` int(11) default '0',
`userdiscid3` int(11) default '0',
`userdiscid4` int(11) default '0',
`userdiscid5` int(11) default '0',
`salestax` decimal(5,2),
`deliveryorderstate` tinyint(2) NOT NULL default -1,
`meta_description` varchar(255),
`keywords` varchar(255),
`forcart` tinyint(1) unsigned NOT NULL default 0,
`curr` varchar(5),
`classname` varchar(100),
`ordering` int(11) NOT NULL,
`checked_out` int(11) unsigned default '0',
`checked_out_time` datetime default '0000-00-00 00:00:00',
`published` tinyint(1) unsigned NOT NULL default '1',
`description` TEXT,
`fulldescription` TEXT,
`params` text,
`dropdown` text,
`destcode` TEXT,
PRIMARY KEY (`id`),
UNIQUE `idx_name` (`name`),
KEY `idx_alias` (`alias`),
KEY `idx_mainitem` (`forcart`,`secid`,`catid`,`published`),
KEY `idx_checked_out` (`checked_out`),
KEY `idx_catid` (`catid`),
KEY `idx_secid` (`secid`),
KEY `idx_price` (`cost`),
KEY `idx_shortdesc` (`shortdesc`),
KEY `idx_avail` (`avail`),
KEY `idx_radiogroup` (`showcount`,`radiogroup`),
KEY `idxd_manufacturer` (`manufacturer`),
KEY `idx_rating` (`rating`,`ratingcount`),
) AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
my version of mysql is 5.5.28-log
how I can resolve? thanks
