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 v.vid AS vid FROM {taxonomy_vocabulary} v WHERE (v.module = :db_condition_placeholder_0) AND (v.vid IN ()) ; Array ( [:db_condition_placeholder_0] => nodeorder ) in nodeorder_can_be_ordered() (line 591 of /modules/nodeorder/nodeorder.module).

version = "7.x-1.0"

Seems to be working after I added a couple square brackets on line 582.- nodeorder.module

foreach ($field['settings']['allowed_values'] as $allowed_values) {
        $nodeorder_vocabularies = $allowed_values['vocabulary'];
}

to

foreach ($field['settings']['allowed_values'] as $allowed_values) {
        $nodeorder_vocabularies[] = $allowed_values['vocabulary'];
}

Anyone see any issue with doing this?

Comments

mgifford’s picture

valthebald’s picture

Status: Active » Fixed

You're right, square brackets are necessary. Patch committed to 7.x-1.x
Thank you!

Status: Fixed » Closed (fixed)

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

Anonymous’s picture

Issue summary: View changes

edit