Bug #17209 Division by zero
Submitted: 7 Feb 2006 22:23 Modified: 2 May 2006 16:54
Reporter: Hein Gustavsen Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Query Browser Severity:S1 (Critical)
Version:1.1.19 OS:Windows (Windows XP Pro)
Assigned to: CPU Architecture:Any

[7 Feb 2006 22:23] Hein Gustavsen
Description:
Division by zero is shown on startup and sql editor and result table is missing from screen.

Database and tables list is present, but double-clicking om a table gives access violation at address 005BAF23. Right-clicking on table name does nothing.

This installation and version has worked on my computer before, and I have not reinstalled it.

I connect through ssh tunnel.

Server info:
--------------
mysql  Ver 12.22 Distrib 4.0.20, for slackware-linux (i486)

Connection id:          280636
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Server version:         4.0.20-log
Protocol version:       10
Connection:             Localhost via UNIX socket
Client characterset:    latin1
Server characterset:    latin1
UNIX socket:            /var/run/mysql/mysql.sock
--------------

How to repeat:
Problem appears immediately after startup on my machine.
[8 Feb 2006 16:06] Jorge del Conde
Hi!

I was unable to reproduce this bug under a clean install of XP.  Can you please delete all of QB's configuration files and try again ?

Is there any chance this may be caused by having selected a non-existant database by default ?

Thanks!
[8 Feb 2006 16:51] Hein Gustavsen
I have deleted the configuration in documents and settings\user\application data\mysql.

The user interface now looks better, and no error message on status bar, but I cannot focus the sql field (on top). If I click in the SQL field, the caret is invisible, and if I try to write something, I get a Division by zero on the status bar again.

Right click in SQL field gives the correct popup menu. Clear works, but paste gives a Division by zero error.

When I click around in the SQL field and tries to paste data, the column and row indicators on the status bar sometimes shows normal values, and when I choose clear on SQL field, row and col is set back to 1:1.

I left schema blank when I logged in. When I double-click on the schema name, the tables is listed correctly.

"Edit Table" and "Copy SQL to Clipboard" works.

I have GTK installed, but I don't know if this has anything to do with query browser.

Mvh
Hein Gustavsen
[13 Mar 2007 4:09] Mark Ireland
I have the same divide by zero bug. I am connecting remotely from a WinDoze 2003 machine. The Query Browser is version 1.1.19 (and the About screen just hung!)