Error with null dates

Question

Error with null dates

DavidePastore opened this issue 10 years ago · 8 comments

I have a database with 'birth_date' column, which can be NULL or a date.

If I use plain 'echo' to output birth_day, it works in either case - as null and as a date.

If however I'm using Twig as a template engine and accessing birthday through Twig, it works ONLY when there is a date. If there is NULL, then application crashes and browser gives me back ERR_EMPTY_RESPONSE. Nothing more.

I'm pretty sure the problem occurs somewhere in the ORM, but I can't figure out how to solve it. I'd like to have just and empty string outputed in Twig if there's a NULL in db.

This isn't a problem of Twig because if I pass to it a null value, it simply doesn't print it.

Answer 1 · 2014-02-27T15:21:53.000Z

NULL and empty string are different, so this wouldn't be appropriate, I think.

One way to handle it is to add NOT NULL DEFAULT '' to your column definition in your database, so that you prevent NULLs on the data side.

Answer 2 · 2014-02-27T15:38:23.000Z

@tag: The problem is that the field is of DATE type. If I set it to a NOT NULL DEFAULT '' it will set to the 00:00:00 value.

Answer 3 · 2014-02-27T15:38:25.000Z

There won't be any casting on NULL to an empty string for the reasons @tag
states.

I am not sure why there is an issue with Twig, but a number of users have
reported it as being a recursive call triggering it.

Unfortunately I have never experienced this bug despite using both Idiorm
and Twig in projects so I have been unable to observe it.

Answer 4 · 2014-02-27T15:41:03.000Z

I'll try to create a simple project where the problem arises.

Answer 5 · 2014-02-27T15:57:29.000Z

I use Twig as well, and for various design reasons haven't encountered this error. Off the top of my head, I wonder whether a custom Twig filter might help with the issue as well.

Answer 6 · 2014-02-28T09:07:52.000Z

This is a thread where there is the same problem.

This solution is a little forced.

The real problem is that the application crashes when you try to access to that field via twig. Even a simple check to see if the variable is defined leads to a crash.

I created this project to reproduce the same issue. Check it and the instructions in README.md.

Answer 7 · 2014-03-12T13:13:11.000Z

Hi,

Same issue here :(

Answer 8 · 2014-04-26T13:44:45.000Z

Thank you for all the effort you have put in here. Does anyone have any time to put together a pull request that fixes this issue? I am struggling to find the time to test this out.