magento2: Catalog fails to display when pageSize is set too high; no way to then reduce pageSize

Steps to reproduce

  1. Navigate to Products -> Catalog
  2. Set pageSize to a large integer by typing in a custom value
  3. Catalog fails to load and displays generic “Attention Something went wrong” error
  4. PHP log shows
AH01328: Line too long, URI /index.php, referer: /admin/catalog/product/
  1. 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 as admin__data-grid-loading-mask (animated spinner) does not let the user modify values while it is working
  2. 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 pageSize value stored?)
  3. Deleting cookies, logging out does not reset this and the pageSize value is still preserved session to session

image

Expected result

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

  1. 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)

Commits related to this issue

Most upvoted comments

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