Project

General

Profile

Actions
Copy link

Fehler #70

closed

Fehler #52: 2..1.0RC5 installed failed - error in SQL syntax

Error installing com_eXtplorer_2.1.0RC5.zip on Joomla 1.5.25

Added by francy - over 12 years ago. Updated about 12 years ago.

Status:
Erledigt
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
eXtplorer Version:
Joomla! Version:

Description

I've got the following error trying to install com_eXtplorer_2.1.0RC5.zip on Joomla 1.5.25 (PHP 5.2.17) on IIS6: 

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 13 SQL=CREATE TABLE IF NOT EXISTS `jos_extwebdav_locks` ( token varchar(255) NOT NULL default '', path varchar(200) NOT NULL default '', expires int(11) NOT NULL default '0', owner varchar(200) default NULL, recursive int(11) default '0', writelock int(11) default '0', exclusivelock int(11) NOT NULL default 0, PRIMARY KEY (token), UNIQUE KEY token (token), KEY path (path), KEY expires (expires) ) TYPE=MyISAM;
        SQL =
CREATE TABLE IF NOT EXISTS `jos_extwebdav_locks` (
                                  token varchar(255) NOT NULL default '',
                                  path varchar(200) NOT NULL default '',
                                  expires int(11) NOT NULL default '0',
                                  owner varchar(200) default NULL,
                                  recursive int(11) default '0',
                                  writelock int(11) default '0',
                                  exclusivelock int(11) NOT NULL default 0,
                                  PRIMARY KEY  (token),
                                  UNIQUE KEY token (token),
                                  KEY path (path),
                                  KEY expires (expires)
                                ) 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 13 SQL=CREATE TABLE IF NOT EXISTS `jos_extwebdav_locks` ( token varchar(255) NOT NULL default '', path varchar(200) NOT NULL default '', expires int(11) NOT NULL default '0', owner varchar(200) default NULL, recursive int(11) default '0', writelock int(11) default '0', exclusivelock int(11) NOT NULL default 0, PRIMARY KEY (token), UNIQUE KEY token (token), KEY path (path), KEY expires (expires) ) TYPE=MyISAM;
        SQL =
CREATE TABLE IF NOT EXISTS `jos_extwebdav_locks` (
                                  token varchar(255) NOT NULL default '',
                                  path varchar(200) NOT NULL default '',
                                  expires int(11) NOT NULL default '0',
                                  owner varchar(200) default NULL,
                                  recursive int(11) default '0',
                                  writelock int(11) default '0',
                                  exclusivelock int(11) NOT NULL default 0,
                                  PRIMARY KEY  (token),
                                  UNIQUE KEY token (token),
                                  KEY path (path),
                                  KEY expires (expires)
                                ) TYPE=MyISAM;
Actions
Copy link
 #1

Updated by Sören Eberhardt-Biermann over 12 years ago

  • Status changed from Neu to Erledigt
  • Parent task set to #52

See Ticket #52

Actions
Copy link

Also available in: Atom PDF