Mryntu

How can a new country break out from a developed country without war?

How to preserve electronics (computers, ipads, phones) for hundreds of years?

Would a primitive species be able to learn English from reading books alone?

When is the exact date for EOL of Ubuntu 14.04 LTS?

Should I warn a new PhD Student?

How do I lift the insulation blower into the attic?

"Oh no!" in Latin

Is there a POSIX way to shutdown a UNIX machine?

Did I make a mistake by ccing email to boss to others?

Error in master's thesis, I do not know what to do

Started in 1987 vs. Starting in 1987

Why is implicit conversion not ambiguous for non-primitive types?

Are hand made posters acceptable in Academia?

Trouble reading roman numeral notation with flats

Checking @@ROWCOUNT failing

Should a narrator ever describe things based on a character's view instead of facts?

What should be the ideal length of sentences in a blog post for ease of reading?

Reasons for having MCU pin-states default to pull-up/down out of reset

What is it called when someone votes for an option that's not their first choice?

Why does the frost depth increase when the surface temperature warms up?

Why can't I get pgrep output right to variable on bash script?

Air travel with refrigerated insulin

Why didn’t Eve recognize the little cockroach as a living organism?

Why do Radio Buttons not fill the entire outer circle?

Magento 2 Admin login Problem

Magento 2 Admin Login ErrorMagento2 admin after login redirect back to admin login?Imported products show up in backend but not on front endMagento 2 - Adding 2 (or more) configurable products to cart with custom options causes Integrity constraint violationMagento 2 Insert data to table that contain foreign key error SQLSTATE[23000]: Integrity constraint violationIntegrity constraint violation error when saving product (google experiments on)Magento 2: Creating product with custom OptionsMagento v2.1.7 admin login errorData Migration From Magento 1.9.1 to 2.1.9Random integrity constraint errors saving orders in Magento 2.1 after payment

3

I am able to login to the admin control panel the first time and when I logout and login again it get this message:

There has been an error processing your request
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY', query was: INSERT INTO `admin_user_session` (`session_id`, `user_id`, `status`, `ip`) VALUES (?, ?, ?, ?)

But this works again when I get the empty ADMIN_USER_SESSION table in PHPMyAdmin.

magento-2.1

share|improve this question

edited 13 mins ago

Teja Bhagavan Kollepara

3,00641949

asked Dec 5 '17 at 0:06

VenkateshaVenkatesha

545

add a comment | 

3

I am able to login to the admin control panel the first time and when I logout and login again it get this message:

There has been an error processing your request
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY', query was: INSERT INTO `admin_user_session` (`session_id`, `user_id`, `status`, `ip`) VALUES (?, ?, ?, ?)

But this works again when I get the empty ADMIN_USER_SESSION table in PHPMyAdmin.

magento-2.1

share|improve this question

edited 13 mins ago

Teja Bhagavan Kollepara

3,00641949

asked Dec 5 '17 at 0:06

VenkateshaVenkatesha

545

add a comment | 

I am able to login to the admin control panel the first time and when I logout and login again it get this message:

There has been an error processing your request
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY', query was: INSERT INTO `admin_user_session` (`session_id`, `user_id`, `status`, `ip`) VALUES (?, ?, ?, ?)

But this works again when I get the empty ADMIN_USER_SESSION table in PHPMyAdmin.

magento-2.1

share|improve this question

edited 13 mins ago

Teja Bhagavan Kollepara

3,00641949

asked Dec 5 '17 at 0:06

VenkateshaVenkatesha

545

share|improve this question

edited 13 mins ago

Teja Bhagavan Kollepara

3,00641949

asked Dec 5 '17 at 0:06

VenkateshaVenkatesha

545

share|improve this question

edited 13 mins ago

Teja Bhagavan Kollepara

3,00641949

asked Dec 5 '17 at 0:06

VenkateshaVenkatesha

545

edited 13 mins ago

Teja Bhagavan Kollepara

3,00641949

edited 13 mins ago

Teja Bhagavan Kollepara

3,00641949

asked Dec 5 '17 at 0:06

VenkateshaVenkatesha

545

asked Dec 5 '17 at 0:06

VenkateshaVenkatesha

545

3 Answers
3

active

oldest

votes

0

MAKE SURE YOU HAVE A DB BACKUP

You can verify that your admin_user_session table has the primary key set to auto-increment with this query:

SELECT `AUTO_INCREMENT` FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA 'magento_db' AND TABLE_NAME = 'admin_user_session';

If you see that auto-increment is turned off, then you can fix it with this query:

ALTER TABLE 'admin_user_session' MODIFY COLUMN 'session_id' INT NOT NULL AUTO_INCREMENT;

However, if you need to do that, that is a good indication that either your DB import failed or you have some custom functionality with admin sessions that is blocking the auto-increment functionality.

share|improve this answer

answered Dec 5 '17 at 0:53

HaydenFromITHaydenFromIT

362

add a comment | 

0

Run below query your issue get resolved.

ALTER TABLE `admin_user_session` MODIFY COLUMN 'session_id' INT AUTO_INCREMENT;

share|improve this answer

answered Sep 19 '18 at 14:02

Prashant ValandaPrashant Valanda

9,82412355

add a comment | 

0

CODE USED:

SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA 'magento_db' AND TABLE_NAME = 'admin_user_session' LIMIT 0, 25
MySQL said: Documentation

ERROR CODE:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''magento_db' AND TABLE_NAME = 'admin_user_session' LIMIT 0, 25' at line 1

---

And when i tried to ALTER:

---

CODE USED:
ALTER TABLE 'admin_user_session' MODIFY COLUMN 'session_id' INT NOT NULL AUTO_INCREMENT;

ERROR CODE:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''admin_user_session' MODIFY COLUMN 'session_id' INT NOT NULL AUTO_INCREMENT' at line 1

share|improve this answer

edited 14 mins ago

Teja Bhagavan Kollepara

3,00641949

answered Dec 7 '17 at 5:31

VenkateshaVenkatesha

545

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f204412%2fmagento-2-admin-login-problem%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

MAKE SURE YOU HAVE A DB BACKUP

You can verify that your admin_user_session table has the primary key set to auto-increment with this query:

SELECT `AUTO_INCREMENT` FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA 'magento_db' AND TABLE_NAME = 'admin_user_session';

If you see that auto-increment is turned off, then you can fix it with this query:

ALTER TABLE 'admin_user_session' MODIFY COLUMN 'session_id' INT NOT NULL AUTO_INCREMENT;

However, if you need to do that, that is a good indication that either your DB import failed or you have some custom functionality with admin sessions that is blocking the auto-increment functionality.

share|improve this answer

answered Dec 5 '17 at 0:53

HaydenFromITHaydenFromIT

362

add a comment | 

0

MAKE SURE YOU HAVE A DB BACKUP

You can verify that your admin_user_session table has the primary key set to auto-increment with this query:

SELECT `AUTO_INCREMENT` FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA 'magento_db' AND TABLE_NAME = 'admin_user_session';

If you see that auto-increment is turned off, then you can fix it with this query:

ALTER TABLE 'admin_user_session' MODIFY COLUMN 'session_id' INT NOT NULL AUTO_INCREMENT;

However, if you need to do that, that is a good indication that either your DB import failed or you have some custom functionality with admin sessions that is blocking the auto-increment functionality.

share|improve this answer

answered Dec 5 '17 at 0:53

HaydenFromITHaydenFromIT

362

add a comment | 

MAKE SURE YOU HAVE A DB BACKUP

You can verify that your admin_user_session table has the primary key set to auto-increment with this query:

SELECT `AUTO_INCREMENT` FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA 'magento_db' AND TABLE_NAME = 'admin_user_session';

If you see that auto-increment is turned off, then you can fix it with this query:

ALTER TABLE 'admin_user_session' MODIFY COLUMN 'session_id' INT NOT NULL AUTO_INCREMENT;

However, if you need to do that, that is a good indication that either your DB import failed or you have some custom functionality with admin sessions that is blocking the auto-increment functionality.

share|improve this answer

answered Dec 5 '17 at 0:53

HaydenFromITHaydenFromIT

362

SELECT `AUTO_INCREMENT` FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA 'magento_db' AND TABLE_NAME = 'admin_user_session';

ALTER TABLE 'admin_user_session' MODIFY COLUMN 'session_id' INT NOT NULL AUTO_INCREMENT;

share|improve this answer

answered Dec 5 '17 at 0:53

HaydenFromITHaydenFromIT

362

answered Dec 5 '17 at 0:53

HaydenFromITHaydenFromIT

362

answered Dec 5 '17 at 0:53

HaydenFromITHaydenFromIT

362

0

Run below query your issue get resolved.

ALTER TABLE `admin_user_session` MODIFY COLUMN 'session_id' INT AUTO_INCREMENT;

share|improve this answer

answered Sep 19 '18 at 14:02

Prashant ValandaPrashant Valanda

9,82412355

add a comment | 

0

Run below query your issue get resolved.

ALTER TABLE `admin_user_session` MODIFY COLUMN 'session_id' INT AUTO_INCREMENT;

share|improve this answer

answered Sep 19 '18 at 14:02

Prashant ValandaPrashant Valanda

9,82412355

add a comment | 

Run below query your issue get resolved.

ALTER TABLE `admin_user_session` MODIFY COLUMN 'session_id' INT AUTO_INCREMENT;

share|improve this answer

answered Sep 19 '18 at 14:02

Prashant ValandaPrashant Valanda

9,82412355

ALTER TABLE `admin_user_session` MODIFY COLUMN 'session_id' INT AUTO_INCREMENT;

share|improve this answer

answered Sep 19 '18 at 14:02

Prashant ValandaPrashant Valanda

9,82412355

answered Sep 19 '18 at 14:02

Prashant ValandaPrashant Valanda

9,82412355

answered Sep 19 '18 at 14:02

Prashant ValandaPrashant Valanda

9,82412355

0

CODE USED:

SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA 'magento_db' AND TABLE_NAME = 'admin_user_session' LIMIT 0, 25
MySQL said: Documentation

ERROR CODE:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''magento_db' AND TABLE_NAME = 'admin_user_session' LIMIT 0, 25' at line 1

---

And when i tried to ALTER:

---

CODE USED:
ALTER TABLE 'admin_user_session' MODIFY COLUMN 'session_id' INT NOT NULL AUTO_INCREMENT;

ERROR CODE:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''admin_user_session' MODIFY COLUMN 'session_id' INT NOT NULL AUTO_INCREMENT' at line 1

share|improve this answer

edited 14 mins ago

Teja Bhagavan Kollepara

3,00641949

answered Dec 7 '17 at 5:31

VenkateshaVenkatesha

545

add a comment | 

0

CODE USED:

SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA 'magento_db' AND TABLE_NAME = 'admin_user_session' LIMIT 0, 25
MySQL said: Documentation

ERROR CODE:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''magento_db' AND TABLE_NAME = 'admin_user_session' LIMIT 0, 25' at line 1

---

And when i tried to ALTER:

---

CODE USED:
ALTER TABLE 'admin_user_session' MODIFY COLUMN 'session_id' INT NOT NULL AUTO_INCREMENT;

ERROR CODE:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''admin_user_session' MODIFY COLUMN 'session_id' INT NOT NULL AUTO_INCREMENT' at line 1

share|improve this answer

edited 14 mins ago

Teja Bhagavan Kollepara

3,00641949

answered Dec 7 '17 at 5:31

VenkateshaVenkatesha

545

add a comment | 

CODE USED:

SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA 'magento_db' AND TABLE_NAME = 'admin_user_session' LIMIT 0, 25
MySQL said: Documentation

ERROR CODE:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''magento_db' AND TABLE_NAME = 'admin_user_session' LIMIT 0, 25' at line 1

---

And when i tried to ALTER:

---

CODE USED:
ALTER TABLE 'admin_user_session' MODIFY COLUMN 'session_id' INT NOT NULL AUTO_INCREMENT;

ERROR CODE:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''admin_user_session' MODIFY COLUMN 'session_id' INT NOT NULL AUTO_INCREMENT' at line 1

share|improve this answer

edited 14 mins ago

Teja Bhagavan Kollepara

3,00641949

answered Dec 7 '17 at 5:31

VenkateshaVenkatesha

545

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''magento_db' AND TABLE_NAME = 'admin_user_session' LIMIT 0, 25' at line 1

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''admin_user_session' MODIFY COLUMN 'session_id' INT NOT NULL AUTO_INCREMENT' at line 1

share|improve this answer

edited 14 mins ago

Teja Bhagavan Kollepara

3,00641949

answered Dec 7 '17 at 5:31

VenkateshaVenkatesha

545

edited 14 mins ago

Teja Bhagavan Kollepara

3,00641949

edited 14 mins ago

Teja Bhagavan Kollepara

3,00641949

answered Dec 7 '17 at 5:31

VenkateshaVenkatesha

545

answered Dec 7 '17 at 5:31

VenkateshaVenkatesha

545