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
Comment #1
stevehal commentedI 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
Comment #1.0
stevehal commentedFound an update that appears to repair this issue.
Comment #2
josephcheekOP now includes nodeblock 1.4 which already has this fix.