[Skip to main content](#vessel-content)

#   Changing Order Status Error

##

- **[virusys](/forum/user/51944-virusys "View virusys's Profile")**
- [![virusys's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar51944.jpg)](/forum/user/51944-virusys "View virusys's Profile") Topic Author
- [ Offline](/forum/user/51944-virusys)

Less More

- Posts: 70
- Thank you received: 3
-
-

6 years 2 months ago [\#323664](#323664) by [virusys](/forum/user/51944-virusys "View virusys's Profile")  *[Changing Order Status Error](/forum/35-orders-management/900745-changing-order-status-error#323664 "-- HikaShop version -- : 4.3 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.3  When changing anything about an order (status as mentioned here) I get the following error:  An error has occurred. 1054 Unknown column 'settings' in 'field list' Return to Control Panel  How to fix?")* was created by *[virusys](/forum/user/51944-virusys "View virusys's Profile")*

-- HikaShop version -- : 4.3
-- Joomla version -- : 3.9.21
-- PHP version -- : 7.3

When changing anything about an order (status as mentioned here) I get the following error:

**An error has occurred.
1054 Unknown column 'settings' in 'field list'
Return to Control Panel**

How to fix?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwMDc0NS1jaGFuZ2luZy1vcmRlci1zdGF0dXMtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Philip](/forum/user/34318-philip "View Philip's Profile")**
- [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile")
- [ Offline](/forum/user/34318-philip)

Less More

- Posts: 4820
- Thank you received: 652
-
-

6 years 2 months ago -  6 years 2 months ago [\#323698](#323698) by [Philip](/forum/user/34318-philip "View Philip's Profile")  Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Changing Order Status Error](/forum/35-orders-management/900745-changing-order-status-error#323698 "-- HikaShop version -- : 4.3 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.3  When changing anything about an order (status as mentioned here) I get the following error:  An error has occurred. 1054 Unknown column 'settings' in 'field list' Return to Control Panel  How to fix?")*

Hello,

The first things to try when you have this kind of error message is to process a "**Check database**".
[ ![alt](https://i.imgur.com/AIdZbNv.png) ](https://i.imgur.com/AIdZbNv.png "alt")

Sometimes when you have process an update, that can sometimes leads to breaking the links between the databases.

If that didn't change things, did you carry out operations directly in your database? Like deleted some custom field, and especially order custom field ?

Awaiting news from you to be able to progress on your subject.
Regards

Last edit: 6 years 2 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwMDc0NS1jaGFuZ2luZy1vcmRlci1zdGF0dXMtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[virusys](/forum/user/51944-virusys "View virusys's Profile")**
- [![virusys's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar51944.jpg)](/forum/user/51944-virusys "View virusys's Profile") Topic Author
- [ Offline](/forum/user/51944-virusys)

Less More

- Posts: 70
- Thank you received: 3
-
-

6 years 2 months ago [\#323723](#323723) by [virusys](/forum/user/51944-virusys "View virusys's Profile")  Replied by *[virusys](/forum/user/51944-virusys "View virusys's Profile")* on topic *[Changing Order Status Error](/forum/35-orders-management/900745-changing-order-status-error#323723 "-- HikaShop version -- : 4.3 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.3  When changing anything about an order (status as mentioned here) I get the following error:  An error has occurred. 1054 Unknown column 'settings' in 'field list' Return to Control Panel  How to fix?")*

Thanks Philippe.

Nothing deleted that I know of. Ran the database script - error still there.

I don't see a table 'field list' or a column "settings" in 'hikashop_field'

Pretty strange.

What do you want to do next?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwMDc0NS1jaGFuZ2luZy1vcmRlci1zdGF0dXMtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86541
- Thank you received: 14304
-
-

6 years 2 months ago [\#323726](#323726) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Changing Order Status Error](/forum/35-orders-management/900745-changing-order-status-error#323726 "-- HikaShop version -- : 4.3 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.3  When changing anything about an order (status as mentioned here) I get the following error:  An error has occurred. 1054 Unknown column 'settings' in 'field list' Return to Control Panel  How to fix?")*

Hi,

Activate the "debug mode" setting of the Joomla configuration and try again.
The error page should contain more information, and especially the callstack, which will help us understand where the problem is coming from. Please provide the additional information.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwMDc0NS1jaGFuZ2luZy1vcmRlci1zdGF0dXMtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[virusys](/forum/user/51944-virusys "View virusys's Profile")**
- [![virusys's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar51944.jpg)](/forum/user/51944-virusys "View virusys's Profile") Topic Author
- [ Offline](/forum/user/51944-virusys)

Less More

- Posts: 70
- Thank you received: 3
-
-

6 years 2 months ago [\#323790](#323790) by [virusys](/forum/user/51944-virusys "View virusys's Profile")  Replied by *[virusys](/forum/user/51944-virusys "View virusys's Profile")* on topic *[Changing Order Status Error](/forum/35-orders-management/900745-changing-order-status-error#323790 "-- HikaShop version -- : 4.3 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.3  When changing anything about an order (status as mentioned here) I get the following error:  An error has occurred. 1054 Unknown column 'settings' in 'field list' Return to Control Panel  How to fix?")*

I have it sorted now - a failed Acymailing update was causing the issue.

All is well now....

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50LzkwMDc0NS1jaGFuZ2luZy1vcmRlci1zdGF0dXMtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.063 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
