UserAgent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36

Example URL:

Steps to reproduce the problem:
Open the following HTML in a chrome browser tab (incognito or not doesn't matter)

To clarify, this is not an SQL issue. It is just that with this debug output, the error seems to show up. I've removed all surrounding code and was left with only the following HTML that still reproduces the error.

The error occured on my screen @1920x1080 resolution. On a windows laptop with similar resolution, I had to <CTRL><-> lower the zoom factor from 100 to 67 to reproduce the same problem. As soon as `user_email` comes in the right top part of the screen, the bug shows

<style type="text/css">
                    table.debug{
                        font-family: sans-serif;
                        width:99%;
                        background:#AAAAAA;
                        border-collapse:collapse;
                        border-spacing:2px;
                        margin: 5px auto 5px auto;
                    }

                    table.debug thead{
                        background: #00A0CF;
                    }

                    table.debug td{
                        border: 1px solid black;
                        padding: 10px;
                    }
                    table.debug td.value{
                        word-break: break-all;
                    }
                   </style><table class="debug">
                        <thead class="debug-header"><td colspan="4">/var/www/html/ivette-arellano/notary-scanner/web/www/en/libs/sql.php@211</td></thead>
                        <thead class="debug-columns"><td>Key</td><td>Type</td><td>Size</td><td>Value</td></thead><tr>
                        <td>Unknown</td>
                        <td>string</td>
                        <td>1076</td>
                        <td class="value"> SELECT    `categories`.`id`,
                                       `categories`.`meta_id`,
                                       `categories`.`name`,
                                       `categories`.`seoname`,
                                       `categories`.`status`,
                                       `categories`.`createdon`,
                                       `categories`.`description`,

                                       `users`.`name`     AS `user_name`,
                                       `users`.`email`    AS `user_email`,
                                       `users`.`username` AS `user_username`,

                                       `parents`.`name`   AS `parent`

                             FROM      `categories`

                             LEFT JOIN `categories` AS `parents`
                             ON        `parents`.`id` = `categories`.`parents_id`

                             LEFT JOIN `users`
                             ON        `users`.`id` = `categories`.`createdby` WHERE `categories`.`seoname` = &quot;test&quot; ;</td>
                    </tr>
                    </table>

What is the expected behavior?
Should show a gray table with a blue header and black borders on a white background. In there, it should show the query:

SELECT `categories`.`id`, `categories`.`meta_id`, `categories`.`name`, `categories`.`seoname`, `categories`.`status`, `categories`.`createdon`, `categories`.`description`, `users`.`name` AS `user_name`, `users`.`email` AS `user_email`, `users`.`username` AS `user_username`, `parents`.`name` AS `parent` FROM `categories` LEFT JOIN `categories` AS `parents` ON `parents`.`id` = `categories`.`parents_id` LEFT JOIN `users` ON `users`.`id` = `categories`.`createdby` WHERE `categories`.`seoname` = "test" ;

What went wrong?
It shows the following query instead (Note the missing comma at the part "AS `user_email` `users`.`username`"

NOTE: The bug only shows when `user_email` is in the right top part of the screen, you may need to adjust screen zoom factor up or down for this to happen. When it does, though, it should show `user_email`, but shows `user_email`

SELECT `categories`.`id`, `categories`.`meta_id`, `categories`.`name`, `categories`.`seoname`, `categories`.`status`, `categories`.`createdon`, `categories`.`description`, `users`.`name` AS `user_name`, `users`.`email` AS `user_email` `users`.`username` AS `user_username`, `parents`.`name` AS `parent` FROM `categories` LEFT JOIN `categories` AS `parents` ON `parents`.`id` = `categories`.`parents_id` LEFT JOIN `users` ON `users`.`id` = `categories`.`createdby` WHERE `categories`.`seoname` = "test" ;

Does it occur on multiple sites: N/A

Is it a problem with a plugin? No 

Did this work before? N/A 

Does this work in other browsers? N/A

Chrome version: 66.0.3359.181  Channel: n/a
OS Version: comma
Flash Version:
 

Deleted: chrome_fail.png 73.4 KB

	chrome_fail.png 73.4 KB View Download