Author Topic: Error 1146 after changing order status  (Read 1187 times)

m.davide82

  • Jr. Member
  • **
  • Posts: 134
Error 1146 after changing order status
« 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!

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9024
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.4.2
Re: Error 1146 after changing order status
« Reply #1 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
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

m.davide82

  • Jr. Member
  • **
  • Posts: 134
Re: Error 1146 after changing order status
« Reply #2 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!

microtribe

  • Beginner
  • *
  • Posts: 39
Re: Error 1146 after changing order status
« Reply #3 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?

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9024
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.4.2
Re: Error 1146 after changing order status
« Reply #4 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
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

blackrat999

  • Jr. Member
  • **
  • Posts: 215
Re: Error 1146 after changing order status
« Reply #5 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?

blackrat999

  • Jr. Member
  • **
  • Posts: 215
Re: Error 1146 after changing order status
« Reply #6 on: May 24, 2019, 15:19:08 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

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9024
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.4.2
Re: Error 1146 after changing order status
« Reply #7 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
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation