Installation Error (Database)

Hi,

I am trying to install ModX locally, running MySQL 5.0.22, Apache 2.0.59, PHP 5.2.0 and WinXP SP2.

When I run the ModX installer I get the following errors:

Setup will now attempt to setup the database:
Creating connection to the database: OK!
Selecting database `modx`: Database selection failed... The database does not exist. Setup will attempt to create it.
Creating database `modx`: OK!
Checking table prefix `modx_`: OK!
Creating database tables: Database Alerts!
MODx setup couldn’t install/alter some tables inside the selected database.
The following errors had occurred during installation

Too long comment for table ’modx_system_eventnames’ during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_system_eventnames` ( `id` INT(10) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `service` tinyint NOT NULL COMMENT ’System Service number’, `groupname` varchar(20) NOT NULL default ’’, PRIMARY KEY(`id`) ) TYPE=MYISAM COMMENT=’System Event Names. Service = 1 - Kernel, 2 - Manager Access, 3 - Web Access, 4 - Cache, 5 - Template System ’.

BLOB/TEXT column ’setting_value’ can’t have a default value during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_system_settings` ( `setting_name` varchar(50) NOT NULL default ’’, `setting_value` text NOT NULL default ’’, UNIQUE KEY `setting_name` (`setting_name`) ) TYPE=MyISAM COMMENT=’Contains Content Manager settings.’.

Table ’modx.modx_system_settings’ doesn’t exist during the execution of SQL statement ALTER TABLE `modx_system_settings` MODIFY COLUMN `setting_value` text NOT NULL.

Table ’modx.modx_system_eventnames’ doesn’t exist during the execution of SQL statement ALTER TABLE `modx_system_eventnames` ADD COLUMN `groupname` varchar(20) NOT NULL AFTER `service`.

Table ’modx.modx_system_settings’ doesn’t exist during the execution of SQL statement REPLACE INTO `modx_system_settings` (setting_name, setting_value) VALUES (’manager_theme’,’’), (’settings_version’,’0.9.1’), (’server_offset_time’,’0’), (’server_protocol’,’http’), (’manager_language’,’english’), (’etomite_charset’,’iso-8859-1’), (’site_name’,’My MODx Site’), (’site_start’,’1’), (’error_page’,’1’), (’unauthorized_page’,’1’), (’site_status’,’1’), (’site_unavailable_message’,’The site is currently unavailable’), (’track_visitors’,’1’), (’resolve_hostnames’,’1’), (’top_howmany’,’10’), (’default_template’,’1’), (’old_template’,’’), (’publish_default’,’0’), (’cache_default’,’1’), (’search_default’,’1’), (’friendly_urls’,’0’), (’friendly_url_prefix’,’’), (’friendly_url_suffix’,’.html’), (’friendly_alias_urls’,’1’), (’use_alias_path’,’0’), (’use_udperms’,’1’), (’udperms_allowroot’,’0’), (’use_captcha’,’0’), (’captcha_words’,’MODx,Access,Better,BitCode,Cache,Desc,Design,Excell,Enjoy,URLs,TechView,Gerald,Griff,Humphrey,Holiday,Intel,Integration,Joystick,Join(),Tattoo,Genetic,Light,Likeness,Marit,Maaike,Niche,Netherlands,Ordinance,Oscillo,Parser,Phusion,Query,Question,Regalia,Righteous,Snippet,Sentinel,Template,Thespian,Unity,Enterprise,Verily,Veri,Website,WideWeb,Yap,Yellow,Zebra,Zygote’), (’emailsender’,’[email protected]’), (’emailsubject’,’Your login details’), (’signupemail_message’,’Hello [+uid+] \r\n\r\nHere are your login details for [+sname+] Content Manager:\r\n\r\nUsername: [+uid+]\r\nPassword: [+pwd+]\r\n\r\nOnce you log into the Content Manager at [+surl+], you can change your password.\r\n\r\nRegards,\r\nSite Administrator’), (’websignupemail_message’,’Hello [+uid+] \r\n\r\nHere are your login details for [+sname+]:\r\n\r\nUsername: [+uid+]\r\nPassword: [+pwd+]\r\n\r\nOnce you log into [+sname+] at [+surl+], you can change your password.\r\n\r\nRegards,\r\nSite Administrator’), (’webpwdreminder_message’,’Hello [+uid+]\r\n\r\nTo active you new password click the following link:\r\n\r\n[+surl+]\r\n\r\nIf successful you can use the following password to login:\r\n\r\nPassword:[+pwd+]\r\n\r\nIf you did not request this email then please ignore it.\r\n\r\nRegards,\r\nSite Administrator’), (’number_of_logs’,’100’), (’number_of_messages’,’30’), (’number_of_results’,’20’), (’use_editor’,’1’), (’use_browser’,’1’), (’rb_base_dir’,’C:/Development/Webserver/Apache2/htdocs/ModX Test Site/assets/’), (’rb_base_url’,’http://localhost/ModX Test Site/assets/’), (’which_editor’,’FCKEditor’), (’fck_editor_toolbar’,’standard’), (’fck_editor_autolang’,’0’), (’editor_css_path’,’’), (’editor_css_selectors’,’’), (’strip_image_paths’,’0’), (’upload_files’,’jpg,gif,png,ico,txt,php,html,htm,xml,js,css,cache,zip,gz,rar,z,tgz,tar,htaccess,bmp,mp3,mp4,aac,wav,au,wmv,avi,mpg,mpeg,pdf,psd,doc,xls,txt’), (’upload_maxsize’,’1048576’), (’show_preview’,’1’), (’filemanager_path’,’C:/Development/Webserver/Apache2/htdocs/ModX Test Site/’), (’theme_refresher’,’’), (’manager_layout’,’4’), (’custom_contenttype’,’text/css,text/html,text/javascript,text/plain,text/xml’).

Table ’modx.modx_system_eventnames’ doesn’t exist during the execution of SQL statement REPLACE INTO `modx_system_eventnames` (id,name,service,groupname) VALUES (’1’,’OnDocPublished’,’5’,’’), (’2’,’OnDocUnPublished’,’5’,’’), (’3’,’OnWebPagePrerender’,’5’,’’), (’4’,’OnWebLogin’,’3’,’’), (’5’,’OnBeforeWebLogout’,’3’,’’), (’6’,’OnWebLogout’,’3’,’’), (’7’,’OnWebSaveUser’,’3’,’’), (’8’,’OnWebDeleteUser’,’3’,’’), (’9’,’OnWebChangePassword ’,’3’,’’), (’10’,’OnWebCreateGroup’,’3’,’’), (’11’,’OnManagerLogin’,’2’,’’), (’12’,’OnBeforeManagerLogout’,’2’,’’), (’13’,’OnManagerLogout’,’2’,’’), (’14’,’OnManagerSaveUser ’,’2’,’’), (’15’,’OnManagerDeleteUser’,’2’,’’), (’16’,’OnManagerChangePassword ’,’2’,’’), (’17’,’OnManagerCreateGroup’,’2’,’’), (’18’,’OnBeforeCacheUpdate’,’4’,’’), (’19’,’OnCacheUpdate’,’4’,’’), (’20’,’OnLoadWebPageCache’,’4’,’’), (’21’,’OnBeforeSaveWebPageCache’,’4’,’’), (’22’,’OnChunkFormPrerender’,’1’,’Chunks’), (’23’,’OnChunkFormRender’,’1’,’Chunks’), (’24’,’OnBeforeChunkFormSave’,’1’,’Chunks’), (’25’,’OnChunkFormSave’,’1’,’Chunks’), (’26’,’OnBeforeChunkFormDelete’,’1’,’Chunks’), (’27’,’OnChunkFormDelete’,’1’,’Chunks’), (’28’,’OnDocFormPrerender’,’1’,’Documents’), (’29’,’OnDocFormRender’,’1’,’Documents’), (’30’,’OnBeforeDocFormSave’,’1’,’Documents’), (’31’,’OnDocFormSave’,’1’,’Documents’), (’32’,’OnBeforeDocFormDelete’,’1’,’Documents’), (’33’,’OnDocFormDelete’,’1’,’Documents’), (’34’,’OnPluginFormPrerender’,’1’,’Plugins’), (’35’,’OnPluginFormRender’,’1’,’Plugins’), (’36’,’OnBeforePluginFormSave’,’1’,’Plugins’), (’37’,’OnPluginFormSave’,’1’,’Plugins’), (’38’,’OnBeforePluginFormDelete’,’1’,’Plugins’), (’39’,’OnPluginFormDelete’,’1’,’Plugins’), (’40’,’OnSnipFormPrerender’,’1’,’Snippets’), (’41’,’OnSnipFormRender’,’1’,’Snippets’), (’42’,’OnBeforeSnipFormSave’,’1’,’Snippets’), (’43’,’OnSnipFormSave’,’1’,’Snippets’), (’44’,’OnBeforeSnipFormDelete’,’1’,’Snippets’), (’45’,’OnSnipFormDelete’,’1’,’Snippets’), (’46’,’OnTempFormPrerender’,’1’,’Templates’), (’47’,’OnTempFormRender’,’1’,’Templates’), (’48’,’OnBeforeTempFormSave’,’1’,’Templates’), (’49’,’OnTempFormSave’,’1’,’Templates’), (’50’,’OnBeforeTempFormDelete’,’1’,’Templates’), (’51’,’OnTempFormDelete’,’1’,’Templates’), (’52’,’OnTVFormPrerender’,’1’,’Template Variables’), (’53’,’OnTVFormRender’,’1’,’Template Variables’), (’54’,’OnBeforeTVFormSave’,’1’,’Template Variables’), (’55’,’OnTVFormSave’,’1’,’Template Variables’), (’56’,’OnBeforeTVFormDelete’,’1’,’Template Variables’), (’57’,’OnTVFormDelete’,’1’,’Template Variables’), (’58’,’OnUserFormPrerender’,’1’,’Users’), (’59’,’OnUserFormRender’,’1’,’Users’), (’60’,’OnBeforeUserFormSave’,’1’,’Users’), (’61’,’OnUserFormSave’,’1’,’Users’), (’62’,’OnBeforeUserFormDelete’,’1’,’Users’), (’63’,’OnUserFormDelete’,’1’,’Users’), (’64’,’OnWUsrFormPrerender’,’1’,’Web Users’), (’65’,’OnWUsrFormRender’,’1’,’Web Users’), (’66’,’OnBeforeWUsrFormSave’,’1’,’Web Users’), (’67’,’OnWUsrFormSave’,’1’,’Web Users’), (’68’,’OnBeforeWUsrFormDelete’,’1’,’Web Users’), (’69’,’OnWUsrFormDelete’,’1’,’Web Users’), (’70’,’OnSiteRefresh’,’1’,’’), (’71’,’OnFileManagerUpload’,’1’,’’), (’72’,’OnModFormPrerender’,’1’,’Modules’), (’73’,’OnModFormRender’,’1’,’Modules’), (’74’,’OnBeforeModFormDelete’,’1’,’Modules’), (’75’,’OnModFormDelete’,’1’,’Modules’), (’76’,’OnBeforeModFormSave’,’1’,’Modules’), (’77’,’OnModFormSave’,’1’,’Modules’), (’78’,’OnBeforeWebLogin’,’3’,’’), (’79’,’OnWebAuthentication’,’3’,’’), (’80’,’OnBeforeManagerLogin’,’2’,’’), (’81’,’OnManagerAuthentication’,’2’,’’), (’82’,’OnSiteSettingsRender’,’1’,’System Settings’), (’83’,’OnFriendlyURLSettingsRender’,’1’,’System Settings’), (’84’,’OnUserSettingsRender’,’1’,’System Settings’), (’85’,’OnInterfaceSettingsRender’,’1’,’System Settings’), (’86’,’OnMiscSettingsRender’,’1’,’System Settings’), (’87’,’OnRichTextEditorRegister’,’1’,’RichText Editor’), (’88’,’OnRichTextEditorInit’,’1’,’RichText Editor’), (’89’,’OnManagerPageInit’,’2’,’’), (’90’,’OnWebPageInit’,’5’,’’), (’91’,’OnLoadWebDocument’,’5’,’’), (’92’,’OnParseDocument’,’5’,’’), (’200’,’OnCreateDocGroup’,’1’,’Documents’), (’999’,’OnPageUnauthorized’,’1’,’’), (’1000’,’OnPageNotFound’,’1’,’’).

Some tables were not updated. This might be due to previous modifications.

Can anybody help?

Thanks

This is due to "STRICT" sql_mode restrictions added in MySQL 5.x and enabled by default on some platforms. I am assuming this is MODx 0.9.2.2, so your easiest solutions are to either modify the MySQL configuration to turn off the STRICT sql_mode option( s ) OR Download and install MODx 0.9.5 RC3 which should run fine with the STRICT sql_mode options and is only a few days away from being final.

Thanks for the help

I modified the MySQL configuration, and now it installs.