#4413 (ok 4.2.8) Navigation Error in Nav Tree for Search Results Past the First Page

[Owen]

Observed Behavior

Default tables shown on one page is 25. After filtering the tables, when expanding a table that would normally be past the first page, a "An error has occurred while loading the navigation tree" error is shown.

Expected Behavior

Tables can be expanded at any time

Steps to Reproduce

1. Create some tables using the attached SQL script
2. Expand the list of tables in the database
3. Filter the tables by '3'
4. Expand table38

[Owen]

Screenshot of the error and SQL script to create test tables

[Madhura Jayaratne]

I have difficulty in reproducing this bug.
If I set 'Maximum items in branch' to 25, table38 would be on the second page and filtering for 3 would not bring it to view.
If I go with default value for 'Maximum items in branch', 50 and filter for 3, it would achieve the filtered list shown in the attachment. However I'm still not getting the error you see when expanding table 38.

[Owen]

I'm attaching a screencast of reproducing the error. Apologies for the Flash format but, it's the only screencast software available to me.

[Madhura Jayaratne]

Thanks Owen. I can reproduce the bug following the steps in your screencast.

[Marc Delisle]

Madhura, can you also reproduce it with version 4.2.3?

[Madhura Jayaratne]

Marc, it seems to be fixed in QA_4_2 branch.

[Marc Delisle]

Thanks Madhura for the feedback.

[Madhura Jayaratne]

Hi Marc,

My mistake, I misread the bug report. The bug is still there.

[Atul Pratap Singh]

Should be fixed after https://github.com/phpmyadmin/phpmyadmin/commit/7e5026cde4f001c563dd56fae9904a53033ee14d