Results 1 to 3 of 3

Strange results when testing...HELP

This is a discussion on Strange results when testing...HELP within the osCommerce 2.2 Installation Help forums, part of the osCommerce 2.2 Forums category; Greetings- So, i browse around and add one item to my cart. I proceed thru the entire checkout process and ...

      
  1. #1
    Member sheikyerbouti's Avatar
    Join Date
    Oct 2002
    Posts
    45
    Rep Power
    0


    Default Strange results when testing...HELP

    Greetings-

    So, i browse around and add one item to my cart. I proceed thru the entire checkout process and everything looks great. I get the order confirmation page and then i continue shopping.....

    Here's the problem: When i go to the administrative side of things (because i was showing my client how she will check orders and process them) it shows not one but TWO orders placed at the very same time. The first one that is listed in the line items there shows for the item and amount that i placed the order. Beneath that is another order (placed at exactly the same time on the same day) but the "Order Total" amount is like 3 times the actual product i ordered. I can click on each of the two different items there (orders) and the page that i get is exactly the same.

    It lists the product i ordered, the price is correct ($39.50), but then as i move down the page i get a sub-total that is $171.32, another subtotal line beneath that that shows $39.50 (that sounds right), tax $4.83 but i have tax set up to charge only for in-state purchases and i set this "customer" to be shipped out of state, another tax line reading $0.00, then two versions of Best Way (shipping), one for $8.75 and one for $6.00. I get two "Total" lines beneath that, one for $180.07 and the correct one for this order of $45.50 (my $39.50 product and the $6 shipping charge.

    Can anyone tell me why this thing is coming up with two different orders when i only placed one order? And why does the appropriate order show up PLUS one for three times the accurate amount?

    That was really embarassing to sit down with the client as we're about to launch the cart and have this major mishap! In my previous testing of the cart i didn't have this problem.

    (A side note, i just went to the admin side of things, cleared out both of those orders and then placed another order for one product totalling $40. This time i again get two orders processed at the same time, the correct one for $40 and one for just over $200. So, it seems to be accumulating dollar amounts even though i have cleared all past orders for this customer.)

    Please help!!
    Thanks,
    pete

  2. #2
    Member
    Join Date
    Nov 2002
    Location
    Pennsylvania
    Posts
    93
    Rep Power
    0


    Default

    It sounds like something very similiar to an event that I encountered.

    first thing, you stated you tested the system before without any such event.

    ok when you deleted the previos testing order, it sounds like you did not remove all remains of the order and the program is calling portions of your previous tested order.

    Look at your mysql database and look for remains of your previous order.

    also depending on the number of test orders you did, the problem should correct itself once you get past the previous number of test orders.

    hth

  3. #3
    Member sheikyerbouti's Avatar
    Join Date
    Oct 2002
    Posts
    45
    Rep Power
    0


    Default

    Thank you very much! I found some tables in the database that i hadn't emptied, and that made all the difference!

    I appreciate the help.

    -pete

Similar Threads

  1. filter results
    By no1uknow in forum osCmax v2 Customization/Mods
    Replies: 1
    Last Post: 07-22-2006, 10:24 PM
  2. How do you print the results of tep_db_query()
    By dhobson in forum osCommerce 2.2 Modification Help
    Replies: 3
    Last Post: 01-27-2005, 08:43 AM
  3. PayPal Testing
    By dweeble in forum osCommerce 2.2 Modification Help
    Replies: 2
    Last Post: 11-15-2004, 06:19 AM
  4. Customised installation, strange results on first visit
    By figgles in forum osCmax v1.7 Discussion
    Replies: 1
    Last Post: 04-13-2004, 09:33 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •