The 2026 Drupal Business Survey is open. Your response will help shape the future of the Drupal business ecosystem.When trying to install the Node Access module, I get the following error:
* user warning: BLOB/TEXT column 'permissions' can't have a default value query: CREATE TABLE user_relationship_node_access ( `nid` int(10) unsigned NOT NULL default 0, `permissions` text NOT NULL default '', PRIMARY KEY (nid) ) /*!40100 DEFAULT CHARACTER SET utf8*/ in C:\Web\site\drupal\includes\database.mysql.inc on line 172.
* The installation of the User Relationship Private Nodes module as unsuccessful.
* user warning: Table 'drupal.user_relationship_node_access' doesn't exist query: SELECT permissions FROM user_relationship_node_access WHERE nid = 1 in C:\Web\site\drupal\includes\database.mysql.inc on line 172.
* user warning: Table 'drupal.user_relationship_node_access' doesn't exist query: SELECT permissions FROM user_relationship_node_access WHERE nid = 2 in C:\Web\site\drupal\includes\database.mysql.inc on line 172.
* user warning: Table 'drupal.user_relationship_node_access' doesn't exist query: SELECT permissions FROM user_relationship_node_access WHERE nid = 3 in C:\Web\site\drupal\includes\database.mysql.inc on line 172.
* user warning: Table 'drupal.user_relationship_node_access' doesn't exist query: SELECT permissions FROM user_relationship_node_access WHERE nid = 4 in C:\Web\site\drupal\includes\database.mysql.inc on line 172.
* user warning: Table 'drupal.user_relationship_node_access' doesn't exist query: SELECT permissions FROM user_relationship_node_access WHERE nid = 5 in C:\Web\site\drupal\includes\database.mysql.inc on line 172.
* user warning: Table 'drupal.user_relationship_node_access' doesn't exist query: SELECT permissions FROM user_relationship_node_access WHERE nid = 6 in C:\Web\site\drupal\includes\database.mysql.inc on line 172.
* user warning: Table 'drupal.user_relationship_node_access' doesn't exist query: SELECT permissions FROM user_relationship_node_access WHERE nid = 7 in C:\Web\site\drupal\includes\database.mysql.inc on line 172.
* user warning: Table 'drupal.user_relationship_node_access' doesn't exist query: SELECT permissions FROM user_relationship_node_access WHERE nid = 16 in C:\Web\site\drupal\includes\database.mysql.inc on line 172.
* user warning: Table 'drupal.user_relationship_node_access' doesn't exist query: SELECT permissions FROM user_relationship_node_access WHERE nid = 19 in C:\Web\site\drupal\includes\database.mysql.inc on line 172.
* user warning: Table 'drupal.user_relationship_node_access' doesn't exist query: SELECT permissions FROM user_relationship_node_access WHERE nid = 20 in C:\Web\site\drupal\includes\database.mysql.inc on line 172.
This page http://drupal.org/node/115869 indicates that a TEXT column cannot have a default value on MySQL under Windows. I removed default '' for the permissions column and the module installed properly. Not sure how this affects Linux installations or actual module logic.
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | user_relationship_node_access.install.272576.patch | 1.1 KB | jaydub |
| #2 | user_relationship_node_access-d6.module.272676.patch | 973 bytes | jaydub |
Comments
Comment #1
Roman S commentedFurthermore, uninstalling the node access module leaves the node_access table in an inconsistent state. I had to click Administer -> Content management -> Post settings -> Rebuild permissions to fix it. Otherwise new nodes were not accessible by users (other than UID 0).
Comment #2
jaydub commentedYes it's true regardless of Win/Linux/other with MySQL you should not set DEFAULT values for TEXT columns. See these pages on d.o.:
Settings to 6.x as it appears in that branch as well.
http://drupal.org/node/190504
http://drupal.org/node/159330
http://drupal.org/node/159333
http://drupal.org/node/146939
Comment #3
jaydub commentedComment #4
jaydub commentedFixed in CVS