Home Forum
2017-11-23
Menu principale
Prodotti
Giochi a premi
Accedi ai servizi
Newsletter
Ricezione
Benvenuto, Ospite
Nome Utente Password: Ricordami

Installation problem with tag meta component
(1 Online) (1) Ospite
  • Pagina:
  • 1

ARGOMENTO: Installation problem with tag meta component

Installation problem with tag meta component 8 Anni, 4 Mesi fa #287

  • catfish
  • Offline
  • Fresh Boarder
  • Messaggi: 8
Hi,
I am havin g the same problem as a previous poster. My system:
PHP Built on: Linux infong 2.4 #1 SMP Tue Dec 18 22:34:10 UTC 2007 i686 GNU/Linux
Database Version: 4.0.27-standard
Database Collation: N/A (mySQL < 4.1.2)
PHP Version: 4.4.9
Web Server: Apache
Web Server to PHP interface: cgi
Joomla! Version: Joomla! 1.5.8 Production/Stable [ Wohnaiki ] 10-November-2008 23:00 GMT
User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.4) Gecko/2008102920 Firefox/3.0.4

Error message when installing the component:


* JInstaller::install: SQL Error. 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 'default CHARSET=utf8' at line 18 SQL=CREATE TABLE IF NOT EXISTS `jos_tagmeta` ( `id` int(11) NOT NULL auto_increment, `uri` varchar(255) NOT NULL default '', `title` varchar(70) default NULL, `description` varchar(160) default NULL, `keywords` varchar(160) default NULL, `rindex` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip', `rfollow` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip', `rsnippet` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip', `rarchive` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip', `rodp` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip', `ordering` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `idxuri` (`uri`) ) type=MyISAM default CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `jos_tagmeta` (
`id` int(11) NOT NULL auto_increment,
`uri` varchar(255) NOT NULL default '',
`title` varchar(70) default NULL,
`description` varchar(160) default NULL,
`keywords` varchar(160) default NULL,
`rindex` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip',
`rfollow` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip',
`rsnippet` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip',
`rarchive` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip',
`rodp` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `idxuri` (`uri`)
) type=MyISAM default CHARSET=utf8;

* Component Install: SQL Error. 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 'default CHARSET=utf8' at line 18 SQL=CREATE TABLE IF NOT EXISTS `jos_tagmeta` ( `id` int(11) NOT NULL auto_increment, `uri` varchar(255) NOT NULL default '', `title` varchar(70) default NULL, `description` varchar(160) default NULL, `keywords` varchar(160) default NULL, `rindex` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip', `rfollow` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip', `rsnippet` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip', `rarchive` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip', `rodp` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip', `ordering` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `idxuri` (`uri`) ) type=MyISAM default CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `jos_tagmeta` (
`id` int(11) NOT NULL auto_increment,
`uri` varchar(255) NOT NULL default '',
`title` varchar(70) default NULL,
`description` varchar(160) default NULL,
`keywords` varchar(160) default NULL,
`rindex` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip',
`rfollow` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip',
`rsnippet` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip',
`rarchive` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip',
`rodp` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `idxuri` (`uri`)
) type=MyISAM default CHARSET=utf8;

Re:Installation problem with tag meta component 8 Anni, 4 Mesi fa #289

  • admin
  • Offline
  • Administrator
  • Messaggi: 1603
Hi,
the problem should be that you MySQL 4 version seems to not support collation:

Database Collation: N/A (mySQL < 4.1.2)

And the error is:

Check the manual that corresponds to your MySQL server version for the right syntax to use near 'default CHARSET=utf8'

So, you should replace the attached file in your zip, and retry to install component. I've removed the part "type=MyISAM default CHARSET=utf8".

Let me know,
Luigi I file di questo Forum sono invisibili ai visitatori. Prego accedi o registrati per visualizzarli.
Allegati:
  • Allegato I file di questo Forum sono invisibili ai visitatori. Prego accedi o registrati per visualizzarli.
Ultima modifica: 8 Anni, 4 Mesi fa Da admin.
  • Pagina:
  • 1
Moderatori: admin
Tempo generazione pagina: 0.25 secondi
News
Cerca con Google
Chi è online
 82 visitatori online
Sponsor

Slotmachineaamsonline.com è una guida alle migliori slot machine online legali in Italia. Sul sito trovi un elenco sempre aggiornato dei casino online con Slot machine e bonus slot, le ultime novità dal mondo delle slot online e le migliori strategie per vincere. Inoltre, è disponibile una sezione dedicata alle slot machine da BAR che finalmente sono disponibili nella versione online.