Tue, Nov 26, 6:29 AM CST

Renderosity Forums / MarketPlace Customers



Welcome to the MarketPlace Customers Forum

Forum Moderators: tim, msansing, ebasham

MarketPlace Customers F.A.Q (Last Updated: 2024 Nov 25 8:06 am)

Contact and Support Information:

To reach our Marketplace staff, please open a support ticket at
support.renderosity.com

Our goal is to respond to support tickets within 24 hours, 7 days a week.



Subject: Could be me, but not sure..


MadMac420 ( ) posted Fri, 21 September 2001 at 8:38 PM · edited Wed, 13 November 2024 at 8:52 AM

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


rcook ( ) posted Sat, 22 September 2001 at 12:44 AM

Thanks for pointing this out. It was a small error in an SQL query affecting the "Related Purchases" list at the bottom of the page. Annoying for sure, but not a serious problems. Thanks again, Russell


Privacy Notice

This site uses cookies to deliver the best experience. Our own cookies make user accounts and other features possible. Third-party cookies are used to display relevant ads and to analyze how Renderosity is used. By using our site, you acknowledge that you have read and understood our Terms of Service, including our Cookie Policy and our Privacy Policy.