XF 2.2 Bulk update error

[SAS1024]

I tried to update huge count of posts in transaction:

            $finder = \XF::finder( 'XF:Post' );
            $db = \XF::db();

            /** @var Post[] $posts */
            $posts = $finder
                ->where( 'message_state', '=', 'visible' )
                ->fetch();

            // $posts contains over 1000 elements...

            $db->beginTransaction();
            foreach ( $posts as $post ) {
                $post->message = 'some updated message';
                $post->save();
            }
            $db->commit();

But I've got an error:

In Entity.php line 215:

  Unknown column

What going wrong? Where is my mistake? Please, help me to resolve this issue.

 

[NikitOS]

Please give the full text of the error.

 

[SAS1024]

@NikitOS it was full text of the error.
I've solved my issue by using raw db layer without entities.