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

[Chris]

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.

[Chris]

Example table with relationship

[Marc Delisle]

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.

[Chris]

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

[Marc Delisle]

Which checkbox? Please attach a screenshot.

[Chris]

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]

screenshot

[Marc Delisle]

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