CiviCRM Community Forums (archive)

Hi,

I've just upgraded our site from CiviCRM 3.4.x to 4.5.2. I've left it until now because every time I tried it before, the db migration scripts failed, and it's taken me hours to get it finally working. At least I thought it was working, but whenever a new person registers and wants to have a WordPress Account it falls over with the following error:

#0 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(191): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/packages/DB.php(975): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...")
#4 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...")
#5 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...", "DB_Error", TRUE)
#6 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(899): DB_common->raiseError(-1, NULL, NULL, NULL, "1436 ** Thread stack overrun:  7344 bytes used of a 131072 byte stack, and 12...")
#7 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
#8 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...")
#9 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2442): DB_common->query("INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...")
#10 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1060): DB_DataObject->_query("INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , di...")
#11 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(455): DB_DataObject->insert()
#12 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Contact.php(228): CRM_Core_DAO->save()
#13 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Contact.php(320): CRM_Contact_BAO_Contact::add((Array:10))
#14 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Contact.php(1849): CRM_Contact_BAO_Contact::create((Array:10))
#15 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/UFMatch.php(307): CRM_Contact_BAO_Contact::createProfileContact((Array:4), (Array:0))
#16 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/UFMatch.php(124): CRM_Core_BAO_UFMatch::synchronizeUFMatch(Object(WP_User), 2, "bla@mysite.com", "WordPress", NULL, "Individual", FALSE)
#17 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm.php(398): CRM_Core_BAO_UFMatch::synchronize(Object(WP_User), FALSE, "WordPress", "Individual")
#18 /var/www/vhosts/<mysite>/httpdocs/wp-content/plugins/civicrm/civicrm.php(455): CiviCRM_For_WordPress->initialize()
#19 [internal function](): CiviCRM_For_WordPress->invoke("")
#20 /var/www/vhosts/<mysite>/httpdocs/wp-includes/plugin.php(505): call_user_func_array((Array:2), (Array:1))
#21 /var/www/vhosts/<mysite>/httpdocs/wp-admin/admin.php(212): do_action("toplevel_page_CiviCRM")
#22 {main}

Looking at the logs, I find the problem SQL is
INSERT INTO civicrm_contact (contact_type , contact_sub_type , sort_name , display_name , preferred_language , hash , first_name , last_name , email_greeting_id , postal_greeting_id , addressee_id ) VALUES ('Individual' ,  NULL , 'Last, First' , 'First Last' , 'en_US' , '0d0b1439e15a0311e0ae3cf7abc2593c' , 'First' , 'Last' ,  1 ,  1 ,  1 )

If I run this in phpMyAdmin I get #1436 - Thread stack overrun: 7344 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.
Unfortunately I don't have the ability to specify a bigger stack, but anyway I don't think that's the real issue.

I'm currently stuck with a broken site, can anyone help?

Thanks
Denis