News:

Looking for documentation? Take a look on our wiki

Main Menu

Error 1146 after changing order status

Started by m.davide82, October 11, 2016, 18:20:52 PM

Previous topic - Next topic

m.davide82

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

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 https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 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
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

m.davide82

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

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

????

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 https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 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
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

blackrat999

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

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

GJC Web Design

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 https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 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
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation