Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 Problems and bugs
 Crosseling products
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

borisvel
Starting Member

Slovenia
47 Posts

Posted - December 18 2011 :  09:21:44  Show Profile  Visit borisvel's Homepage  Reply with Quote
Hi,

if crosseling is enabled ( vp asp version 6.094 ), than it works in Chrome browser, but doesn't works in IE 9.0. Error message:

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'catalogid in ( ) and hide=0 and cstock> 0'.
/shopproductsubs.asp, line 1705


Browser Type:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/5.0; SLCC1; .NET CLR 2.0.50727; InfoPath.1; .NET4.0C; .NET CLR 3.0.30729)

Page:
GET /shopexd.asp

Please help.

Thanks and kind regards, Boris


diegomilito
VP-CART Expert

Argentina
779 Posts

Posted - December 20 2011 :  03:52:46  Show Profile  Reply with Quote
can u willing to show me your site url for the page that have cross sell ? i want to look at it before assume anything.

Diego
Go to Top of Page

borisvel
Starting Member

Slovenia
47 Posts

Posted - December 20 2011 :  05:40:14  Show Profile  Visit borisvel's Homepage  Reply with Quote
Hi,

i found error.:

file: shopfileio.asp

line 1145

FindInDatabase "CROSSSELLING", strcrossProductids, fieldtype, rc, parsearray


Just one S to mach...

Kind regards, Boris
Go to Top of Page

borisvel
Starting Member

Slovenia
47 Posts

Posted - December 22 2011 :  04:58:55  Show Profile  Visit borisvel's Homepage  Reply with Quote
Hi,
please ignore my previous explanation, IT'S WRONG.

There must be 3 SSS....

Problem was in SPACE character i have in Crossselling field in PRODUCTS table. I removed it and now it works fine.

Sorry for previous mistake.

Kind regards, Boris
Go to Top of Page

diegomilito
VP-CART Expert

Argentina
779 Posts

Posted - January 14 2012 :  02:28:50  Show Profile  Reply with Quote
boris, looks you have solved yourself. That's good!

enjoy weekend! and im going to play golf on this weekend.

Diego
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00