JInstaller::install: Ошибка 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=InnoDB' at line 30 SQL=-- -- Install SQL Script -- -- @version $Id: install.sql 170 2009-08-12 07:29:38Z dr_drsh $ -- @package Joomla -- @subpackage JForms -- @copyright Copyright (C) 2008 Mostafa Muhammad. All rights reserved. -- @license GNU/GPL -- CREATE TABLE IF NOT EXISTS `jos_jforms_forms` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `type` int(11) NOT NULL, `plugins` varchar(100) NOT NULL, `theme` varchar(100) NOT NULL DEFAULT 'default', `state` tinyint(3) NOT NULL DEFAULT '0', `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` int(11) unsigned NOT NULL DEFAULT '0', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) unsigned NOT NULL DEFAULT '0', `checked_out` int(11) unsigned NOT NULL DEFAULT '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `groups` varchar(255) NOT NULL, `hits` int(11) unsigned NOT NULL DEFAULT '0', `thank` mediumtext NOT NULL, PRIMARY KEY (`id`) ) TYPE=InnoDB ;
SQL =
--
-- Install SQL Script
--
-- @version $Id: install.sql 170 2009-08-12 07:29:38Z dr_drsh $
-- @package Joomla
-- @subpackage JForms
-- @copyright Copyright (C) 2008 Mostafa Muhammad. All rights reserved.
-- @license GNU/GPL
--
CREATE TABLE IF NOT EXISTS `jos_jforms_forms` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`type` int(11) NOT NULL,
`plugins` varchar(100) NOT NULL,
`theme` varchar(100) NOT NULL DEFAULT 'default',
`state` tinyint(3) NOT NULL DEFAULT '0',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` int(11) unsigned NOT NULL DEFAULT '0',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_by` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`groups` varchar(255) NOT NULL,
`hits` int(11) unsigned NOT NULL DEFAULT '0',
`thank` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) TYPE=InnoDB ;
Компонент Установить: Ошибка SQL или нечитаемый файл 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=InnoDB' at line 30 SQL=-- -- Install SQL Script -- -- @version $Id: install.sql 170 2009-08-12 07:29:38Z dr_drsh $ -- @package Joomla -- @subpackage JForms -- @copyright Copyright (C) 2008 Mostafa Muhammad. All rights reserved. -- @license GNU/GPL -- CREATE TABLE IF NOT EXISTS `jos_jforms_forms` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `type` int(11) NOT NULL, `plugins` varchar(100) NOT NULL, `theme` varchar(100) NOT NULL DEFAULT 'default', `state` tinyint(3) NOT NULL DEFAULT '0', `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` int(11) unsigned NOT NULL DEFAULT '0', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) unsigned NOT NULL DEFAULT '0', `checked_out` int(11) unsigned NOT NULL DEFAULT '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `groups` varchar(255) NOT NULL, `hits` int(11) unsigned NOT NULL DEFAULT '0', `thank` mediumtext NOT NULL, PRIMARY KEY (`id`) ) TYPE=InnoDB ;
SQL =
--
-- Install SQL Script
--
-- @version $Id: install.sql 170 2009-08-12 07:29:38Z dr_drsh $
-- @package Joomla
-- @subpackage JForms
-- @copyright Copyright (C) 2008 Mostafa Muhammad. All rights reserved.
-- @license GNU/GPL
--
CREATE TABLE IF NOT EXISTS `jos_jforms_forms` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`type` int(11) NOT NULL,
`plugins` varchar(100) NOT NULL,
`theme` varchar(100) NOT NULL DEFAULT 'default',
`state` tinyint(3) NOT NULL DEFAULT '0',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` int(11) unsigned NOT NULL DEFAULT '0',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_by` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`groups` varchar(255) NOT NULL,
`hits` int(11) unsigned NOT NULL DEFAULT '0',
`thank` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) TYPE=InnoDB ;