[Skip to main content](#vessel-content) # Hikashop configuration is gone after every update ## - **[Jonkerm](/forum/user/33565-jonkerm "View Jonkerm's Profile")** - [![Jonkerm's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33565-jonkerm "View Jonkerm's Profile") Topic Author - [ Offline](/forum/user/33565-jonkerm) Less More - Posts: 8 - Thank you received: 1 - - 2 years 2 months ago [\#362851](#362851) by [Jonkerm](/forum/user/33565-jonkerm "View Jonkerm's Profile") *[Hikashop configuration is gone after every update](/forum/25-install-update/908538-hikashop-configuration-is-gone-after-every-update#362851 "-- HikaShop version -- : Essential 5.1.0 -- Joomla version -- : 3.10 -- PHP version -- : 7.4.33 -- Browser(s) name and version -- : Chrome After every Hikashop-update my name, adress, e-mailadresses are overwritten by the default values in the configuration. There is a adres in the UK -we are in the Netherlands- and on a lot of places he fill in the e-mailadres of the webmaster (from the Joomla-system-configuration I think). Is there a way to avoid that, so he update Hikashop, but leave my settings/config alone? Thanks for your answer(s)!")* was created by *[Jonkerm](/forum/user/33565-jonkerm "View Jonkerm's Profile")* -- HikaShop version -- : Essential 5.1.0 -- Joomla version -- : 3.10 -- PHP version -- : 7.4.33 -- Browser(s) name and version -- : Chrome After every Hikashop-update my name, adress, e-mailadresses are overwritten by the default values in the configuration. There is a adres in the UK -we are in the Netherlands- and on a lot of places he fill in the e-mailadres of the webmaster (from the Joomla-system-configuration I think). Is there a way to avoid that, so he update Hikashop, but leave my settings/config alone? Thanks for your answer(s)! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwODUzOC1oaWthc2hvcC1jb25maWd1cmF0aW9uLWlzLWdvbmUtYWZ0ZXItZXZlcnktdXBkYXRlP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 2 years 1 month ago [\#362946](#362946) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Hikashop configuration is gone after every update](/forum/25-install-update/908538-hikashop-configuration-is-gone-after-every-update#362946 "-- HikaShop version -- : Essential 5.1.0 -- Joomla version -- : 3.10 -- PHP version -- : 7.4.33 -- Browser(s) name and version -- : Chrome After every Hikashop-update my name, adress, e-mailadresses are overwritten by the default values in the configuration. There is a adres in the UK -we are in the Netherlands- and on a lot of places he fill in the e-mailadres of the webmaster (from the Joomla-system-configuration I think). Is there a way to avoid that, so he update Hikashop, but leave my settings/config alone? Thanks for your answer(s)!")* Hi, Sorry for not answering earlier. I checked the situation on our end. No one else reported the problem and we can't reproduce it either. These settings are set with the code in the function addPref of the file install.hikashop.php at the root of the install package of HikaShop. At the end of the function, you can see the MySQL query running to set these parameters. And yes, this MySQL is run each time HikaShop is installed or updated. However, as you can read there, this MySQL query is like this: Code: INSERT IGNORE INTO `#__hikashop_config` (`config_namekey`,`config_value`,`config_default`) VALUES ... What "INSERT IGNORE" means is that MySQL will look at the entries in the hikashop_config table. If a row in that table already exists with the same config_namekey, it will skip it, otherwise it will add it. So you can't have more than one row with the same namekey and once a row with a namekey is added after the first installation, subsequent updates won't add them again, unless you empty the hikashop_config table manually via your PHPMyAdmin. What this all means for you is that I suspect that the primary key on the "config_namekey" column has been removed from the hikashop_config table on your website. Without the primary key there, this MySQL query I talked about above will add new rows each time HikaShop is installed. And when HikaShop loads the settings for that table, Joomla will group the rows with the same namekey and only keep the latest one. I remember someone having a similar issue because of a problem during the migration of the database with the tool they were using which lost the primary key on the table. To check if my theory is correct, go in your PHPMyAdmin and access the hikashop_config table. You can check its structure. There, it should mention the primary key, at the bottom, under the "indexes" section: [ phpandmysql.com/extras/composite-primary...te-primary-key-2.png](https://phpandmysql.com/extras/composite-primary-key/images/create-composite-primary-key-2.png) You can also check if you have several entries with the same config_namekey in that table. Supposing that we're in this scenario, in order to fix the problem, you won't be able to add the primary key directly. It will be refused by PHPMyAdmin because you have several entries with the same config_namekey. So, I think the simplest would be to delete the hikashop_config table completely and install HikaShop again. The installer will add the table with the proper primary key and set the default values. You'll have to reconfigure your HikaShop once again, but after this, further updates won't change your settings back to default. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwODUzOC1oaWthc2hvcC1jb25maWd1cmF0aW9uLWlzLWdvbmUtYWZ0ZXItZXZlcnktdXBkYXRlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jonkerm](/forum/user/33565-jonkerm "View Jonkerm's Profile")** - [![Jonkerm's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33565-jonkerm "View Jonkerm's Profile") Topic Author - [ Offline](/forum/user/33565-jonkerm) Less More - Posts: 8 - Thank you received: 1 - - 1 year 9 months ago [\#365369](#365369) by [Jonkerm](/forum/user/33565-jonkerm "View Jonkerm's Profile") Replied by *[Jonkerm](/forum/user/33565-jonkerm "View Jonkerm's Profile")* on topic *[Hikashop configuration is gone after every update](/forum/25-install-update/908538-hikashop-configuration-is-gone-after-every-update#365369 "-- HikaShop version -- : Essential 5.1.0 -- Joomla version -- : 3.10 -- PHP version -- : 7.4.33 -- Browser(s) name and version -- : Chrome After every Hikashop-update my name, adress, e-mailadresses are overwritten by the default values in the configuration. There is a adres in the UK -we are in the Netherlands- and on a lot of places he fill in the e-mailadres of the webmaster (from the Joomla-system-configuration I think). Is there a way to avoid that, so he update Hikashop, but leave my settings/config alone? Thanks for your answer(s)!")* Thank you and sorry for the late answer, Nicolas! You are right: the config-table keeps growing, it has more than 20.000 rows/items. The table is different than the normal Joomla-tables, where (in phpMyAdmin) every item is a row, and you can edit, select and drop rows or empty the table. You can not do that in the Hikashop-config table: Above are 3 colums: "config_namekey", "config_value" and "config_default", and then every setting looks like a row, but you can't select that and there are no options to delete or drop the table. In the top of the page there is a warning: "Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available." I have tried your solution to delete the Hikashop-config-table, but then the administrator-section of Joomla don't work anymore and you can't instal extensions anymore. Finaly it seems to work: I have renamed the original config-table, instal Hikashop in another Joomla 3.10 site, export that new config-table and import it in the original database. It looks good (like a normal table, with rows you can edit, delete etc.), so I now delete the renamed-table. Just want to let you know, in case someone else has the same problem. The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwODUzOC1oaWthc2hvcC1jb25maWd1cmF0aW9uLWlzLWdvbmUtYWZ0ZXItZXZlcnktdXBkYXRlP3RtcGw9bWFya2Rvd24=) 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.214 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)