Problem with mysql5

[GniDhal]

Hello,

sorry for my expression, i'm not really english spoken, :blush:

 

My problem :

each new order are correctly inserted in te orders table with orders_id autoincrement good.

the link tables (orders_products, orders_total...) have a new line so but the orders_id is not transfered, the value of these id is 0.

Infact, the new order is not displayed in the admin panel.

The same problem is happend when new customer register : address_book table not have customers_id right (value =0).

It seem to be a problem about mysql5 because the same scripts and the same DB on PHP4/MySQL4 config run correctly.

 

I identified this : the orders_id is assigned by the tep_db_insert_id() function

line 97-99 of checkout_process.php MS2 ver :

  tep_db_perform(TABLE_ORDERS, $sql_data_array);
 $insert_id = tep_db_insert_id();
 for ($i=0, $n=sizeof($order_totals); $i<$n; $i++) {
$sql_data_array = array('orders_id' => $insert_id,

Why this value is comuted to 0 ? :blink:

Do you know a solution or the way to solve this problem ? (whithout downgrade the mysql version)

 

Thanks'

 

Apologise for duplicate entry. Its a too long delay response of the web...