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.
Please publish the problem’s screenshot.
Have someone got solution ?
Let’s make reindex the database of your site by command:
php -f path_to_your_magento2/bin/magento indexer:reindex
Regards,
Quynhvv
Already done reinndexing, but yet not solved.
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.
2.0.2, but it is not possible to reinstall magento because i have 4k products.
You can reinstall in that database 
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
The issue is fixed, i run the
update magento.indexer_state set status=‘invalid’ where status =‘working’
in sql,
and reindexed the magento.
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
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 ??
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
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
seems like you migrate magento from 1 to magento 2.
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.
