[Skip to main content](#vessel-content) # Error in address\_country setting main attributes default value ## - **[michaelgilkes](/forum/user/5244-michaelgilkes "View michaelgilkes's Profile")** - [![michaelgilkes's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5244-michaelgilkes "View michaelgilkes's Profile") Topic Author - [ Offline](/forum/user/5244-michaelgilkes) Less More - Posts: 14 - Thank you received: 0 - - 8 years 4 months ago - 8 years 4 months ago [\#294709](#294709) by [michaelgilkes](/forum/user/5244-michaelgilkes "View michaelgilkes's Profile") *[Error in address\_country setting main attributes default value](/forum/3-bug-report/895134-error-in-address-country-setting-main-attributes-default-value#294709 "-- HikaShop version -- : 3.4.1 -- Joomla version -- : 3.8.10 -- PHP version -- : 7.1.0 -- Browser(s) name and version -- : Safari 11.1.1 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'guest_mode' in 'field list' /xxxxxxx/xxxxxx/xxxxx/xxxxxxxx/libraries/joomla/database/driver/mysqli.php:650 Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:2278 3 JDatabaseDriver->updateObject() JROOT/administrator/components/com_hikashop/helpers/helper.php:1940 4 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/field.php:1561 5 hikashopFieldClass->save() JROOT/administrator/components/com_hikashop/classes/field.php:609 6 hikashopFieldClass->handleZone() JROOT/administrator/components/com_hikashop/classes/field.php:562 7 hikashopFieldClass->prepareFields() JROOT/administrator/components/com_hikashop/classes/field.php:158 8 hikashopFieldClass->getFields() JROOT/administrator/components/com_hikashop/views/field/view.html.php:34 9 FieldViewField->form() JROOT/administrator/components/com_hikashop/views/field/view.html.php:19 10 FieldViewField->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 16 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382 17 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 18 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 19 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 20 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 21 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Ok. I seemed to have uncovered an error, and not sure how to fix it. I went to Display > Custom fields. Clicked on address_country. In extra attributes, I changed "Add a 'Please select' value" to "Yes". Then in Main Attributes, I changed Default Value to "Please make a selection from the list". Then I clicked "Save". Immediately, after I clicked save, I get "An error has occurred. 1054 Unknown column 'guest_mode' in 'field list'". And now I can't get to change it back. I goes directly to this error every time I click on address_country. Can you help me fix this? Michael")* was created by *[michaelgilkes](/forum/user/5244-michaelgilkes "View michaelgilkes's Profile")* -- HikaShop version -- : 3.4.1 -- Joomla version -- : 3.8.10 -- PHP version -- : 7.1.0 -- Browser(s) name and version -- : Safari 11.1.1 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'guest_mode' in 'field list' /xxxxxxx/xxxxxx/xxxxx/xxxxxxxx/libraries/joomla/database/driver/mysqli.php:650 Call stack \# Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:2278 3 JDatabaseDriver->updateObject() JROOT/administrator/components/com_hikashop/helpers/helper.php:1940 4 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/field.php:1561 5 hikashopFieldClass->save() JROOT/administrator/components/com_hikashop/classes/field.php:609 6 hikashopFieldClass->handleZone() JROOT/administrator/components/com_hikashop/classes/field.php:562 7 hikashopFieldClass->prepareFields() JROOT/administrator/components/com_hikashop/classes/field.php:158 8 hikashopFieldClass->getFields() JROOT/administrator/components/com_hikashop/views/field/view.html.php:34 9 FieldViewField->form() JROOT/administrator/components/com_hikashop/views/field/view.html.php:19 10 FieldViewField->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 16 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382 17 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 18 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 19 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 20 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 21 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Ok. I seemed to have uncovered an error, and not sure how to fix it. I went to Display > Custom fields. Clicked on address_country. In extra attributes, I changed "Add a 'Please select' value" to "Yes". Then in Main Attributes, I changed Default Value to "Please make a selection from the list". Then I clicked "Save". Immediately, after I clicked save, I get "An error has occurred. 1054 Unknown column 'guest_mode' in 'field list'". And now I can't get to change it back. I goes directly to this error every time I click on address_country. Can you help me fix this? Michael Last edit: 8 years 4 months ago by [michaelgilkes](/forum/user/5244-michaelgilkes "View michaelgilkes's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84OTUxMzQtZXJyb3ItaW4tYWRkcmVzcy1jb3VudHJ5LXNldHRpbmctbWFpbi1hdHRyaWJ1dGVzLWRlZmF1bHQtdmFsdWU/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/avatars/resized/size144/users/avatar34318_2015-11-18-2.png)](/forum/user/34318-philip "View Philip's Profile") - [ Offline](/forum/user/34318-philip) Less More - Posts: 4820 - Thank you received: 654 - - 8 years 4 months ago - 8 years 4 months ago [\#294757](#294757) by [Philip](/forum/user/34318-philip "View Philip's Profile") Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Error in address\_country setting main attributes default value](/forum/3-bug-report/895134-error-in-address-country-setting-main-attributes-default-value#294757 "-- HikaShop version -- : 3.4.1 -- Joomla version -- : 3.8.10 -- PHP version -- : 7.1.0 -- Browser(s) name and version -- : Safari 11.1.1 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'guest_mode' in 'field list' /xxxxxxx/xxxxxx/xxxxx/xxxxxxxx/libraries/joomla/database/driver/mysqli.php:650 Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:2278 3 JDatabaseDriver->updateObject() JROOT/administrator/components/com_hikashop/helpers/helper.php:1940 4 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/field.php:1561 5 hikashopFieldClass->save() JROOT/administrator/components/com_hikashop/classes/field.php:609 6 hikashopFieldClass->handleZone() JROOT/administrator/components/com_hikashop/classes/field.php:562 7 hikashopFieldClass->prepareFields() JROOT/administrator/components/com_hikashop/classes/field.php:158 8 hikashopFieldClass->getFields() JROOT/administrator/components/com_hikashop/views/field/view.html.php:34 9 FieldViewField->form() JROOT/administrator/components/com_hikashop/views/field/view.html.php:19 10 FieldViewField->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 16 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382 17 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 18 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 19 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 20 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 21 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Ok. I seemed to have uncovered an error, and not sure how to fix it. I went to Display > Custom fields. Clicked on address_country. In extra attributes, I changed "Add a 'Please select' value" to "Yes". Then in Main Attributes, I changed Default Value to "Please make a selection from the list". Then I clicked "Save". Immediately, after I clicked save, I get "An error has occurred. 1054 Unknown column 'guest_mode' in 'field list'". And now I can't get to change it back. I goes directly to this error every time I click on address_country. Can you help me fix this? Michael")* Hello, First things to do is to make a check database : image missing https://cdn.pbrd.co/images/Hsz8NdH.png Other point to precise, **how** can you change this default value in Main Attributes for "*Please make a selection from the list*" ? image missing https://cdn.pbrd.co/images/HsziX5E.png Here, we have a dropdown to select selected **only country value**, and so I wonder how you can change this another value type ?... Can you provide a screenshot ? Awaiting news from you. Regards Last edit: 8 years 4 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84OTUxMzQtZXJyb3ItaW4tYWRkcmVzcy1jb3VudHJ5LXNldHRpbmctbWFpbi1hdHRyaWJ1dGVzLWRlZmF1bHQtdmFsdWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[michaelgilkes](/forum/user/5244-michaelgilkes "View michaelgilkes's Profile")** - [![michaelgilkes's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5244-michaelgilkes "View michaelgilkes's Profile") Topic Author - [ Offline](/forum/user/5244-michaelgilkes) Less More - Posts: 14 - Thank you received: 0 - - 8 years 4 months ago [\#294771](#294771) by [michaelgilkes](/forum/user/5244-michaelgilkes "View michaelgilkes's Profile") Replied by *[michaelgilkes](/forum/user/5244-michaelgilkes "View michaelgilkes's Profile")* on topic *[Error in address\_country setting main attributes default value](/forum/3-bug-report/895134-error-in-address-country-setting-main-attributes-default-value#294771 "-- HikaShop version -- : 3.4.1 -- Joomla version -- : 3.8.10 -- PHP version -- : 7.1.0 -- Browser(s) name and version -- : Safari 11.1.1 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'guest_mode' in 'field list' /xxxxxxx/xxxxxx/xxxxx/xxxxxxxx/libraries/joomla/database/driver/mysqli.php:650 Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:2278 3 JDatabaseDriver->updateObject() JROOT/administrator/components/com_hikashop/helpers/helper.php:1940 4 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/field.php:1561 5 hikashopFieldClass->save() JROOT/administrator/components/com_hikashop/classes/field.php:609 6 hikashopFieldClass->handleZone() JROOT/administrator/components/com_hikashop/classes/field.php:562 7 hikashopFieldClass->prepareFields() JROOT/administrator/components/com_hikashop/classes/field.php:158 8 hikashopFieldClass->getFields() JROOT/administrator/components/com_hikashop/views/field/view.html.php:34 9 FieldViewField->form() JROOT/administrator/components/com_hikashop/views/field/view.html.php:19 10 FieldViewField->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 16 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382 17 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 18 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 19 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 20 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 21 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Ok. I seemed to have uncovered an error, and not sure how to fix it. I went to Display > Custom fields. Clicked on address_country. In extra attributes, I changed "Add a 'Please select' value" to "Yes". Then in Main Attributes, I changed Default Value to "Please make a selection from the list". Then I clicked "Save". Immediately, after I clicked save, I get "An error has occurred. 1054 Unknown column 'guest_mode' in 'field list'". And now I can't get to change it back. I goes directly to this error every time I click on address_country. Can you help me fix this? Michael")* Hi Philip, Please check my explanation. you have to change "Add a 'Please select' value" to "Yes" in extra attributes, first. See my screenshot. [ ![ScreenShot2018-07-02at8.26.16AM.png](/forum/attachment/44070) ](/forum/attachment/44070 "...t8.26.16AM.png") - [ ![ScreenShot2018-07-02at8.26.16AM.png](/forum/attachment/44070) ](/forum/attachment/44070 "...t8.26.16AM.png") [ ](/forum/attachment/44070?download=1 "...t8.26.16AM.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84OTUxMzQtZXJyb3ItaW4tYWRkcmVzcy1jb3VudHJ5LXNldHRpbmctbWFpbi1hdHRyaWJ1dGVzLWRlZmF1bHQtdmFsdWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 8 years 4 months ago [\#294773](#294773) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Error in address\_country setting main attributes default value](/forum/3-bug-report/895134-error-in-address-country-setting-main-attributes-default-value#294773 "-- HikaShop version -- : 3.4.1 -- Joomla version -- : 3.8.10 -- PHP version -- : 7.1.0 -- Browser(s) name and version -- : Safari 11.1.1 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'guest_mode' in 'field list' /xxxxxxx/xxxxxx/xxxxx/xxxxxxxx/libraries/joomla/database/driver/mysqli.php:650 Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:2278 3 JDatabaseDriver->updateObject() JROOT/administrator/components/com_hikashop/helpers/helper.php:1940 4 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/field.php:1561 5 hikashopFieldClass->save() JROOT/administrator/components/com_hikashop/classes/field.php:609 6 hikashopFieldClass->handleZone() JROOT/administrator/components/com_hikashop/classes/field.php:562 7 hikashopFieldClass->prepareFields() JROOT/administrator/components/com_hikashop/classes/field.php:158 8 hikashopFieldClass->getFields() JROOT/administrator/components/com_hikashop/views/field/view.html.php:34 9 FieldViewField->form() JROOT/administrator/components/com_hikashop/views/field/view.html.php:19 10 FieldViewField->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 16 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382 17 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 18 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 19 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 20 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 21 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Ok. I seemed to have uncovered an error, and not sure how to fix it. I went to Display > Custom fields. Clicked on address_country. In extra attributes, I changed "Add a 'Please select' value" to "Yes". Then in Main Attributes, I changed Default Value to "Please make a selection from the list". Then I clicked "Save". Immediately, after I clicked save, I get "An error has occurred. 1054 Unknown column 'guest_mode' in 'field list'". And now I can't get to change it back. I goes directly to this error every time I click on address_country. Can you help me fix this? Michael")* Hello, I tried to reproduce your issue on my end and it worked fine, did you tried to use the "Check database" option via "Hikashop->System->Configuration" ? Best regards, Mohamed Thelji. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84OTUxMzQtZXJyb3ItaW4tYWRkcmVzcy1jb3VudHJ5LXNldHRpbmctbWFpbi1hdHRyaWJ1dGVzLWRlZmF1bHQtdmFsdWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[michaelgilkes](/forum/user/5244-michaelgilkes "View michaelgilkes's Profile")** - [![michaelgilkes's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5244-michaelgilkes "View michaelgilkes's Profile") Topic Author - [ Offline](/forum/user/5244-michaelgilkes) Less More - Posts: 14 - Thank you received: 0 - - 8 years 4 months ago - 8 years 4 months ago [\#294790](#294790) by [michaelgilkes](/forum/user/5244-michaelgilkes "View michaelgilkes's Profile") Replied by *[michaelgilkes](/forum/user/5244-michaelgilkes "View michaelgilkes's Profile")* on topic *[Error in address\_country setting main attributes default value](/forum/3-bug-report/895134-error-in-address-country-setting-main-attributes-default-value#294790 "-- HikaShop version -- : 3.4.1 -- Joomla version -- : 3.8.10 -- PHP version -- : 7.1.0 -- Browser(s) name and version -- : Safari 11.1.1 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'guest_mode' in 'field list' /xxxxxxx/xxxxxx/xxxxx/xxxxxxxx/libraries/joomla/database/driver/mysqli.php:650 Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:2278 3 JDatabaseDriver->updateObject() JROOT/administrator/components/com_hikashop/helpers/helper.php:1940 4 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/field.php:1561 5 hikashopFieldClass->save() JROOT/administrator/components/com_hikashop/classes/field.php:609 6 hikashopFieldClass->handleZone() JROOT/administrator/components/com_hikashop/classes/field.php:562 7 hikashopFieldClass->prepareFields() JROOT/administrator/components/com_hikashop/classes/field.php:158 8 hikashopFieldClass->getFields() JROOT/administrator/components/com_hikashop/views/field/view.html.php:34 9 FieldViewField->form() JROOT/administrator/components/com_hikashop/views/field/view.html.php:19 10 FieldViewField->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 16 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382 17 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 18 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 19 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 20 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 21 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Ok. I seemed to have uncovered an error, and not sure how to fix it. I went to Display > Custom fields. Clicked on address_country. In extra attributes, I changed "Add a 'Please select' value" to "Yes". Then in Main Attributes, I changed Default Value to "Please make a selection from the list". Then I clicked "Save". Immediately, after I clicked save, I get "An error has occurred. 1054 Unknown column 'guest_mode' in 'field list'". And now I can't get to change it back. I goes directly to this error every time I click on address_country. Can you help me fix this? Michael")* Hi Mohamed, I don't understand why you are not able to reproduce this error given my explanation of the steps I took. However, I just did the same steps again and the error came up. The check database didn't fix the issue either. To fix it I had to manually go to the mysql database backend, go the hikashop_field table, edit the row with field_namekey address_country and using the value from a backup copy of my database, add the value in the backup for field_default column, since I found it blank. I made a screen video of it happening, but your file attachment won't allow me to upload it even though I zipped it up and it was under 4mb. I hope you can reproduce it. Here are my steps again for your reference: 1. I went to Display > Custom fields. Clicked on address_country. 2. In extra attributes, I changed "Add a 'Please select' value" to "Yes". 3. Then in Main Attributes, I changed Default Value to "Please make a selection from the list". 4. Then I clicked "Save". Immediately, after I clicked save, I get "An error has occurred. 1054 Unknown column 'guest_mode' in 'field list'". You must do step 2 in order to reproduce the error. In the screenshot provided by Philip, "Add a 'Please select' value" in extra attributes was set to "No". If it is set to no, then you can't do step 3. Set it to "Yes", and then you should be able to reproduce the error. I provided another screenshot. you can see the option appear right at the top above Afghanistan. Thanks, Michael - [ ![ScreenShot2018-07-02at9.46.04PM.png](/forum/attachment/44075) ](/forum/attachment/44075 "...t9.46.04PM.png") [ ](/forum/attachment/44075?download=1 "...t9.46.04PM.png") Last edit: 8 years 4 months ago by [michaelgilkes](/forum/user/5244-michaelgilkes "View michaelgilkes's Profile"). Reason: adding screenshot Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84OTUxMzQtZXJyb3ItaW4tYWRkcmVzcy1jb3VudHJ5LXNldHRpbmctbWFpbi1hdHRyaWJ1dGVzLWRlZmF1bHQtdmFsdWU/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: 86320 - Thank you received: 14279 - - 8 years 3 months ago [\#294811](#294811) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error in address\_country setting main attributes default value](/forum/3-bug-report/895134-error-in-address-country-setting-main-attributes-default-value#294811 "-- HikaShop version -- : 3.4.1 -- Joomla version -- : 3.8.10 -- PHP version -- : 7.1.0 -- Browser(s) name and version -- : Safari 11.1.1 -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'guest_mode' in 'field list' /xxxxxxx/xxxxxx/xxxxx/xxxxxxxx/libraries/joomla/database/driver/mysqli.php:650 Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:2278 3 JDatabaseDriver->updateObject() JROOT/administrator/components/com_hikashop/helpers/helper.php:1940 4 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/field.php:1561 5 hikashopFieldClass->save() JROOT/administrator/components/com_hikashop/classes/field.php:609 6 hikashopFieldClass->handleZone() JROOT/administrator/components/com_hikashop/classes/field.php:562 7 hikashopFieldClass->prepareFields() JROOT/administrator/components/com_hikashop/classes/field.php:158 8 hikashopFieldClass->getFields() JROOT/administrator/components/com_hikashop/views/field/view.html.php:34 9 FieldViewField->form() JROOT/administrator/components/com_hikashop/views/field/view.html.php:19 10 FieldViewField->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 16 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382 17 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 18 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 19 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 20 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 21 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Ok. I seemed to have uncovered an error, and not sure how to fix it. I went to Display > Custom fields. Clicked on address_country. In extra attributes, I changed "Add a 'Please select' value" to "Yes". Then in Main Attributes, I changed Default Value to "Please make a selection from the list". Then I clicked "Save". Immediately, after I clicked save, I get "An error has occurred. 1054 Unknown column 'guest_mode' in 'field list'". And now I can't get to change it back. I goes directly to this error every time I click on address_country. Can you help me fix this? Michael")* Hi, Thank you for the details. We've added a patch for that. Please download the install package on our website and install it again and that should help. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84OTUxMzQtZXJyb3ItaW4tYWRkcmVzcy1jb3VudHJ5LXNldHRpbmctbWFpbi1hdHRyaWJ1dGVzLWRlZmF1bHQtdmFsdWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & 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.403 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)