apopular Posted November 15, 2014 Share Posted November 15, 2014 Hi, i upgrade my store 2.2 to 2.3 and i dont know why mu orders total table have more than 44000 records, i can delet this i update every thing, costumers, orders. nice weekend I did, helped or traslate. http://addons.oscommerce.com/profile/104964 My english it´s só poor, but of you need help in portuguese, like shipping and payment that´s make a diference in brazil, come one, Obrigado (thank´s) Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted November 16, 2014 Share Posted November 16, 2014 Hi You will probably have 3 records in OT for each order. Sub-total Delivery Total So if you have had 11,300 orders that is about right. Otherwise there is a problem somewhere. If you write some sql to remove excess records you could add it to the Database Check Tool. http://addons.oscommerce.com/info/9087 Or I can give you the sql to find them SELECT ot.orders_total_id FROM (orders_total ot) LEFT JOIN orders o ON o.orders_id = ot.orders_total_id WHERE o.orders_id = '' OR o.orders_id IS NULL GROUP BY ot.orders_total_id HTH G Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
apopular Posted November 16, 2014 Author Share Posted November 16, 2014 @@geoffreywalton Thank you, problem solved. tks again 8) how to edit this topic title to resolved on top? I did, helped or traslate. http://addons.oscommerce.com/profile/104964 My english it´s só poor, but of you need help in portuguese, like shipping and payment that´s make a diference in brazil, come one, Obrigado (thank´s) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.