We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 45160
    • 1 Posts
    Добрый день всем!

    При установке MODX Evolution 1.0.12 на Denwer PHP 5.3.13, MySQL 5.1 (http://localhost/modx/www/install) на последнем этапе видно программа показывает следующее:

    Install results
    Setup will now attempt to setup the database:
    
    
    Creating connection to the database: OK!
    
    Selecting database `modx`: OK!
    
    Checking table prefix `modx_`: OK!
    
    Creating database tables: Database Alerts!
    
    


    И после этого целая куча ошибок:
    The following errors had occurred during installation
    
    Specified key was too long; max key length is 1000 bytes during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_documentgroup_names` ( `id` int(10) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `private_memgroup` tinyint DEFAULT 0 COMMENT 'determine whether the document group is private to manager users', `private_webgroup` tinyint DEFAULT 0 COMMENT 'determines whether the document is private to web users', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM COMMENT='Contains data used for access permissions.'.
    
    
    --------------------------------------------------------------------------------
    Specified key was too long; max key length is 1000 bytes during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_membergroup_names` ( `id` int(10) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM COMMENT='Contains data used for access permissions.'.
    --------------------------------------------------------------------------------
    Column 'pagetitle' cannot be part of FULLTEXT index during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_site_content` ( `id` int(10) NOT NULL auto_increment, `type` varchar(20) NOT NULL default 'document', `contentType` varchar(50) NOT NULL default 'text/html', `pagetitle` varchar(255) NOT NULL default '', `longtitle` varchar(255) NOT NULL default '', `description` varchar(255) NOT NULL default '', `alias` varchar(255) default '', `link_attributes` varchar(255) NOT NULL default '' COMMENT 'Link attriubtes', `published` int(1) NOT NULL default '0', `pub_date` int(20) NOT NULL default '0', `unpub_date` int(20) NOT NULL default '0', `parent` int(10) NOT NULL default '0', `isfolder` int(1) NOT NULL default '0', `introtext` text COMMENT 'Used to provide quick summary of the document', `content` mediumtext, `richtext` tinyint(1) NOT NULL default '1', `template` int(10) NOT NULL default '0', `menuindex` int(10) NOT NULL default '0', `searchable` int(1) NOT NULL default '1', `cacheable` int(1) NOT NULL default '1', `createdby` int(10) NOT NULL default '0', `createdon` int(20) NOT NULL default '0', `editedby` int(10) NOT NULL default '0', `editedon` int(20) NOT NULL default '0', `deleted` int(1) NOT NULL default '0', `deletedon` int(20) NOT NULL default '0', `deletedby` int(10) NOT NULL default '0', `publishedon` int(20) NOT NULL default '0' COMMENT 'Date the document was published', `publishedby` int(10) NOT NULL default '0' COMMENT 'ID of user who published the document', `menutitle` varchar(255) NOT NULL DEFAULT '' COMMENT 'Menu title', `donthit` tinyint(1) NOT NULL default '0' COMMENT 'Disable page hit count', `haskeywords` tinyint(1) NOT NULL default '0' COMMENT 'has links to keywords', `hasmetatags` tinyint(1) NOT NULL default '0' COMMENT 'has links to meta tags', `privateweb` tinyint(1) NOT NULL default '0' COMMENT 'Private web document', `privatemgr` tinyint(1) NOT NULL default '0' COMMENT 'Private manager document', `content_dispo` tinyint(1) NOT NULL default '0' COMMENT '0-inline, 1-attachment', `hidemenu` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Hide document from menu', `alias_visible` INT(2) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `parent` (`parent`), KEY aliasidx (`alias`), KEY typeidx (`type`), FULLTEXT KEY `content_ft_idx` (`pagetitle`,`description`,`content`) ) ENGINE=MyISAM COMMENT='Contains the site document tree.'.
    --------------------------------------------------------------------------------
    Column 'value' cannot be part of FULLTEXT index during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_site_tmplvar_contentvalues` ( `id` int(11) NOT NULL auto_increment, `tmplvarid` int(10) NOT NULL default '0' COMMENT 'Template Variable id', `contentid` int(10) NOT NULL default '0' COMMENT 'Site Content Id', `value` text, PRIMARY KEY (id), KEY idx_tmplvarid (tmplvarid), KEY idx_id (contentid), FULLTEXT KEY `value_ft_idx` (`value`) ) ENGINE=MyISAM COMMENT='Site Template Variables Content Values Link Table'.
    --------------------------------------------------------------------------------
    Specified key was too long; max key length is 1000 bytes during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_webgroup_names` ( `id` int(10) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM COMMENT='Contains data used for web access permissions.'.
    --------------------------------------------------------------------------------
    Table 'modx.modx_site_content' doesn't exist during the execution of SQL statement ALTER TABLE `modx_site_content` ADD COLUMN `publishedon` int(20) NOT NULL DEFAULT '0' COMMENT 'Date the document was published' AFTER `deletedby`.
    --------------------------------------------------------------------------------
    Table 'modx.modx_site_content' doesn't exist during the execution of SQL statement ALTER TABLE `modx_site_content` ADD COLUMN `publishedby` int(10) NOT NULL DEFAULT '0' COMMENT 'ID of user who published the document' AFTER `publishedon`.
    --------------------------------------------------------------------------------
    Table 'modx.modx_site_content' doesn't exist during the execution of SQL statement ALTER TABLE `modx_site_content` MODIFY COLUMN `pagetitle` varchar(255) NOT NULL default '', MODIFY COLUMN `alias` varchar(255) default '', MODIFY COLUMN `introtext` text COMMENT 'Used to provide quick summary of the document', MODIFY COLUMN `content` mediumtext, MODIFY COLUMN `menutitle` varchar(255) NOT NULL DEFAULT '' COMMENT 'Menu title'.
    --------------------------------------------------------------------------------
    Table 'modx.modx_site_content' doesn't exist during the execution of SQL statement ALTER TABLE `modx_site_content` ADD COLUMN `link_attributes` varchar(255) NOT NULL DEFAULT '' COMMENT 'Link attriubtes' AFTER `alias`.
    --------------------------------------------------------------------------------
    Table 'modx.modx_site_tmplvar_contentvalues' doesn't exist during the execution of SQL statement ALTER TABLE `modx_site_tmplvar_contentvalues` MODIFY COLUMN `tmplvarid` int(10) NOT NULL DEFAULT '0' COMMENT 'Template Variable id', MODIFY COLUMN `value` text.
    --------------------------------------------------------------------------------
    Table 'modx.modx_documentgroup_names' doesn't exist during the execution of SQL statement UPDATE modx_documentgroup_names AS dgn LEFT JOIN modx_membergroup_access AS mga ON mga.documentgroup = dgn.id LEFT JOIN modx_webgroup_access AS wga ON wga.documentgroup = dgn.id SET dgn.private_memgroup = (mga.membergroup IS NOT NULL), dgn.private_webgroup = (wga.webgroup IS NOT NULL).
    --------------------------------------------------------------------------------
    Table 'modx.modx_site_content' doesn't exist during the execution of SQL statement UPDATE `modx_site_content` SET `type`='reference', `contentType`='text/html' WHERE `type`='' AND `content` REGEXP '^https?://([-\w\.]+)+(:\d+)?/?'.
    --------------------------------------------------------------------------------
    Table 'modx.modx_site_content' doesn't exist during the execution of SQL statement UPDATE `modx_site_content` SET `type`='document', `contentType`='text/xml' WHERE `type`='' AND `alias` REGEXP '[.period.](rss|xml)$'.
    --------------------------------------------------------------------------------
    Table 'modx.modx_site_content' doesn't exist during the execution of SQL statement UPDATE `modx_site_content` SET `type`='document', `contentType`='text/javascript' WHERE `type`='' AND `alias` REGEXP '[.period.]js$'.
    --------------------------------------------------------------------------------
    Table 'modx.modx_site_content' doesn't exist during the execution of SQL statement UPDATE `modx_site_content` SET `type`='document', `contentType`='text/css' WHERE `type`='' AND `alias` REGEXP '[.period.]css$'.
    --------------------------------------------------------------------------------
    Table 'modx.modx_site_content' doesn't exist during the execution of SQL statement UPDATE `modx_site_content` SET `type`='document', `contentType`='text/html' WHERE `type`=''.
    --------------------------------------------------------------------------------
    Table 'modx.modx_site_content' doesn't exist during the execution of SQL statement ALTER TABLE `modx_site_content` MODIFY COLUMN `template` int(10) NOT NULL default '0'.
    --------------------------------------------------------------------------------
    Table 'modx.modx_site_content' doesn't exist during the execution of SQL statement ALTER TABLE `modx_site_content` ADD INDEX `typeidx` (`type`).
    --------------------------------------------------------------------------------
    Table 'modx.modx_site_tmplvar_contentvalues' doesn't exist during the execution of SQL statement ALTER TABLE `modx_site_tmplvar_contentvalues` ADD FULLTEXT `value_ft_idx` (`value`).
    --------------------------------------------------------------------------------
    Table 'modx.modx_site_content' doesn't exist during the execution of SQL statement ALTER TABLE `modx_site_content` ADD COLUMN `alias_visible` INT( 2 ) NOT NULL DEFAULT '1'.
    --------------------------------------------------------------------------------
    Table 'modx.modx_site_content' doesn't exist during the execution of SQL statement REPLACE INTO `modx_site_content` VALUES (1,'document','text/html','MODX CMS Install Success','Welcome to the MODX Content Management System','','minimal-base','',1,0,0,0,0,'','Install Successful!\r\nYou have successfully installed MODX Evolution.\r\n\r\nGetting Help\r\nThe MODX Community provides a great starting point to learn all things MODX Evolution, or you can also see some great learning resources (books, tutorials, blogs and screencasts).\r\nWelcome to MODX!\r\n',1,3,0,1,1,1,1130304721,1,1130304927,0,0,0,1130304721,1,'Base Install',0,0,0,0,0,0,0,1).
    --------------------------------------------------------------------------------
    


    Подскажите, что делать?


    Всем огромное спасибо! Проблема разрешилась - достаточно было не менять кодировку (оставить utf 8 general по умолчанию.) [ed. note: sailorotec last edited this post 13 years, 1 month ago.]