[fixed] Order Status Reply to topic

Receive a database error when trying to update an order status on 9.4.1


CMS Warning line 75: On /admin.php?op=Storez While executing query "SELECT payMethodName, payMethodData, billEmail, transactionid FROM cms_cart_orders WHERE orderID='2'" the following error occured: Unknown column 'transactionid' in 'field list' In: /home/*****/public_html/modules/Storez/admin/orders.php on line: 480

Initiated by Bugger (Original Entry) - Comments Here Please.

I am having the same problem, is there a fix for this?

Thanks

That field was added back in v9.4.0 - it should have been added to the database table when you upgraded the module through admin modules edit.

If not, it is:

transactionid VARCHAR(64) DEFAULT NULL

Thanks for the support Phoenix, do I run this as a sql import? This was a fresh install I also get an error when I click on the coupon admin link.

Click the SQL tab at the top of phpmyadmin for your db and run this command:

ALTER TABLE cms_cart_orders ADD transactionid VARCHAR( 64 ) DEFAULT NULL

Coupons is only partially completed so it won't work yet.