#3778 - installer fails to create cache database during install
-
By xrsean
- Added
- 0 views
| Identifier | #3778 |
|---|---|
| Issue type | Major issue (breaks an entire feature) |
| Title | installer fails to create cache database during install |
| Status | Completed |
| Handling member | Chris Graham |
| Addon | installer |
| Description | Windows 2012
IIS mysql 8 Going through the install process the installer script fails to create the cache db and the install cannot proceed. install.php?step=5 |
| Steps to reproduce | go through install wizard |
| Additional information | An error has occurred
Unfortunately a query has failed [CREATE TABLE cmpsr_cache ( id integer unsigned auto_increment NOT NULL, cached_for varchar(80) NOT NULL, identifier varchar(40) NOT NULL, the_theme varchar(40) NOT NULL, staff_status tinyint(1) NULL, the_member integer NULL, groups varchar(255) NOT NULL, is_bot tinyint(1) NULL, timezone varchar(40) NOT NULL, lang varchar(5) NOT NULL, the_value longtext NOT NULL, dependencies longtext NOT NULL, date_and_time integer unsigned NOT NULL, PRIMARY KEY (id) ) CHARACTER SET=utf8mb4 engine=MyISAM] [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 'groups varchar(255) NOT NULL, is_bot tinyint(1) NULL, timezone varchar(4' at line 8] Here is the stack trace: Below is a stack trace revealing the state Composr was in when the error occurred. If this represents a bug in the unmodified software, you may want to check Composr website for a fix, and if there isn't one, report this as a bug. Please note that merely posting a stack trace is not sufficient for us to solve your problem; the stack trace is just an aid that presents us with additional information. We still need to know the error message, what you tried to do, how you tried to do it, version numbers, and any other appropriate information. We apologize for this problem and if it's a bug we hope you will work with us so that we can fix it for you promptly. File 'E:\\inetpub\\wwwroot\\composr\\sources\\minikernel.php' Line '288' Function 'get_html_trace' Args File 'E:\\inetpub\\wwwroot\\composr\\sources\\database\\mysqli.php' Line '258' Function 'fatal_exit' Args object File 'E:\\inetpub\\wwwroot\\composr\\sources\\database_helper.php' Line '252' Function 'db_query' Class 'Database_Static_mysqli' Object Database_Static_mysqli::__set_state(array( 'cache_db' => array ( 'a:2:{i:0;s:7:"composr";i:1;s:9:"127.0.0.1";}' => mysqli::__set_state(array( 'affected_rows' => NULL, 'client_info' => NULL, 'client_version' => NULL, 'connect_errno' => NULL, 'connect_error' => NULL, 'errno' => NULL, 'error' => NULL, 'error_list' => NULL, 'field_count' => NULL, 'host_info' => NULL, 'info' => NULL, 'insert_id' => NULL, 'server_info' => NULL, 'server_version' => NULL, 'stat' => NULL, 'sqlstate' => NULL, 'protocol_version' => NULL, 'thread_id' => NULL, 'warning_count' => NULL, )), ), 'last_select_db' => array ( 0 => mysqli::__set_state(array( 'affected_rows' => NULL, 'client_info' => NULL, 'client_version' => NULL, 'connect_errno' => NULL, 'connect_error' => NULL, 'errno' => NULL, 'error' => NULL, 'error_list' => NULL, 'field_count' => NULL, 'host_info' => NULL, 'info' => NULL, 'insert_id' => NULL, 'server_info' => NULL, 'server_version' => NULL, 'stat' => NULL, 'sqlstate' => NULL, 'protocol_version' => NULL, 'thread_id' => NULL, 'warning_count' => NULL, )), 1 => 'composr', ), 'reconnected_once' => false, )) Type '->' Args 'CREATE TABLE cmpsr_cache ( id integer unsigned auto_increment NOT NULL, cached_for varchar(80) NOT NULL, identifier varchar(40) NOT NULL, the_theme varchar(40) NOT NULL, staff_status tinyint(1) NULL, the_member integer NULL, groups varchar(255) NOT NULL, is_bot tinyint(1) NULL, timezone varchar(40) NOT NULL, lang varchar(5) NOT NULL, the_value longtext NOT NULL, dependencies longtext NOT NULL, date_and_time integer unsigned NOT NULL, PRIMARY KEY (id) ) CHARACTER SET=utf8mb4 engine=MyISAM' array ( 0 => mysqli::__set_state(array( 'affected_rows' => NULL, 'client_info' => NULL, 'client_version' => NULL, 'connect_errno' => NULL, 'connect_error' => NULL, 'errno' => NULL, 'error' => NULL, 'error_list' => NULL, 'field_count' => NULL, 'host_info' => NULL, 'info' => NULL, 'insert_id' => NULL, 'server_info' => NULL, 'server_version' => NULL, 'stat' => NULL, 'sqlstate' => NULL, 'protocol_version' => NULL, 'thread_id' => NULL, 'warning_count' => NULL, )), 1 => 'composr', ) File 'E:\\inetpub\\wwwroot\\composr\\sources\\database.php' Line '1,045' Function '_helper_create_table' Args ... 'cache' array ( 'id' => '*AUTO', 'cached_for' => 'ID_TEXT', 'identifier' => 'MINIID_TEXT', 'the_theme' => 'MINIID_TEXT', 'staff_status' => '?BINARY', 'the_member' => '?MEMBER', 'groups' => 'SHORT_TEXT', 'is_bot' => '?BINARY', 'timezone' => 'MINIID_TEXT', 'lang' => 'LANGUAGE_NAME', 'the_value' => 'LONG_TEXT', 'dependencies' => 'LONG_TEXT', 'date_and_time' => 'TIME', ) false false false File 'E:\\inetpub\\wwwroot\\composr\\sources\\zones2.php(464) : eval()\'d code' Line '289' Function 'create_table' Class 'DatabaseConnector' Object DatabaseConnector::__set_state(array( 'table_prefix' => 'cmpsr_', 'connection_read' => array ( 0 => mysqli::__set_state(array( 'affected_rows' => NULL, 'client_info' => NULL, 'client_version' => NULL, 'connect_errno' => NULL, 'connect_error' => NULL, 'errno' => NULL, 'error' => NULL, 'error_list' => NULL, 'field_count' => NULL, 'host_info' => NULL, 'info' => NULL, 'insert_id' => NULL, 'server_info' => NULL, 'server_version' => NULL, 'stat' => NULL, 'sqlstate' => NULL, 'protocol_version' => NULL, 'thread_id' => NULL, 'warning_count' => NULL, )), 1 => 'composr', ), 'connection_write' => array ( 0 => mysqli::__set_state(array( 'affected_rows' => NULL, 'client_info' => NULL, 'client_version' => NULL, 'connect_errno' => NULL, 'connect_error' => NULL, 'errno' => NULL, 'error' => NULL, 'error_list' => NULL, 'field_count' => NULL, 'host_info' => NULL, 'info' => NULL, 'insert_id' => NULL, 'server_info' => NULL, 'server_version' => NULL, 'stat' => NULL, 'sqlstate' => NULL, 'protocol_version' => NULL, 'thread_id' => NULL, 'warning_count' => NULL, )), 1 => 'composr', ), 'text_lookup_original_cache' => array ( ), 'text_lookup_cache' => array ( ), 'table_exists_cache' => array ( 'menu_items' => true, 'trackbacks' => true, 'captchas' => true, 'member_tracking' => true, 'cache_on' => true, 'webstandards_checked_once' => true, 'edit_pings' => true, 'values_elective' => true, 'tutorial_links' => true, 'member_privileges' => true, 'member_zone_access' => true, 'member_page_access' => true, 'member_category_access' => true, 'autosave' => true, 'messages_to_render' => true, 'url_title_cache' => true, 'rating' => true, 'comcode_pages' => true, 'cached_comcode_pages' => true, 'url_id_monikers' => true, 'review_supplement' => true, 'logged_mail_messages' => true, 'link_tracker' => true, 'incoming_uploads' => true, ), 'static_ob' => Database_Static_mysqli::__set_state(array( 'cache_db' => array ( 'a:2:{i:0;s:7:"composr";i:1;s:9:"127.0.0.1";}' => mysqli::__set_state(array( 'affected_rows' => NULL, 'client_info' => NULL, 'client_version' => NULL, 'connect_errno' => NULL, 'connect_error' => NULL, 'errno' => NULL, 'error' => NULL, 'error_list' => NULL, 'field_count' => NULL, 'host_info' => NULL, 'info' => NULL, 'insert_id' => NULL, 'server_info' => NULL, 'server_version' => NULL, 'stat' => NULL, 'sqlstate' => NULL, 'protocol_version' => NULL, 'thread_id' => NULL, 'warning_count' => NULL, )), ), 'last_select_db' => array ( 0 => mysqli::__set_state(array( 'affected_rows' => NULL, 'client_info' => NULL, 'client_version' => NULL, 'connect_errno' => NULL, 'connect_error' => NULL, 'errno' => NULL, 'error' => NULL, 'error_list' => NULL, 'field_count' => NULL, 'host_info' => NULL, 'info' => NULL, 'insert_id' => NULL, 'server_info' => NULL, 'server_version' => NULL, 'stat' => NULL, 'sqlstate' => NULL, 'protocol_version' => NULL, 'thread_id' => NULL, 'warning_count' => NULL, )), 1 => 'composr', ), 'reconnected_once' => false, )), 'dedupe_mode' => false, )) Type '->' Args 'cache' array ( 'id' => '*AUTO', 'cached_for' => 'ID_TEXT', 'identifier' => 'MINIID_TEXT', 'the_theme' => 'MINIID_TEXT', 'staff_status' => '?BINARY', 'the_member' => '?MEMBER', 'groups' => 'SHORT_TEXT', 'is_bot' => '?BINARY', 'timezone' => 'MINIID_TEXT', 'lang' => 'LANGUAGE_NAME', 'the_value' => 'LONG_TEXT', 'dependencies' => 'LONG_TEXT', 'date_and_time' => 'TIME', ) File 'E:\\inetpub\\wwwroot\\composr\\sources\\zones2.php(464) : eval()\'d code' Line '882' Function 'installadmin_version323404797_1' Args File 'E:\\inetpub\\wwwroot\\composr\\sources\\zones2.php' Line '464' Function 'eval' File 'E:\\inetpub\\wwwroot\\composr\\install.php' Line '2,277' Function 'reinstall_module' Args 'adminzone' 'admin_version' File 'E:\\inetpub\\wwwroot\\composr\\install.php' Line '204' Function 'step_7' Args |
| Funded? | No |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".
Comments