Magento 2: Admin Customer Listing Not Displaying Record
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,755864141
|
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,755864141
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,755864141
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,755864141
asked Oct 21 '16 at 6:15
Ankit ShahAnkit Shah
4,755864141
edited Oct 21 '16 at 7:16
Ankit Shah
asked Oct 21 '16 at 6:15
Ankit ShahAnkit Shah
4,755864141
asked Oct 21 '16 at 6:15
Ankit ShahAnkit Shah
4,755864141
asked Oct 21 '16 at 6:15
Ankit ShahAnkit Shah
4,755864141
4,755864141
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:rest 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
21.4k64086
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
9111
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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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:rest 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
21.4k64086
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:rest 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
21.4k64086
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:rest 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
21.4k64086
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:rest 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
21.4k64086
edited Dec 6 '18 at 14:41
answered Oct 21 '16 at 8:12
Khoa TruongDinhKhoa TruongDinh
21.4k64086
answered Oct 21 '16 at 8:12
Khoa TruongDinhKhoa TruongDinh
21.4k64086
answered Oct 21 '16 at 8:12
Khoa TruongDinhKhoa TruongDinh
21.4k64086
21.4k64086
add a comment |
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
9111
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
9111
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
9111
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
9111
answered Jun 28 '17 at 16:14
Alta WorksAlta Works
9111
answered Jun 28 '17 at 16:14
Alta WorksAlta Works
9111
answered Jun 28 '17 at 16:14
Alta WorksAlta Works
9111
9111
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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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