Hello,
I have just installed the advanced template, used the singup field ok for the first user but then when I try to add a second user I get this error, I cannot work out why you would get a duplicate on the id which is set to INT(11)
Here is the error. thank you:
`
Integrity constraint violation – yii\db\IntegrityException
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
The SQL being executed was: INSERT INTO `user` (`username`, `email`, `password_hash`, `auth_key`, `status_id`, `role_id`, `user_type_id`, `created_at`, `updated_at`) VALUES ('benoit3', '44321321@hotmail.com', '$2y$13$qRpSesNVYwuY1PUDFMu1v.5d9CcA.cRjlTefTGosoiFOPncjxn/4C', 'PtxahtBvxaTQEJZBVoe8tbb0NG5siYXF', 10, 10, 10, NOW(), NOW())
Error Info: Array
(
[0] => 23000
[1] => 1062
[2] => Duplicate entry '0' for key 'PRIMARY'
)
↵
Caused by: PDOException
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
in C:\xampp\htdocs\yii2build\vendor\yiisoft\yii2\db\Command.php at line 768
1. in C:\xampp\htdocs\yii2build\vendor\yiisoft\yii2\db\Schema.php at line 532
523524525526527528529530531532533534535536537538539540541
$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 boolean whether a SQL statement is for read purpose.
*/
public function isReadQuery($sql)
{
2. in C:\xampp\htdocs\yii2build\vendor\yiisoft\yii2\db\Command.php – yii\db\Schema::convertException(PDOException, 'INSERT INTO `user` (`username`, ...') at line 776
3. in C:\xampp\htdocs\yii2build\vendor\yiisoft\yii2\db\ActiveRecord.php – yii\db\Command::execute() at line 452
4. in C:\xampp\htdocs\yii2build\vendor\yiisoft\yii2\db\ActiveRecord.php – yii\db\ActiveRecord::insertInternal(null) at line 427
5. in C:\xampp\htdocs\yii2build\vendor\yiisoft\yii2\db\BaseActiveRecord.php – yii\db\ActiveRecord::insert(true, null) at line 582
6. in C:\xampp\htdocs\yii2build\frontend\models\SignupForm.php – yii\db\BaseActiveRecord::save() at line 51
45464748495051525354555657 if ($this->validate()) {
$user = new User();
$user->username = $this->username;
$user->email = $this->email;
$user->setPassword($this->password);
$user->generateAuthKey();
$user->save();
return $user;
}
return null;
}
}
7. in C:\xampp\htdocs\yii2build\frontend\controllers\SiteController.php – frontend\models\SignupForm::signup() at line 123
117118119120121122123124125126127128129 }
public function actionSignup()
{
$model = new SignupForm();
if ($model->load(Yii::$app->request->post())) {
if ($user = $model->signup()) {
if (Yii::$app->getUser()->login($user)) {
return $this->goHome();
}
}
}
8. frontend\controllers\SiteController::actionSignup()
9. in C:\xampp\htdocs\yii2build\vendor\yiisoft\yii2\base\InlineAction.php – call_user_func_array([frontend\controllers\SiteController, 'actionSignup'], []) at line 55
10. in C:\xampp\htdocs\yii2build\vendor\yiisoft\yii2\base\Controller.php – yii\base\InlineAction::runWithParams(['r' => 'site/signup']) at line 151
145146147148149150151152153154155156157 }
$result = null;
if ($runAction && $this->beforeAction($action)) {
// run the action
$result = $action->runWithParams($params);
$result = $this->afterAction($action, $result);
// call afterAction on modules
foreach ($modules as $module) {
/* @var $module Module */
11. in C:\xampp\htdocs\yii2build\vendor\yiisoft\yii2\base\Module.php – yii\base\Controller::runAction('signup', ['r' => 'site/signup']) at line 455
12. in C:\xampp\htdocs\yii2build\vendor\yiisoft\yii2\web\Application.php – yii\base\Module::runAction('site/signup', ['r' => 'site/signup']) at line 83
13. in C:\xampp\htdocs\yii2build\vendor\yiisoft\yii2\base\Application.php – yii\web\Application::handleRequest(yii\web\Request) at line 375
14. in C:\xampp\htdocs\yii2build\frontend\web\index.php – yii\base\Application::run() at line 18
12131415161718 require(__DIR__ . '/../../common/config/main-local.php'),
require(__DIR__ . '/../config/main.php'),
require(__DIR__ . '/../config/main-local.php')
);
$application = new yii\web\Application($config);
$application->run();
$_GET = [
'r' => 'site/signup',
];
$_POST = [
'_csrf' => 'UWppTHNBLVUbPQguIRkaHBUAACheOBk.GCkKCiY0WAIDBSsKCwh1Ag==',
'SignupForm' => [
'username' => 'benoit3',
'email' => '44321321@hotmail.com',
'password' => '123456789',
],
'signup-button' => '',
];
$_SERVER = [
'MIBDIRS' => 'C:/xampp/php/extras/mibs',
'MYSQL_HOME' => '\\xampp\\mysql\\bin',
'OPENSSL_CONF' => 'C:/xampp/apache/bin/openssl.cnf',
'PHP_PEAR_SYSCONF_DIR' => '\\xampp\\php',
'PHPRC' => '\\xampp\\php',
'TMP' => '\\xampp\\tmp',
'HTTP_HOST' => 'yii2build.com',
'HTTP_CONNECTION' => 'keep-alive',
'CONTENT_LENGTH' => '194',
'HTTP_CACHE_CONTROL' => 'max-age=0',
'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8',
'HTTP_ORIGIN' => 'http://yii2build.com',
'HTTP_USER_AGENT' => 'Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36',
'CONTENT_TYPE' => 'application/x-www-form-urlencoded',
'HTTP_REFERER' => 'http://yii2build.com/index.php?r=site%2Fsignup',
'HTTP_ACCEPT_ENCODING' => 'gzip, deflate',
'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.8',
'HTTP_COOKIE' => '_csrf=21e5fd76b7cd07b5aad452b30119e8e69003883a2e257ec2e7266f85e2b58839s%3A32%3A%22JWabRX7IDjid-y4kICcFUuuWRoBFxIXW%22%3B; PHPSESSID=17515dp4026qav907u621mpif0',
'PATH' => 'C:\\ProgramData\\Oracle\\Java\\javapath;C:\\Program Files (x86)\\Intel\\iCLS Client\\;C:\\Program Files\\Intel\\iCLS Client\\;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem;C:\\WINDOWS\\System32\\WindowsPowerShell\\v1.0\\;C:\\Program Files (x86)\\Intel\\OpenCL SDK\\2.0\\bin\\x86;C:\\Program Files (x86)\\Intel\\OpenCL SDK\\2.0\\bin\\x64;C:\\Program Files\\Intel\\Intel(R) Management Engine Components\\DAL;C:\\Program Files\\Intel\\Intel(R) Management Engine Components\\IPT;C:\\Program Files (x86)\\Intel\\Intel(R) Management Engine Components\\DAL;C:\\Program Files (x86)\\Intel\\Intel(R) Management Engine Components\\IPT;C:\\Program Files (x86)\\Windows Kits\\8.0\\Windows Performance Toolkit\\;C:\\xampp\\php;C:\\ProgramData\\ComposerSetup\\bin',
'SystemRoot' => 'C:\\WINDOWS',
'COMSPEC' => 'C:\\WINDOWS\\system32\\cmd.exe',
'PATHEXT' => '.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC',
'WINDIR' => 'C:\\WINDOWS',
'SERVER_SIGNATURE' => '
Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.6.3 Server at yii2build.com Port 80
',
'SERVER_SOFTWARE' => 'Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.6.3',
'SERVER_NAME' => 'yii2build.com',
'SERVER_ADDR' => '127.0.0.1',
'SERVER_PORT' => '80',
'REMOTE_ADDR' => '127.0.0.1',
'DOCUMENT_ROOT' => 'C:/xampp/htdocs/yii2build/frontend/web',
'REQUEST_SCHEME' => 'http',
'CONTEXT_PREFIX' => '',
'CONTEXT_DOCUMENT_ROOT' => 'C:/xampp/htdocs/yii2build/frontend/web',
'SERVER_ADMIN' => 'postmaster@localhost',
'SCRIPT_FILENAME' => 'C:/xampp/htdocs/yii2build/frontend/web/index.php',
'REMOTE_PORT' => '61011',
'GATEWAY_INTERFACE' => 'CGI/1.1',
'SERVER_PROTOCOL' => 'HTTP/1.1',
'REQUEST_METHOD' => 'POST',
'QUERY_STRING' => 'r=site%2Fsignup',
'REQUEST_URI' => '/index.php?r=site%2Fsignup',
'SCRIPT_NAME' => '/index.php',
'PHP_SELF' => '/index.php',
'REQUEST_TIME_FLOAT' => 1418855701.0959999561309814453125,
'REQUEST_TIME' => 1418855701,
];
$_COOKIE = [
'_csrf' => '21e5fd76b7cd07b5aad452b30119e8e69003883a2e257ec2e7266f85e2b58839s:32:"JWabRX7IDjid-y4kICcFUuuWRoBFxIXW";',
'PHPSESSID' => '17515dp4026qav907u621mpif0',
];
$_SESSION = [
'__flash' => [],
'__captcha/site/captcha' => 'wasuzli',
'__captcha/site/captchacount' => 1,
'__id' => null,
];
Yii Framework
2014-12-17, 23:35:02
Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.6.3
Yii Framework/2.0.0
Thanks!
Ben
