Gsyfuy

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;
}

3

1

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

share|improve this question

edited Oct 21 '16 at 7:16

Ankit Shah

asked Oct 21 '16 at 6:15

Ankit ShahAnkit Shah

4,976967144

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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
  

  
  
  
  

 | 
show 2 more comments

3

1

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

share|improve this question

edited Oct 21 '16 at 7:16

Ankit Shah

asked Oct 21 '16 at 6:15

Ankit ShahAnkit Shah

4,976967144

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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
  

  
  
  
  

 | 
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

share|improve this question

edited Oct 21 '16 at 7:16

Ankit Shah

asked Oct 21 '16 at 6:15

Ankit ShahAnkit Shah

4,976967144

share|improve this question

edited Oct 21 '16 at 7:16

Ankit Shah

asked Oct 21 '16 at 6:15

Ankit ShahAnkit Shah

4,976967144

share|improve this question

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

2 Answers
2

active

oldest

votes

5

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

share|improve this answer

edited 1 min ago

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
  8 hours ago
  

  
  
  
  

add a comment | 

4

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

share|improve this answer

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
});


}
});

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%2f141964%2fmagento-2-admin-customer-listing-not-displaying-record%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

5

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

share|improve this answer

edited 1 min ago

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
  8 hours ago
  

  
  
  
  

add a comment | 

5

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

share|improve this answer

edited 1 min ago

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
  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

share|improve this answer

edited 1 min ago

answered Oct 21 '16 at 8:12

Khoa TruongDinhKhoa TruongDinh

22.1k64187

php bin/magento indexer:reset customer_grid

show processlist; 

kill "id number";

php -dmemory_limit=512M bin/magento indexer:reindex customer_grid

share|improve this answer

edited 1 min 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

4

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

share|improve this answer

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 | 

4

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

share|improve this answer

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

share|improve this answer

answered Jun 28 '17 at 16:14

Alta WorksAlta Works

10111

php bin/magento indexer:reset customer_grid

php bin/magento indexer:reindex customer_grid

share|improve this answer

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