Guest Posted December 10, 2004 Posted December 10, 2004 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 Posted December 11, 2004 Posted December 11, 2004 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 Posted December 15, 2004 Posted December 15, 2004 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 Posted December 16, 2004 Posted December 16, 2004 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!
Jen7pc Posted December 14, 2005 Posted December 14, 2005 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 Posted January 28, 2007 Posted January 28, 2007 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 Posted May 14, 2007 Posted May 14, 2007 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 Posted June 11, 2007 Posted June 11, 2007 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 Posted November 6, 2007 Posted November 6, 2007 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. Best wishes, Alex Z.
Guest Posted October 29, 2009 Posted October 29, 2009 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 Posted October 29, 2009 Posted October 29, 2009 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...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.