Ciao a tutti, sono nuovo qui e ancora non conosco bene Joomla, dopo aver installato in locale la versione 1.7, ho effettuato un tentativo di installazione del componente JoomShopping e subito ho riscontrato l'errore seguente, sto cercando aiuto per la risoluzione di qst problema.
Grazie.
JInstaller: :Install: Errore SQL DB function fallita con errore numero 1064
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 'CREATE TABLE IF NOT EXISTS `e5agt__jshopping_categories` ( `category_id` int' at line 1 SQL=CREATE TABLE IF NOT EXISTS `e5agt__jshopping_categories` ( `category_id` int(11) NOT NULL auto_increment, `category_image` varchar(255), `category_parent_id` int(11) NOT NULL default '0', `category_publish` tinyint(1) unsigned NOT NULL default '1', `category_ordertype` tinyint(1) unsigned NOT NULL default '1', `category_template` varchar(64), `ordering` int(3) NOT NULL, `category_add_date` datetime default '0000-00-00 00:00:00', `products_page` int(
NOT NULL default '12', `products_row` int(3) NOT NULL default '3', `access` int(3) NOT NULL default '1', PRIMARY KEY (`category_id`), KEY `sort_add_date` (`category_add_date`) ) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
SQL =
CREATE TABLE IF NOT EXISTS `e5agt__jshopping_categories` (
`category_id` int(11) NOT NULL auto_increment,
`category_image` varchar(255),
`category_parent_id` int(11) NOT NULL default '0',
`category_publish` tinyint(1) unsigned NOT NULL default '1',
`category_ordertype` tinyint(1) unsigned NOT NULL default '1',
`category_template` varchar(64),
`ordering` int(3) NOT NULL,
`category_add_date` datetime default '0000-00-00 00:00:00',
`products_page` int(
NOT NULL default '12',
`products_row` int(3) NOT NULL default '3',
`access` int(3) NOT NULL default '1',
PRIMARY KEY (`category_id`),
KEY `sort_add_date` (`category_add_date`)
) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
Installazione componente: file errore SQL DB function fallita con errore numero 1064
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 'CREATE TABLE IF NOT EXISTS `e5agt__jshopping_categories` ( `category_id` int' at line 1 SQL=CREATE TABLE IF NOT EXISTS `e5agt__jshopping_categories` ( `category_id` int(11) NOT NULL auto_increment, `category_image` varchar(255), `category_parent_id` int(11) NOT NULL default '0', `category_publish` tinyint(1) unsigned NOT NULL default '1', `category_ordertype` tinyint(1) unsigned NOT NULL default '1', `category_template` varchar(64), `ordering` int(3) NOT NULL, `category_add_date` datetime default '0000-00-00 00:00:00', `products_page` int(
NOT NULL default '12', `products_row` int(3) NOT NULL default '3', `access` int(3) NOT NULL default '1', PRIMARY KEY (`category_id`), KEY `sort_add_date` (`category_add_date`) ) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
SQL =
CREATE TABLE IF NOT EXISTS `e5agt__jshopping_categories` (
`category_id` int(11) NOT NULL auto_increment,
`category_image` varchar(255),
`category_parent_id` int(11) NOT NULL default '0',
`category_publish` tinyint(1) unsigned NOT NULL default '1',
`category_ordertype` tinyint(1) unsigned NOT NULL default '1',
`category_template` varchar(64),
`ordering` int(3) NOT NULL,
`category_add_date` datetime default '0000-00-00 00:00:00',
`products_page` int(
NOT NULL default '12',
`products_row` int(3) NOT NULL default '3',
`access` int(3) NOT NULL default '1',
PRIMARY KEY (`category_id`),
KEY `sort_add_date` (`category_add_date`)
) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;