VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: m.davide82 on October 11, 2016, 18:20:52 PM

Title: Error 1146 after changing order status
Post by: m.davide82 on October 11, 2016, 18:20:52 PM
Hello,

this is what I receive when I chenge the order status:

Error 1146

Table 'mytable.#__virtuemart_ordersave' doesn't exist SQL=SELECT virtuemart_order_id FROM `#__virtuemart_ordersave` WHERE `virtuemart_order_id` = '774' AND `state` != '-2'


Anyone can help me? Thanks a lot!
Title: Re: Error 1146 after changing order status
Post by: GJC Web Design on October 11, 2016, 18:24:00 PM
hmmm ...  table #__virtuemart_ordersave is from my Reviews component

have you uninstalled/disabled but left the plugin active?

Email me if u need further help
Title: Re: Error 1146 after changing order status
Post by: m.davide82 on October 17, 2016, 11:50:51 AM
Hello,

thanks a lot for your answer, I was been crazy!
Probably in the old versions of the website he tried your component, now I just disabled the plugin and everything is ok!

Thanks a lot!
Title: Re: Error 1146 after changing order status
Post by: microtribe on January 22, 2017, 02:17:21 AM
I had this trouble too after uninstalling your software. I deactivated the plugin and then uninstalled. How can I uninstall your software without getting this error?
Title: Re: Error 1146 after changing order status
Post by: GJC Web Design on January 22, 2017, 16:36:28 PM
????

It is a completely standard extension .. un-publish / or uninstall the related plugins - and remove any template over rides/changes associated with the extension

the storage/query of the table #__virtuemart_ordersave is only active if u have my plugins active
Title: Re: Error 1146 after changing order status
Post by: blackrat999 on May 24, 2019, 15:14:46 PM
GJC i am using a cloned template of another site which had your review software installed, the site is nearly ready and i went through cleaning out stuff that i didnt need including the review component, now i am getting this error.
I have unpublished the only plugin that i can find "VM Custom - Show Reviews" but im still getting that error when i change status of an order _ hoping you might still get notification on this thread!

Any ideas what could still be causing the error please?
Title: Re: Error 1146 after changing order status
Post by: blackrat999 on May 24, 2019, 15:19:08 PM
Quote from: blackrat999 on May 24, 2019, 15:14:46 PM
GJC i am using a cloned template of another site which had your review software installed, the site is nearly ready and i went through cleaning out stuff that i didnt need including the review component, now i am getting this error.
I have unpublished the only plugin that i can find "VM Custom - Show Reviews" but im still getting that error when i change status of an order _ hoping you might still get notification on this thread!

Any ideas what could still be causing the error please?

Reinstalling the component has fixed the issue but not very satisfactory to have component im not using so in your own time if you can suggest best way to remove i will be grateful
Title: Re: Error 1146 after changing order status
Post by: GJC Web Design on May 25, 2019, 12:28:57 PM
check the pdf for the changes that would have been made in the template over rides .. u need to remove them then the comp. is never called/used

https://www.gjcwebdesign.com/eximg/productreview/GJC_VMReview.1.6.0_Virtuemart_3_J3.pdf