Magento 2: Admin Customer Listing Not Displaying RecordAfter registering the customers in the admin is not...
How is it possible for user's password to be changed after storage was encrypted? (on OS X, Android)
When blogging recipes, how can I support both readers who want the narrative/journey and ones who want the printer-friendly recipe?
How to deal with fear of taking dependencies
Eliminate empty elements from a list with a specific pattern
What is the command to reset a PC without deleting any files
LWC and complex parameters
Finding files for which a command fails
How would photo IDs work for shapeshifters?
I see my dog run
Is every set a filtered colimit of finite sets?
What do you call words made from common English words?
How to move the player while also allowing forces to affect it
Piano - What is the notation for a double stop where both notes in the double stop are different lengths?
What is GPS' 19 year rollover and does it present a cybersecurity issue?
aging parents with no investments
Was there ever an axiom rendered a theorem?
Lied on resume at previous job
How to answer pointed "are you quitting" questioning when I don't want them to suspect
Re-submission of rejected manuscript without informing co-authors
What do the Banks children have against barley water?
Is it wise to focus on putting odd beats on left when playing double bass drums?
I’m planning on buying a laser printer but concerned about the life cycle of toner in the machine
extract characters between two commas?
What do you call something that goes against the spirit of the law, but is legal when interpreting the law to the letter?
Magento 2: Admin Customer Listing Not Displaying Record
After registering the customers in the admin is not visibleMagento 2: Not showing customers in backend gridAdmin Manage Customers - not showing Customer InformationHow do I connect to database from admin?Customer user group admin magentoevent for customer log record add afterMagento Customer Login and Account Creation content is not displayingAdmin customer set option_idCustomer Backend Fax option not displayingMagento 2: How to reset Per Page Record Show in AdminMagento 2 : Unable to View Customer's Listing Page in AdminMagento 2 admin auth panel not displaying
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I have an entry of 54K users in Customers. In Database customer_entity
table it's showing count.
It's working an hour before. Suddenly it's not displaying in Admin Customer Listing. Trying to search as well. Still not displaying record.
I have cleared cache as well. No errors in Log
What's the reason behind this issue or why it occurs? Because Magento behaves strangely.
magento2 admin customer
|
show 2 more comments
I have an entry of 54K users in Customers. In Database customer_entity
table it's showing count.
It's working an hour before. Suddenly it's not displaying in Admin Customer Listing. Trying to search as well. Still not displaying record.
I have cleared cache as well. No errors in Log
What's the reason behind this issue or why it occurs? Because Magento behaves strangely.
magento2 admin customer
Is there any customer fromcustomer_grid_flat
table?
– Khoa TruongDinh
Oct 21 '16 at 6:16
customer_grid_flat
table is Blank :( No records. It's 0
– Ankit Shah
Oct 21 '16 at 6:18
Tried to reindex database?
– Khoa TruongDinh
Oct 21 '16 at 6:18
Let me do thatstatic:content-deploy
is not going to affect right?
– Ankit Shah
Oct 21 '16 at 6:19
php bin/magento indexer:reindex
– Khoa TruongDinh
Oct 21 '16 at 6:20
|
show 2 more comments
I have an entry of 54K users in Customers. In Database customer_entity
table it's showing count.
It's working an hour before. Suddenly it's not displaying in Admin Customer Listing. Trying to search as well. Still not displaying record.
I have cleared cache as well. No errors in Log
What's the reason behind this issue or why it occurs? Because Magento behaves strangely.
magento2 admin customer
I have an entry of 54K users in Customers. In Database customer_entity
table it's showing count.
It's working an hour before. Suddenly it's not displaying in Admin Customer Listing. Trying to search as well. Still not displaying record.
I have cleared cache as well. No errors in Log
What's the reason behind this issue or why it occurs? Because Magento behaves strangely.
magento2 admin customer
magento2 admin customer
edited Oct 21 '16 at 7:16
Ankit Shah
asked Oct 21 '16 at 6:15
Ankit ShahAnkit Shah
4,976967144
4,976967144
Is there any customer fromcustomer_grid_flat
table?
– Khoa TruongDinh
Oct 21 '16 at 6:16
customer_grid_flat
table is Blank :( No records. It's 0
– Ankit Shah
Oct 21 '16 at 6:18
Tried to reindex database?
– Khoa TruongDinh
Oct 21 '16 at 6:18
Let me do thatstatic:content-deploy
is not going to affect right?
– Ankit Shah
Oct 21 '16 at 6:19
php bin/magento indexer:reindex
– Khoa TruongDinh
Oct 21 '16 at 6:20
|
show 2 more comments
Is there any customer fromcustomer_grid_flat
table?
– Khoa TruongDinh
Oct 21 '16 at 6:16
customer_grid_flat
table is Blank :( No records. It's 0
– Ankit Shah
Oct 21 '16 at 6:18
Tried to reindex database?
– Khoa TruongDinh
Oct 21 '16 at 6:18
Let me do thatstatic:content-deploy
is not going to affect right?
– Ankit Shah
Oct 21 '16 at 6:19
php bin/magento indexer:reindex
– Khoa TruongDinh
Oct 21 '16 at 6:20
Is there any customer from
customer_grid_flat
table?– Khoa TruongDinh
Oct 21 '16 at 6:16
Is there any customer from
customer_grid_flat
table?– Khoa TruongDinh
Oct 21 '16 at 6:16
customer_grid_flat
table is Blank :( No records. It's 0– Ankit Shah
Oct 21 '16 at 6:18
customer_grid_flat
table is Blank :( No records. It's 0– Ankit Shah
Oct 21 '16 at 6:18
Tried to reindex database?
– Khoa TruongDinh
Oct 21 '16 at 6:18
Tried to reindex database?
– Khoa TruongDinh
Oct 21 '16 at 6:18
Let me do that
static:content-deploy
is not going to affect right?– Ankit Shah
Oct 21 '16 at 6:19
Let me do that
static:content-deploy
is not going to affect right?– Ankit Shah
Oct 21 '16 at 6:19
php bin/magento indexer:reindex
– Khoa TruongDinh
Oct 21 '16 at 6:20
php bin/magento indexer:reindex
– Khoa TruongDinh
Oct 21 '16 at 6:20
|
show 2 more comments
2 Answers
2
active
oldest
votes
Reset your databse: Magento 2: Not showing customers in backend grid
update indexer_state set status = 'invalid' where status != 'valid';
[EDIT]:
We should use
php bin/magento indexer:reset customer_grid
Possible errors:
--Disable safe mode
update magento.indexer_state set status = 'invalid' where status !=
'valid' Error Code: 1175. You are using safe update mode and you tried
to update a table without a WHERE that uses a KEY column To disable
safe mode, toggle the option in Preferences -> SQL Editor and
reconnect. 0.000 sec
Reference here: https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench
--Not able to run php bin/magento indexer:reindex customer_grid
Customer Grid index is locked by another reindex process. Skipping.
show processlist;
kill "id number";
Or, we can restart mysql server.
--A large number of database - php -dmemory_limit=512M
If you have a large number of database, run the command with
php -dmemory_limit=512M bin/magento indexer:reindex customer_grid
Or should increase the memory_limit
~ 512M in php.ini
1
Should be: php bin/magento indexer:reset customer_grid instead of php bin/magento indexer:rest customer_grid
– KyleBunga
8 hours ago
add a comment |
I will NOT recommend to mess with Magento database directly.
Try this:
php bin/magento indexer:reset customer_grid
php bin/magento indexer:reindex customer_grid
Thanks @alta-works, your solution is much easy and straight forward.
– Mohit Kumar Arora
Sep 6 '17 at 7:12
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
});
}
});
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f141964%2fmagento-2-admin-customer-listing-not-displaying-record%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Reset your databse: Magento 2: Not showing customers in backend grid
update indexer_state set status = 'invalid' where status != 'valid';
[EDIT]:
We should use
php bin/magento indexer:reset customer_grid
Possible errors:
--Disable safe mode
update magento.indexer_state set status = 'invalid' where status !=
'valid' Error Code: 1175. You are using safe update mode and you tried
to update a table without a WHERE that uses a KEY column To disable
safe mode, toggle the option in Preferences -> SQL Editor and
reconnect. 0.000 sec
Reference here: https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench
--Not able to run php bin/magento indexer:reindex customer_grid
Customer Grid index is locked by another reindex process. Skipping.
show processlist;
kill "id number";
Or, we can restart mysql server.
--A large number of database - php -dmemory_limit=512M
If you have a large number of database, run the command with
php -dmemory_limit=512M bin/magento indexer:reindex customer_grid
Or should increase the memory_limit
~ 512M in php.ini
1
Should be: php bin/magento indexer:reset customer_grid instead of php bin/magento indexer:rest customer_grid
– KyleBunga
8 hours ago
add a comment |
Reset your databse: Magento 2: Not showing customers in backend grid
update indexer_state set status = 'invalid' where status != 'valid';
[EDIT]:
We should use
php bin/magento indexer:reset customer_grid
Possible errors:
--Disable safe mode
update magento.indexer_state set status = 'invalid' where status !=
'valid' Error Code: 1175. You are using safe update mode and you tried
to update a table without a WHERE that uses a KEY column To disable
safe mode, toggle the option in Preferences -> SQL Editor and
reconnect. 0.000 sec
Reference here: https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench
--Not able to run php bin/magento indexer:reindex customer_grid
Customer Grid index is locked by another reindex process. Skipping.
show processlist;
kill "id number";
Or, we can restart mysql server.
--A large number of database - php -dmemory_limit=512M
If you have a large number of database, run the command with
php -dmemory_limit=512M bin/magento indexer:reindex customer_grid
Or should increase the memory_limit
~ 512M in php.ini
1
Should be: php bin/magento indexer:reset customer_grid instead of php bin/magento indexer:rest customer_grid
– KyleBunga
8 hours ago
add a comment |
Reset your databse: Magento 2: Not showing customers in backend grid
update indexer_state set status = 'invalid' where status != 'valid';
[EDIT]:
We should use
php bin/magento indexer:reset customer_grid
Possible errors:
--Disable safe mode
update magento.indexer_state set status = 'invalid' where status !=
'valid' Error Code: 1175. You are using safe update mode and you tried
to update a table without a WHERE that uses a KEY column To disable
safe mode, toggle the option in Preferences -> SQL Editor and
reconnect. 0.000 sec
Reference here: https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench
--Not able to run php bin/magento indexer:reindex customer_grid
Customer Grid index is locked by another reindex process. Skipping.
show processlist;
kill "id number";
Or, we can restart mysql server.
--A large number of database - php -dmemory_limit=512M
If you have a large number of database, run the command with
php -dmemory_limit=512M bin/magento indexer:reindex customer_grid
Or should increase the memory_limit
~ 512M in php.ini
Reset your databse: Magento 2: Not showing customers in backend grid
update indexer_state set status = 'invalid' where status != 'valid';
[EDIT]:
We should use
php bin/magento indexer:reset customer_grid
Possible errors:
--Disable safe mode
update magento.indexer_state set status = 'invalid' where status !=
'valid' Error Code: 1175. You are using safe update mode and you tried
to update a table without a WHERE that uses a KEY column To disable
safe mode, toggle the option in Preferences -> SQL Editor and
reconnect. 0.000 sec
Reference here: https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench
--Not able to run php bin/magento indexer:reindex customer_grid
Customer Grid index is locked by another reindex process. Skipping.
show processlist;
kill "id number";
Or, we can restart mysql server.
--A large number of database - php -dmemory_limit=512M
If you have a large number of database, run the command with
php -dmemory_limit=512M bin/magento indexer:reindex customer_grid
Or should increase the memory_limit
~ 512M in php.ini
edited 1 min ago
answered Oct 21 '16 at 8:12
Khoa TruongDinhKhoa TruongDinh
22.1k64187
22.1k64187
1
Should be: php bin/magento indexer:reset customer_grid instead of php bin/magento indexer:rest customer_grid
– KyleBunga
8 hours ago
add a comment |
1
Should be: php bin/magento indexer:reset customer_grid instead of php bin/magento indexer:rest customer_grid
– KyleBunga
8 hours ago
1
1
Should be: php bin/magento indexer:reset customer_grid instead of php bin/magento indexer:rest customer_grid
– KyleBunga
8 hours ago
Should be: php bin/magento indexer:reset customer_grid instead of php bin/magento indexer:rest customer_grid
– KyleBunga
8 hours ago
add a comment |
I will NOT recommend to mess with Magento database directly.
Try this:
php bin/magento indexer:reset customer_grid
php bin/magento indexer:reindex customer_grid
Thanks @alta-works, your solution is much easy and straight forward.
– Mohit Kumar Arora
Sep 6 '17 at 7:12
add a comment |
I will NOT recommend to mess with Magento database directly.
Try this:
php bin/magento indexer:reset customer_grid
php bin/magento indexer:reindex customer_grid
Thanks @alta-works, your solution is much easy and straight forward.
– Mohit Kumar Arora
Sep 6 '17 at 7:12
add a comment |
I will NOT recommend to mess with Magento database directly.
Try this:
php bin/magento indexer:reset customer_grid
php bin/magento indexer:reindex customer_grid
I will NOT recommend to mess with Magento database directly.
Try this:
php bin/magento indexer:reset customer_grid
php bin/magento indexer:reindex customer_grid
answered Jun 28 '17 at 16:14
Alta WorksAlta Works
10111
10111
Thanks @alta-works, your solution is much easy and straight forward.
– Mohit Kumar Arora
Sep 6 '17 at 7:12
add a comment |
Thanks @alta-works, your solution is much easy and straight forward.
– Mohit Kumar Arora
Sep 6 '17 at 7:12
Thanks @alta-works, your solution is much easy and straight forward.
– Mohit Kumar Arora
Sep 6 '17 at 7:12
Thanks @alta-works, your solution is much easy and straight forward.
– Mohit Kumar Arora
Sep 6 '17 at 7:12
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f141964%2fmagento-2-admin-customer-listing-not-displaying-record%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Is there any customer from
customer_grid_flat
table?– Khoa TruongDinh
Oct 21 '16 at 6:16
customer_grid_flat
table is Blank :( No records. It's 0– Ankit Shah
Oct 21 '16 at 6:18
Tried to reindex database?
– Khoa TruongDinh
Oct 21 '16 at 6:18
Let me do that
static:content-deploy
is not going to affect right?– Ankit Shah
Oct 21 '16 at 6:19
php bin/magento indexer:reindex
– Khoa TruongDinh
Oct 21 '16 at 6:20