Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

order_total table more than 44.000 records


apopular

Recommended Posts

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

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

@@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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...