Author |
Topic |
|
peebee
Starting Member
USA
30 Posts |
Posted - March 13 2002 : 12:50:04
|
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-CART New User
United Kingdom
72 Posts |
Posted - July 15 2004 : 00:42:42
|
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.
|
|
|
Sam
Starting Member
USA
16 Posts |
Posted - April 24 2006 : 14:12:49
|
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 |
|
|
Doug Page
VP-CART New User
Canada
85 Posts |
Posted - April 24 2006 : 14:25:16
|
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 |
|
|
Sam
Starting Member
USA
16 Posts |
Posted - April 24 2006 : 14:28:50
|
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. |
|
|
Doug Page
VP-CART New User
Canada
85 Posts |
Posted - April 24 2006 : 14:41:55
|
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 |
|
|
ironhawker
VP-CART Super User
USA
260 Posts |
|
|
Topic |
|