[Not a bug] Duplicate order ids show in admin->customers->orders

[swguy]

You can see from the attached image that the same order number shows up twice for the last 2 orders.



The debug statement on line 843 (when uncommented) displays

I SEE C: select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, o.customers_company, o.customers_email_address, o.customers_street_address, o.delivery_company, o.delivery_name, o.delivery_street_address, o.billing_company, o.billing_name, o.billing_street_address, o.payment_module_code, o.shipping_module_code, o.ip_address from (zen_orders_status s, zen_orders o ) left join zen_orders_total ot on (o.orders_id = ot.orders_id and ot.class = 'ot_total') where (o.orders_status = s.orders_status_id and s.language_id = '1') order by o.orders_id DESC

I believe this could be fixed by modifying admin/orders.php line 841 to add just before the order by " GROUP BY o.orders_id"

[swguy]

ARGH! This issue was created by a database with dangling records. I thought I had cleaned out some records but hadn't.

[Eric Chen]

I got the same problem after I used "TRUNCATE TABLE `orders`" on my database.

Afterwards, I recovered these tables with "Order_..." in my database, and then it works right.

[DrByte]

I got the same problem after I used "TRUNCATE TABLE `orders`" on my database.

Yup. TRUNCATE is a bad thing to do without first studying how all the 93 database tables interact with each other ;)