The following updates returned messages
nodeblock module
Update #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() (Zeile 193 von ./nodeblock/nodeblock.install).

Comments

mudsurfer’s picture

I got the same error, BUT on update #7102: on updating nodeblock to latest version 7.x-1.3

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 FROM {node} n WHERE (type IN ()) ; Array ( ) in nodeblock_update_7102(....

Anonymous’s picture

subscribe

nodeblock module
Update #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/drupco5/public_html/nmp/htdocs/profiles/openpublish/modules/contrib/nodeblock/nodeblock.install).

kpm’s picture

subscribing... I got the same error

nodeblock module
Update #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 /var/aegir/platforms/openpublish-7.x-1.0-beta7/profiles/openpublish/modules/contrib/nodeblock/nodeblock.install).
Johnny vd Laar’s picture

Ah that means that you don't have any nodeblock enabled content types (I think that you can remove the module anyway as you are not using it).

Johnny vd Laar’s picture

kpm’s picture

Thank you Johnny vd Laar!
A quick question though... does this mean that we should install the dev version or apply a patch?

Johnny vd Laar’s picture

You can do both. If you report that the patch works then I will release a new nodeblock version.

tonyyarusso’s picture

Patch works for me.

WillieWalker’s picture

Patch worked fine :)

thorn’s picture

Works fine.

kpm’s picture

I installed the dev version and error message went away but page load slowed to a crawl. I doubt nodeblock was the cause since I reverted back to the original version, ran db update and error was still gone but page load was still slow... I cleared caches ran cron... still slow... the next day however, things seem back to normal.

Johnny vd Laar’s picture

Status: Active » Fixed

Marking this as fixed.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.