An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=25&op=do StatusText: error ResponseText: PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'protected_node_is_protected' at row 1: INSERT INTO {protected_nodes} (protected_node_is_protected, protected_node_passwd, protected_node_show_title, nid, protected_node_hint) 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] => [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => 0 [:db_insert_placeholder_3] => 557 [:db_insert_placeholder_4] => ) in _protected_node_save() (line 718 of foo/protected_node.module).

nodes are without protection ...

Comments

sachbearbeiter’s picture

sachbearbeiter commented
Priority: Normal » Major 
An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: /system/ajax
StatusText: error
ResponseText: PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'protected_node_is_protected' at row 1: INSERT INTO {protected_nodes} (protected_node_is_protected, protected_node_passwd, protected_node_show_title, nid, protected_node_hint) 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] => 
[:db_insert_placeholder_1] => 
[:db_insert_placeholder_2] => 0
[:db_insert_placeholder_3] => 455
[:db_insert_placeholder_4] => 
)
in _protected_node_save() (line 734 of foo/protected_node/protected_node.module).

together with editable fields ...

ytsurk’s picture

ytsurk
Location Switzerland
commented

i got the same error

PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'protected_node_is_protected' at row 1: INSERT INTO {protected_nodes} (protected_node_is_protected, protected_node_passwd, protected_node_show_title, nid, protected_node_hint) 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] => [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => 0 [:db_insert_placeholder_3] => 2 [:db_insert_placeholder_4] => ) in _protected_node_save() (Zeile 748 von XXX/drupal/sites/all/modules/protected_node/protected_node.module).

when saving a node in a copied drupal instance with protected-node. in the 'original' i don't get this error.

changing

'protected_node_is_protected' => FALSE,

to

'protected_node_is_protected' => 0,

in protected_node.module Line:770
solved the problem.

sachbearbeiter’s picture

sachbearbeiter commented

thanks - i will try ...

acke’s picture

acke commented

There's a patch in this issue: https://drupal.org/node/1757742

izus’s picture

izus commented
Issue summary: View changes
Status: Active » Closed (duplicate)

issue mentionned in #4 is fixed, and so is this one :)
Thanks