Hello..
I've installed Ubercart version alpha-7e and I have a problem when I change an order status. If I change the status, all statuses will appear on the list. If I change the status again, the list is doubled. I traced the code and I think I found something strange.
<?php
// uc_order.module line 2625
$join = " LEFT JOIN {uc_order_statuses} AS os ON oc.order_status = os.order_status_id";
?>That is the SQL code for joining uc_order_comments table and uc_order_statusses table based on oc.order_status = os.order_status_id criteria. If I look to the table CREATE statement, the type of oc.order_status is tinyint(4) and os.order_status_id is varchar(32). So we can see those two data types are different.
I think that's why if I change the status, all statuses suddenly appear on the list.
I'll make changes where appropriate. I thought I ran into this problem myself, but I couldn't reproduce the problem so I figured it was a fluke.
Joined: 10/07/2007