I'm using Drupal 7.0-alpha 5 and I'm getting this error when trying to add a group to a node:

PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'sa_update' at row 1: INSERT INTO {simple_access_node} (nid, gid, sa_view, sa_update, sa_delete) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array ( [:db_insert_placeholder_0] => 10 [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => [:db_insert_placeholder_4] => ) in simple_access_node_save() (line 254 of /srv/www/xxxx/public_html/sites/all/modules/simple_access/simple_access.module).

Comments

gordon’s picture

gordon commented
Status: Active » Fixed

Thanks this is now fixed in dev.

jmcsweet’s picture

jmcsweet commented

I applied the patches and it's working well. Thanks so much for your work.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

aaronpbrown’s picture

aaronpbrown commented
Status: Closed (fixed) » Needs review

I got the same error, but I repasted it in case there is any variation

The website encountered an unexpected error. Please try again later.

PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'sa_update' at row 1: INSERT INTO {simple_access_node} (nid, gid, sa_view, sa_update, sa_delete) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array ( [:db_insert_placeholder_0] => 17 [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => [:db_insert_placeholder_4] => ) in simple_access_node_save() (line 254 of /var/www/vhosts/winhoodhomes.com/httpdocs/drupal/sites/all/modules/simple_access/simple_access.module).

simon georges’s picture

simon georges commented
Status: Needs review » Needs work

Closing #898530: Can't attach group to node... as a duplicate of this one.

gordon’s picture

gordon commented
Status: Needs work » Closed (duplicate)

  • Commit a0acc42 on master, 8.x-3.x by gordon: 
    #825494 by artisanfitness: Fixed Error When adding a Group to a Node.