#3499 (ok 3.4.10) Setting data to NULL and drop-downs

3.4.9
fixed
Interface (555)
1
2013-06-11
2012-01-03
Chris
No

I'm on Windows, and these are my webserver details:
Apache/2.2.21 (Win32) mod_ssl/2.2.21 - PHP 5.35

I have downloaded the latest Git snapshot and it works well mostly on my server, but when it comes to setting results as NULL, it does not allow you to.
Whether the link contains a hyperlink or not, try setting it to NULL, it will not allow you to - and this applies only to tables with referential integrity, not normal tables where there's no link to another one, that works fine.

This applies from 3.48 onwards, I've continually upgraded and tried to reproduce this.

Attached is the database; import it into your 3.49 or snapshot version and see if you can make any records null, it does not seem to let me.

Discussion

  • Chris

    Chris - 2012-01-03

    Example table with relationship

     
  • Chris

    Chris - 2012-01-03
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2012-01-04
    • assigned_to: lem9 --> nobody
     
  • Marc Delisle

    Marc Delisle - 2012-01-04

    If you are referring to an error message such as
    #1451 - Cannot delete or update a parent row: a foreign key constraint fails (`test`.`sales`, CONSTRAINT `sales_ibfk_2` FOREIGN KEY (`marque`) REFERENCES `cars` (`marque`) ON UPDATE CASCADE)

    this message comes from MySQL and is normal. If you define a foreign key constraint, MySQL enforces it.

     
  • Marc Delisle

    Marc Delisle - 2012-01-04
    • assigned_to: nobody --> lem9
    • status: open --> wont-fix-invalid
     
  • Chris

    Chris - 2012-01-04

    I'm not referring to that; rather the fact is the checkbox does not allow null records for foreign keys.

     
  • Marc Delisle

    Marc Delisle - 2012-01-04
    • status: wont-fix-invalid --> open
     
  • Marc Delisle

    Marc Delisle - 2012-01-04

    Which checkbox? Please attach a screenshot.

     
  • Marc Delisle

    Marc Delisle - 2012-01-05
    • status: open --> pending
     
  • Chris

    Chris - 2012-01-20

    OK, here is the screenshot:
    http://img705.imageshack.us/img705/2862/phpmyadminerror1.jpg

    It's the checkbox under the NULL column.

    This seems to happen on any database once I have over at least 30-50 records, no idea WHY this happens though.

     
  • Chris

    Chris - 2012-01-20
    • labels: 509096 --> Interface
    • status: pending --> open
     
  • Chris

    Chris - 2012-01-20

    screenshot

     
  • Marc Delisle

    Marc Delisle - 2012-01-21
    • milestone: 415859 --> 3.4.9
     
  • Marc Delisle

    Marc Delisle - 2012-01-21
    • summary: Setting data to NULL - does not work for some reason --> Setting data to NULL and drop-downs
     
  • Marc Delisle

    Marc Delisle - 2012-01-21

    This bug was fixed in repository and will be part of a future release; thanks for reporting.

     
  • Marc Delisle

    Marc Delisle - 2012-01-21
    • summary: Setting data to NULL and drop-downs --> (ok 3.4.10) Setting data to NULL and drop-downs
    • priority: 5 --> 1
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2012-02-14
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed