Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.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 ')) AND (cid = '1') ORDER BY nid ASC' at line 2: SELECT webform_component.* FROM {webform_component} webform_component WHERE (nid IN ()) AND (cid = :db_condition_placeholder_0) ORDER BY nid ASC; Array ( [:db_condition_placeholder_0] => 1 ) en webform_localization_component_get_translations() (línea 44 de webform_localization/includes/webform_localization.component.sync.inc).
Will post a patch asap.
Marked as "major" because it is not possible to update a webform node configured for content translation/sync, but does not have a translated node yet. It's just rthe first node in a translation set, and fails.
| Comment | File | Size | Author |
|---|---|---|---|
| #11 | webform_localization-2396007-11.patch | 2.09 KB | joseph.olstad |
Comments
Comment #1
markus_petrux commentedComment #2
markus_petrux commentedBTW, before that error, a PHP warning is also generated:
The patch will fix this as well. Reported here for easy reference.
Comment #3
markus_petrux commentedComment #5
joseph.olstadrun test
Comment #7
joseph.olstadsimpletest needs a new file to process, same patch, different filename.
Comment #8
joseph.olstadlooks like similar or related , might be same issue
Comment #10
joseph.olstadis this still an issue for people out there? I haven't yet taken the time to properly test this and reproduce the issue.
Comment #11
joseph.olstadComment #12
joseph.olstadCan someone please confirm if this is still an issue? I know the patch is passing, but no one has commented any feedback about this saying if this is helping them or not.
Comment #13
joseph.olstadNo one has commented on this issue in over a month, therefore it is probably safe to say that this is a duplicate of "#2397109: Invalid argument supplied for foreach() in webform_localization.module line 195 when no translations available"
Comment #14
kybermanI don't think this is a duplicate of #2397109 because that issue solves only deleting and it didn't help with this issue. I still have the same problems with 7.x-4.2 and 7.x-4.x-dev for the same conditions as it was reported by markus_petrux. The #11 patch helped a lot, thanks!
Comment #15
joseph.olstadThanks to markus_petrux for his great work on the initial patch and also to kyberman for confirming fix.