Forum: MarketPlace Customers


Subject: Could be me, but not sure..

MadMac420 opened this issue on Sep 21, 2001 ยท 2 posts


MadMac420 posted Fri, 21 September 2001 at 8:38 PM

When going into the profile of any specific product, where it normally displays what other products customers have bought I am getting flooded with SQL query errors. I say it could be me because my roomate decided to be a nice guy and update my computer with IE6 when I wasn't around, and I've been having weird happenings at the renderosity and daz store since. I've also tried using Netscape 4.06 with the same results. Sample error dump: SQL Query Error: You have an error in your SQL syntax near '.username, softgood.username2, softgood.username3 FROM purchase LEFT JOIN ' at line 5 Query was: SELECT purchase2.softgoodid, purchase2.name, count(purchase2.softgoodid) as count, softgood.thumb, softgood.thumbwidth, softgood.thumbheight, purchase2.softgoodid softgood.username, softgood.username2, softgood.username3 FROM purchase LEFT JOIN purchase AS purchase2 ON purchase.username = purchase2.username LEFT JOIN softgood ON purchase2.softgoodid = softgood.softgoodid WHERE purchase.softgoodid=272 AND purchase2.softgoodid <> 272 AND softgood.approved = 'Y' GROUP BY purchase2.softgoodid ORDER BY count desc LIMIT 4