Syntax Error on SQL Queries

Hello,

I have recently updated to 8.x-1.0-beta3 on my site (Drupal 8.6.9).

Prior to this update, I have been using the module without problem to grant write permissions to more than one user on specific nodes.

However, the first time I tried to use it after updating to beta3, whenever I type the user's name and click 'search' in order to find them and then grant the necessary permissions, site crashes with the following error:

(I am trying to grant access to nodes of a specific content type to users of specific role, both of which used to function without problems before).

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int)) WHERE na.nid = '259' AND na.realm = 'nod' at line 1: SELECT count(*) FROM {node_access} na LEFT JOIN {user__roles} r ON (na.gid = CAST(r.roles_target_id as int)) WHERE na.nid = :nid AND na.realm = :realm AND r.entity_id = :uid AND :grant_type = :one LIMIT 0, 1; Array ( [:nid] => 259 [:realm] => nodeaccess_rid [:uid] => 370 [:grant_type] => grant_view [:one] => 1 ) στην Drupal\nodeaccess\Form\GrantsForm->buildForm() (line 127 from /var/www/www-dev/modules/nodeaccess/src/Form/GrantsForm.php).

I read in the release notes that SQL queries were refactored in this beta3 release - could this be the problem?

PS - This is the first issue I post for a drupal module, I am still a newbie - please let me know if I can provide more help and data. I hope this can be resolved, it is an extremely useful module.

.........................
(error details from original issue summary)
.........................

</br></br><em class="placeholder">Drupal\Core\Database\DatabaseExceptionWrapper</em>: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#039;int))
                WHERE na.nid = &#039;359&#039;
                  AND na.realm = &#039;nod&#039; at line 1: 
                SELECT count(*) FROM {node_access} na
                LEFT JOIN {user__roles} r ON (na.gid = CAST(r.roles_target_id as int))
                WHERE na.nid = :nid
                  AND na.realm = :realm
                  AND r.entity_id = :uid
                  AND :grant_type = :one LIMIT 0, 1; Array
(
    [:nid] =&gt; 359
    [:realm] =&gt; nodeaccess_rid
    [:uid] =&gt; 370
    [:grant_type] =&gt; grant_view
    [:one] =&gt; 1
)
 in <em class="placeholder">Drupal\nodeaccess\Form\GrantsForm-&gt;buildForm()</em> (line <em class="placeholder">127</em> of <em class="placeholder">modules/nodeaccess/src/Form/GrantsForm.php</em>). <pre class="backtrace">Drupal\Core\Database\Statement-&gt;execute(Array, Array) (Line: 625)
Drupal\Core\Database\Connection-&gt;query(&#039;
                SELECT count(*) FROM {node_access} na
                LEFT JOIN {user__roles} r ON (na.gid = CAST(r.roles_target_id as int))
                WHERE na.nid = :nid
                  AND na.realm = :realm
                  AND r.entity_id = :uid
                  AND :grant_type = :one LIMIT 0, 1&#039;, Array, Array) (Line: 358)
Drupal\Core\Database\Driver\mysql\Connection-&gt;query(&#039;
                SELECT count(*) FROM {node_access} na
                LEFT JOIN {user__roles} r ON (na.gid = CAST(r.roles_target_id as int))
                WHERE na.nid = :nid
                  AND na.realm = :realm
                  AND r.entity_id = :uid
                  AND :grant_type = :one LIMIT 0, 1&#039;, Array, Array) (Line: 540)
Drupal\Core\Database\Driver\mysql\Connection-&gt;queryRange(&#039;
                SELECT count(*) FROM {node_access} na
                LEFT JOIN {user__roles} r ON (na.gid = CAST(r.roles_target_id as int))
                WHERE na.nid = :nid
                  AND na.realm = :realm
                  AND r.entity_id = :uid
                  AND :grant_type = :one&#039;, 0, 1, Array) (Line: 127)
Drupal\nodeaccess\Form\GrantsForm-&gt;buildForm(Array, Object, Object)
call_user_func_array(Array, Array) (Line: 518)
Drupal\Core\Form\FormBuilder-&gt;retrieveForm(&#039;nodeaccess_grants_form&#039;, Object) (Line: 368)
Drupal\Core\Form\FormBuilder-&gt;rebuildForm(&#039;nodeaccess_grants_form&#039;, Object, Array) (Line: 625)
Drupal\Core\Form\FormBuilder-&gt;processForm(&#039;nodeaccess_grants_form&#039;, Array, Object) (Line: 318)
Drupal\Core\Form\FormBuilder-&gt;buildForm(&#039;nodeaccess_grants_form&#039;, Object) (Line: 93)
Drupal\Core\Controller\FormController-&gt;getContentResult(Object, Object)
call_user_func_array(Array, Array) (Line: 123)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber-&gt;Drupal\Core\EventSubscriber\{closure}() (Line: 582)
Drupal\Core\Render\Renderer-&gt;executeInRenderContext(Object, Object) (Line: 124)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber-&gt;wrapControllerExecutionInRenderContext(Array, Array) (Line: 97)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber-&gt;Drupal\Core\EventSubscriber\{closure}() (Line: 151)
Symfony\Component\HttpKernel\HttpKernel-&gt;handleRaw(Object, 1) (Line: 68)
Symfony\Component\HttpKernel\HttpKernel-&gt;handle(Object, 1, 1) (Line: 57)
Drupal\Core\StackMiddleware\Session-&gt;handle(Object, 1, 1) (Line: 47)
Drupal\Core\StackMiddleware\KernelPreHandle-&gt;handle(Object, 1, 1) (Line: 99)
Drupal\page_cache\StackMiddleware\PageCache-&gt;pass(Object, 1, 1) (Line: 78)
Drupal\page_cache\StackMiddleware\PageCache-&gt;handle(Object, 1, 1) (Line: 47)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware-&gt;handle(Object, 1, 1) (Line: 52)
Drupal\Core\StackMiddleware\NegotiationMiddleware-&gt;handle(Object, 1, 1) (Line: 23)
Stack\StackedHttpKernel-&gt;handle(Object, 1, 1) (Line: 693)
Drupal\Core\DrupalKernel-&gt;handle(Object) (Line: 19)