Answers.Body: <p>The part of the error that matters is this part:</p>
  
  <pre><code>Thread stack overrun:  8640 bytes used of a 131072 byte stack, and 128000 bytes needed.  Use 'mysqld --thread_stack=#' to specify a bigger stack.
  </code></pre>
  
  <p>See <a href="https://docs.civicrm.org/sysadmin/en/latest/requirements/" rel="nofollow noreferrer">https://docs.civicrm.org/sysadmin/en/latest/requirements/</a> under MySQL configuration - it needs to be 192k or higher. FYI the thread_stack variable needs to be set in the mysql configuration file and mysql needs to be restarted - you can't change it on the fly.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-28T14:31:47.150Z
Answers.LastActivityDate: 2018-03-28T14:31:47.150Z
Answers.UserDisplayName: Demerit
Answers.Body: <p>Thank you for your help Demerit<br>
  I found the my.ini file in UniserverZ<br>
  I searched google to look for the same problem but it told me to find my.cnf file to edit the thread_stack, I was in frustration last night for unable to find one.<br>
  <br>
  <br>
  <a href="https://i.sstatic.net/w16gg.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/w16gg.png" alt="enter image description here"></a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-29T02:37:17.533Z
Answers.Text: Great! Good googling.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-29T02:10:05.263Z
Answers.LastActivityDate: 2018-03-29T02:10:05.263Z
Answers.UserDisplayName: Jennifer Lee
Body: <p>it's fresh install of CiviCrm into my Joomla, run with UniserverZ<br>
  (assume all Apps are in latest version)</p>
  
  <p><a href="https://i.sstatic.net/aGZaa.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/aGZaa.png" alt="Joomla Admin Panel"></a></p>
  
  <p>When I clicked CiviCRM, in Components, there was a DB Error: unknown error<br>
  In the joomla/media/civicrm/ConfigAndLog displays</p>
  
  <pre><code>
  Mar 28 07:58:42  [info] $Fatal Error Details = Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => handle
          )
  
      [code] => -1
      [message] => DB Error: unknown error
      [mode] => 16
      [debug_info] => INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , display_name , preferred_language , hash , first_name , last_name , communication_style_id , email_greeting_id , postal_greeting_id , addressee_id ) VALUES ('Individual' ,  NULL , 'User, Super' , 'Super User' , 'en_US' , '4657797a1e8c1944237e5e83dc3f8b38' , 'Super' , 'User' ,  1 ,  1 ,  1 ,  1 )  [nativecode=1436 ** Thread stack overrun:  8640 bytes used of a 131072 byte stack, and 128000 bytes needed.  Use 'mysqld --thread_stack=#' to specify a bigger stack.]
      [type] => DB_Error
      [user_info] => INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , display_name , preferred_language , hash , first_name , last_name , communication_style_id , email_greeting_id , postal_greeting_id , addressee_id ) VALUES ('Individual' ,  NULL , 'User, Super' , 'Super User' , 'en_US' , '4657797a1e8c1944237e5e83dc3f8b38' , 'Super' , 'User' ,  1 ,  1 ,  1 ,  1 )  [nativecode=1436 ** Thread stack overrun:  8640 bytes used of a 131072 byte stack, and 128000 bytes needed.  Use 'mysqld --thread_stack=#' to specify a bigger stack.]
      [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , display_name , preferred_language , hash , first_name , last_name , communication_style_id , email_greeting_id , postal_greeting_id , addressee_id ) VALUES ('Individual' ,  NULL , 'User, Super' , 'Super User' , 'en_US' , '4657797a1e8c1944237e5e83dc3f8b38' , 'Super' , 'User' ,  1 ,  1 ,  1 ,  1 )  [nativecode=1436 ** Thread stack overrun:  8640 bytes used of a 131072 byte stack, and 128000 bytes needed.  Use 'mysqld --thread_stack=#' to specify a bigger stack.]"]
  )
  
  
  Mar 28 07:58:42  [info] $backTrace = #0 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\CRM\Core\Error.php(232): CRM_Core_Error::backtrace("backTrace", TRUE)
  #1 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\PEAR.php(921): CRM_Core_Error::handle(Object(DB_Error))
  #2 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\DB.php(984): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...")
  #3 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...")
  #4 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), "INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...", "DB_Error", TRUE)
  #5 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\DB\common.php(1905): PEAR->__call("raiseError", (Array:7))
  #6 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\DB\mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, "INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...", "1436 ** Thread stack overrun:  8640 bytes used of a 131072 byte stack, and 12...")
  #7 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\DB\mysqli.php(403): DB_mysqli->mysqliRaiseError()
  #8 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\DB\common.php(1216): DB_mysqli->simpleQuery("INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...")
  #9 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\DB\DataObject.php(2446): DB_common->query("INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...")
  #10 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\DB\DataObject.php(1068): DB_DataObject->_query("INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...")
  #11 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\CRM\Core\DAO.php(525): DB_DataObject->insert()
  #12 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\CRM\Contact\BAO\Contact.php(214): CRM_Core_DAO->save()
  #13 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\CRM\Contact\BAO\Contact.php(308): CRM_Contact_BAO_Contact::add((Array:12))
  #14 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\CRM\Contact\BAO\Contact.php(1992): CRM_Contact_BAO_Contact::create((Array:12))
  #15 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\CRM\Core\BAO\UFMatch.php(298): CRM_Contact_BAO_Contact::createProfileContact((Array:5), (Array:0))
  #16 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\CRM\Core\BAO\UFMatch.php(118): CRM_Core_BAO_UFMatch::synchronizeUFMatch(Object(Joomla\CMS\User\User), "121", "temp@temp.com", "Joomla", NULL, "Individual", TRUE)
  #17 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm.php(97): CRM_Core_BAO_UFMatch::synchronize(Object(Joomla\CMS\User\User), FALSE, "Joomla", "Individual", TRUE)
  #18 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm.php(40): civicrm_invoke()
  #19 C:\Users\USER\Desktop\UniServerZ\www\joomla\libraries\src\Component\ComponentHelper.php(382): require_once("C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civi...")
  #20 C:\Users\USER\Desktop\UniServerZ\www\joomla\libraries\src\Component\ComponentHelper.php(357): Joomla\CMS\Component\ComponentHelper::executeComponent("C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator/components/com_civi...")
  #21 C:\Users\USER\Desktop\UniServerZ\www\joomla\libraries\src\Application\AdministratorApplication.php(101): Joomla\CMS\Component\ComponentHelper::renderComponent("com_civicrm")
  #22 C:\Users\USER\Desktop\UniServerZ\www\joomla\libraries\src\Application\AdministratorApplication.php(159): Joomla\CMS\Application\AdministratorApplication->dispatch()
  #23 C:\Users\USER\Desktop\UniServerZ\www\joomla\libraries\src\Application\CMSApplication.php(303): Joomla\CMS\Application\AdministratorApplication->doExecute()
  #24 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\index.php(51): Joomla\CMS\Application\CMSApplication->execute()
  #25 {main}
  </code>
  </pre>
  
  <p>I'm a newbie, don't know what went wrong? Please help</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-03-28T11:31:08.173Z
Comments.Text: This sounds like something is wrong at the server level with the database configuration. You could probably ask your hosting provider.
Comments.UserDisplayName: Jaap Jansma - CiviCooP
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-03-29T02:11:33.993Z
Comments.Text: it was run in UniserverZ, a localhost
Comments.UserDisplayName: Jennifer Lee
Tags: <joomla><error><database><mysql><civicrm-contact>
Title: DB Error: unknown error - [debug_info] => INSERT INTO civicrm_contact
ThreadText: # DB Error: unknown error - [debug_info] => INSERT INTO civicrm_contact
  
  (Asked by: username_0 on 2018-03-28)
  
  it's fresh install of CiviCrm into my Joomla, run with UniserverZ
  (assume all Apps are in latest version)
  
  When I clicked CiviCRM, in Components, there was a DB Error: unknown error
  In the joomla/media/civicrm/ConfigAndLog displays
  
  Mar 28 07:58:42  [info] $Fatal Error Details = Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => handle
          )
  
      [code] => -1
      [message] => DB Error: unknown error
      [mode] => 16
      [debug_info] => INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , display_name , preferred_language , hash , first_name , last_name , communication_style_id , email_greeting_id , postal_greeting_id , addressee_id ) VALUES ('Individual' ,  NULL , 'User, Super' , 'Super User' , 'en_US' , '4657797a1e8c1944237e5e83dc3f8b38' , 'Super' , 'User' ,  1 ,  1 ,  1 ,  1 )  [nativecode=1436 ** Thread stack overrun:  8640 bytes used of a 131072 byte stack, and 128000 bytes needed.  Use 'mysqld --thread_stack=#' to specify a bigger stack.]
      [type] => DB_Error
      [user_info] => INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , display_name , preferred_language , hash , first_name , last_name , communication_style_id , email_greeting_id , postal_greeting_id , addressee_id ) VALUES ('Individual' ,  NULL , 'User, Super' , 'Super User' , 'en_US' , '4657797a1e8c1944237e5e83dc3f8b38' , 'Super' , 'User' ,  1 ,  1 ,  1 ,  1 )  [nativecode=1436 ** Thread stack overrun:  8640 bytes used of a 131072 byte stack, and 128000 bytes needed.  Use 'mysqld --thread_stack=#' to specify a bigger stack.]
      [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , display_name , preferred_language , hash , first_name , last_name , communication_style_id , email_greeting_id , postal_greeting_id , addressee_id ) VALUES ('Individual' ,  NULL , 'User, Super' , 'Super User' , 'en_US' , '4657797a1e8c1944237e5e83dc3f8b38' , 'Super' , 'User' ,  1 ,  1 ,  1 ,  1 )  [nativecode=1436 ** Thread stack overrun:  8640 bytes used of a 131072 byte stack, and 128000 bytes needed.  Use 'mysqld --thread_stack=#' to specify a bigger stack.]"]
  )
  
  
  Mar 28 07:58:42  [info] $backTrace = #0 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\CRM\Core\Error.php(232): CRM_Core_Error::backtrace("backTrace", TRUE)
  #1 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\PEAR.php(921): CRM_Core_Error::handle(Object(DB_Error))
  #2 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\DB.php(984): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...")
  #3 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...")
  #4 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), "INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...", "DB_Error", TRUE)
  #5 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\DB\common.php(1905): PEAR->__call("raiseError", (Array:7))
  #6 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\DB\mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, "INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...", "1436 ** Thread stack overrun:  8640 bytes used of a 131072 byte stack, and 12...")
  #7 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\DB\mysqli.php(403): DB_mysqli->mysqliRaiseError()
  #8 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\DB\common.php(1216): DB_mysqli->simpleQuery("INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...")
  #9 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\DB\DataObject.php(2446): DB_common->query("INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...")
  #10 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\packages\DB\DataObject.php(1068): DB_DataObject->_query("INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...")
  #11 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\CRM\Core\DAO.php(525): DB_DataObject->insert()
  #12 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\CRM\Contact\BAO\Contact.php(214): CRM_Core_DAO->save()
  #13 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\CRM\Contact\BAO\Contact.php(308): CRM_Contact_BAO_Contact::add((Array:12))
  #14 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\CRM\Contact\BAO\Contact.php(1992): CRM_Contact_BAO_Contact::create((Array:12))
  #15 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\CRM\Core\BAO\UFMatch.php(298): CRM_Contact_BAO_Contact::createProfileContact((Array:5), (Array:0))
  #16 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm\CRM\Core\BAO\UFMatch.php(118): CRM_Core_BAO_UFMatch::synchronizeUFMatch(Object(Joomla\CMS\User\User), "121", "temp@temp.com", "Joomla", NULL, "Individual", TRUE)
  #17 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm.php(97): CRM_Core_BAO_UFMatch::synchronize(Object(Joomla\CMS\User\User), FALSE, "Joomla", "Individual", TRUE)
  #18 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civicrm\civicrm.php(40): civicrm_invoke()
  #19 C:\Users\USER\Desktop\UniServerZ\www\joomla\libraries\src\Component\ComponentHelper.php(382): require_once("C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\components\com_civi...")
  #20 C:\Users\USER\Desktop\UniServerZ\www\joomla\libraries\src\Component\ComponentHelper.php(357): Joomla\CMS\Component\ComponentHelper::executeComponent("C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator/components/com_civi...")
  #21 C:\Users\USER\Desktop\UniServerZ\www\joomla\libraries\src\Application\AdministratorApplication.php(101): Joomla\CMS\Component\ComponentHelper::renderComponent("com_civicrm")
  #22 C:\Users\USER\Desktop\UniServerZ\www\joomla\libraries\src\Application\AdministratorApplication.php(159): Joomla\CMS\Application\AdministratorApplication->dispatch()
  #23 C:\Users\USER\Desktop\UniServerZ\www\joomla\libraries\src\Application\CMSApplication.php(303): Joomla\CMS\Application\AdministratorApplication->doExecute()
  #24 C:\Users\USER\Desktop\UniServerZ\www\joomla\administrator\index.php(51): Joomla\CMS\Application\CMSApplication->execute()
  #25 {main}
  
  
  I'm a newbie, don't know what went wrong? Please help
  
  **Tags:** joomla, error, database, mysql, civicrm-contact
  
  > **Comments:**
  > **username_1**: This sounds like something is wrong at the server level with the database configuration. You could probably ask your hosting provider.  
  > **username_0**: it was run in UniserverZ, a localhost  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2018-03-28. Score: 2 | Accepted answer
  
  The part of the error that matters is this part:
  Thread stack overrun:  8640 bytes used of a 131072 byte stack, and 128000 bytes needed.  Use 'mysqld --thread_stack=#' to specify a bigger stack.
  
  See https://docs.civicrm.org/sysadmin/en/latest/requirements/ under MySQL configuration - it needs to be 192k or higher. FYI the thread_stack variable needs to be set in the mysql configuration file and mysql needs to be restarted - you can't change it on the fly.
  
  
  ---
  
  ### Answer by username_0 on 2018-03-29. Score: 3
  
  Thank you for your help username_2  
  I found the my.ini file in UniserverZ  
  I searched google to look for the same problem but it told me to find my.cnf file to edit the thread\_stack, I was in frustration last night for unable to find one.  
    
    
  [![enter image description here](https://i.sstatic.net/w16gg.png)](https://i.sstatic.net/w16gg.png)
  
  > **Comments:**
  > **username_2**: Great! Good googling.  
  
  ---
  
  