Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

No entires in orders_total


tmorton

Recommended Posts

Posted

Hello,

I've got a rather strange problem.

When an order is made, no entries are made in the orders_total table. The code on line 97 of checkout_process.php is still there:

$insert_id = tep_db_insert_id();
 for ($i=0, $n=sizeof($order_totals); $i<$n; $i++) {
   $sql_data_array = array('orders_id' => $insert_id,
                           'title' => $order_totals[$i]['title'],
                           'text' => $order_totals[$i]['text'],
                           'value' => $order_totals[$i]['value'], 
                           'class' => $order_totals[$i]['code'], 
                           'sort_order' => $order_totals[$i]['sort_order']);
   tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);
 }

 

So it should be getting entered. But I guess not?

An ideas?

Thanks, Taj

"My software never has bugs, it just develops random features."

  • 3 weeks later...
Posted

Actually, I've having this problem with a new shop I'm working on as well.

 

It doesnt' error out during the order, and it seems as if all is well, except there is not entry in the orders_total table, and therefore no entries are appearsing in the orders section of the admin.

 

Wondering if any others are having this problem, or if anyone has solved it?

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Posted

Are either of you using I.E. browser 6.0 ?

Are you familiar with the microsoft critcal update KB832894. That messes up the input in to OSC from the browser??? Very nasty against SSL 3.0

Posted

Nope.,

 

I don't use IE at all.

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Posted

My problem was that the shipping cost did not have decimal points.

HTH, Taj

"My software never has bugs, it just develops random features."

  • 1 year later...
Posted

Ok, i just made a test and if i modify my code like this

 

die("line 97 ".sizeof($order_totals));
for ($i = 0, $n = sizeof($order_totals); $i < $n; $i++) {
   $sql_data_array = array('orders_id' => $insert_id,
       'title' => $order_totals[$i]['title'],
       'text' => $order_totals[$i]['text'],
       'value' => $order_totals[$i]['value'],
       'class' => $order_totals[$i]['code'],
       'sort_order' => $order_totals[$i]['sort_order']);
   tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);

 

the result is:

line 97 0

 

this means that $order_totals is empty, how can i solve this?

 

please :)

 

 

 

j.

Posted

I read the whole checkout_process.php, order_totals.php my payment gateway, and tons of other things, i dont know what else to do.

 

please help!!!

 

 

j

Archived

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

×
×
  • Create New...