Closed (fixed)
Project:
Kelkoo Feed
Version:
6.x-1.1
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
28 Nov 2010 at 08:14 UTC
Updated:
5 Jan 2011 at 05:04 UTC
On line 65 a SQL query is used:
$result = db_query("SELECT node.nid FROM {uc_products} INNER JOIN {node} ON uc_products.nid = node.nid WHERE node.status = 1");
Brackets { } are used only in FROM part of the query. They should be used in all table references in the query, instead. The right sintax is:
$result = db_query("SELECT {node}.nid FROM {uc_products} INNER JOIN {node} ON {uc_products}.nid = {node}.nid WHERE {node}.status = 1");
Comments
Comment #1
netbabu commentedfixed in the release 6.x-1.101
Comment #2
netbabu commented