Assets field used in Matrix as a Low Variable doesn't pull information from DB
I have a variable type set to Matrix, and there I have one column set to Assets (default, no multiple selection), other one is simple text. When I submit the form with images selected in Assets, they get written in DB, but after the page is reloaded there are no thumbs/files in Assets. If I submit again the form (after first submit) as Assets field is empty, I overwrite DB values with nothing, so the images get lost.
The same Matrix setup in channel field works fine.
EE 255, Assets 201 Low Variables 232 (Tested it on clean/default install see attach image with only these 3 addons)
I first reported this to P&T (in contact with Lisa). But its better to check with both. Thank you
Replies
Cem Meric 17 Jan 2013 22:49
Same here with the latest versions of everything Assets and Low Variables not playing nice anymore.
Low 17 Jan 2013 23:27
Definitely looks like a P&T issue. Any news from them?
Davor Peic 18 Jan 2013 00:06
No, Lisa from P&T sad that I inform you that they are also working on this. Maybe if you would have some ideas or tips.
The "only" problem I can see is pulling the info from db, as low var save it with no issue. but strange that it works out of low vars.
thanks
Low 18 Jan 2013 10:03
I found the issue within Assets. It has to do with a query getting the files in.
In Assets 2.0.2, open up ft.assets.php and on line #565 change this:
$sql .= " ae.entry_id = '{$entry_id}'AND ae.field_id = '{$this->field_id}'";
...with this:
$sql .= " ae.entry_id ". ($entry_id ? "= '{$entry_id}'" : 'IS NULL'). " AND ae.field_id ". ($this->field_id ? "= '{$this->field_id}'" : 'IS NULL');
And the files should appear again.
Davor Peic 18 Jan 2013 14:17
What can I say.. priceless :)
Thank you Low!
Brandon Kelly 18 Jan 2013 22:02
Thanks Low!
Looks like Andris got this fix in already. It’ll be today’s 2.0.3 release.