During any event registration while the user is not logged in (i.e., if they are a new user) produces the following error. After doing a bunch of research, the consensus seemed to be that the issue was fixed in an earlier version of CiviCRM. I upgraded Civi to the most recent version to no avail. Here are the following steps I have taken:
- Cleared Cache
- Disabled every extension
- Disabled any custom module using civicrm
- Upgraded CiviCRM to the most recent version
- Restarted the entire server, upgraded the server (Probably unnecessary but figured I would since I was already there).
It appears to work fine if the user is already logged in.
CiviCRM: 5.50.1
Drupal: 9.3.16
Ubuntu: 20.04
PHP: 7.4.30
Server version: Apache/2.4.54 (Ubuntu)
MariaDB: 10.3.34
[error] $Fatal Error Details = array:3 [ "message" => "DB Error: already exists" "code" => null "exception" => PEAR_Exception {#15678
#cause: DB_Error {#15680
+error_message_prefix: ""
+mode: 16
+level: 1024
+code: -5
+message: "DB Error: already exists"
+userinfo: "INSERT INTO `civicrm_uf_match` (`domain_id` , `uf_id` , `uf_name` , `contact_id` ) VALUES ( 1 , 1529 , '[email protected]' , 12102 ) [nativecode=1062 ** Duplicate entry '[email protected]' for key 'UI_uf_name_domain_id']"
+backtrace: array:41 [
0 => array:6 [
"file" => "/var/www/website.org/vendor/pear/db/DB.php"
"line" => 997
"function" => "__construct"
"class" => "PEAR_Error"
"type" => "->"
"args" => array:5 [
0 => "DB Error: already exists"
1 => -5
2 => 16
3 => array:2 [
0 => "CRM_Core_Error"
1 => "exceptionHandler"
]
4 => "INSERT INTO `civicrm_uf_match` (`domain_id` , `uf_id` , `uf_name` , `contact_id` ) VALUES ( 1 , 1529 , '[email protected]' , 12102 ) [nativecode=1062 ** Duplicate entry '[email protected]' for key 'UI_uf_name_domain_id']"
]
]
Any help would be greatly appreciated. Thank you!
EDIT: Still an issue.