Menu

#4538 (ok 4.2.9) Column headers move when scrolling, fix included in report.

4.2.8
fixed
1
2014-09-20
2014-09-18
usrhlp
No

There is a bug in line 586 of the file sql.js in the JS directory in PHPMyAdmin.

The line
return $originalColumns.eq(i).width();

needs changing to

return Math.floor($originalColumns.eq(i).width()) + 1;

Without this the column headers get moved all over the place when you scroll through tables with many columns and large amounts of information in both the column name and data.

It has been like this for many versions.

4.2.8.1 also still has this bug.

Support request open in this location, also showing example of the bug happening, namely here http://b2b.resource-ps.co.uk/phpmyadmin/phpmabug.jpg along with the fix.

http://stackoverflow.com/questions/24635110/phpmyadmin-column-headers-move-in-table-when-you-scroll

If this quick and simple code change could be made that would be excellent.

Thanks.

Discussion

  • Atul Pratap Singh

    • assigned_to: Atul Pratap Singh
     
  • Atul Pratap Singh

    Hi usrhlp,

    Thanks a lot for the correction, could you please provide your name and email, so that I can put you as author while committing this change in our repository?

    If not I can just put a reference to your stackoverflow question in commit message.

     
  • usrhlp

    usrhlp - 2014-09-18

    Sure, my name is Dean Moncaster, i am dean@deanmoncaster.co.uk

    Thanks

     
  • Atul Pratap Singh

    • summary: Column headers move when scrolling, fix included in report. --> (ok 4.2.9) Column headers move when scrolling, fix included in report.
    • status: open --> resolved
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2014-09-20
    • Status: resolved --> fixed
     
Monday.com Logo