DragonflyCMS Projects > Storez > [fixed] Order Status > Community Forums > Phoenix Netology
Forum Index > eCommerce > Storez

[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.

Please enter your server specs in your user profile! 😢


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

Thanks

Please enter your server specs in your user profile! 😢


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

Donations & Audit for DragonflyCMS

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


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.

Please enter your server specs in your user profile! 😢


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.

Donations & Audit for DragonflyCMS

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

All times are Australia/Adelaide


Jump to: