When submitting a node (that has a taxonomy field), the following error appears:

PDOException: SQLSTATE[HY093]: : SELECT v.vid AS vid FROM {taxonomy_vocabulary_node_type} vnt JOIN {taxonomy_vocabulary} v ON vnt.vid = v.vid WHERE vnt.type = :vnt.type AND v.module = :v.module; Array ( [:vnt.type] => product [:v.module] => nodeorder ) in nodeorder_can_be_ordered() (line 571 of [...]/sites/all/modules/nodeorder/nodeorder.module).

As I see, the problem is that there is no 'taxonomy_vocabulary_node_type' table in D7. (D7 has no taxonomy-node relation, it uses fields instead)

    $sql = "SELECT v.vid AS vid FROM {taxonomy_vocabulary_node_type} vnt JOIN {taxonomy_vocabulary} v ON vnt.vid = v.vid WHERE vnt.type = '%s' AND v.module = 'nodeorder'";
    $result = db_query("SELECT v.vid AS vid FROM {taxonomy_vocabulary_node_type} vnt JOIN {taxonomy_vocabulary} v ON vnt.vid = v.vid WHERE vnt.type = :vnt.type AND v.module = :v.module", array(':vnt.type' => $node->type, ':v.module' => 'nodeorder'));

Am I missing something? It seems, this module doesn't work on Drupal 7 at all (I've tried the latest -aplha2 and -dev code).

Regards,
Roland

Comments

valthebald’s picture

Version: 7.x-1.0-alpha2 » 7.x-1.x-dev
Status: Active » Needs review

Please check if the problem persists in the current 7.x-1.x

roland.molnar’s picture

Version: 7.x-1.x-dev » 7.x-1.2
Status: Needs review » Closed (fixed)