Magento 2: Admin Customer Listing Not Displaying RecordAfter 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
What happens when a metallic dragon and a chromatic dragon mate?
Lied on resume at previous job
Crop image to path created in TikZ?
Was there ever an axiom rendered a theorem?
LWC and complex parameters
How can I fix this gap between bookcases I made?
What causes the sudden spool-up sound from an F-16 when enabling afterburner?
Why airport relocation isn't done gradually?
When blogging recipes, how can I support both readers who want the narrative/journey and ones who want the printer-friendly recipe?
I see my dog run
How to deal with fear of taking dependencies
How to make payment on the internet without leaving a money trail?
Email Account under attack (really) - anything I can do?
Where else does the Shulchan Aruch quote an authority by name?
How to move the player while also allowing forces to affect it
Is "plugging out" electronic devices an American expression?
How to answer pointed "are you quitting" questioning when I don't want them to suspect
Are cabin dividers used to "hide" the flex of the airplane?
Is it legal to have the "// (c) 2019 John Smith" header in all files when there are hundreds of contributors?
Why doesn't a const reference extend the life of a temporary object passed via a function?
Unbreakable Formation vs. Cry of the Carnarium
Need help identifying/translating a plaque in Tangier, Morocco
What is the meaning of "of trouble" in the following sentence?
What does it exactly mean if a random variable follows a distribution
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
asked Oct 21 '16 at 6:15
Ankit ShahAnkit Shah
4,976967144
|
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
asked Oct 21 '16 at 6:15
Ankit ShahAnkit Shah
4,976967144
Is there any customer fromcustomer_grid_flattable?
– Khoa TruongDinh
Oct 21 '16 at 6:16
customer_grid_flattable 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-deployis 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
asked Oct 21 '16 at 6:15
Ankit ShahAnkit Shah
4,976967144
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
asked Oct 21 '16 at 6:15
Ankit ShahAnkit Shah
4,976967144
asked Oct 21 '16 at 6:15
Ankit ShahAnkit Shah
4,976967144
edited Oct 21 '16 at 7:16
Ankit Shah
asked Oct 21 '16 at 6:15
Ankit ShahAnkit Shah
4,976967144
asked Oct 21 '16 at 6:15
Ankit ShahAnkit Shah
4,976967144
asked Oct 21 '16 at 6:15
Ankit ShahAnkit Shah
4,976967144
4,976967144
Is there any customer fromcustomer_grid_flattable?
– Khoa TruongDinh
Oct 21 '16 at 6:16
customer_grid_flattable 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-deployis 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_flattable?
– Khoa TruongDinh
Oct 21 '16 at 6:16
customer_grid_flattable 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-deployis 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
answered Oct 21 '16 at 8:12
Khoa TruongDinhKhoa TruongDinh
22.1k64187
1
Should be: php bin/magento indexer:reset customer_grid instead of php bin/magento indexer:rest customer_grid
– KyleBunga
11 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
answered Jun 28 '17 at 16:14
Alta WorksAlta Works
10111
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
answered Oct 21 '16 at 8:12
Khoa TruongDinhKhoa TruongDinh
22.1k64187
1
Should be: php bin/magento indexer:reset customer_grid instead of php bin/magento indexer:rest customer_grid
– KyleBunga
11 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
answered Oct 21 '16 at 8:12
Khoa TruongDinhKhoa TruongDinh
22.1k64187
1
Should be: php bin/magento indexer:reset customer_grid instead of php bin/magento indexer:rest customer_grid
– KyleBunga
11 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
answered Oct 21 '16 at 8:12
Khoa TruongDinhKhoa TruongDinh
22.1k64187
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
answered Oct 21 '16 at 8:12
Khoa TruongDinhKhoa TruongDinh
22.1k64187
edited 3 hours ago
answered Oct 21 '16 at 8:12
Khoa TruongDinhKhoa TruongDinh
22.1k64187
answered Oct 21 '16 at 8:12
Khoa TruongDinhKhoa TruongDinh
22.1k64187
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
11 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
11 hours ago
1
1
Should be: php bin/magento indexer:reset customer_grid instead of php bin/magento indexer:rest customer_grid
– KyleBunga
11 hours ago
Should be: php bin/magento indexer:reset customer_grid instead of php bin/magento indexer:rest customer_grid
– KyleBunga
11 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
answered Jun 28 '17 at 16:14
Alta WorksAlta Works
10111
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
answered Jun 28 '17 at 16:14
Alta WorksAlta Works
10111
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
answered Jun 28 '17 at 16:14
Alta WorksAlta Works
10111
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
answered Jun 28 '17 at 16:14
Alta WorksAlta Works
10111
answered Jun 28 '17 at 16:14
Alta WorksAlta Works
10111
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_flattable?– Khoa TruongDinh
Oct 21 '16 at 6:16
customer_grid_flattable 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-deployis 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