tim_o_boy Posted December 9, 2003 Posted December 9, 2003 Searching has come up with a few threads on this subject, but I can't find an answer. There is also a closed bug #686 that offers no help. Everything worked fine yesterday and the orders I made yesterday show up fine today, but not the new ones. It seems that all tables are being updated at order time except orders_total. The two orders that were made yesterday have the following entrys in orders_totals: (#'s used for spacing) orders_total_id ##### orders_id ##### title 1 ##### 1 ##### Sub-Total: 2 ##### 1 ##### Flat Rate (Best Way): 3 ##### 1 ##### Total: 4 ##### 2 ##### Sub-Total: 5 ##### 2 ##### Flat Rate (Best Way): 6 ##### 2 ##### Total: My non-expert guess would be that every order should have these 3 values attached to them and they will be inserted when catalog/checkout_process.php is called. This table is then used (among others) when pulling out orders in admin and in my account. Is this correct and if so, does anyone know why this suddenly isn't happening? I've not changed the standard code in any way. Any help appreciated.
tim_o_boy Posted December 10, 2003 Author Posted December 10, 2003 Well, for anyone who's interested, I finally worked out what the problem was. In the "configuration" db table "configuration_id" 68 and 69 had empty values under "configuration_value". "configuration_description" for these 2 rows states that they are updated automatically and don't need editing. But they need a value in them to fix my original problem (row 68) and also in 69 for the shipping rate to be added to orders, which I now noticed wasn't working. Anyway, I've added the values ot_total in row 68 and flat.php in row 69. Currently the system seems to be working fine again, but I don't know why this happened in the first place and it's worrying. Hope this makes sense to anyone in the same position.
akerin Posted December 19, 2003 Posted December 19, 2003 As another FYI: EXACTLY the same happened to me - on about the same date. Suddenly no data was being added to orders_total. Your fix (adding data to configuration) worked. There is something strange going on - is there a new version of mysql or php that ISPs are using that has caused this, or was there some sort of bug in the code??? Anyway, thanks.
bluedevil920 Posted January 7, 2004 Posted January 7, 2004 SAME PROBLEM here, thanks for the fix.. i dont know what happened either.. oh well it works i guess...
Guest Posted January 11, 2004 Posted January 11, 2004 In order to show all the total items, row 68 of configuration should contain: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php Issues like this should be debugged however--the code shouldn't just break due to a database corruption. This is probably costing various users lots of times before they stumble on the correct solution on the forums. search keywords: orders_total empty subtotal missing order status empty
Kurt Posted January 14, 2004 Posted January 14, 2004 I have the same problem, but i have no notion what to do to fix it. Thank you in advance your help
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.