Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Error Message when editing invoice.
(1 viewing) (1) Guest
Support forum for customers who have purchased this product. Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: Error Message when editing invoice.

Error Message when editing invoice. 5 years ago #45194

Hi,

Since we have upgraded from (V2.0.38) we are getting the errors.

I am using ARTIO VM Invoice (V2.0.40) for virtuemart (V2.6.6)

After I change something in an order(edit the price or quantity) in VM Invoice and save it, I get the following error:

Cannot store order shipment. TableVm2OrderShipment: :store failed
Unknown column 'shipment_package_fee' in 'field list' SQL=UPDATE `jos_virtuemart_shipment_plg_rules_shipping_advanced` SET `virtuemart_order_id`='6172',`order_number`='6172',`virtuemart_shipmentmethod_id`='236',`shipment_cost`='0.00',`shipment_package_fee`='',`modified_on`='2014-07-10 13:41:11',`modified_by`='8129' WHERE `id`='676'

The changes are saved and the price/quantity is updated but there does not seem to be any problems. How can we eliminate this error message?

Error1.jpg


Error2.jpg
The topic has been locked.

Re: Error Message when editing invoice. 5 years ago #45225

  • dajo
  • OFFLINE
  • Posts: 5070
Hi,

It seems that your shipment plugin doesn't have a required column in its database table. We'll handle this in next version of VM Invoice.
In the meantime, you can fix this by running the following SQL query on your database using phpMyAdmin:
ALTER TABLE `jos_virtuemart_shipment_plg_rules_shipping_advanced` ADD COLUMN `shipment_package_fee` DECIMAL(10, 2);


Of course backing up your website and database is recommended before doing this.
ARTIO Support Team
The topic has been locked.

Re: Error Message when editing invoice. 5 years ago #45231

Hi,

Thanks for the feedback; however we can not edit the SQL database.

Please can you indicate when the next update will be available?

Regards
The topic has been locked.

Re: Error Message when editing invoice. 4 years, 12 months ago #45259

  • dajo
  • OFFLINE
  • Posts: 5070
Hi,

I'm sorry, I can't promise any release date. We'll try our best to release it as soon as possible.
ARTIO Support Team
The topic has been locked.
  • Page:
  • 1
User Login Empty