magento2: Catalog fails to display when pageSize is set too high; no way to then reduce pageSize
Steps to reproduce
- Navigate to Products -> Catalog
- Set
pageSizeto a large integer by typing in a custom value - Catalog fails to load and displays generic “Attention Something went wrong” error
- PHP log shows
AH01328: Line too long, URI /index.php, referer: /admin/catalog/product/
- Now that page size preference has been set to an unusable amount, the user has no way of ever changing this value since it is not possible to change
paging[pageSize]dropdown asadmin__data-grid-loading-mask(animated spinner) does not let the user modify values while it is working - Spinner never goes away, essentially permanently breaking the catalog view for that user as there is no obvious way to delete view preferences (where is
pageSizevalue stored?) - Deleting cookies, logging out does not reset this and the
pageSizevalue is still preserved session to session

Expected result
- If value is set too high the user should be presented with a more specific error or at least the ability to reset it to a working value.
Actual result
- The way the page is designed right now, the user can never ever see the catalog again from their account since it will repeatedly display that error with no way to restore a previous working value as the error locks the form.
I understand every environment has different limitations and perhaps some installations can support displaying 999 products, but if it cannot then it should fail more gracefully than bricking the account. A quick fix is to create a new user, where the default pagination is set to 20, but not an ideal solution.
About this issue
- Original URL
- State: closed
- Created 8 years ago
- Reactions: 1
- Comments: 16 (7 by maintainers)
solution is here.
Go to database table “ui_bookmark” and use below query
SELECT * FROM ui_bookmark where namespace like ‘product_listing’ AND identifier like ‘current’ AND user_id = 1
then copy “config” column value from result and search 999 you will get below json -
…“paging”:{“options”:{“20”:{“value”:20,“label”:20},“30”:{“value”:30,“label”:30},“50”:{“value”:50,“label”:50},“100”:{“value”:100,“label”:100},“200”:{“value”:200,“label”:200},“999”:{“value”:999,“label”:999,“_value”:999,“editable”:true}},“value”:999},…
and replace last 999 to 20 from json so final json will be -
…“paging”:{“options”:{“20”:{“value”:20,“label”:20},“30”:{“value”:30,“label”:30},“50”:{“value”:50,“label”:50},“100”:{“value”:100,“label”:100},“200”:{“value”:200,“label”:200},“999”:{“value”:999,“label”:999,“_value”:999,“editable”:true}},“value”:20},…
and update same config column from resultant row.
This will definitely help you. Enjoy coding !
I am having this same problem on Magento 2.1 CE