Bug #51848 | Display in info column not always readable | ||
---|---|---|---|
Submitted: | 8 Mar 2010 22:47 | Modified: | 27 May 2010 11:17 |
Reporter: | John Haney | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
Version: | 5.2.21 | OS: | Windows (XP x32) |
Assigned to: | Mike Lischke | CPU Architecture: | Any |
[8 Mar 2010 22:47]
John Haney
[9 Mar 2010 9:27]
Johannes Taxacher
Hi John, could you explain what you mean by "sent from PHP" and what info column you're referring to? thanks in advance
[9 Mar 2010 17:17]
John Haney
By PHP I mean if the query is sent from our web application which uses PHP to connect to MySQL. The 'info' column is in the connections tab of an admin tab. So start an admin of a server and then click the connections tab to see the active connections. The last default column is the 'info' column that I see the problem in.
[10 Mar 2010 6:57]
Susanne Ebrecht
According to http://dev.mysql.com/doc/refman/5.1/en/comments.html you need spaces between the comment command and the next options. Do you have same failure when you use: /* test */ select * from table
[11 Mar 2010 0:41]
John Haney
Yes it still happens. We have the spaces (always have) and I just did not put them in when I typed the example queries.
[16 Mar 2010 12:17]
Valeriy Kravchuk
What do you see in the Info column when you execute /* test */ select * from table and it "fails"? The problem is in missing comment or in something else?
[16 Mar 2010 18:16]
John Haney
The display is different at times but most common thing is the queries will be truncated (at random places) and where the query should display there will be what looks like pixels from the bottom of the query string characters. Changing the width of the column has no affect. If the paragragh above was the actual query text it may display as: The dis_ _ __ ___ _ _ _
[29 Mar 2010 20:27]
MySQL Verification Team
Thank you for the feedback. Could you please provide a screen-shot of the issue reported?. Thanks in advance.
[7 Apr 2010 17:35]
John Haney
Image of garbage text as requested.
Attachment: garbage_text_mysql_gui.PNG (image/x-png, text), 7.07 KiB.
[7 Apr 2010 17:37]
John Haney
Just to clarify what the image shows - Notice that the text is missing in the 'info' column. Only a few pixels are displayed where the entire query should be displayed. Also it is still this way in version 5.2.17. John
[11 Apr 2010 15:36]
Valeriy Kravchuk
Please, send the results of Help > System Info menu item.
[13 Apr 2010 14:46]
John Haney
Checked server status: Server is stopped.Checked server status: Server is running.get_server_version: parsed (5, 0, 27) Checked server status: Server is running.get_server_version: parsed (5, 0, 27) Checked server status: Server is running.get_server_version: parsed (5, 0, 27) Checked server status: Server is running.get_server_version: parsed (5, 0, 27) Checked server status: Server is running.get_server_version: parsed (5, 0, 27) Checked server status: Server is stopped.Checked server status: Server is running.get_server_version: parsed (5, 0, 27) Checked server status: Server is running.get_server_version: parsed (5, 0, 27) have_bdb new have_bdb new have_bdb new have_bdb new have_bdb new have_bdb new have_bdb new have_bdb new have_bdb new have_bdb new ctrl_be: Query Error Error executing 'show global status': 2006. Error:2006 Failed to connect to MySQL server Checked server status: Server is running.get_server_version: parsed (5, 0, 89) ctrl_be: Query Error Error executing 'show global status': 2006. Error:2006 Failed to connect to MySQL server Checked server status: Server is stopped.ctrl_be: Query Error Error executing 'show global status': 2006. Error:2006 Channel closed. Channel closed. Channel closed. Channel closed. Channel closed. Channel closed. Channel closed. Channel closed. Channel closed. Channel closed. Channel closed. Channel closed. Channel closed. Channel closed. Channel closed. MySQL Workbench OSS for Windows version 5.2.17 Cairo Version: 1.8.8 Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering. OpenGL Driver Version: 2.1.7415 Release OS: Microsoft Windows XP Professional Service Pack 3 (build 2600) CPU: 2x Intel(R) Core(TM)2 Duo CPU E8400 @ 3.00GHz, 3.0 GiB RAM Video adapter info: Adapter type: ATI Radeon HD 2400 Pro Chip Type: ATI Radeon Graphics Processor (0x94C1) BIOS String: 113-B27602-113 Video Memory: 262144 KB
[26 Apr 2010 7:42]
Sveta Smirnova
Thank you for the feedback. This looks like same problem as in bug #51119. Please provide full exact query you run from PHP script. You can add it as hidden comment.
[17 May 2010 15:53]
Mike Lischke
Fixed in repository.
[26 May 2010 20:39]
Johannes Taxacher
fix confirmed in repository
[27 May 2010 11:17]
Tony Bedford
An entry has been added to the 5.2.22 changelog: In the Connections tab of the Administrator, queries containing a comment did not always display correctly in the Info column.