VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Problems and bugs
 Problems!!! Somebody HELP!
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

peebee
Starting Member

USA
30 Posts

Posted - March 13 2002 :  12:50:04  Show Profile  Reply with Quote
We fixed our database problems with read and write.
But we ran into some other difficulties. It worked great before but for some odd reason it stopped. This is the problem:

Microsoft JET Database Engine error '80040e14'

Syntax error in ORDER BY clause.

/shopping/shop$db.asp, line 424

This is what's on line 424 in shop$db.asp

if getconfig("xdebug")="Yes" then
DebugWrite mysql
end if
rstemp.Open MYSQL,dbc,adOpenKeyset,adLockReadOnly, adCmdText
if not rstemp.eof then
rstemp.movefirst
rstemp.pagesize=mypagesize
maxpages=cint(rstemp.pagecount)
maxrecs=cint(rstemp.pagesize)
rstemp.absolutepage=mypage
end if
end sub

What is it that we need to change?

Thank you for a prompt response.



jackbox
VP-ASP New User

United Kingdom
72 Posts

Posted - July 15 2004 :  00:42:42  Show Profile  Visit jackbox's Homepage  Reply with Quote
We ran into problems with xproductperpage being changed (no idea why)to "Yes" instead of a number. In short, cart sits there expecting instructions on how many products to display and gets er...."Yes" - hence error. Check you configuration.

Go to Top of Page

Sam
Starting Member

USA
16 Posts

Posted - April 24 2006 :  14:12:49  Show Profile  Visit Sam's Homepage  Reply with Quote
This and the other response from another user regarding this issue both prove to be unhelpful fixing this very same problem that we are having. Support has not responded to this issue so one must assume that they are unable/unwilling to fix this problem since it is now more than 4 years old.

Support may be open 20 hours per day (and 16 hours on weekends, WOOHOO!) but if they do not solve problems they may as well be closed permanently. 4 years for a response. Are you kidding me?

Edited by - Sam on April 24 2006 14:13:31
Go to Top of Page

Doug Page
VP-ASP New User

Canada
85 Posts

Posted - April 24 2006 :  14:25:16  Show Profile  Reply with Quote
Sam,

You did post this very important problem of yours to the HELPDESK!

This is a USER forum that support will shime in on but if you are having a serious problem you should contact them directly.

Bet you they can fix the problem quickly once they have a little more info from you.

Edited by - Doug Page on April 24 2006 14:26:17
Go to Top of Page

Sam
Starting Member

USA
16 Posts

Posted - April 24 2006 :  14:28:50  Show Profile  Visit Sam's Homepage  Reply with Quote
Actually, I DIDN'T post this to the help desk because I do not have any points nor am I willing to buy any for the simple fact that I feel that the level of support shown here leaves a lot to be desired.

Four years without a response from Support on this issue. Most companies would go out of business with this level of service.
Go to Top of Page

Doug Page
VP-ASP New User

Canada
85 Posts

Posted - April 24 2006 :  14:41:55  Show Profile  Reply with Quote
Sam,

It was only ONE incidence from the same person that you are mentioning. And they only made messages on two days. I bet their problem was fixed but they never came back to the message board to let everyone else know.

Judging from the other peoples responses, it is probably erroneous data in your database somewhere that is not being interpreted correctly. If you are unable to track it down yourself, you might have to bite the bullet and get the helpdesk to respond. It is my understanding that if there is a problem with the software that they don't charge you for it - makes sense! However, if you leave a message yourself explaining in detail how you arrived at the problem that you are having maybe the rest of us can throw some suggestions your way - many heads being better than one.

Doug
Go to Top of Page

ironhawker
VP-ASP Super User

USA
260 Posts

Posted - April 24 2006 :  16:20:13  Show Profile  Visit ironhawker's Homepage  Reply with Quote
Sometimes when you google an error you might get help in troubleshooting.
http://support.microsoft.com/?kbid=306518
http://www.adopenstatic.com/faq/80040e14.asp
http://www.aspfaqs.com/aspfaqs/ShowCategory.asp?CatID=21
http://www.dmxzone.com/ShowDetail.asp?NewsId=476
http://www.aspfaq.com/show.asp?id=2400
http://www.2enetworx.com/dev/projects/view.asp?ids=4,920,3
So it is a big world with lots of people to help



~-~-~-~-~-~-~-~-~-~
Randy "RC" Corn
[email protected]
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000