Hello, just doing some preliminary testing on version 7. When you bulk update content (e.g. select multiple nodes for "Publish selected content" as example), it returns an error:

•Notice: Undefined offset: 1 in nodehierarchy_views_update() (line 191 of U:\xampp\htdocs\sites\all\modules\nodehierarchy\nodehierarchy_views\nodehierarchy_views.module).
•PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'nh_children_view_display' cannot be null: INSERT INTO {nodehierarchy_views} (nid, nh_children_view, nh_children_view_display) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => 8 [:db_insert_placeholder_1] => nodehierarchy_children_list [:db_insert_placeholder_2] => ) in nodehierarchy_views_update() (line 198 of C:\xampp\htdocs\sites\all\modules\nodehierarchy\nodehierarchy_views\nodehierarchy_views.module).

Changing different update options (e.g. “Promote selected content to front page”) still throws this error.

Cheers!

Comments

mattez’s picture

StatusFileSize
new46.97 KB
new25.29 KB

+1 subscribing

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /en/batch?id=16&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'nh_children_view_display' cannot be null: INSERT INTO {nodehierarchy_views} (nid, nh_children_view, nh_children_view_display) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => 23 [:db_insert_placeholder_1] => nodehierarchy_children_list [:db_insert_placeholder_2] => ) in nodehierarchy_views_update() (line 198 of .../sites/all/modules/nodehierarchy/nodehierarchy_views/nodehierarchy_views.module).
mattez’s picture

StatusFileSize
new54.88 KB
new14.01 KB

+1 similar issue when editing (add/delete img) custom field (multiple image field) content in @ node/*/edit
Setup:
- Multilingual site (2 languages, i18n enabled)
- image field (synchronized on translation)
it shows this error only for admin (uid=1), when I'm logged as another user with edit privileges it works IMHO fine (strange):

Notice: Undefined offset: 1 in nodehierarchy_views_update() (line 191 of .../sites/all/modules/nodehierarchy/nodehierarchy_views/nodehierarchy_views.module).
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'nh_children_view_display' cannot be null: INSERT INTO {nodehierarchy_views} (nid, nh_children_view, nh_children_view_display) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => 13 [:db_insert_placeholder_1] => nodehierarchy_children_list [:db_insert_placeholder_2] => ) in nodehierarchy_views_update() (line 198 of .../sites/all/modules/nodehierarchy/nodehierarchy_views/nodehierarchy_views.module).

provisional SOLUTION in this case (not for prew post) is to turn off translate synchronization for that image field. Then works OK.

Anonymous’s picture

I'm getting the error to. How do I fix it?
Nobody a solution for this problem?

I removed all extra modules not required by Node Hierarchy, but still the same problem.
Starting to get crazy, I would love to use Drupal 7 for my new intranet.

But without this functionality it has to be Drupal 6...

Lot's off the problems solft, like multi-parent, but still a problem with the views, when this is enabled I can't make new child nodes, but I can still edit existing nodes.

At the moment I turn the function off when I wound to add nodes en turn it back on when I'm done...

ronan’s picture

Status: Active » Closed (duplicate)
divined’s picture

..\modules\nodehierarchy\nodehierarchy_views\nodehierarchy_views.module
-191;+191
-list($view, $display) = explode(':', $node->nh_children_view);
+@list($view, $display) = explode(':', $node->nh_children_view);