Subscriptions quotes nid, breaks in PostgreSQL.

PMunn - February 27, 2007 - 03:53
Project:Subscriptions
Version:5.x-1.x-dev
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:closed
Description

The dev version of subscriptions 5.x-1.x-dev is selecting NIDs improperly, at least it breaks in PostgreSQL. Taxonomy does this right:

taxonomy/taxonomy.module:  db_query('DELETE FROM {term_node} WHERE nid = %d', $n
id);

But the subscriptions module is doing it wrong:
subscriptions/subscriptions.module:  $result = db_query('SELECT tid FROM {term_n
ode} WHERE nid = "%s"', $nid);

This patch fixes this by changing the latter to match the former, fixing the bug.

AttachmentSize
subscriptions_module_20070226_extraquotes.patch497 bytes

#1

arthurf - February 27, 2007 - 06:42
Status:needs review» fixed

Thanks for pointing this out, this is now fixed in cvs.

#2

Anonymous - March 13, 2007 - 06:45
Status:fixed» closed
 
 

Drupal is a registered trademark of Dries Buytaert.