[fixed] Order Status
-> Storez
#1: [fixed] Order Status Author: Rusty_,
Posted: Fri May 21, 2010 10:44 am
----
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.
#2: Re: Order Status Author: FrankS,
Posted: Thu Feb 17, 2011 6:50 pm
----
I am having the same problem, is there a fix for this?
Thanks
#3: Re: Order Status Author: Phoenix, Location: Netizen
Posted: Thu Feb 17, 2011 10:01 pm
----
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
#4: Re: Order Status Author: FrankS,
Posted: Thu Feb 17, 2011 11:34 pm
----
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.
#5: Re: Order Status Author: Phoenix, Location: Netizen
Posted: Fri Feb 18, 2011 2:05 am
----
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.
-> Storez
All times are GMT
Page 1 of 1