Back to top

Autore Topic: Errore Installazione JoomShopping  (Letto 1177 volte)

Offline execute1

  • Nuovo arrivato
  • *
  • Post: 3
    • Mostra profilo
Errore Installazione JoomShopping
« il: 10 Mag 2012, 12:34:29 »
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(8) 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(8) 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(8) 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(8) 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*/;
 

 



Web Design Bolzano Kreatif