Post by hendrickboards » Mon Apr 16, 2012 5:26 am

I am installing Order Manager - Bulk update order status comment export orders to excel(Support option export) and on step 2 (listed below) I am a bit confused on how to do this??

Step 2:Modify Mysql
Add one more field named "comment"to table order_stutas
Note:for table "order_status",please add prefix.
For example,if the table name is test_order_status,the sql will be
ALTER TABLE `test_order_status` ADD `comment` text COLLATE utf8_bin NOT NULL


Any suggestions please. Thank you !


Posts

Joined
Sun Dec 04, 2011 5:33 am

Post by GoGo OpenCart » Mon Apr 16, 2012 5:56 am

Login to your cPanel, click phpMyAdmin, and click your database. Then click on the "SQL" menu from above, and paste this code inside:

ALTER TABLE `order_status` ADD `comment` text COLLATE utf8_bin NOT NULL

and press "Go".

Please make sure that the "order_status" text in the above code is the same as your "order_status" table, i.e. if there is some prefix, add the prefix as well, so it would become like this:

ALTER TABLE `prefix_order_status` ADD `comment` text COLLATE utf8_bin NOT NULL

NOTE: PLEASE MAKE A BACKUP OF YOUR DATABASE BEFORE DOING THIS!

See all my extensions: https://www.opencart.com/index.php?rout ... 20OpenCart


User avatar
Active Member

Posts

Joined
Mon Nov 14, 2011 11:30 pm
Who is online

Users browsing this forum: No registered users and 5 guests