Metadata error if editing more than one item

Squiz Matrix Support
1

Running 3.12.0 in our dev environment. Using a number of metadata items, 3 schemas, 14 fields in total.


I can edit/update any one item of my choosing (and can edit it multiple times). But if I attempt to edit a second item, either at the same time or subsequently I get the following error:

[quote]MySource Error

File: [SYSTEM_ROOT]/core/include/assertions.inc Line: 508

Message: [ASSERT EXCEPTION] DB Error: unknown errorDELETE FROM

sq_ast_mdata_val

WHERE

assetid = '313' AND fieldid NOT IN (115,128) [nativecode=ERROR: IN types character varying and integer cannot be matched] (LINE 616 IN [SYSTEM_ROOT]/core/include/metadata_manager.inc) [SYS0270]

Backtrace: Show[/quote]

2

I believe this was fixed. The problem is the unquoted asset IDs in the IN clause. The latest 3.12 version is 3.12.8, so you should upgrade to that.

3

Thanks Greg, will get my system admin to do that for me shortly.