After I enabled the subsite access control, I get "The content access permissions need to be rebuilt." I tried to rebuild it, but then I got this.
An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /mysite/batch?id=153&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'grant_update' at row 1: INSERT INTO {node_access} (nid, realm, gid, grant_view, grant_update, grant_delete) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5), (:db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11), (:db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17), (:db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23), (:db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29), (:db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35); Array ( [:db_insert_placeholder_0] => 21 [:db_insert_placeholder_1] => subsites_view_featured_slider [:db_insert_placeholder_2] => 0 [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => 21 [:db_insert_placeholder_7] => subsites_update_featured_slider [:db_insert_placeholder_8] => 0 [:db_insert_placeholder_9] => 1 [:db_insert_placeholder_10] => 1 [:db_insert_placeholder_11] => [:db_insert_placeholder_12] => 21 [:db_insert_placeholder_13] => subsites_delete_featured_slider [:db_insert_placeholder_14] => 0 [:db_insert_placeholder_15] => 1 [:db_insert_placeholder_16] => [:db_insert_placeholder_17] => 1 [:db_insert_placeholder_18] => 21 [:db_insert_placeholder_19] => subsites_view_own_featured_slider_0 [:db_insert_placeholder_20] => 1 [:db_insert_placeholder_21] => 1 [:db_insert_placeholder_22] => [:db_insert_placeholder_23] => [:db_insert_placeholder_24] => 21 [:db_insert_placeholder_25] => subsites_update_own_featured_slider_0 [:db_insert_placeholder_26] => 1 [:db_insert_placeholder_27] => 1 [:db_insert_placeholder_28] => 1 [:db_insert_placeholder_29] => [:db_insert_placeholder_30] => 21 [:db_insert_placeholder_31] => subsites_delete_own_featured_slider_0 [:db_insert_placeholder_32] => 1 [:db_insert_placeholder_33] => 1 [:db_insert_placeholder_34] => [:db_insert_placeholder_35] => 1 ) in node_access_write_grants() (line 3392 of mysite\modules\node\node.module).
Things go back to normal again after I disable the subsite access control
Comments
Comment #1
gislePostponing all Subsites Access Control issues until the main module has been successfully upgraded to Drupal 7.
Comment #2
chunty commentedIf this is causing you problems see my comment here: https://www.drupal.org/node/800880#comment-10799684
Seemed to fix the rebuilding issue for me - yet to see if this actually does permissions correctly cos this D7 upgrade is taking me ages!