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

#   An error occurred. 1054 Unknown column 'badge\_url"

##

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

Less More

- Posts: 69
- Thank you received: 1
-
-
-
-

13 years 3 months ago [\#117366](#117366) by [dkmetz@taylorbruce.com](/forum/user/11254-dkmetz-taylorbruce-com "View dkmetz@taylorbruce.com's Profile")  *[An error occurred. 1054 Unknown column 'badge\_url"](/forum/3-bug-report/860709-an-error-occurred-1054-unknown-column-badge-url#117366 "-- url of the page with the problem -- :   steiner.taylorbruce.com/administrator/in...&#95;hikashop&amp;ctrl=badge  -- HikaShop version -- : 2.2.0 -- Joomla version -- : Joomla! 3.1.1 Stable &#91; Ember &#93; 26-April-2013 14:00 GMT -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : FF latest (22?) -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  An error has occurred. 1054 Unknown column 'badge&#95;url' in 'field list' SQL=INSERT IGNORE INTO &#96;brzfh&#95;hikashop&#95;badge&#96; ( &#96;badge&#95;id&#96;,&#96;badge&#95;name&#96;,&#96;badge&#95;published&#96;,&#96;badge&#95;start&#96;,&#96;badge&#95;end&#96;,&#96;badge&#95;quantity&#96;,&#96;badge&#95;category&#95;id&#96;,&#96;badge&#95;category&#95;childs&#96;,&#96;badge&#95;discount&#95;id&#96;,&#96;badge&#95;url&#96;,&#96;badge&#95;keep&#95;size&#96;,&#96;badge&#95;size&#96;,&#96;badge&#95;position&#96;,&#96;badge&#95;vertical&#95;distance&#96;,&#96;badge&#95;horizontal&#95;distance&#96; ) VALUES ( '0','Badge1','0','','','1','45','0','','taylorbruce.com','0','30','topright','0','0' ) Return to Control Panel")* was created by *[dkmetz@taylorbruce.com](/forum/user/11254-dkmetz-taylorbruce-com "View dkmetz@taylorbruce.com's Profile")*

-- url of the page with the problem -- : [ steiner.taylorbruce.com/administrator/in...\_hikashop&amp;ctrl=badge](http://steiner.taylorbruce.com/administrator/index.php?option=com_hikashop&ctrl=badge)
-- HikaShop version -- : 2.2.0
-- Joomla version -- : Joomla! 3.1.1 Stable [ Ember ] 26-April-2013 14:00 GMT
-- PHP version -- : 5.3.27
-- Browser(s) name and version -- : FF latest (22?)
-- Error-message(debug-mod must be tuned on) -- : Error_message

**An error has occurred.**
1054 Unknown column 'badge_url' in 'field list' SQL=INSERT IGNORE INTO &#96;brzfh_hikashop_badge&#96; ( &#96;badge_id&#96;,&#96;badge_name&#96;,&#96;badge_published&#96;,&#96;badge_start&#96;,&#96;badge_end&#96;,&#96;badge_quantity&#96;,&#96;badge_category_id&#96;,&#96;badge_category_childs&#96;,&#96;badge_discount_id&#96;,&#96;badge_url&#96;,&#96;badge_keep_size&#96;,&#96;badge_size&#96;,&#96;badge_position&#96;,&#96;badge_vertical_distance&#96;,&#96;badge_horizontal_distance&#96; ) VALUES ( '0','Badge1','0','','','1','45','0','','taylorbruce.com','0','30','topright','0','0' )
Return to Control Panel

---

\_\_\_\_\_\_\_\_\_\_\_\_\_\_
Dennis Kmetz

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

13 years 3 months ago [\#117383](#117383) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[An error occurred. 1054 Unknown column 'badge\_url"](/forum/3-bug-report/860709-an-error-occurred-1054-unknown-column-badge-url#117383 "-- url of the page with the problem -- :   steiner.taylorbruce.com/administrator/in...&#95;hikashop&amp;ctrl=badge  -- HikaShop version -- : 2.2.0 -- Joomla version -- : Joomla! 3.1.1 Stable &#91; Ember &#93; 26-April-2013 14:00 GMT -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : FF latest (22?) -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  An error has occurred. 1054 Unknown column 'badge&#95;url' in 'field list' SQL=INSERT IGNORE INTO &#96;brzfh&#95;hikashop&#95;badge&#96; ( &#96;badge&#95;id&#96;,&#96;badge&#95;name&#96;,&#96;badge&#95;published&#96;,&#96;badge&#95;start&#96;,&#96;badge&#95;end&#96;,&#96;badge&#95;quantity&#96;,&#96;badge&#95;category&#95;id&#96;,&#96;badge&#95;category&#95;childs&#96;,&#96;badge&#95;discount&#95;id&#96;,&#96;badge&#95;url&#96;,&#96;badge&#95;keep&#95;size&#96;,&#96;badge&#95;size&#96;,&#96;badge&#95;position&#96;,&#96;badge&#95;vertical&#95;distance&#96;,&#96;badge&#95;horizontal&#95;distance&#96; ) VALUES ( '0','Badge1','0','','','1','45','0','','taylorbruce.com','0','30','topright','0','0' ) Return to Control Panel")*

Hi,

There was an error in a previous HikaShop 2.2.0 package.
We fixed the problem and add a fix in order to create the missing column.

Please re-download HikaShop 2.2.0 and install it as an update. The column will be added.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

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

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

Less More

- Posts: 69
- Thank you received: 1
-
-
-
-

13 years 3 months ago [\#117570](#117570) by [dkmetz@taylorbruce.com](/forum/user/11254-dkmetz-taylorbruce-com "View dkmetz@taylorbruce.com's Profile")  Replied by *[dkmetz@taylorbruce.com](/forum/user/11254-dkmetz-taylorbruce-com "View dkmetz@taylorbruce.com's Profile")* on topic *[An error occurred. 1054 Unknown column 'badge\_url"](/forum/3-bug-report/860709-an-error-occurred-1054-unknown-column-badge-url#117570 "-- url of the page with the problem -- :   steiner.taylorbruce.com/administrator/in...&#95;hikashop&amp;ctrl=badge  -- HikaShop version -- : 2.2.0 -- Joomla version -- : Joomla! 3.1.1 Stable &#91; Ember &#93; 26-April-2013 14:00 GMT -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : FF latest (22?) -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  An error has occurred. 1054 Unknown column 'badge&#95;url' in 'field list' SQL=INSERT IGNORE INTO &#96;brzfh&#95;hikashop&#95;badge&#96; ( &#96;badge&#95;id&#96;,&#96;badge&#95;name&#96;,&#96;badge&#95;published&#96;,&#96;badge&#95;start&#96;,&#96;badge&#95;end&#96;,&#96;badge&#95;quantity&#96;,&#96;badge&#95;category&#95;id&#96;,&#96;badge&#95;category&#95;childs&#96;,&#96;badge&#95;discount&#95;id&#96;,&#96;badge&#95;url&#96;,&#96;badge&#95;keep&#95;size&#96;,&#96;badge&#95;size&#96;,&#96;badge&#95;position&#96;,&#96;badge&#95;vertical&#95;distance&#96;,&#96;badge&#95;horizontal&#95;distance&#96; ) VALUES ( '0','Badge1','0','','','1','45','0','','taylorbruce.com','0','30','topright','0','0' ) Return to Control Panel")*

Hi,

I still get the same error message.

Here is what I did:
(1.) I downloaded the **com\_hikashop\_business\_2.2.0\_2013-08-06.zip** file and installed (via the the Install Manager) by clicking INSTALL then browsing for and uploading the file. The install appeared successful.

(2.) Then I went to the Install Manager and MANAGE and noticed that the Hikashop information did not change... it still says **Component 2.2.0 with a June 2012 date** .

Within Install Manager when I click UPDATE, nothing shows up.

What am I doing wrong?

Dennis

---

\_\_\_\_\_\_\_\_\_\_\_\_\_\_
Dennis Kmetz

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NjA3MDktYW4tZXJyb3Itb2NjdXJyZWQtMTA1NC11bmtub3duLWNvbHVtbi1iYWRnZS11cmw/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
-
-

13 years 3 months ago [\#117575](#117575) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[An error occurred. 1054 Unknown column 'badge\_url"](/forum/3-bug-report/860709-an-error-occurred-1054-unknown-column-badge-url#117575 "-- url of the page with the problem -- :   steiner.taylorbruce.com/administrator/in...&#95;hikashop&amp;ctrl=badge  -- HikaShop version -- : 2.2.0 -- Joomla version -- : Joomla! 3.1.1 Stable &#91; Ember &#93; 26-April-2013 14:00 GMT -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : FF latest (22?) -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  An error has occurred. 1054 Unknown column 'badge&#95;url' in 'field list' SQL=INSERT IGNORE INTO &#96;brzfh&#95;hikashop&#95;badge&#96; ( &#96;badge&#95;id&#96;,&#96;badge&#95;name&#96;,&#96;badge&#95;published&#96;,&#96;badge&#95;start&#96;,&#96;badge&#95;end&#96;,&#96;badge&#95;quantity&#96;,&#96;badge&#95;category&#95;id&#96;,&#96;badge&#95;category&#95;childs&#96;,&#96;badge&#95;discount&#95;id&#96;,&#96;badge&#95;url&#96;,&#96;badge&#95;keep&#95;size&#96;,&#96;badge&#95;size&#96;,&#96;badge&#95;position&#96;,&#96;badge&#95;vertical&#95;distance&#96;,&#96;badge&#95;horizontal&#95;distance&#96; ) VALUES ( '0','Badge1','0','','','1','45','0','','taylorbruce.com','0','30','topright','0','0' ) Return to Control Panel")*

Hi,

I don't think that it has anything to do with an error in the 2.2 release as Jerome said.

This is typical of when the database structure couldn't be successfully updated during an update.
We actually have a documentation explaining that more in depth here:
[ www.hikashop.com/support/support/documen...lity-issues.html#SQL](http://www.hikashop.com/support/support/documentation/61-hikashop-compatibility-issues.html#SQL)

So as recommended there, you can run manually the query to add the missing column in the database via phpmyadmin.
In your case the query should be:
ALTER TABLE &#96;brzfh_hikashop_badge&#96; ADD &#96;badge_url&#96; VARCHAR( 255 ) NULL DEFAULT '';

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

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