#2 Mysql navigator 1.4.2 produces mysql code with error

open
nobody
None
5
2004-07-13
2004-07-13
Anonymous
No

The error below has been found in mysql navigator 1.4.2

When I have opened the user table in the mysql database
and choose "tools", "insert" I get a new window with
mysql code. If I try to execute that code, I get an
error message that the number of fields do not match
the number of values. In the mysql code there values
that completely blank. If I replace those with '' the
code work.

In enclosed file I reproduce the code as produced by
mysql navigator, plus the corrected code, which can be
executed.

I find the error in several situations. I also
encounter an error when I try to add a user directly,
which I enterpret as the same error.

Discussion

  • Example of mysql code with error and correction.

     
    Attachments
  • Mats Dufberg
    Mats Dufberg
    2004-07-13

    Logged In: YES
    user_id=1082951

    The bug (?) was submitted by me (before I had an account).