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

#   "Error Saving" when trying to save badges

##

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

Less More

- Posts: 29
- Thank you received: 0
-
-

13 years 3 months ago [\#114388](#114388) by [peters](/forum/user/24426-peters "View peters's Profile")  *["Error Saving" when trying to save badges](/forum/3-bug-report/85449-error-saving-when-trying-to-save-badges#114388 "When I try to save a badge I get an save error. (see attachment)  joomla 2.5.11 hikashop 2.2.0")* was created by *[peters](/forum/user/24426-peters "View peters's Profile")*

When I try to save a badge I get an save error. (see attachment)

joomla 2.5.11
hikashop 2.2.0

- [ ![17&#95;07a.png](/forum/attachment/11191) ](/forum/attachment/11191 "17&#95;07a.png") [ ](/forum/attachment/11191?download=1 "17&#95;07a.png")
- [ ![17&#95;07b.png](/forum/attachment/11192) ](/forum/attachment/11192 "17&#95;07b.png") [ ](/forum/attachment/11192?download=1 "17&#95;07b.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NTQ0OS1lcnJvci1zYXZpbmctd2hlbi10cnlpbmctdG8tc2F2ZS1iYWRnZXM/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: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

13 years 3 months ago [\#114419](#114419) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *["Error Saving" when trying to save badges](/forum/3-bug-report/85449-error-saving-when-trying-to-save-badges#114419 "When I try to save a badge I get an save error. (see attachment)  joomla 2.5.11 hikashop 2.2.0")*

Hi,

Can you activate temporally the Joomla debug mode ?
It is possible that you have a SQL error. By activating the Joomla debug mode, we will have more information about the error and why the badge is not saved.

Regards,

---

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

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

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

Less More

- Posts: 29
- Thank you received: 0
-
-

13 years 3 months ago [\#114476](#114476) by [peters](/forum/user/24426-peters "View peters's Profile")  Replied by *[peters](/forum/user/24426-peters "View peters's Profile")* on topic *["Error Saving" when trying to save badges](/forum/3-bug-report/85449-error-saving-when-trying-to-save-badges#114476 "When I try to save a badge I get an save error. (see attachment)  joomla 2.5.11 hikashop 2.2.0")*

500 - Es ist ein Fehler aufgetreten

JDatabaseMySQLi::query: 1054 - Unknown column 'badge_url' in 'field list' SQL=INSERT IGNORE INTO &#96;jos_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;,&#96;badge_image&#96; ) VALUES ( '0','hausgemacht','0','','','','37','0','','','0','30','topright','0','0','hausgemacht2_122019911.png' )

Zurück zum Kontrollzentrum

Call stack
\# Function Location
1 JAdministrator-&gt;dispatch() /home/.sites/54/site1086/web/shop/administrator/index.php:46
2 JComponentHelper::renderComponent() /home/.sites/54/site1086/web/shop/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /home/.sites/54/site1086/web/shop/libraries/joomla/application/component/helper.php:351
4 require_once() /home/.sites/54/site1086/web/shop/libraries/joomla/application/component/helper.php:383
5 hikashopController-&gt;execute() /home/.sites/54/site1086/web/shop/administrator/components/com_hikashop/hikashop.php:54
6 JController-&gt;execute() /home/.sites/54/site1086/web/shop/administrator/components/com_hikashop/helpers/helper.php:1291
7 hikashopController-&gt;apply() /home/.sites/54/site1086/web/shop/libraries/joomla/application/component/controller.php:761
8 hikashopController-&gt;store() /home/.sites/54/site1086/web/shop/administrator/components/com_hikashop/helpers/helper.php:1077
9 hikashopBadgeClass-&gt;saveForm() /home/.sites/54/site1086/web/shop/administrator/components/com_hikashop/helpers/helper.php:1141
10 hikashopBadgeClass-&gt;save() /home/.sites/54/site1086/web/shop/administrator/components/com_hikashop/classes/badge.php:34
11 hikashopClass-&gt;save() /home/.sites/54/site1086/web/shop/administrator/components/com_hikashop/classes/badge.php:166
12 JDatabase-&gt;query() /home/.sites/54/site1086/web/shop/administrator/components/com_hikashop/helpers/helper.php:1342
13 JDatabaseMySQLi-&gt;execute() /home/.sites/54/site1086/web/shop/libraries/joomla/database/database.php:1253
14 JError::raiseError() /home/.sites/54/site1086/web/shop/libraries/joomla/database/database/mysqli.php:396
15 JError::raise() /home/.sites/54/site1086/web/shop/libraries/joomla/error/error.php:251

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NTQ0OS1lcnJvci1zYXZpbmctd2hlbi10cnlpbmctdG8tc2F2ZS1iYWRnZXM/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: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

13 years 3 months ago [\#114479](#114479) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *["Error Saving" when trying to save badges](/forum/3-bug-report/85449-error-saving-when-trying-to-save-badges#114479 "When I try to save a badge I get an save error. (see attachment)  joomla 2.5.11 hikashop 2.2.0")*

Hi,

You had a problem during the HikaShop update.
The column "badge_url" is added during the 2.2.0 update.

You can find all database query launch during the update in the file "install.hikashop.com".
Please check that the table "hikashop_massaction" right exists in your database. If the update script stoped, it possible that other columns will be missing too.

You can add manually the missing column in your database manager (like PhpMyAdmin) by using the query: Code:

ALTER TABLE &#96;#__hikashop_badge&#96; ADD &#96;badge_url&#96; VARCHAR( 255 ) NULL DEFAULT '';

Replace "#_" with your database prefix. If the prefix is "jos" the table name will be: "jos_hikashop_badge".

Regards,

---

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

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

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

Less More

- Posts: 29
- Thank you received: 0
-
-

13 years 3 months ago [\#114503](#114503) by [peters](/forum/user/24426-peters "View peters's Profile")  Replied by *[peters](/forum/user/24426-peters "View peters's Profile")* on topic *["Error Saving" when trying to save badges](/forum/3-bug-report/85449-error-saving-when-trying-to-save-badges#114503 "When I try to save a badge I get an save error. (see attachment)  joomla 2.5.11 hikashop 2.2.0")*

thanks, it works now.
the table "hikashop_massaction" exists.

it was no update, it was a new 2.2.0 installation

regards
peter

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NTQ0OS1lcnJvci1zYXZpbmctd2hlbi10cnlpbmctdG8tc2F2ZS1iYWRnZXM/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: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

13 years 3 months ago -  13 years 3 months ago [\#114507](#114507) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *["Error Saving" when trying to save badges](/forum/3-bug-report/85449-error-saving-when-trying-to-save-badges#114507 "When I try to save a badge I get an save error. (see attachment)  joomla 2.5.11 hikashop 2.2.0")*

Hi,

Thanks for the information. We fixed the installation script.

Regards,

---

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

Last edit: 13 years 3 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile").

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

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