Relationship-based permissions - give sql error - 5.2.2.0

Since an update to version 5.2.2.0

There is a problem with the relationship-base permissions. Whenever I use any of them the list view does not load, just gives "Error in SQL Query ListView=18338"


Following error code shows up in de system logs;

Error in SQL Query ListView=18338

SELECT COUNT(*) FROM (SELECT A.OBJ_ID FROM RB_OBJ_DATA A LEFT OUTER JOIN RB_RELATIONSHIP Q ON Q.OBJ1_ID=A.OBJ_ID WHERE A.OBJ_DEF_ID=17441 AND (( A.CREATED_BY=36015 ) OR (Q.OBJ2_ID=36015 AND Q.RELATIONSHIP_ID=17954 AND )) )

The last bit seems the problem there is nothing following the last AND.


Anything I can do, besides making views circumventing this issue?

Continue reading...