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

#   Upgrade deletes Custom Fields &amp; Custom Order #'s

##

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

Less More

- Posts: 40
- Thank you received: 0
-
-

13 years 9 months ago [\#88386](#88386) by [cluckngood](/forum/user/11050-cluckngood "View cluckngood's Profile")  *[Upgrade deletes Custom Fields &amp; Custom Order #'s](/forum/3-bug-report/78007-upgrade-deletes-custom-fields-custom-order-s#88386 "I've just upgraded my HS Business from v2.0.0 dated june 2012 to the most recent version the changelog shows as the same version 2.0.0 dated &quot;November 2012&quot;. First off i'm a little confused about...")* was created by *[cluckngood](/forum/user/11050-cluckngood "View cluckngood's Profile")*

I've just upgraded my HS Business from v2.0.0 dated june 2012 to the most recent version the changelog shows as the same version 2.0.0 dated "November 2012". First off i'm a little confused about this different release of the same version 5 months later.

I'm experiencing a situation where after upgrading all of my custom fields used for my checkout have been deleted. I have tried to recreate them and now they will not publish at all. One of the custom fields i was able to recreate in the Custom Fields manager. Another one i cannot recreate as i receive an error that the item already exists in the database. I see know way to fix this as i don't know how to delete it out of the db to recreate it.

The other issue is that my custom order #'s have been reset to the HS default. An easy fix but somewhat annoying as i just launched this site and am now find out these issues which i did not expect to occur.

If anyone knows of a patch or easy way to correct these would be great.

Jason

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

Less More

- Posts: 86560
- Thank you received: 14307
-
-

13 years 9 months ago [\#88526](#88526) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Upgrade deletes Custom Fields &amp; Custom Order #'s](/forum/3-bug-report/78007-upgrade-deletes-custom-fields-custom-order-s#88526 "I've just upgraded my HS Business from v2.0.0 dated june 2012 to the most recent version the changelog shows as the same version 2.0.0 dated &quot;November 2012&quot;. First off i'm a little confused about...")*

Hi,

It's not possible that HikaShop delete orders and custom fields from the database during an update. There is no such code which could do that.
I'm guessing that during the update, some table structure couldn't be updated successfully and thus the MySQL queries loading the orders/fields crash and you don't see any on the listings, or something like that.
I would recommend to follow the procedure here:
[ www.hikashop.com/en/support/documentatio...lity-issues.html#SQL](http://www.hikashop.com/en/support/documentation/61-hikashop-compatibility-issues.html#SQL)
If what I'm thinking is right, that should allow you to fix your issue.

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

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

Less More

- Posts: 40
- Thank you received: 0
-
-

13 years 9 months ago [\#88718](#88718) by [cluckngood](/forum/user/11050-cluckngood "View cluckngood's Profile")  Replied by *[cluckngood](/forum/user/11050-cluckngood "View cluckngood's Profile")* on topic *[Upgrade deletes Custom Fields &amp; Custom Order #'s](/forum/3-bug-report/78007-upgrade-deletes-custom-fields-custom-order-s#88718 "I've just upgraded my HS Business from v2.0.0 dated june 2012 to the most recent version the changelog shows as the same version 2.0.0 dated &quot;November 2012&quot;. First off i'm a little confused about...")*

After looking into this further it turns out the update link from within the Joomla Extension manager download and installed the Essential version of the HS cart software and not the Business version update which was installed. This is the only explanation i can find for the features becoming disabled.

I downloaded the update from my HS user account and installed it and all the features were available again.

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

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