0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

PHPのログイン機能に関するDBエラー

Last updated at Posted at 2020-10-14

エラー名
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'aaa@fff.com' for key 'email' in (略...) Stack trace: #0 (パス...): PDOStatement->execute(Array) 以下略...

・エラー出現
新規登録を押してユーザー登録が成功したが、もう1度更新すると上記エラーが出た。

・なぜ出たか?
1度データベースにnameやらemailやらpassやら入れたのに、再度同じ情報(名前もidもpassも)で更新したから。

・MAMP使いました。
8EAD5073-F7B7-4E40-B417-16B5E93D8804_4_5005_c.jpeg

結論
気にしないことにしました。

(初投稿...)

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?