Closed (fixed)
Project:
Nodeblock
Version:
7.x-1.3
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
13 Apr 2013 at 08:00 UTC
Updated:
2 May 2013 at 08:00 UTC
Jump to comment: Most recent
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
Comment #1
mudsurfer commentedI 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(....
Comment #2
Anonymous (not verified) commentedsubscribe
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).
Comment #3
kpm commentedsubscribing... I got the same error
Comment #4
Johnny vd Laar commentedAh 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).
Comment #5
Johnny vd Laar commentedI've committed a fix here:
http://drupalcode.org/project/nodeblock.git/commitdiff/a572a78
Comment #6
kpm commentedThank you Johnny vd Laar!
A quick question though... does this mean that we should install the dev version or apply a patch?
Comment #7
Johnny vd Laar commentedYou can do both. If you report that the patch works then I will release a new nodeblock version.
Comment #8
tonyyarusso commentedPatch works for me.
Comment #9
WillieWalker commentedPatch worked fine :)
Comment #10
thorn commentedWorks fine.
Comment #11
kpm commentedI 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.
Comment #12
Johnny vd Laar commentedMarking this as fixed.