tur
09-02-2011, 10:52
Witam!
Mam problem z instalacją AceSEF - instalator wyrzuca błąd. Hosting mam na Home.pl, jak rozumiem chodzi o problem z bazą danych, ale nie wiem jak to naprawić. Proszę o pomoc kogoś zorientowanego:) Komunikat wygląda tak:
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 'TYPE=MyISAM CHARACTER SET `utf8`' at line 15 SQL=CREATE TABLE IF NOT EXISTS `jos_acesef_urls` ( `id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT, `url_sef` VARCHAR(255) NOT NULL DEFAULT '', `url_real` VARCHAR(255) NOT NULL DEFAULT '', `cdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `mdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `used` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `hits` INT(12) UNSIGNED NOT NULL DEFAULT '0', `source` TEXT NOT NULL, `params` TEXT NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `url_real` (`url_real`), KEY `url_sef` (`url_sef`), KEY `used` (`used`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL = CREATE TABLE IF NOT EXISTS `jos_acesef_urls` (
`id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
`url_sef` VARCHAR(255) NOT NULL DEFAULT '',
`url_real` VARCHAR(255) NOT NULL DEFAULT '',
`cdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`mdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`used` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`hits` INT(12) UNSIGNED NOT NULL DEFAULT '0',
`source` TEXT NOT NULL,
`params` TEXT NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `url_real` (`url_real`),
KEY `url_sef` (`url_sef`),
KEY `used` (`used`)
) TYPE=MyISAM CHARACTER SET `utf8`;
Component Install: SQL error or missing or unreadable SQL file. 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 CHARACTER SET `utf8`' at line 15 SQL=CREATE TABLE IF NOT EXISTS `jos_acesef_urls` ( `id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT, `url_sef` VARCHAR(255) NOT NULL DEFAULT '', `url_real` VARCHAR(255) NOT NULL DEFAULT '', `cdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `mdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `used` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `hits` INT(12) UNSIGNED NOT NULL DEFAULT '0', `source` TEXT NOT NULL, `params` TEXT NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `url_real` (`url_real`), KEY `url_sef` (`url_sef`), KEY `used` (`used`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL = CREATE TABLE IF NOT EXISTS `jos_acesef_urls` (
`id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
`url_sef` VARCHAR(255) NOT NULL DEFAULT '',
`url_real` VARCHAR(255) NOT NULL DEFAULT '',
`cdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`mdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`used` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`hits` INT(12) UNSIGNED NOT NULL DEFAULT '0',
`source` TEXT NOT NULL,
`params` TEXT NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `url_real` (`url_real`),
KEY `url_sef` (`url_sef`),
KEY `used` (`used`)
) TYPE=MyISAM CHARACTER SET `utf8`;
Mam problem z instalacją AceSEF - instalator wyrzuca błąd. Hosting mam na Home.pl, jak rozumiem chodzi o problem z bazą danych, ale nie wiem jak to naprawić. Proszę o pomoc kogoś zorientowanego:) Komunikat wygląda tak:
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 'TYPE=MyISAM CHARACTER SET `utf8`' at line 15 SQL=CREATE TABLE IF NOT EXISTS `jos_acesef_urls` ( `id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT, `url_sef` VARCHAR(255) NOT NULL DEFAULT '', `url_real` VARCHAR(255) NOT NULL DEFAULT '', `cdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `mdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `used` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `hits` INT(12) UNSIGNED NOT NULL DEFAULT '0', `source` TEXT NOT NULL, `params` TEXT NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `url_real` (`url_real`), KEY `url_sef` (`url_sef`), KEY `used` (`used`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL = CREATE TABLE IF NOT EXISTS `jos_acesef_urls` (
`id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
`url_sef` VARCHAR(255) NOT NULL DEFAULT '',
`url_real` VARCHAR(255) NOT NULL DEFAULT '',
`cdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`mdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`used` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`hits` INT(12) UNSIGNED NOT NULL DEFAULT '0',
`source` TEXT NOT NULL,
`params` TEXT NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `url_real` (`url_real`),
KEY `url_sef` (`url_sef`),
KEY `used` (`used`)
) TYPE=MyISAM CHARACTER SET `utf8`;
Component Install: SQL error or missing or unreadable SQL file. 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 CHARACTER SET `utf8`' at line 15 SQL=CREATE TABLE IF NOT EXISTS `jos_acesef_urls` ( `id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT, `url_sef` VARCHAR(255) NOT NULL DEFAULT '', `url_real` VARCHAR(255) NOT NULL DEFAULT '', `cdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `mdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `used` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `hits` INT(12) UNSIGNED NOT NULL DEFAULT '0', `source` TEXT NOT NULL, `params` TEXT NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `url_real` (`url_real`), KEY `url_sef` (`url_sef`), KEY `used` (`used`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL = CREATE TABLE IF NOT EXISTS `jos_acesef_urls` (
`id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
`url_sef` VARCHAR(255) NOT NULL DEFAULT '',
`url_real` VARCHAR(255) NOT NULL DEFAULT '',
`cdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`mdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`used` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`hits` INT(12) UNSIGNED NOT NULL DEFAULT '0',
`source` TEXT NOT NULL,
`params` TEXT NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `url_real` (`url_real`),
KEY `url_sef` (`url_sef`),
KEY `used` (`used`)
) TYPE=MyISAM CHARACTER SET `utf8`;