Answers.Body: <p>The error occurs when it tries to create the table _drupal7`.log_civicrm_value__4.  It is trying to create it having storage engine of ARCHIVE.   You can't see the whole command from the log.  It would be something like </p>
  
  <pre><code>create table_name ( column1, column2) Engine=ARCHIVE...  
  </code></pre>
  
  <p>So do you have that engine?  From mysql do a </p>
  
  <pre><code>show engines;
  </code></pre>
  
  <p>You should get something like</p>
  
  <pre><code>mysql&gt; SHOW ENGINES;
  +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
  | Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
  +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
  | MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
  | CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
  | MyISAM             | DEFAULT | MyISAM storage engine                                          | NO           | NO   | NO         |
  | BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
  | FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
  | PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
  | ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
  | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
  +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
  </code></pre>
  
  <p>I suspect you'll not see an entry for ARCHIVE or it might have a No in the Support column. </p>
  
  <p>Here is some info on enabling it</p>
  
  <p><a href="https://stackoverflow.com/questions/1458122/enabling-archive-engine">https://stackoverflow.com/questions/1458122/enabling-archive-engine</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-17T13:06:00.533Z
Answers.Text: ARCHIVE is not present as an engine, and in shared hosting i cannot enable it. Is it possible to change the command in CiviCRM? Is INNODB for the civicrm log files a drawback?
Answers.UserDisplayName: MarkDQ
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-17T18:46:29.970Z
Answers.Text: "The ARCHIVE Storage Engine was enabled by default until MariaDB 10.0. From MariaDB 10.1, the plugin needs to be specifically enabled."
  
  see https://mariadb.com/kb/en/mariadb/archive/ .
  
  Because my webhost did not enable the plugin, i need another solution.
Answers.UserDisplayName: MarkDQ
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-17T23:40:37.750Z
Answers.Text: Do you logging turned on (admin=>system=>misc)?  It is trying to create the logging table for this field.  The code is basically hard coded to create the table with engine=archive.  What's odd to me is if logging is turned on how did it create all the other log tables?  Do you see lots of tables that are civicrm_log_TABLENAME?  Logging is handled with a trigger.  Do you see a trigger on civicrm_value_FIELDSETNAME_4?  Do you have a test instance?  If so you could try dropping the trigger or try turning off logging.  I can't remember if you turn of logging is a major thing with it drop triggers
Answers.UserDisplayName: Paul-Tahoe
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-18T16:59:46.230Z
Answers.Text: The site was moved recently to a faster server. The old server had MySQL with ARCHIVE engine, the new server MariaDB 10.1 without ARCHIVE. That explains why we did not have problems before, only after the change. Our provider got a reply from the CPANEL guys (MARIADB is installed using CPANEL): we are working on a new version, a beta will be released next Friday, the 24th. I am wondering why they need a new version, as MARIADB stated that only "INSTALL SONAME 'ha_archive';" has to be added...
Answers.UserDisplayName: MarkDQ
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-18T17:02:10.193Z
Answers.Text: And yes, disabling logging (admin=>system=>misc) removed the error, as no ARCHIVE table has to be created.
Answers.UserDisplayName: MarkDQ
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-17T01:44:08.387Z
Answers.LastActivityDate: 2017-03-17T01:44:08.387Z
Answers.LastEditDate: 2017-05-23T12:38:59.763Z
Answers.UserDisplayName: Paul-Tahoe
Body: <p>Adding a new field to a set of fields results in an error
      DB Error: unknown error</p>
  
  <p>In ConfigAndLog (real names are replaced by ,  and ):</p>
  
  <pre><code>Mar 16 05:19:37  [info] $backTrace = #0 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(229): CRM_Core_Error::backtrace("backTrace", TRUE)
  #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
  #2 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/PEAR.php(921): call_user_func((Array:2), Object(DB_Error))
  #3 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error-&gt;__construct("DB Error: unknown error", -1, 16, (Array:2), "CREATE TABLE `&lt;prefix&gt;_drupal7`.log_civicrm_value_&lt;name&gt;_4 (\n  `id` in...")
  #4 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/PEAR.php(575): DB_Error-&gt;__construct(-1, 16, (Array:2), "CREATE TABLE `&lt;prefix&gt;_drupal7`.log_civicrm_value_&lt;name&gt;_4 (\n  `id` in...")
  #5 [internal function](): PEAR-&gt;_raiseError(Object(DB_mysqli), NULL, -1, NULL, NULL, "CREATE TABLE `&lt;prefix&gt;_drupal7`.log_civicrm_value_&lt;name&gt;_4 (\n  `id` in...", "DB_Error", TRUE)
  #6 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/PEAR.php(224): call_user_func_array((Array:2), (Array:8))
  #7 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR-&gt;__call("raiseError", (Array:7))
  #8 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR-&gt;raiseError(NULL, -1, NULL, NULL, "CREATE TABLE `&lt;prefix&gt;_drupal7`.log_civicrm_value_&lt;name&gt;_4 (\n  `id` in...", "DB_Error", TRUE)
  #9 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common-&gt;raiseError(-1, NULL, NULL, NULL, "1286 ** Unknown storage engine 'ARCHIVE'")
  #10 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli-&gt;mysqliRaiseError()
  #11 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli-&gt;simpleQuery("CREATE TABLE `&lt;prefix&gt;_drupal7`.log_civicrm_value_&lt;name&gt;_4 (\n  `id` in...")
  #12 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(2438): DB_common-&gt;query("CREATE TABLE `&lt;prefix&gt;_drupal7`.log_civicrm_value_&lt;name&gt;_4 (\n  `id` in...")
  #13 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(1627): DB_DataObject-&gt;_query("CREATE TABLE `&lt;prefix&gt;_drupal7`.log_civicrm_value_&lt;name&gt;_4 (\n  `id` in...")
  #14 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(354): DB_DataObject-&gt;query("CREATE TABLE `&lt;prefix&gt;_drupal7`.log_civicrm_value_&lt;name&gt;_4 (\n  `id` in...")
  #15 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(1297): CRM_Core_DAO-&gt;query("CREATE TABLE `&lt;prefix&gt;_drupal7`.log_civicrm_value_&lt;name&gt;_4 (\n  `id` in...", FALSE)
  #16 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Logging/Schema.php(718): CRM_Core_DAO::executeQuery("CREATE TABLE `&lt;prefix&gt;_drupal7`.log_civicrm_value_&lt;name&gt;_4 (\n  `id` in...", (Array:0), TRUE, NULL, FALSE, FALSE)
  #17 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Logging/Schema.php(385): CRM_Logging_Schema-&gt;createLogTableFor("civicrm_value_&lt;name&gt;_4")
  #18 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Core/BAO/SchemaHandler.php(348): CRM_Logging_Schema-&gt;fixSchemaDifferencesFor("civicrm_value_&lt;name&gt;_4", (Array:1), FALSE)
  #19 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Core/BAO/CustomField.php(1842): CRM_Core_BAO_SchemaHandler::alterFieldSQL((Array:6), FALSE, TRUE)
  #20 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Core/BAO/CustomField.php(312): CRM_Core_BAO_CustomField::createField(Object(CRM_Core_DAO_CustomField), "add", FALSE, TRUE)
  #21 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Custom/Form/Field.php(1000): CRM_Core_BAO_CustomField::create((Array:35))
  #22 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Core/Form.php(435): CRM_Custom_Form_Field-&gt;postProcess()
  #23 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Done.php(75): CRM_Core_Form-&gt;mainProcess()
  #24 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Done-&gt;perform(Object(CRM_Custom_Form_Field), "done")
  #25 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller-&gt;handle(Object(CRM_Custom_Form_Field), "done")
  #26 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page-&gt;handle("done")
  #27 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller-&gt;run()
  #28 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(284): CRM_Utils_Wrapper-&gt;run("CRM_Custom_Form_Field", "Aangepast veld - Toevoegen", NULL)
  #29 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
  #30 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:6))
  #31 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:6))
  #32 [internal function](): civicrm_invoke("admin", "custom", "group", "field", "add")
  #33 /home/&lt;domain&gt;/public_html/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:5))
  #34 /home/&lt;domain&gt;/public_html/index.php(27): menu_execute_active_handler()
  #35 {main}
  </code></pre>
  
  <p>I think the error is created in lines 9 and 10 ...</p>
  
  <pre><code>#9 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common-&gt;raiseError(-1, NULL, NULL, NULL, "1286 ** Unknown storage engine 'ARCHIVE'")
  #10 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli-&gt;mysqliRaiseError()
  #11 /home/&lt;domain&gt;/public_html/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli-&gt;simpleQuery("CREATE TABLE `&lt;prefix&gt;_drupal7`.log_civicrm_value_&lt;name&gt;_4 (\n  `id` in...")
  </code></pre>
  
  <p>Searching for "1286 ** Unknown storage engine 'ARCHIVE'" i found this entry:</p>
  
  <pre><code>http://civicrm.stackexchange.com/questions/15218/civicrm-logging-enabled-i-am-now-getting-an-error-on-mysqldump-unknown-storage
  </code></pre>
  
  <p>Executing</p>
  
  <pre><code>ALTER TABLE log_civicrm_install_canary ENGINE=InnoDB
  </code></pre>
  
  <p>results in</p>
  
  <pre><code>#1146 - Table '&lt;prefix&gt;_drupal7.log_civicrm_install_canary' doesn't exist
  </code></pre>
  
  <p>In the comment: <em>"The civicrm_install_canary is a table used for installation purposes. The purpose is explained in the answer on What is the installation canary?"</em></p>
  
  <pre><code>http://civicrm.stackexchange.com/questions/15594/what-is-the-installation-canary
  </code></pre>
  
  <p>But no information in this link how to install/create <em>civicrm_install_canary</em> if the table is missing.</p>
  
  <p>Is the non existence of this table, the real cause of the <em>"DB error unknown"</em>?
  If so, how to create it?</p>
  
Tags: <custom-fields><db-logging>
Title: "DB Error: unknown error" when adding (custom) field
ThreadText: # "DB Error: unknown error" when adding (custom) field
  
  (Asked by: username_0 on 2017-03-16)
  
  Adding a new field to a set of fields results in an error
  DB Error: unknown error
  
  In ConfigAndLog (real names are replaced by , and ):
  
  ```
  Mar 16 05:19:37  [info] $backTrace = #0 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(229): CRM_Core_Error::backtrace("backTrace", TRUE)
  #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
  #2 /home/<domain>/public_html/sites/all/modules/civicrm/packages/PEAR.php(921): call_user_func((Array:2), Object(DB_Error))
  #3 /home/<domain>/public_html/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "CREATE TABLE `<prefix>_drupal7`.log_civicrm_value_<name>_4 (\n  `id` in...")
  #4 /home/<domain>/public_html/sites/all/modules/civicrm/packages/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "CREATE TABLE `<prefix>_drupal7`.log_civicrm_value_<name>_4 (\n  `id` in...")
  #5 [internal function](): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, NULL, NULL, "CREATE TABLE `<prefix>_drupal7`.log_civicrm_value_<name>_4 (\n  `id` in...", "DB_Error", TRUE)
  #6 /home/<domain>/public_html/sites/all/modules/civicrm/packages/PEAR.php(224): call_user_func_array((Array:2), (Array:8))
  #7 /home/<domain>/public_html/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->__call("raiseError", (Array:7))
  #8 /home/<domain>/public_html/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "CREATE TABLE `<prefix>_drupal7`.log_civicrm_value_<name>_4 (\n  `id` in...", "DB_Error", TRUE)
  #9 /home/<domain>/public_html/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, NULL, "1286 ** Unknown storage engine 'ARCHIVE'")
  #10 /home/<domain>/public_html/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
  #11 /home/<domain>/public_html/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("CREATE TABLE `<prefix>_drupal7`.log_civicrm_value_<name>_4 (\n  `id` in...")
  #12 /home/<domain>/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(2438): DB_common->query("CREATE TABLE `<prefix>_drupal7`.log_civicrm_value_<name>_4 (\n  `id` in...")
  #13 /home/<domain>/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(1627): DB_DataObject->_query("CREATE TABLE `<prefix>_drupal7`.log_civicrm_value_<name>_4 (\n  `id` in...")
  #14 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(354): DB_DataObject->query("CREATE TABLE `<prefix>_drupal7`.log_civicrm_value_<name>_4 (\n  `id` in...")
  #15 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(1297): CRM_Core_DAO->query("CREATE TABLE `<prefix>_drupal7`.log_civicrm_value_<name>_4 (\n  `id` in...", FALSE)
  #16 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Logging/Schema.php(718): CRM_Core_DAO::executeQuery("CREATE TABLE `<prefix>_drupal7`.log_civicrm_value_<name>_4 (\n  `id` in...", (Array:0), TRUE, NULL, FALSE, FALSE)
  #17 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Logging/Schema.php(385): CRM_Logging_Schema->createLogTableFor("civicrm_value_<name>_4")
  #18 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Core/BAO/SchemaHandler.php(348): CRM_Logging_Schema->fixSchemaDifferencesFor("civicrm_value_<name>_4", (Array:1), FALSE)
  #19 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Core/BAO/CustomField.php(1842): CRM_Core_BAO_SchemaHandler::alterFieldSQL((Array:6), FALSE, TRUE)
  #20 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Core/BAO/CustomField.php(312): CRM_Core_BAO_CustomField::createField(Object(CRM_Core_DAO_CustomField), "add", FALSE, TRUE)
  #21 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Custom/Form/Field.php(1000): CRM_Core_BAO_CustomField::create((Array:35))
  #22 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Core/Form.php(435): CRM_Custom_Form_Field->postProcess()
  #23 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Done.php(75): CRM_Core_Form->mainProcess()
  #24 /home/<domain>/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Done->perform(Object(CRM_Custom_Form_Field), "done")
  #25 /home/<domain>/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Custom_Form_Field), "done")
  #26 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("done")
  #27 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller->run()
  #28 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(284): CRM_Utils_Wrapper->run("CRM_Custom_Form_Field", "Aangepast veld - Toevoegen", NULL)
  #29 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
  #30 /home/<domain>/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:6))
  #31 /home/<domain>/public_html/sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:6))
  #32 [internal function](): civicrm_invoke("admin", "custom", "group", "field", "add")
  #33 /home/<domain>/public_html/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:5))
  #34 /home/<domain>/public_html/index.php(27): menu_execute_active_handler()
  #35 {main}
  
  ```
  
  I think the error is created in lines 9 and 10 ...
  
  ```
  #9 /home/<domain>/public_html/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, NULL, "1286 ** Unknown storage engine 'ARCHIVE'")
  #10 /home/<domain>/public_html/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
  #11 /home/<domain>/public_html/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("CREATE TABLE `<prefix>_drupal7`.log_civicrm_value_<name>_4 (\n  `id` in...")
  
  ```
  
  Searching for "1286 \*\* Unknown storage engine 'ARCHIVE'" i found this entry:
  
  ```
  http://civicrm.stackexchange.com/questions/15218/civicrm-logging-enabled-i-am-now-getting-an-error-on-mysqldump-unknown-storage
  
  ```
  
  Executing
  
  ```
  ALTER TABLE log_civicrm_install_canary ENGINE=InnoDB
  
  ```
  
  results in
  
  ```
  #1146 - Table '<prefix>_drupal7.log_civicrm_install_canary' doesn't exist
  
  ```
  
  In the comment: *"The civicrm\_install\_canary is a table used for installation purposes. The purpose is explained in the answer on What is the installation canary?"*
  
  ```
  http://civicrm.stackexchange.com/questions/15594/what-is-the-installation-canary
  
  ```
  
  But no information in this link how to install/create *civicrm\_install\_canary* if the table is missing.
  
  Is the non existence of this table, the real cause of the *"DB error unknown"*?
  If so, how to create it?
  
  **Tags:** custom-fields, db-logging
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-03-17. Score: 3
  
  The error occurs when it tries to create the table \_drupal7`.log\_civicrm\_value\_\_4. It is trying to create it having storage engine of ARCHIVE. You can't see the whole command from the log. It would be something like
  
  ```
  create table_name ( column1, column2) Engine=ARCHIVE...  
  
  ```
  
  So do you have that engine? From mysql do a
  
  ```
  show engines;
  
  ```
  
  You should get something like
  
  ```
  mysql> SHOW ENGINES;
  +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
  | Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
  +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
  | MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
  | CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
  | MyISAM             | DEFAULT | MyISAM storage engine                                          | NO           | NO   | NO         |
  | BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
  | FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
  | PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
  | ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
  | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
  +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
  
  ```
  
  I suspect you'll not see an entry for ARCHIVE or it might have a No in the Support column.
  
  Here is some info on enabling it
  
  <https://stackoverflow.com/questions/1458122/enabling-archive-engine>
  
  > **Comments:**
  > **username_0**: ARCHIVE is not present as an engine, and in shared hosting i cannot enable it. Is it possible to change the command in CiviCRM? Is INNODB for the civicrm log files a drawback?  
  > **username_0**: "The ARCHIVE Storage Engine was enabled by default until MariaDB 10.0. From MariaDB 10.1, the plugin needs to be specifically enabled."  see https://mariadb.com/kb/en/mariadb/archive/ .  Because my webhost did not enable the plugin, i need another solution.  
  > **username_1**: Do you logging turned on (admin=>system=>misc)?  It is trying to create the logging table for this field.  The code is basically hard coded to create the table with engine=archive.  What's odd to me is if logging is turned on how did it create all the other log tables?  Do you see lots of tables that are civicrm_log_TABLENAME?  Logging is handled with a trigger.  Do you see a trigger on civicrm_value_FIELDSETNAME_4?  Do you have a test instance?  If so you could try dropping the trigger or try turning off logging.  I can't remember if you turn of logging is a major thing with it drop triggers  
  > **username_0**: The site was moved recently to a faster server. The old server had MySQL with ARCHIVE engine, the new server MariaDB 10.1 without ARCHIVE. That explains why we did not have problems before, only after the change. Our provider got a reply from the CPANEL guys (MARIADB is installed using CPANEL): we are working on a new version, a beta will be released next Friday, the 24th. I am wondering why they need a new version, as MARIADB stated that only "INSTALL SONAME 'ha_archive';" has to be added...  
  > **username_0**: And yes, disabling logging (admin=>system=>misc) removed the error, as no ARCHIVE table has to be created.  
  
  ---
  
  