There was a recent change in the 5.x-2.3 to 5.x-2.4 versions that changed the SQL from checking for trid (5.x-2.3) verses now checking for trid IS NOT NULL (5.x-2.4). I think that the proper check is trid <> 0 but since it's currently looking for NULL, I've put together a patch that looks for 0 and NULL.

CommentFileSizeAuthor
notnull.patch1.85 KBdouggreen

Comments

owen barton’s picture

owen barton commented
Status: Needs review » Reviewed & tested by the community

I can reproduce this problem and the attached patch fixes it.

fall_0ut’s picture

fall_0ut commented

I reproduce the same problem and this patch fixed.

Thanks

scb’s picture

scb commented

Agreed. I've had the same problem, and testing for trid<>0 fixes it. RTBC, IMO.

add1sun’s picture

add1sun commented

Yep, bit by the same bug and came up with the same solution. Still RTBC.

nedjo’s picture

nedjo
he/him/his
Primary language English
commented

I marked [#/289502] a duplicate. That patch removed the IS NOT NULL.

jose reyero’s picture

jose reyero commented
Status: Reviewed & tested by the community » Fixed

Applied the patch, just in case anyone still using this version. Thanks.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.