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

netbabu’s picture

Status: Active » Fixed

fixed in the release 6.x-1.101

netbabu’s picture

Status: Fixed » Closed (fixed)