Products Admin - Discounts Applied problem

Author	« Topic »
Roger Advanced Member 342 Posts	Posted - 10/07/2017 : 10:50:16 In 6.8.1, on adminprods.asp, trying to determine the products that have a particular discount applied gives a database error. All Discounts works fine, just the individual discounts return the error. Thanks for any input. Roger Edited by - Roger on 10/10/2017 08:26:56
Andy ECT Moderator 95440 Posts	Posted - 10/07/2017 : 11:48:01 Hi Roger Do you mean when clicking on the Assign button or something else? Andy Please feel free to review / rate our software
Roger Advanced Member 342 Posts	Posted - 10/07/2017 : 11:54:10 Hi Andy, on adminprods.asp, choose Discounts Applied from the "look in" drop down, choose any discount but the default All Discounts. That's when I get the error. Thanks, Roger
Andy ECT Moderator 95440 Posts	Posted - 10/07/2017 : 11:56:35 Sorry, should have followed better. I'm not seeing a problem here. What error do you get? Andy Please feel free to review / rate our software
Roger Advanced Member 342 Posts	Posted - 10/07/2017 : 11:58:35 You'll have to click List Products of course. Roger
Roger Advanced Member 342 Posts	Posted - 10/07/2017 : 12:00:37 This just freaky. Here is the error message I get: ***** Sorry, we've had a server error This may be caused by some quick maintenance being done of the database; please be patient. There was a problem with the resource your are looking for and it cannot be displayed. Please return to our home page and use the search function to find the file; sometimes it's just a matter of spelling. **** Haven't bothered to try to determine exactly what the error is so far. Roger
Roger Advanced Member 342 Posts	Posted - 10/07/2017 : 12:12:45 BTW, is this function new? Don't remember seeing it before...but that's not unusual. Roger
Andy ECT Moderator 95440 Posts	Posted - 10/07/2017 : 12:34:27 That's not an error from ECT. Do you still get that message? Andy Please feel free to review / rate our software
Roger Advanced Member 342 Posts	Posted - 10/07/2017 : 12:39:59 Yes, on anything but the default All Discounts. Roger
Andy ECT Moderator 95440 Posts	Posted - 10/07/2017 : 13:16:48 I guess that's a friendly error message coming from the host which is making the real error. Can you ask them if that is the case? What database is the store running off by the way, is it Access? Andy Please feel free to review / rate our software
Roger Advanced Member 342 Posts	Posted - 10/07/2017 : 13:29:07 Here you go: Microsoft JET Database Engine error '80040e14' Syntax error (missing operator) in query expression 'products.pId=multisections.pId INNER JOIN cpnassign ON products.pID=cpnassign.cpaAssignment'. /vsadmin/inc/incprods.asp, line 3150 Roger
Roger Advanced Member 342 Posts	Posted - 10/07/2017 : 13:32:20 Yes, Access. Roger
Andy ECT Moderator 95440 Posts	Posted - 10/07/2017 : 14:33:06 OK, thanks, we'll do some testing and get back to you. Andy Please feel free to review / rate our software
Roger Advanced Member 342 Posts	Posted - 10/07/2017 : 15:42:48 Nothing critical, but very useful. Thanks. Roger
Vince Administrator 42756 Posts	Posted - 10/10/2017 : 07:54:20 Hi Roger I've got a fix for this now and we'll get this into the updater at the next opportunity. Thanks for your patience here. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
Roger Advanced Member 342 Posts	Posted - 10/10/2017 : 08:25:47 No problem. Roger
	« Topic »