#1033 NULL-values changes to empty string

closed
None
5
2007-07-27
2007-05-09
No

First detected the problem when I change some information in a row in a table.

As soon as you select a input field to edit all the checkboxes that show that one value is set to NULL are cleared.

And even if you only have one value that is NULL, and you make sure to check the checkbox it clears as soon as you click the submit button.

I then tried to insert an new row, but same result.

All the checkboxes cleard.

Have tried on serveral servers, running both MySQL 5.0.x and MySQL 4.1.x. Same problem on every installation.

So, my suggestion is that there is a bug in the code.

/marcus

Discussion

  • Sebastian Mendel

    • labels: 317619 --> 509103
     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    What browser are you using?
    Do you get any JavaScript errors, warnings or notices?

    Can you repeat this in different tables or just on one specific?
    If only on one specific please provide table structure and sample data.

     
  • Marcus Farrington

    Logged In: YES
    user_id=1788562
    Originator: YES

    IE7.0 (7.0.5730.11)

    No JavaScript errors, warnings or noties.

    Yes, same problem for all tables.

    It happens everytime one click somewhere in the frame, then all the checkboxes goes unchecked.

     
  • Sebastian Mendel

    • status: open --> pending
     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    tested with IE7 - cannot reproduce

     
  • Jürgen Wind

    Jürgen Wind - 2007-05-10

    Logged In: YES
    user_id=1383652
    Originator: NO

    What if you try Firefox ?
    How does it behave on http://pma.cihar.com/STABLE/ (user root, no pw) ?

     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    if you just upgraded your phpMyAdmin installation try clearing your complete browser cache - possible some old JavaScript files are in your browser cache.

     
  • Marcus Farrington

    Logged In: YES
    user_id=1788562
    Originator: YES

    well same result at "your" site, except for the null-checkbox for text area.

     
  • Marcus Farrington

    • status: pending --> open
     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    no one can repeat

    Can you please try from another computer?
    Can you please try with another browser?
    In IE7 you can easily disable all BHO, please try to do so and test again.

     
  • Sebastian Mendel

    • milestone: 713394 -->
    • labels: 509103 -->
     
  • Sebastian Mendel

    • status: open --> pending
     
  • SourceForge Robot

    Logged In: YES
    user_id=1312539
    Originator: NO

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

     
  • SourceForge Robot

    • status: pending --> closed
     
  • Marcus Farrington

    Logged In: YES
    user_id=1788562
    Originator: YES

    Updated to 2.10.2.

    Problem remains.

    Has tested from other computers, and other browsers.

    Have not had time to deal with the problem, before... but now I'm back.

    /marcus

     
  • Marcus Farrington

    • status: closed --> open
     
  • Marcus Farrington

    Logged In: YES
    user_id=1788562
    Originator: YES

    BTW: Has tried all the suggested things proposed so far.

     
  • Marcus Farrington

    Logged In: YES
    user_id=1788562
    Originator: YES

    Has asked around and there are other who have had the same problem.
    They tried the same things as you have suggested, with no success. Finally they reinstalled version 2.9.2, and there where no problem anymore.

    So, in what way have you changed the JavaScript? Since 2.9.2 works on all computers, on all browser (that I have installed), on all servers etc. and 2.10.x does not.

     
  • Marc Delisle

    Marc Delisle - 2007-07-12
    • assigned_to: nobody --> lem9
    • status: open --> pending
     
  • Marc Delisle

    Marc Delisle - 2007-07-12

    Logged In: YES
    user_id=210714
    Originator: NO

    Could you try the trunk snapshot (2.11-dev) from http://www.phpmyadmin.net/snapshot and report here?

     
  • SourceForge Robot

    • status: pending --> closed
     
  • SourceForge Robot

    Logged In: YES
    user_id=1312539
    Originator: NO

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks