When running through the Drupal database update, I have one update hung that cannot get completed. I tried to locate this bug elsewhere but could not, so I will post it here. Here is the error report after running the database update:

The following updates returned messages

nodeblock moduleUpdate #7103

Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1: SELECT n.nid AS nid, n.title AS title FROM {node} n WHERE (type IN ()) ; Array ( ) in nodeblock_update_7103() (line 193 of /home/useracct/public_html/profiles/openpublish/modules/contrib/nodeblock/nodeblock.install).

EDIT: I found a fix here and it seemed to work: http://drupalcode.org/project/nodeblock.git/commitdiff/a572a78

Comments

stevehal’s picture

I found this update in the Drupal distribution that appears to fix this issue.

http://drupalcode.org/project/nodeblock.git/commitdiff/a572a78

Also see http://drupal.org/node/1969378

stevehal’s picture

Issue summary: View changes

Found an update that appears to repair this issue.

josephcheek’s picture

Issue summary: View changes
Status: Active » Closed (fixed)

OP now includes nodeblock 1.4 which already has this fix.