Copy StacktraceSearch StackoverflowSearch GoogleException
Integrity constraint violation – yii\db\IntegrityException
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'TestUser678@coinsence.org' for key 'unique_email'
The SQL being executed was: INSERT INTO user (email, username, tags, guid, language, auth_mode, visibility, status, time_zone, created_at, created_by, updated_at, updated_by) VALUES ('TestUser678@coinsence.org', 'TestUser678', 'Entrepreneur', 'ca3df7dc-be23-400f-92d8-30787eed8166', 'en_gb', 'local', 2, 1, 'Europe/Berlin', NOW(), NULL, NOW(), NULL)
Error Info: Array
(
[0] => 23000
[1] => 1062
[2] => Duplicate entry 'TestUser678@coinsence.org' for key 'unique_email'
)
↵
Caused by: PDOException
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'TestUser678@coinsence.org' for key 'unique_email'
in /var/www/coinsence/protected/vendor/yiisoft/yii2/db/Command.php at line 1258
in /var/www/coinsence/protected/vendor/yiisoft/yii2/db/Schema.phpat line 664
655656657658659660661662663664665666667668669670671672673
$exceptionClass = '\yii\db\Exception';
foreach ($this->exceptionMap as $error => $class) {
if (strpos($e->getMessage(), $error) !== false) {
$exceptionClass = $class;
}
}
$message = $e->getMessage() . "\nThe SQL being executed was: $rawSql";
$errorInfo = $e instanceof \PDOException ? $e->errorInfo : null;
return new $exceptionClass($message, $errorInfo, (int) $e->getCode(), $e);
}
/**
Returns a value indicating whether a SQL statement is for read purpose.
@param string $sql the SQL statement
@return bool whether a SQL statement is for read purpose.
*/
public function isReadQuery($sql)
{
in /var/www/coinsence/protected/vendor/yiisoft/yii2/db/Command.php at line 1263– yii\db\Schema::convertException(PDOException, 'INSERT INTO user (email, `us...')
in /var/www/coinsence/protected/vendor/yiisoft/yii2/db/Command.php at line 1075– yii\db\Command::internalExecute('INSERT INTO user (email, `us...')
in /var/www/coinsence/protected/vendor/yiisoft/yii2/db/Schema.php at line 433– yii\db\Command::execute()
in /var/www/coinsence/protected/vendor/yiisoft/yii2/db/ActiveRecord.php at line 544– yii\db\Schema::insert('user', ['email' => 'TestUser678@coinsence.org', 'username' => 'TestUser678', 'tags' => 'Entrepreneur', 'guid' => 'ca3df7dc-be23-400f-92d8-30787eed...', ...])
in /var/www/coinsence/protected/vendor/yiisoft/yii2/db/ActiveRecord.php at line 510– yii\db\ActiveRecord::insertInternal(null)
in /var/www/coinsence/protected/vendor/yiisoft/yii2/db/BaseActiveRecord.php at line 670– yii\db\ActiveRecord::insert(true, null)
in /var/www/coinsence/protected/humhub/modules/user/models/forms/Registration.php at line 283– yii\db\BaseActiveRecord::save()
277278279280281282283284285286287288289 $this->models['User']->language = Yii::$app->language;
if ($this->enableUserApproval) {
$this->models['User']->status = User::STATUS_NEED_APPROVAL;
$this->models['User']->registrationGroupId = $this->models['GroupUser']->group_id;
}
if ($this->models['User']->save()) {
// Save User Profile
$this->models['Profile']->user_id = $this->models['User']->id;
$this->models['Profile']->save();
$this->models['User']->populateRelation('profile', $this->models['Profile']);
in /var/www/coinsence/protected/humhub/modules/user/controllers/RegistrationController.php at line 80– humhub\modules\user\models\forms\Registration::register(null)
74757677787980818283848586 $this->handleAuthClientRegistration($authClient, $registration);
} else {
Yii::$app->session->setFlash('error', 'Registration failed.');
return $this->redirect(['/user/auth/login']);
}
if ($registration->submitted('save') && $registration->validate() && $registration->register($authClient)) {
Yii::$app->session->remove('authClient');
if ($userInvite) {
if ($space = $userInvite->getSpace()->one()) {
MemberEvent::trigger(Membership::class, Membership::EVENT_MEMBER_ADDED, new MemberEvent([
'space' => $space, 'user' => User::findOne(['email' => $registration->getUser()->email])
humhub\modules\user\controllers\RegistrationController::actionIndex()
in /var/www/coinsence/protected/vendor/yiisoft/yii2/base/InlineAction.php at line 57– call_user_func_array([humhub\modules\user\controllers\RegistrationController, 'actionIndex'], [])
in /var/www/coinsence/protected/vendor/yiisoft/yii2/base/Controller.php at line 157– yii\base\InlineAction::runWithParams(['token' => 'knDInvVZU-tS'])
in /var/www/coinsence/protected/vendor/yiisoft/yii2/base/Module.php at line 528– yii\base\Controller::runAction('', ['token' => 'knDInvVZU-tS'])
in /var/www/coinsence/protected/vendor/yiisoft/yii2/web/Application.php at line 103– yii\base\Module::runAction('user/registration', ['token' => 'knDInvVZU-tS'])
in /var/www/coinsence/protected/vendor/yiisoft/yii2/base/Application.php at line 386– yii\web\Application::handleRequest(humhub\components\Request)
in /var/www/coinsence/index.php at line 31– yii\base\Application::run()
25262728293031 (is_readable(DIR . '/protected/config/web.php')) ? require(DIR . '/protected/config/web.php') : []
);
$dotenv = new Dotenv();
$dotenv->load(DIR.'/.env');
(new humhub\components\Application($config))->run();
I got this error message (Did not add country name) Probably i user registration link twice
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'TestUser678@coinsence.org' for key 'unique_email' in /var/www/coinsence/protected/vendor/yiisoft/yii2/db/Command.php:1258 Stack trace:
0 /var/www/coinsence/protected/vendor/yiisoft/yii2/db/Command.php(1258): PDOStatement->execute()
1 /var/www/coinsence/protected/vendor/yiisoft/yii2/db/Command.php(1075): yii\db\Command->internalExecute('INSERT INTO `us...')
2 /var/www/coinsence/protected/vendor/yiisoft/yii2/db/Schema.php(433): yii\db\Command->execute()
3 /var/www/coinsence/protected/vendor/yiisoft/yii2/db/ActiveRecord.php(544): yii\db\Schema->insert('user', Array)
4 /var/www/coinsence/protected/vendor/yiisoft/yii2/db/ActiveRecord.php(510): yii\db\ActiveRecord->insertInternal(NULL)
5 /var/www/coinsence/protected/vendor/yiisoft/yii2/db/BaseActiveRecord.php(670): yii\db\ActiveRecord->insert(true, NULL)
6 /var/www/coinsence/protected/humhub/modules/user/models/forms/Registration.php(283): yii\db\BaseActiveRecord->save()
7 /var/www/coinsence/protected/humhub/modules/user/controllers/RegistrationController.php(80): humhub\modules\user\models\forms\Registration->register(NULL)
8 [internal function]: humhub\modules\user\controllers\RegistrationController->actionIndex()
9 /var/www/coinsence/protected/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
10 /var/www/coinsence/protected/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
11 /var/www/coinsence/protected/vendor/yiisoft/yii2/base/Module.php(528): yii\base\Controller->runAction('', Array)
12 /var/www/coinsence/protected/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction('user/registrati...', Array)
13 /var/www/coinsence/protected/vendor/yiisoft/yii2/base/Application.php(386): yii\web\Application->handleRequest(Object(humhub\components\Request))
14 /var/www/coinsence/index.php(31): yii\base\Application->run()
15 {main}
Next yii\db\IntegrityException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'TestUser678@coinsence.org' for key 'unique_email' The SQL being executed was: INSERT INTO user (email, username, tags, guid, language, auth_mode, visibility, status, time_zone, created_at, created_by, updated_at, updated_by) VALUES ('TestUser678@coinsence.org', 'TestUser678', 'Entrepreneur', 'ca3df7dc-be23-400f-92d8-30787eed8166', 'en_gb', 'local', 2, 1, 'Europe/Berlin', NOW(), NULL, NOW(), NULL) in /var/www/coinsence/protected/vendor/yiisoft/yii2/db/Schema.php:664 Stack trace:
0 /var/www/coinsence/protected/vendor/yiisoft/yii2/db/Command.php(1263): yii\db\Schema->convertException(Object(PDOException), 'INSERT INTO us...') #1 /var/www/coinsence/protected/vendor/yiisoft/yii2/db/Command.php(1075): yii\db\Command->internalExecute('INSERT INTO us...')
2 /var/www/coinsence/protected/vendor/yiisoft/yii2/db/Schema.php(433): yii\db\Command->execute()
3 /var/www/coinsence/protected/vendor/yiisoft/yii2/db/ActiveRecord.php(544): yii\db\Schema->insert('user', Array)
4 /var/www/coinsence/protected/vendor/yiisoft/yii2/db/ActiveRecord.php(510): yii\db\ActiveRecord->insertInternal(NULL)
5 /var/www/coinsence/protected/vendor/yiisoft/yii2/db/BaseActiveRecord.php(670): yii\db\ActiveRecord->insert(true, NULL)
6 /var/www/coinsence/protected/humhub/modules/user/models/forms/Registration.php(283): yii\db\BaseActiveRecord->save()
7 /var/www/coinsence/protected/humhub/modules/user/controllers/RegistrationController.php(80): humhub\modules\user\models\forms\Registration->register(NULL)
8 [internal function]: humhub\modules\user\controllers\RegistrationController->actionIndex()
9 /var/www/coinsence/protected/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
10 /var/www/coinsence/protected/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
11 /var/www/coinsence/protected/vendor/yiisoft/yii2/base/Module.php(528): yii\base\Controller->runAction('', Array)
12 /var/www/coinsence/protected/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction('user/registrati...', Array)
13 /var/www/coinsence/protected/vendor/yiisoft/yii2/base/Application.php(386): yii\web\Application->handleRequest(Object(humhub\components\Request))
14 /var/www/coinsence/index.php(31): yii\base\Application->run()
15 {main}
Additional Information: Array ( [0] => 23000 [1] => 1062 [2] => Duplicate entry 'TestUser678@coinsence.org' for key 'unique_email' )
Copy StacktraceSearch StackoverflowSearch GoogleException Integrity constraint violation – yii\db\IntegrityException SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'TestUser678@coinsence.org' for key 'unique_email' The SQL being executed was: INSERT INTO user (email, username, tags, guid, language, auth_mode, visibility, status, time_zone, created_at, created_by, updated_at, updated_by) VALUES ('TestUser678@coinsence.org', 'TestUser678', 'Entrepreneur', 'ca3df7dc-be23-400f-92d8-30787eed8166', 'en_gb', 'local', 2, 1, 'Europe/Berlin', NOW(), NULL, NOW(), NULL) Error Info: Array ( [0] => 23000 [1] => 1062 [2] => Duplicate entry 'TestUser678@coinsence.org' for key 'unique_email' ) ↵ Caused by: PDOException SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'TestUser678@coinsence.org' for key 'unique_email' in /var/www/coinsence/protected/vendor/yiisoft/yii2/db/Command.php at line 1258
$dotenv = new Dotenv(); $dotenv->load(DIR.'/.env');
(new humhub\components\Application($config))->run();
$_GET = [ 'token' => 'knDInvVZU-tS', ];
$_POST = [ '_csrf' => 'gn6O9KjbAxqvCORiBvT8_xAM9_a9hau53ZdEaROgxHntL8yuwJFnTZ9Dly5zrsi-XXiRxPDT-_WY8D49ZviCPQ==', 'User' => [ 'username' => 'TestUser678', 'tags' => [ 'Entrepreneur', ], ], 'GroupUser' => [ 'group_id' => '2', ], 'Password' => [ 'newPassword' => 'TestUser678', 'newPasswordConfirm' => 'TestUser678', ], 'Profile' => [ 'firstname' => 'Test', 'lastname' => 'User6', 'country' => '', ], 'RegistrationChecks' => [ 'termsCheck' => '1', 'dataPrivacyCheck' => '1', ], 'save' => '', ];
$_COOKIE = [ 'language' => 'e9480a16dca13979f7616ad115e289c06b7301df3d6f05c849097c10e7fadd84a:2:{i:0;s:8:"language";i:1;s:5:"en_gb";}', '_ga' => 'GA1.2.275330535.1620141749', '_csrf' => 'cdefaa173f62d432d7d3de24018029f512ffa3e69190e3f46e6edb1725398521a:2:{i:0;s:5:"_csrf";i:1;s:32:"oQBZhJdW0KsLuZ4AMtf2MVPLEgzTuXFD";}', 'PHPSESSID' => '7haplg91v44i0339m6rgvbldbq', 'pm_new-people-panel' => 'expanded', 'pm_new-spaces-panel' => 'expanded', ];
$_SESSION = [ 'flash' => [], 'returnUrl' => '/p/ibb-login-redirect', ]; Yii Framework 2021-09-07, 17:21:53
Apache/2.4.29 (Ubuntu)
Yii Framework/2.0.15
Hidden Gallery ‹ › × × Add image/file Upload
Close × Add link Title Title of your link Target Enter a url (e.g. http://example.com) Close Add link