Problems with orders_total

[Guest]

After some heavy modifications of OsCommerce (xhtml 1.0 strict & css compliant, and non os-look), I seem to have run into a funky little problem.

 

The thing is that when a customer confirms an order, data is no longer inputed into the db-table "orders_total". I came to this conclusion by browsing the db-tables manually and saw that the orders were where they were supposed to be, except in this table, and manually inputting the data there fixed it all.

 

So the question now remains, where is the data inputted into the db-table 'orders_total', in what file / under what function.

All i can seem to figure out by browsing code is that it must be somewhere inside 'checkout_process.php' ? Or am i completely mistaken.

 

I would really appreaciate some help on this subject, and if i have yet to make my self clear enough on the problem, please tell me to elaborate :'(

 

sincerely

-vebj?rn l. berg

[warrenthewindmill]

I have the same problem.

My web hosting company "upgraded" my server earlier in the week and I've been fixing problems ever since.

 

One thing I have noticed is that when you get to the checkout confirmation page, the shipping cost does not display on the page. I also get no entries in the orders_total table and am adding them manually.

 

I wonder if the problem is something to do with nulls? If the shipping cost is not picked up by checkout confirmation perhaps the code tries to write a null value to the table. I tried setting the 'nulls allowed' for the 'value' field in orders_total to Yes but it didn't make any difference.

 

I am having real problems with this because after having to reset all the paths in my configure files yesterday everything was working fine. Unless someone at the web hosts did something?

 

Any clues would be much appreciated.

Thanks

[warrenthewindmill]

I found a solution to my problem, hope it helps to solve yours. I wasn't far out with my reference to nulls.

Check your configuration table and look for the CONFIGURATION_KEY entry MODULE_ORDER_TOTAL_INSTALLED

This defines what modules are called when calculating order totals. You need one module for each line in the totals table, usually sub-total, shipping and total. The modules are named:

ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php

 

The Configuration description contains the following:

List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)

 

The configuration value should contain the module filenames:

ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php

 

Needless to say mine was null meaning the modules were not being called. There was a field amended time on the record of about the time my hosting company were checking something out for me and they say they didn't go near the DB so a coincidence? Either way the only other person with access is me and I was out of the office at the time the amendment occurred. Gremlins maybe.

 

Your problem sounds similar so check it out. Hope this helps

[MzBeanz]

I have this problem with the module order total. It was working and now when I click on the link in admin all i see is this

 

 

I checked the CONFIGURATION_KEY entry MODULE_ORDER_TOTAL_INSTALLED as you suggested and this is what I see there

 

68 Installed Modules MODULE_ORDER_TOTAL_INSTALLED ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_coup... List of order_total module filenames separated by ... 6 0 2004-09-24 23:10:48 2004-03-13 11:50:25 NULL NULL

 

I tried to change this to not null but every time I do and save it I go check and it is back??!! What do I do?? Is there another file that thispulls info from that I can change? Any help would be great thanks!

[MzBeanz]

Thanks for helping :D

[Jen7pc]

Hi,

I'm having a possibly related problem - wherein my customer's checkout is now not adding in tax. In the admin GUI it's all set up correctly, but isn't working. Checkout is, however, adding in shipping.

 

I came across the following re the db and looked there, and discovered that in the CONFIGURATION_KEY entry MODULE_ORDER_TOTAL_INSTALLED was not even there at all.

 

How can I add it back in?

 

Thanks,

J

...

Check your configuration table and look for the CONFIGURATION_KEY entry MODULE_ORDER_TOTAL_INSTALLED

This defines what modules are called when calculating order totals. You need one module for each line in the totals table, usually sub-total, shipping and total. The modules are named:

ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php

 

The Configuration description contains the following:

List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)

 

The configuration value should contain the module filenames:

ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php

 

Needless to say mine was null ...

[Guest]

I found a solution to my problem, hope it helps to solve yours. I wasn't far out with my reference to nulls.

Check your configuration table and look for the CONFIGURATION_KEY entry MODULE_ORDER_TOTAL_INSTALLED

This defines what modules are called when calculating order totals. You need one module for each line in the totals table, usually sub-total, shipping and total. The modules are named:

ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php

 

I've just used this to solve a problem I found whilst working on a shop that had been moved from one server to another, the database had a few problems - chiefly that none of the auto-increment field had remained as auto-increment. Once we had the site running properly we found that orders were not appearing in the admin orders list (but were in the database and could be viewed from the admin by using the order number)

 

Looking at MODULE_ORDER_TOTAL_INSTALLED the values ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php were simply missing - everything else was there

 

Many thanks

 

Graeem

 

 

 

move server, database error, new store

[thugpassion]

I've just used this to solve a problem I found whilst working on a shop that had been moved from one server to another, the database had a few problems - chiefly that none of the auto-increment field had remained as auto-increment. Once we had the site running properly we found that orders were not appearing in the admin orders list (but were in the database and could be viewed from the admin by using the order number)

 

Looking at MODULE_ORDER_TOTAL_INSTALLED the values ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php were simply missing - everything else was there

 

Many thanks

 

Graeem

move server, database error, new store

 

That did it for me too! Server tansfer...

[Guest]

I had this exact same problem ... and it involved a server transfer as well ... HOWEVER ... it had nothing to do with the MODULE_ORDER_TOTAL issue reported here.

 

It seems that my host somehow changed the ID field of the CONFIGURATION table to INT(10) attributes UNSIGNED.

 

All other auto-increment fields in the database are INT(11) with no attributes. Thinking this a little odd, I changed it back and VOILA!! it works - well for the small test I performed.

 

Interesting how a server change can go so wrong for so many of us. It certainly isn't to do with OsC itself since I didn't re-install, all paths/domains remain the same, just a new server.

 

I'm guessing that somehow the DB backup process for the company is dodgy.

 

Hope that helps others out there.

Q

[Alex Zuyev]

I had this exact same problem ... and it involved a server transfer as well ... HOWEVER ... it had nothing to do with the MODULE_ORDER_TOTAL issue reported here.

 

It seems that my host somehow changed the ID field of the CONFIGURATION table to INT(10) attributes UNSIGNED.

 

All other auto-increment fields in the database are INT(11) with no attributes. Thinking this a little odd, I changed it back and VOILA!! it works - well for the small test I performed.

 

Interesting how a server change can go so wrong for so many of us. It certainly isn't to do with OsC itself since I didn't re-install, all paths/domains remain the same, just a new server.

 

The same problem as well and orders_total_id line in ORDERS_TOTAL table also became to INT(10) attributes UNSIGNED. I changed it to INT(11) with no attributes but ((( it didn't help. Will be really grateful for anything else about the problem.

[Guest]

I am havin this same issue... Are you looking in the catalog/admin/includes/database_tables.php for this...

Sorry pretty new at all this... If Im looking in the right place I dont have any of the above mentioned table entrys..

[Guest]

I am havin this same issue... Are you looking in the catalog/admin/includes/database_tables.php for this...

Sorry pretty new at all this... If Im looking in the right place I dont have any of the above mentioned table entrys..

 

Ok. Found where to check this... Everything is fine all looks correct yet I cannot see orders in the admin panel... I can call up a specific order number..

So I know the orders are in the database.. Anyother ideas.. Thanks for everyones help...