languages mixed up

[chrismole]

In the Admin, when I go to the order details page (admin/orders.php), the subtotal, tax, etc. lines are in French. It looks like this:

Sous-Total : $194.00
TVA : $104.48
Réduction : $0.00
Livraison : $0.00
Total : $298.48

Plus, I see the same thing when I go to edit orders (admin/edit_orders.php).

Is this a code or db issue? I have the default language set to "en" in the config. Any help is much appreciated.

Thx,
C

[jpf]

Auto select language might be the problem - WHAT is the default language the server you installed it on? You can change the language displayed in the admin then "remove" french and german if you don't need it. If you need them then you could copy the admin english files over the french files..... then it alway displays english in the ADMIN only - even if french is being selected...

[chrismole]

funny... I thought of that and tried it, but no luck, it still shows in French. Must be a bug in the code.

[michael_s]

It is a bug in the manual order entry mod. It was written by a person that French is their native language, and the mod is not fully dynamic language compatible. Perhaps a more recent version of the mod has corrected this.

[spottedhaggis]

I have the same bug in mine, however I am not sure its a bug in a file but a bug in the db. Mine was fine up to last night when I discovered the client had added some 200 more products into his old OSC database, so during my process or inserting these, I found it was easier to do a complete re-sync of the databases and then simply import the required tables, same as last time.

Everything went perfectly (since I have this down now) exept now my edit orders page in admin has french wording.

This to me suggests its a database entry, problem is i cant find it.

[spottedhaggis]

I found the problem was located in the Orders_totals section of the database. I have absolutely no idea how they got there, when the others are all english, but it is simply fixed.

This is what the area concerned looks like in phpmyadmin



Wish I knew how it got there though, thats truly weird

As it turns out the 2 orders this corresponds to was my testing the create order option for a customer, these entries were then created.

This leads me to believe the french issue is caused by the creation of orders by admin in admin?

Anyone got any ideas?

[spottedhaggis]

ok confirmation. If you create a new order it creates the french text. Does anyone know where this is happening

[spottedhaggis]

You can find the fault inside the following file - admin/create_orders.php

it looks like this

$sql_data_array = array('orders_id' => $insert_id,
//Comment out line you don't need
//'new_value' => $new_value, //for 2.2
'orders_status_id' => $new_value, //for MS1 or MS2
'date_added' => 'now()');
tep_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array);


$sql_data_array = array('orders_id' => $insert_id,
'title' => "Sous-Total :",
'text' => $temp_amount,
'value' => "0.00",
'class' => "ot_subtotal",
'sort_order' => "1");
tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);


$sql_data_array = array('orders_id' => $insert_id,
'title' => "Réduction :",
'text' => $temp_amount,
'value' => "0.00",
'class' => "ot_customer_discount",
'sort_order' => "2");
tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);


$sql_data_array = array('orders_id' => $insert_id,
'title' => "TVA :",
'text' => $temp_amount,
'value' => "0.00",
'class' => "ot_tax",
'sort_order' => "2");
tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);


$sql_data_array = array('orders_id' => $insert_id,
'title' => "Livraison :",
'text' => $temp_amount,
'value' => "0.00",
'class' => "ot_shipping",
'sort_order' => "3");
tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);



$sql_data_array = array('orders_id' => $insert_id,
'title' => "Total :",
'text' => $temp_amount,
'value' => "0.00",
'class' => "ot_total",
'sort_order' => "4");
tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);