"Error Saving" when trying to save badges

  • Posts: 29
  • Thank you received: 0
11 years 4 months ago #114388

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

joomla 2.5.11
hikashop 2.2.0

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
11 years 4 months ago #114419

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 & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 29
  • Thank you received: 0
11 years 4 months ago #114476

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

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
11 years 4 months ago #114479

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:

ALTER TABLE `#__hikashop_badge` ADD `badge_url` 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 & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 29
  • Thank you received: 0
11 years 4 months ago #114503

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 or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
11 years 4 months ago #114507

Hi,

Thanks for the information. We fixed the installation script.

Regards,

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

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Last edit: 11 years 4 months ago by Jerome.

Please Log in or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum