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

#   Getting some strange errors, can't fix it

##

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

Less More

- Posts: 37
- Thank you received: 2
-
-

13 years 4 months ago [\#111404](#111404) by [karlvann](/forum/user/7701-karlvann "View karlvann's Profile")  *[Getting some strange errors, can't fix it](/forum/4-how-to/84317-getting-some-strange-errors-cant-fix-it#111404 "Tried to delete some custom fields, got  1091 Can't DROP 'guarantee'; check that column/key exists SQL=ALTER TABLE co466&#95;hikashop&#95;product DROP &#96;guarantee&#96;, DROP &#96;feel&#96;, DROP &#96;fabric&#96;, DROP &#96;features&#96;  Trying to save a product  1054 Unknown column 'guarantee' in 'field list' SQL=INSERT IGNORE INTO &#96;co466&#95;hikashop&#95;product&#96; ( &#96;product&#95;name&#96;,&#96;product&#95;url&#96;,&#96;product&#95;meta&#95;description&#96;,&#96;product&#95;keywords&#96;,&#96;product&#95;page&#95;title&#96;,&#96;product&#95;alias&#96;,&#96;product&#95;canonical&#96;,&#96;product&#95;code&#96;,&#96;product&#95;tax&#95;id&#96;,&#96;product&#95;manufacturer&#95;id&#96;,&#96;product&#95;layout&#96;,&#96;product&#95;quantity&#96;,&#96;product&#95;min&#95;per&#95;order&#96;,&#96;product&#95;max&#95;per&#95;order&#96;,&#96;product&#95;sale&#95;start&#96;,&#96;product&#95;sale&#95;end&#96;,&#96;product&#95;msrp&#96;,&#96;product&#95;weight&#96;,&#96;product&#95;weight&#95;unit&#96;,&#96;product&#95;length&#96;,&#96;product&#95;width&#96;,&#96;product&#95;dimension&#95;unit&#96;,&#96;product&#95;height&#96;,&#96;product&#95;published&#96;,&#96;product&#95;access&#96;,&#96;product&#95;group&#95;after&#95;purchase&#96;,&#96;guarantee&#96;,&#96;feel&#96;,&#96;fabric&#96;,&#96;features&#96;,&#96;product&#95;type&#96;,&#96;product&#95;description&#96;,&#96;product&#95;modified&#96;,&#96;product&#95;created&#96; ) VALUES ( 'under5','','','','','','','under5','11','0','','-1','0','0','','','','','kg','','','cm','','1','all','','','','','','main','','1372518260','1372518260' )  I had previously uninstalled all of hikashop, deleted all tables and all trace of hikashop, then reinstalled and I still get these errors, I should have probably asked before doing all of that, oh well..  Can you give me a point in the right direction?")* was created by *[karlvann](/forum/user/7701-karlvann "View karlvann's Profile")*

Tried to delete some custom fields, got

1091 Can't DROP 'guarantee'; check that column/key exists SQL=ALTER TABLE co466_hikashop_product DROP &#96;guarantee&#96;, DROP &#96;feel&#96;, DROP &#96;fabric&#96;, DROP &#96;features&#96;

Trying to save a product

1054 Unknown column 'guarantee' in 'field list' SQL=INSERT IGNORE INTO &#96;co466_hikashop_product&#96; ( &#96;product_name&#96;,&#96;product_url&#96;,&#96;product_meta_description&#96;,&#96;product_keywords&#96;,&#96;product_page_title&#96;,&#96;product_alias&#96;,&#96;product_canonical&#96;,&#96;product_code&#96;,&#96;product_tax_id&#96;,&#96;product_manufacturer_id&#96;,&#96;product_layout&#96;,&#96;product_quantity&#96;,&#96;product_min_per_order&#96;,&#96;product_max_per_order&#96;,&#96;product_sale_start&#96;,&#96;product_sale_end&#96;,&#96;product_msrp&#96;,&#96;product_weight&#96;,&#96;product_weight_unit&#96;,&#96;product_length&#96;,&#96;product_width&#96;,&#96;product_dimension_unit&#96;,&#96;product_height&#96;,&#96;product_published&#96;,&#96;product_access&#96;,&#96;product_group_after_purchase&#96;,&#96;guarantee&#96;,&#96;feel&#96;,&#96;fabric&#96;,&#96;features&#96;,&#96;product_type&#96;,&#96;product_description&#96;,&#96;product_modified&#96;,&#96;product_created&#96; ) VALUES ( 'under5','','','','','','','under5','11','0','','-1','0','0','','','','','kg','','','cm','','1','all','','','','','','main','','1372518260','1372518260' )

I had previously uninstalled all of hikashop, deleted all tables and all trace of hikashop, then reinstalled and I still get these errors, I should have probably asked before doing all of that, oh well..

Can you give me a point in the right direction?

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

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

Less More

- Posts: 37
- Thank you received: 2
-
-

13 years 4 months ago [\#111405](#111405) by [karlvann](/forum/user/7701-karlvann "View karlvann's Profile")  Replied by *[karlvann](/forum/user/7701-karlvann "View karlvann's Profile")* on topic *[Getting some strange errors, can't fix it](/forum/4-how-to/84317-getting-some-strange-errors-cant-fix-it#111405 "Tried to delete some custom fields, got  1091 Can't DROP 'guarantee'; check that column/key exists SQL=ALTER TABLE co466&#95;hikashop&#95;product DROP &#96;guarantee&#96;, DROP &#96;feel&#96;, DROP &#96;fabric&#96;, DROP &#96;features&#96;  Trying to save a product  1054 Unknown column 'guarantee' in 'field list' SQL=INSERT IGNORE INTO &#96;co466&#95;hikashop&#95;product&#96; ( &#96;product&#95;name&#96;,&#96;product&#95;url&#96;,&#96;product&#95;meta&#95;description&#96;,&#96;product&#95;keywords&#96;,&#96;product&#95;page&#95;title&#96;,&#96;product&#95;alias&#96;,&#96;product&#95;canonical&#96;,&#96;product&#95;code&#96;,&#96;product&#95;tax&#95;id&#96;,&#96;product&#95;manufacturer&#95;id&#96;,&#96;product&#95;layout&#96;,&#96;product&#95;quantity&#96;,&#96;product&#95;min&#95;per&#95;order&#96;,&#96;product&#95;max&#95;per&#95;order&#96;,&#96;product&#95;sale&#95;start&#96;,&#96;product&#95;sale&#95;end&#96;,&#96;product&#95;msrp&#96;,&#96;product&#95;weight&#96;,&#96;product&#95;weight&#95;unit&#96;,&#96;product&#95;length&#96;,&#96;product&#95;width&#96;,&#96;product&#95;dimension&#95;unit&#96;,&#96;product&#95;height&#96;,&#96;product&#95;published&#96;,&#96;product&#95;access&#96;,&#96;product&#95;group&#95;after&#95;purchase&#96;,&#96;guarantee&#96;,&#96;feel&#96;,&#96;fabric&#96;,&#96;features&#96;,&#96;product&#95;type&#96;,&#96;product&#95;description&#96;,&#96;product&#95;modified&#96;,&#96;product&#95;created&#96; ) VALUES ( 'under5','','','','','','','under5','11','0','','-1','0','0','','','','','kg','','','cm','','1','all','','','','','','main','','1372518260','1372518260' )  I had previously uninstalled all of hikashop, deleted all tables and all trace of hikashop, then reinstalled and I still get these errors, I should have probably asked before doing all of that, oh well..  Can you give me a point in the right direction?")*

I just Fixed It, I deleted the custom field tables in mysql and all is well.. sorry for the post!

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

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