Cerca nel Blog con Google

MONITORE NAPOLETANO

mercoledì, gennaio 23, 2013

Joomla - JInstaller::install: Errore SQL. DB function failed with error number 1064

Questo erroresi verifica quando si cercano di installare il componente Morfeo Show ed il componente Docman.

Ciò è dovuto ad una istruzione divenuta obsoleta nei nuovi motori di MySQL

Il problema, da quanto sperimentato, si risolve sostituendo l'istruzione "Type" con "Engine" nel file install.sql

In Morfeo Show il file è posizionato admin/install.mysql.sql 

In Docman il file è docman.xml (nella cartella appena scompattata)

Ricordo che per la versione del Docman 1.4.0rc3 è necessario attivare il plug-in System Legacy nella sezione plug-in

Di seguito sono riportati i file corretti con, incorporati, le traduzioni italiane

Riporto tutto l'errore che si presenta quando si installano questi oggetti senzala correzione



        JInstaller::install: Errore SQL. DB function failed with error number 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 'TYPE=MyISAM' at line 29 SQL=CREATE TABLE IF NOT EXISTS `jos_docman` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 1, `dmname` text NOT NULL, `dmdescription` longtext, `dmdate_published` datetime NOT NULL default '0000-00-00 00:00:00', `dmowner` int(4) NOT NULL default -1, `dmfilename` text NOT NULL, `published` tinyint(1) NOT NULL default 0, `dmurl` text NULL, `dmcounter` int(11) NULL default 0, `checked_out` int(11) NOT NULL default 0, `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `approved` tinyint(1) NOT NULL default 0, `dmthumbnail` text NULL, `dmlastupdateon` datetime default '0000-00-00 00:00:00', `dmlastupdateby` int(5) NOT NULL default -1, `dmsubmitedby` int(5) NOT NULL default -1, `dmmantainedby` int(5) default 0, `dmlicense_id` int(5) default 0, `dmlicense_display` tinyint(1) NOT NULL default 0, `access` int(11) unsigned NOT NULL default 0, `attribs` text NOT NULL, PRIMARY KEY (`id`), KEY `pub_appr_own_cat_name` (`published`,`approved`,`dmowner`,`catid`,`dmname`(64)), KEY `appr_pub_own_cat_date` (`approved`,`published`,`dmowner`,`catid`,`dmdate_published`), KEY `own_pub_appr_cat_count`(`dmowner`,`published`,`approved`,`catid`,`dmcounter`), KEY `own_pub_appr_cat_id` (`dmowner`, `published`, `approved`, `catid`, `id`) ) TYPE=MyISAM
        SQL =

        CREATE TABLE IF NOT EXISTS `jos_docman` (
              `id` int(11) NOT NULL auto_increment,
              `catid` int(11) NOT NULL default 1,
              `dmname` text NOT NULL, `dmdescription` longtext,
              `dmdate_published` datetime NOT NULL default '0000-00-00 00:00:00',
              `dmowner` int(4) NOT NULL default -1,
              `dmfilename` text NOT NULL,
              `published` tinyint(1) NOT NULL default 0,
              `dmurl` text NULL,
              `dmcounter` int(11) NULL default 0,
              `checked_out` int(11) NOT NULL default 0,
              `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
              `approved` tinyint(1) NOT NULL default 0,
              `dmthumbnail` text NULL,
              `dmlastupdateon` datetime default '0000-00-00 00:00:00',
              `dmlastupdateby` int(5) NOT NULL default -1,
              `dmsubmitedby` int(5) NOT NULL default -1,
              `dmmantainedby` int(5) default 0,
              `dmlicense_id` int(5) default 0,
              `dmlicense_display` tinyint(1) NOT NULL default 0,
              `access` int(11) unsigned NOT NULL default 0,
              `attribs` text NOT NULL,
              PRIMARY KEY (`id`),
              KEY `pub_appr_own_cat_name` (`published`,`approved`,`dmowner`,`catid`,`dmname`(64)),
              KEY `appr_pub_own_cat_date` (`approved`,`published`,`dmowner`,`catid`,`dmdate_published`),
              KEY `own_pub_appr_cat_count`(`dmowner`,`published`,`approved`,`catid`,`dmcounter`),
              KEY `own_pub_appr_cat_id`   (`dmowner`, `published`, `approved`, `catid`, `id`)
              )
              TYPE=MyISAM

        componente Installa: Errore SQL. DB function failed with error number 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 'TYPE=MyISAM' at line 29 SQL=CREATE TABLE IF NOT EXISTS `jos_docman` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 1, `dmname` text NOT NULL, `dmdescription` longtext, `dmdate_published` datetime NOT NULL default '0000-00-00 00:00:00', `dmowner` int(4) NOT NULL default -1, `dmfilename` text NOT NULL, `published` tinyint(1) NOT NULL default 0, `dmurl` text NULL, `dmcounter` int(11) NULL default 0, `checked_out` int(11) NOT NULL default 0, `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `approved` tinyint(1) NOT NULL default 0, `dmthumbnail` text NULL, `dmlastupdateon` datetime default '0000-00-00 00:00:00', `dmlastupdateby` int(5) NOT NULL default -1, `dmsubmitedby` int(5) NOT NULL default -1, `dmmantainedby` int(5) default 0, `dmlicense_id` int(5) default 0, `dmlicense_display` tinyint(1) NOT NULL default 0, `access` int(11) unsigned NOT NULL default 0, `attribs` text NOT NULL, PRIMARY KEY (`id`), KEY `pub_appr_own_cat_name` (`published`,`approved`,`dmowner`,`catid`,`dmname`(64)), KEY `appr_pub_own_cat_date` (`approved`,`published`,`dmowner`,`catid`,`dmdate_published`), KEY `own_pub_appr_cat_count`(`dmowner`,`published`,`approved`,`catid`,`dmcounter`), KEY `own_pub_appr_cat_id` (`dmowner`, `published`, `approved`, `catid`, `id`) ) TYPE=MyISAM
        SQL =

        CREATE TABLE IF NOT EXISTS `jos_docman` (
              `id` int(11) NOT NULL auto_increment,
              `catid` int(11) NOT NULL default 1,
              `dmname` text NOT NULL, `dmdescription` longtext,
              `dmdate_published` datetime NOT NULL default '0000-00-00 00:00:00',
              `dmowner` int(4) NOT NULL default -1,
              `dmfilename` text NOT NULL,
              `published` tinyint(1) NOT NULL default 0,
              `dmurl` text NULL,
              `dmcounter` int(11) NULL default 0,
              `checked_out` int(11) NOT NULL default 0,
              `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
              `approved` tinyint(1) NOT NULL default 0,
              `dmthumbnail` text NULL,
              `dmlastupdateon` datetime default '0000-00-00 00:00:00',
              `dmlastupdateby` int(5) NOT NULL default -1,
              `dmsubmitedby` int(5) NOT NULL default -1,
              `dmmantainedby` int(5) default 0,
              `dmlicense_id` int(5) default 0,
              `dmlicense_display` tinyint(1) NOT NULL default 0,
              `access` int(11) unsigned NOT NULL default 0,
              `attribs` text NOT NULL,
              PRIMARY KEY (`id`),
              KEY `pub_appr_own_cat_name` (`published`,`approved`,`dmowner`,`catid`,`dmname`(64)),
              KEY `appr_pub_own_cat_date` (`approved`,`published`,`dmowner`,`catid`,`dmdate_published`),
              KEY `own_pub_appr_cat_count`(`dmowner`,`published`,`approved`,`catid`,`dmcounter`),
              KEY `own_pub_appr_cat_id`   (`dmowner`, `published`, `approved`, `catid`, `id`)
              )
              TYPE=MyISAM

        Installazione componente: Errore

Nessun commento:

MONITORE NAPOLETANO - Prima Pagina