"Error Saving" when trying to save badges

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,

500 - Es ist ein Fehler aufgetreten

JDatabaseMySQLi::query: 1054 - Unknown column 'badge_url' in 'field list' SQL=INSERT IGNORE INTO `jos_hikashop_badge` ( `badge_id`,`badge_name`,`badge_published`,`badge_start`,`badge_end`,`badge_quantity`,`badge_category_id`,`badge_category_childs`,`badge_discount_id`,`badge_url`,`badge_keep_size`,`badge_size`,`badge_position`,`badge_vertical_distance`,`badge_horizontal_distance`,`badge_image` ) VALUES ( '0','hausgemacht','0','','','','37','0','','','0','30','topright','0','0','hausgemacht2_122019911.png' )

Zurück zum Kontrollzentrum

Call stack
# Function Location
1 JAdministrator->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->execute() /home/.sites/54/site1086/web/shop/administrator/components/com_hikashop/hikashop.php:54
6 JController->execute() /home/.sites/54/site1086/web/shop/administrator/components/com_hikashop/helpers/helper.php:1291
7 hikashopController->apply() /home/.sites/54/site1086/web/shop/libraries/joomla/application/component/controller.php:761
8 hikashopController->store() /home/.sites/54/site1086/web/shop/administrator/components/com_hikashop/helpers/helper.php:1077
9 hikashopBadgeClass->saveForm() /home/.sites/54/site1086/web/shop/administrator/components/com_hikashop/helpers/helper.php:1141
10 hikashopBadgeClass->save() /home/.sites/54/site1086/web/shop/administrator/components/com_hikashop/classes/badge.php:34
11 hikashopClass->save() /home/.sites/54/site1086/web/shop/administrator/components/com_hikashop/classes/badge.php:166
12 JDatabase->query() /home/.sites/54/site1086/web/shop/administrator/components/com_hikashop/helpers/helper.php:1342
13 JDatabaseMySQLi->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

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: Replace "#_" with your database prefix. If the prefix is "jos" the table name will be: "jos_hikashop_badge".

Regards,

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

it was no update, it was a new 2.2.0 installation

regards
peter

Hi,

Thanks for the information. We fixed the installation script.

Regards,