I get the following error message:
PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens: SELECT mlid FROM {menu_links} WHERE link_path LIKE 'node/:nid/mid/%' AND module = :module ; Array ( [:module] => nodesymlinks [:nid] => 75 ) in _nodesymlinks_nodeapi_delete() (Zeile 137 von /PATH/sites/all/modules/nodesymlinks/nodesymlinks.inc).

CommentFileSizeAuthor
#5 1535432-nodesymlinks-cannot-delete-nodes-5.patch767 bytesnsciacca
#2 cant_delete-1535432-2.patch754 bytesmoskito

Comments

Wolfgang Reszel’s picture

Wolfgang Reszel commented

Adding single quotation marks to the query (at :module) will fix it:

  $result = db_query("SELECT mlid FROM {menu_links} WHERE link_path LIKE 'node/:nid /mid/%' AND module = ':module'", array(':module' => 'nodesymlinks', ':nid' => $node->nid));
moskito’s picture

moskito commented
StatusFileSize
new cant_delete-1535432-2.patch754 bytes

Fix in #1 solve it. Here is a patch of it.

moskito’s picture

moskito commented
Status: Active » Needs review

Forgot to change status.

wojtha’s picture

wojtha commented
Status: Needs review » Closed (fixed)

Thanks! Commited.

nsciacca’s picture

nsciacca
She/Her/Hers
Primary language English
commented
Issue summary: View changes
StatusFileSize
new 1535432-nodesymlinks-cannot-delete-nodes-5.patch767 bytes

This didn't work for me, the tokens can't be enclosed in quotes.. not sure if it's a newer database incompatibility. Anyhow, this is a super old issue but in case anyone else runs across it, here's an updated patch