IPrice minimart
powerfull & flexible online Store, price-lists and catalogs for Joomla
Welcome, Guest
Username: Password: Remember me

TOPIC: error sql syntax

error sql syntax 7 years 5 months ago #1345

  • brownie
  • brownie's Avatar
  • Offline
  • Новый участник
  • Posts: 8
  • Karma: 0
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
Login or register to post message.

error sql syntax 7 years 5 months ago #1346

  • support
  • support's Avatar
  • Offline
  • Администратор
  • Posts: 1889
  • Thank you received: 309
  • Karma: 59
There was a typo in the sql script to create a database. Please download the fixed package of IPrice minimart trial using download link in automatic answer for your order. Uninstall IPrice minmart, then remove all iprice tables from database, then install the component again.
Login or register to post message.
Moderators: support

Subscribe



Subscribe to our newsletter and social networks to be updated with the latest updates.

Login