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

#   Can not (re)create custom field with same column name as deleted field

##

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

Less More

- Posts: 29
- Thank you received: 2
-
-

4 years 6 months ago [\#341131](#341131) by [pjdevries](/forum/user/64503-pjdevries "View pjdevries's Profile")  *[Can not (re)create custom field with same column name as deleted field](/forum/31-development/904315-can-not-re-create-custom-field-with-same-column-name-as-deleted-field#341131 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 4.1 -- PHP version -- : 7.4  Not sure where to put this issue, so I'll do it here.  When deleting a custom field, it seems not possible to create a new custom field with the same Column&#95;name for the same Table. The reasons being that the field does get removed from the #&#95;&#95;hikashop&#95;field table but the actual table column is not removed from the table it was designated to.  Is this a bug or a feature?")* was created by *[pjdevries](/forum/user/64503-pjdevries "View pjdevries's Profile")*

-- HikaShop version -- : 4.4.5
-- Joomla version -- : 4.1
-- PHP version -- : 7.4

Not sure where to put this issue, so I'll do it here.

When deleting a custom field, it seems not possible to create a new custom field with the same **Column\_name** for the same **Table**. The reasons being that the field does get removed from the **\#\_\_hikashop\_field** table but the actual table column is not removed from the table it was designated to.

Is this a bug or a feature?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2RldmVsb3BtZW50LzkwNDMxNS1jYW4tbm90LXJlLWNyZWF0ZS1jdXN0b20tZmllbGQtd2l0aC1zYW1lLWNvbHVtbi1uYW1lLWFzLWRlbGV0ZWQtZmllbGQ/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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86564
- Thank you received: 14311
-
-

4 years 6 months ago [\#341134](#341134) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Can not (re)create custom field with same column name as deleted field](/forum/31-development/904315-can-not-re-create-custom-field-with-same-column-name-as-deleted-field#341134 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 4.1 -- PHP version -- : 7.4  Not sure where to put this issue, so I'll do it here.  When deleting a custom field, it seems not possible to create a new custom field with the same Column&#95;name for the same Table. The reasons being that the field does get removed from the #&#95;&#95;hikashop&#95;field table but the actual table column is not removed from the table it was designated to.  Is this a bug or a feature?")*

Hi,

It's made on purpose so that you don't delete inadvertedly the data of your custom fields if you don't know what you're doing.
So either:
- you use another column name and you're ok like that
- you use another column name, and once the custom field is created, you can go in your PHPMyAdmin to change the column name of the custom field in the hikashop_field table so that the new custom field will see the data you had previously entered
- you delete the column manually in the target table via your PHPMyadmin and then you can create a custom field with the old column name

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

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

Less More

- Posts: 29
- Thank you received: 2
-
-

4 years 6 months ago [\#341341](#341341) by [pjdevries](/forum/user/64503-pjdevries "View pjdevries's Profile")  Replied by *[pjdevries](/forum/user/64503-pjdevries "View pjdevries's Profile")* on topic *[Can not (re)create custom field with same column name as deleted field](/forum/31-development/904315-can-not-re-create-custom-field-with-same-column-name-as-deleted-field#341341 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 4.1 -- PHP version -- : 7.4  Not sure where to put this issue, so I'll do it here.  When deleting a custom field, it seems not possible to create a new custom field with the same Column&#95;name for the same Table. The reasons being that the field does get removed from the #&#95;&#95;hikashop&#95;field table but the actual table column is not removed from the table it was designated to.  Is this a bug or a feature?")*

Thanx for the explanation. I anticipated an answer like this ![:)](/media/kunena/emoticons/3.png ":)") It's a rather cumbersome way of maintaining an already complex application though. Don't you think a simple "Are you sure you want to delete the field and all associated data?" confirmation is more user friendly? Especially so for less technical savvy users?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2RldmVsb3BtZW50LzkwNDMxNS1jYW4tbm90LXJlLWNyZWF0ZS1jdXN0b20tZmllbGQtd2l0aC1zYW1lLWNvbHVtbi1uYW1lLWFzLWRlbGV0ZWQtZmllbGQ/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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86564
- Thank you received: 14311
-
-

4 years 6 months ago [\#341342](#341342) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Can not (re)create custom field with same column name as deleted field](/forum/31-development/904315-can-not-re-create-custom-field-with-same-column-name-as-deleted-field#341342 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 4.1 -- PHP version -- : 7.4  Not sure where to put this issue, so I'll do it here.  When deleting a custom field, it seems not possible to create a new custom field with the same Column&#95;name for the same Table. The reasons being that the field does get removed from the #&#95;&#95;hikashop&#95;field table but the actual table column is not removed from the table it was designated to.  Is this a bug or a feature?")*

Hi,

Well, there is already a confirmation when you delete a custom field. But even so, people were deleting their data by inadvertance.
Forcing them to do so via the database avoid this from happening. But I agree it's cumbersome.
I think the best would be to allow users to create custom fields for columns that already exist provided it's not a default column of the table and that it isn't already used by another custom field. That would make for a smoother experience while avoiding cumbersome manipulations in PHPMyAdmin.

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

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

Less More

- Posts: 29
- Thank you received: 2
-
-

4 years 6 months ago [\#341343](#341343) by [pjdevries](/forum/user/64503-pjdevries "View pjdevries's Profile")  Replied by *[pjdevries](/forum/user/64503-pjdevries "View pjdevries's Profile")* on topic *[Can not (re)create custom field with same column name as deleted field](/forum/31-development/904315-can-not-re-create-custom-field-with-same-column-name-as-deleted-field#341343 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 4.1 -- PHP version -- : 7.4  Not sure where to put this issue, so I'll do it here.  When deleting a custom field, it seems not possible to create a new custom field with the same Column&#95;name for the same Table. The reasons being that the field does get removed from the #&#95;&#95;hikashop&#95;field table but the actual table column is not removed from the table it was designated to.  Is this a bug or a feature?")*

Hi Nicolas,

Smoother yes. But if a column already exists and contains data, that data is not necessarily compatible with that of the newly created field. And even if it is, it is quite uncertain if it should be retained. So in the end you may have to delete the existing data anyway. Or is my reasoning somewhat flawed here?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2RldmVsb3BtZW50LzkwNDMxNS1jYW4tbm90LXJlLWNyZWF0ZS1jdXN0b20tZmllbGQtd2l0aC1zYW1lLWNvbHVtbi1uYW1lLWFzLWRlbGV0ZWQtZmllbGQ/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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86564
- Thank you received: 14311
-
-

4 years 6 months ago [\#341347](#341347) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Can not (re)create custom field with same column name as deleted field](/forum/31-development/904315-can-not-re-create-custom-field-with-same-column-name-as-deleted-field#341347 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 4.1 -- PHP version -- : 7.4  Not sure where to put this issue, so I'll do it here.  When deleting a custom field, it seems not possible to create a new custom field with the same Column&#95;name for the same Table. The reasons being that the field does get removed from the #&#95;&#95;hikashop&#95;field table but the actual table column is not removed from the table it was designated to.  Is this a bug or a feature?")*

Hi,

In that case, you could always just use another column name.
But yes, that could be useful, yes. We'll look at how we can improve things there.
Thanks for your feedback.

The following user(s) said Thank You: [pjdevries](/forum/user/64503-pjdevries "View pjdevries's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2RldmVsb3BtZW50LzkwNDMxNS1jYW4tbm90LXJlLWNyZWF0ZS1jdXN0b20tZmllbGQtd2l0aC1zYW1lLWNvbHVtbi1uYW1lLWFzLWRlbGV0ZWQtZmllbGQ/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.075 seconds

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