osCmax v2.5 User Manual
Results 1 to 6 of 6

No order total on SQL

This is a discussion on No order total on SQL within the Paypal forums, part of the Payment Modules category; Hi - when I receive orders and the customer uses paypal ipn the products are showing on the database, along ...

      
  1. #1
    New Member
    Join Date
    Jun 2005
    Posts
    9
    Rep Power
    0


    Default No order total on SQL

    Hi - when I receive orders and the customer uses paypal ipn the products are showing on the database, along with their details in ORDERS; ORDERS_PRODUCTS but the order does not show up in ORDERS_TOTAL. Recently the hosting company moved us to a different server and different IP address - this has been changed in config file. When we look at orders in the admin section all orders are there except the paypal ones (ones without order totals). I have checked the forum but cannot find any solution. What could the problem be?

  2. #2
    New Member
    Join Date
    Jun 2005
    Posts
    9
    Rep Power
    0


    Default Re: No order total on SQL

    hi - since posting this I have installed the latest paypal ipn v2.3.4.6, followed the trouble shooting and still no joy. It is as if the paypal module adds the items to the orders_products but not to the orders_totals!

  3. #3
    osCMax Development Team
    ridexbuilder's Avatar
    Join Date
    Jul 2008
    Location
    Haggisland
    Posts
    3,014
    Rep Power
    36


    Question Re: No order total on SQL

    Which version of 'Max are you running, 2.0.4 presumably?
    Hosting plans with installation, configuration, contributions, support and maintenance.

  4. #4
    New Member
    Join Date
    Jun 2005
    Posts
    9
    Rep Power
    0


    Default Re: No order total on SQL

    Hi - It is version 2.xx not sure which sub-version. I read on some other posts that the paypal module skips over parts of the checkout. I had altered the summary page checkout_confirmation.tpl.php so it showed up neatly, with delivery info; billing info; products; etc in a list. Once I changed this back to the original the paypal worked! Obviously need to check through the file to see what I have missed.

  5. #5
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: No order total on SQL

    I want to add something to this post that is very important to everyone asking for help:

    If something is not working correctly, and you have made mods to the code, do the following:

    1.Tell us you made mods to the code in your first post
    2. Assume your mods have caused the problem!
    3. Detail the mods you have made

    Even if you think it is unrelated, it probably is not.

    Otherwise, we will assume you have a clean installation with some sort of installation issue or server issue, and your problem will go unresolved.


    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  6. #6
    New Member
    Join Date
    Jun 2005
    Posts
    9
    Rep Power
    0


    Default Re: No order total on SQL

    Hi - Point taken! It was actually another post of yours saying much the same thing that prompted me to look at mods i had done around the time that the problem occured.

Similar Threads

  1. Order Total excluding VAT
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 10-22-2008, 07:00 AM
  2. Order Total Priority (not really about sort order)
    By calistared in forum osCmax v2 Customization/Mods
    Replies: 1
    Last Post: 03-12-2008, 08:59 PM
  3. Order Totals: Total $ and Total Sales Count
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 04-18-2007, 09:30 AM
  4. Order Totals: Total $ and Total Sales Count
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 04-17-2007, 05:54 PM
  5. Order Totals: Total $ and Total Sales Count
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 04-17-2007, 11:15 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
  •