Closed (fixed)
Project:
Ubercart Marketplace
Version:
5.x-1.0-beta4
Component:
Code
Priority:
Minor
Category:
Bug report
Assigned:
Reporter:
Created:
15 Oct 2008 at 04:11 UTC
Updated:
11 Feb 2010 at 06:20 UTC
in mp_reports.module
search:
$sql_count = "SELECT COUNT(nid) FROM {node} WHERE node.uid = %d AND type IN (". implode(", ", $product_types) .")";
Replace with:
$sql_count = "SELECT COUNT(*) FROM {node} n WHERE n.uid = %d AND type IN (". implode(", ", $product_types) .")";
// The original sql causes this error: Unknown column 'node.uid' in 'where clause' query: SELECT COUNT(nid) FROM tbl_node WHERE node.uid = 1 AND type IN ('product')
We're working on buyout module + ubercart marketplace integration. :) So far it's great. Thanks to Tugrid.
Comments
Comment #1
Turgrid commentedThanks for reporting the issue and presenting a potential fix. I will look into this and commit it to the next release of Marketplace. Good luck with your module integration. I would love to hear how it turns out for you. Thanks.
Comment #2
syndicateStorm commentedI just confirmed this was fixed on Nov. 8, 2008 by Turgrid. It is included in the 5.x-1.0-beta5 release as well as the 6.x dev release.