order management plug in error
Printed From: SalesCart
Category: Legacy Products
Forum Name: SalesCart Standard / PRO / SQL
Forum Description: All questions pertaining to SalesCart Standard, PRO and SQL should be posted here.
URL: http://forum.salescart.com/forum/forum_posts.asp?TID=287
Printed Date: November/24/24 at 6:53am
Software Version: Web Wiz Forums 11.04 - http://www.webwizforums.com
Topic: order management plug in error
Posted By: jenny
Subject: order management plug in error
Date Posted: January/27/05 at 11:20am
Hi, I am trying to use my online order management plug in at http://www.teasemetoys.com/online/default.asp and I received the following error when trying to manage my orders or any other function of the management plug in:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/online/3_showall.asp, line 251
The error occurs when I choose my dates of retrieval and I hit the retrieve button.
Any help appreciated.
Thanks,
Jenny
|
Replies:
Posted By: MelodyB
Date Posted: January/28/05 at 11:15am
That error means that you trying to pull out information in a database table that doesn't exist.
If memory serves me correct, the database stores dates as mm/dd/yy but the Online Order system's default is mm/dd/yyyy. Get rid of the "20" from the year and it should work.
|
Posted By: jenny
Date Posted: January/28/05 at 8:08pm
Hi,
Thanks for the suggestion but unfortunately it did not work.
|
Posted By: MelodyB
Date Posted: January/29/05 at 11:19am
|
Well - that error means you are trying to view a field in the database that doesn't exist. Have you modified your shop.mdb file at all?
|
Posted By: jenny
Date Posted: February/01/05 at 2:19pm
|
Yes, I did and it worked fine for a few days after that. Then all of the sudden it does not work anymore and my shop.mdb file is completely empty. Is there anyway to restore or fix that?
|
Posted By: MelodyB
Date Posted: February/04/05 at 1:43pm
If your shop.mdb is empty and there aren't any records to pull up - that might be why you are getting the error.
If the database got erased without your knowing about it that would be something you need to take up with your server because something got reverted back.
|
|