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