hello, while doing a mockup purchase in my client's magento site, the checkout process goes fine until i click 'Place Order' button. this error message appear saying: "There was an error processing your order. Please contact us or try again" And an error was forwarded to email saying: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'table_name.sales_order_entity_text' doesn't exist Strangely i checked phpmyadmin, and i couldnt find any table called 'table_name.sales_order_entity_text. I was wondering which plugin is responsible to create that table. Also puzzled me is in the My Account it shows the order is 'Processing' which means the order actually goes thru already but the email that i receive instead of an invoice is an error saying the above. My question is: Is this error caused by any specific plugin?? OR Email template error? OR somethin else? Please advice how can i go about solving this. thanks & happy new year.
It sounds like the database did not get updated correctly. There are a few ways to sort this out. You can either insert it or you can install mage 1.4.2 default and run this http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/db-repair-tool That basically compares a target db with a corrupt dp and fixes it. hope that helps, Nigel