Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

orders_total table not being added to


fissssssi

Recommended Posts

I'm currently testing a store I've been setting up. Everything seems to be fine and working well, except that when orders are placed, no entries are going into the orders_total table. All the e-mails are being sent and orders can be seen when clicking a link from the e-mails or entering the number manually into a link.

 

What this means:

- ISSUE FOR ME - Customers don't see any order history - account_history.php - (and see a negative page navigation list!)

- WORKED AROUND - Orders were also not being listed in the admin section - admin/orders.php - although I used a contribution that changed the query and they are now appearing here

- I don't know if there is anything else important and would rather fix the problem than have problems once live!

 

Having looked through the forums, I've eliminated the following:

- I am using the latest (1.4) PayPal IPN module (the only payment option for the site) set to a valid status (Pending) once acknowledged

- I have checked the configuration table and it contains the correct file names for MODULE_ORDER_TOTAL_INSTALLED

 

I'd be hugely grateful if anyone can help me out with this or at least point me in the direction of more things to check!

 

Cheers,

 

 

Adam

Link to comment
Share on other sites

Be sure USE_PCONNECT and STORE_SESSIONS are set correctly in configure.php. Then check the address book table in the database to be sure an entry exists for the address.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Be sure USE_PCONNECT and STORE_SESSIONS are set correctly in configure.php. Then check the address book table in the database to be sure an entry exists for the address.

 

Jack

 

Thanks for that, but those bits look to be okay too. Any more ideas?

 

Cheers,

 

 

Adam

Link to comment
Share on other sites

  • 3 weeks later...
  • 5 months later...
Finally solved this one - I had overly customised order_confirmation.php so have managed to fix it. Many thanks to all those who tried to help me out on this.

 

 

 

 

 

Adam

order_confirmation.php dosent exist lol, i still have this problem table order_total empty

Link to comment
Share on other sites

  • 1 month later...
order_confirmation.php dosent exist lol, i still have this problem table order_total empty

 

Me too! Has anyone else had this problem - anyone fixed it?

 

I have read through similar posts and checked order_status etc and all seems to be in order...

 

Any help would be much appreciated.

 

Thanks

Link to comment
Share on other sites

  • 4 weeks later...
Me too! Has anyone else had this problem - anyone fixed it?

 

I have read through similar posts and checked order_status etc and all seems to be in order...

 

Any help would be much appreciated.

 

Thanks

 

 

Anyone? I have an empty orders_total, the Orders History does not show anything and gives a negative number for the pages.

Link to comment
Share on other sites

  • 3 years later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...