Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

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

3.4.9
fixed
Marc Delisle
Interface (554)
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

1 2 > >> (Page 1 of 2)
  • Chris
    Chris
    2012-01-03

    Example table with relationship

     
    Attachments
  • 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.

     
1 2 > >> (Page 1 of 2)