Why are the customers not displaying in the backend?

backend
customers-grid
customer
indexing

(Sandeep Pandey) #1

Hi Everyone,

In my admin customers grid not displaying customers where as customers store in database but my customer_flat_grid is blank, but in dashboard i can see the customers in NEW CUSTOMERS tab.

I’m adding customers from admin.

In my log files there it shows no such error.

So can any suggest me why this happen.

but here we can see the customers, but in customer tab there are no such records.


(Dmitry Fedyuk) #2

Please publish the problem’s screenshot.


(Sandeep Pandey) #3

Have someone got solution ?


(Vu Quynh) #4

Let’s make reindex the database of your site by command:

php -f path_to_your_magento2/bin/magento indexer:reindex

Regards,
Quynhvv


(Sandeep Pandey) #5

Already done reinndexing, but yet not solved.


(Vu Quynh) #6

So, what version of Magento 2 you are using. I think in this case, you should try re-install the Magento2.
And let’s me know how it goes.
Regards,
Qvv.


(Sandeep Pandey) #7

2.0.2, but it is not possible to reinstall magento because i have 4k products.


(Vu Quynh) #8

You can reinstall in that database :wink: and you have not loss your data after install.
Example command to install Magento 2 with current database (without clean/reset database):

 php -f /home/qvv/www/mg2/ce200-dev/bin/magento setup:install --db-host="localhost" --db-name="mg2-ce201-dev-sam" --db-user="root" --db-password="root@123" --base-url="http://sites.local/mg2/ce200-dev/" --admin-user="admin" --admin-password="admin123" --admin-email="qvv.hn.vn@gmail.com" --admin-firstname="Super" --admin-lastname="Admin" --backend-frontname="admin"

Regards,
Qvv


(Sandeep Pandey) #9

The issue is fixed, i run the

update magento.indexer_state set status=‘invalid’ where status =‘working’

in sql,

and reindexed the magento.


Why does my product's URL looks wrongly look like «/catalog/product/view/id/<ID>»?
(Sunil Patel) #10

Some time :
php -f path_to_your_magento2/bin/magento indexer:reindex

when you run above code, it is go out of memory so it will stop process.

So you need to go to indexer_state table and you need to set working set to invalid state.

then run below command
php -d memory_limit=1024M bin/magento indexer:reindex


(Lalit Malav) #11

I have facing same issue and I have tried all things but no Luck. please see the screenshot for The review.

can you please let me know what’s the solution ??


(Sunil Patel) #12

So you need to go to indexer_state table and you need to set working set to invalid state for customer grid.

then run below command
php -d memory_limit=1024M bin/magento indexer:reindex


(Shesh Narayan) #13

No luck again I am getting the error and also no records showing in the backend.

Design Config Grid index has been rebuilt successfully in 00:00:00
SELECT e., e.entity_id, TRIM(CONCAT_WS(’ ‘, IF(e.prefix <> ‘’, e.prefix, NULL),
IF(e.firstname <> ‘’, e.firstname, NULL), IF(e.middlename <> ‘’, e.middlename,
NULL), IF(e.lastname <> ‘’, e.lastname, NULL), IF(e.suffix <> ‘’, e.suffix, NUL
L))) AS name, e.email, e.group_id, e.created_at, e.website_id, e.confirmat ion, e.created_in, e.dob, e.gender, e.taxvat, e.lock_expires, TRIM(CONCAT_
WS(’ ‘, IF(billing.street <> ‘’, billing.street, NULL), IF(billing.city <> ‘’, bil ling.city, NULL), IF(billing.region <> ‘’, billing.region, NULL), IF(billing.post code <> ‘’, billing.postcode, NULL))) AS billing_full, billing.firstname AS billing _firstname, billing.lastname AS billing_lastname, billing.telephone AS billing_tele phone, billing.postcode AS billing_postcode, billing.country_id AS billing_country_ id, billing.region AS billing_region, billing.street AS billing_street, billing.
city AS billing_city, billing.fax AS billing_fax, billing.vat_id AS billing_vat_ id, billing.company AS billing_company, TRIM(CONCAT_WS(’ ', IF(shipping.street <> ‘’
, shipping.street, NULL), IF(shipping.city <> ‘’, shipping.city, NULL), IF(shippin g.region <> ‘’, shipping.region, NULL), IF(shipping.postcode <> ‘’, shipping.post code, NULL))) AS shipping_full FROM customer_entity AS e
LEFT JOIN customer_address_entity AS billing ON billing.entity_id=e.default_billing
LEFT JOIN customer_address_entity AS shipping ON shipping.entity_id=e.default_shippingCust
omer Grid indexer process unknown error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.lock_expires’ in ‘field list’, query
was: SELECT e.
, e.entity_id, TRIM(CONCAT_WS(’ ‘, IF(e.prefix <> ‘’, e.prefix, NU
LL), IF(e.firstname <> ‘’, e.firstname, NULL), IF(e.middlename <> ‘’, e.middlena me, NULL), IF(e.lastname <> ‘’, e.lastname, NULL), IF(e.suffix <> ‘’, e.suffix
, NULL))) AS name, e.email, e.group_id, e.created_at, e.website_id, e.conf irmation, e.created_in, e.dob, e.gender, e.taxvat, e.lock_expires, TRIM(CO
NCAT_WS(’ ‘, IF(billing.street <> ‘’, billing.street, NULL), IF(billing.city <> ‘’,
billing.city, NULL), IF(billing.region <> ‘’, billing.region, NULL), IF(billing.
postcode <> ‘’, billing.postcode, NULL))) AS billing_full, billing.firstname AS bi lling_firstname, billing.lastname AS billing_lastname, billing.telephone AS billing _telephone, billing.postcode AS billing_postcode, billing.country_id AS billing_cou ntry_id, billing.region AS billing_region, billing.street AS billing_street, bill ing.city AS billing_city, billing.fax AS billing_fax, billing.vat_id AS billing _vat_id, billing.company AS billing_company, TRIM(CONCAT_WS(’ ', IF(shipping.street
<> ‘’, shipping.street, NULL), IF(shipping.city <> ‘’, shipping.city, NULL), IF(sh ipping.region <> ‘’, shipping.region, NULL), IF(shipping.postcode <> ‘’, shipping.
postcode, NULL))) AS shipping_full FROM customer_entity AS e
LEFT JOIN customer_address_entity AS billing ON billing.entity_id=e.default_billing
LEFT JOIN customer_address_entity AS shipping ON shipping.entity_id=e.default_shipping
Category Products index has been rebuilt successfully in 00:00:00
Product Categories index has been rebuilt successfully in 00:00:00
Product Price index has been rebuilt successfully in 00:00:01
Product EAV index has been rebuilt successfully in 00:00:00
Stock index has been rebuilt successfully in 00:00:00
Catalog Rule Product index has been rebuilt successfully in 00:00:00
Catalog Product Rule index has been rebuilt successfully in 00:00:00
Catalog Search index has been rebuilt successfully in 00:00:00


(Sunil Patel) #14

seems like you migrate magento from 1 to magento 2.


(Shesh Narayan) #15

Yes i have migrated from 1.7 to 2.1.3 and this issue have been resolved but again i am getting error while try to edit or save a product.

Class ‘Magento\Catalog\Model\Product\Attribute\Backend\Media’ not found

Can you suggest me about this error.


(Sunil Patel) #16

Please check attribute in eav_attribute table.