[fixed] Order Status

Rusty_ · Nice Poster Offline Joined: Aug 20, 2008 Posts: 6

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.

FrankS · New Poster Offline Joined: Feb 03, 2011 Posts: 2

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

Thanks

Phoenix · Posted: Fri Feb 18, 2011 2:31 am Post subject: Re: Order Status

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

FrankS · New Poster Offline Joined: Feb 03, 2011 Posts: 2

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.

Phoenix · Posted: Fri Feb 18, 2011 6:35 am Post subject: Re: Order Status

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.