[Skip to main content](#vessel-content) # Error saving ## - **[Joomill](/forum/user/33738-joomill "View Joomill's Profile")** - [![Joomill's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33738.jpg)](/forum/user/33738-joomill "View Joomill's Profile") Topic Author - [ Offline](/forum/user/33738-joomill) Less More - Posts: 224 - Thank you received: 10 - - - [](http://www.joomill.nl) - 11 years 6 months ago - 11 years 6 months ago [\#199966](#199966) by [Joomill](/forum/user/33738-joomill "View Joomill's Profile") *[Error saving](/forum/32-content-creation/876626-error-saving#199966 "-- HikaShop version -- : HikaShop Business: 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.5.17 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : Error Error Saving When i would like to add a product i see "Error saving" I have enabled debug and log message added below. The product-category is empty after saving. I can send you the login when you need. Thanks in advance! Jeroen")* was created by *[Joomill](/forum/user/33738-joomill "View Joomill's Profile")* -- HikaShop version -- : HikaShop Business: 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.5.17 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : Error Error Saving When i would like to add a product i see "Error saving" I have enabled debug and log message added below. The product-category is empty after saving. I can send you the login when you need. Thanks in advance! Jeroen Code: DEBUG - databasequery SELECT extension_id AS id, element AS "option", params, enabled FROM smrt2_extensions WHERE `type` = 'library' AND `element` = 'joomla' DEBUG - databasequery UPDATE `smrt2_extensions` SET `params` = '{\"mediaversion\":\"35efc94ba952809c98ef823738fc4d40\"}' WHERE `type` = 'library' AND `element` = 'joomla' DEBUG - databasequery SELECT template, s.params FROM smrt2_template_styles as s LEFT JOIN smrt2_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id WHERE s.client_id = 1 AND home = '1' ORDER BY home DEBUG - databasequery SELECT * FROM smrt2_hikashop_config WARNING - deprecated JRequest is deprecated. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JApplication is deprecated. DEBUG - databasequery SELECT b.* FROM smrt2_hikashop_category AS a LEFT JOIN smrt2_hikashop_category AS b ON a.category_left >= b.category_left WHERE b.category_right >= a.category_right AND a.category_id IN (2) GROUP BY b.category_id ORDER BY b.category_left DEBUG - databasequery SELECT a.id FROM smrt2_user_usergroup_map AS map LEFT JOIN smrt2_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 645 DEBUG - databasequery SELECT * FROM smrt2_hikashop_field as a WHERE a.`field_published` = 1 AND a.`field_backend` = 1 AND a.field_table='product' AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%') AND ((field_with_sub_categories=0 AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories=1 AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%')))AND (field_products="" OR field_products LIKE '%,0,%') ORDER BY a.`field_ordering` ASC DEBUG - databasequery SELECT * FROM smrt2_hikashop_massaction WHERE massaction_published=1 && massaction_triggers!='' WARNING - deprecated JDatabase::query() is deprecated, use JDatabaseDriver::execute() instead. DEBUG - databasequery INSERT IGNORE INTO `smrt2_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_page_title`,`product_alias`,`product_canonical`,`product_code`,`product_tax_id`,`product_manufacturer_id`,`product_layout`,`product_quantity_layout`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_sale_start`,`product_sale_end`,`product_msrp`,`product_warehouse_id`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_access`,`product_group_after_purchase`,`product_type`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'test','','','','','test','','test','38','0','','','-1','0','0','','','','','','kg','','','m','','1','all','','main','','1430039174','1430039174' ) DEBUG - databasequery SELECT product_id FROM smrt2_hikashop_product WHERE product_code = 'test' LIMIT 1 WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JFactory::getEditor is deprecated. Use JEditor directly. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. DEBUG - databasequery SELECT * FROM smrt2_hikashop_field as a WHERE a.`field_published` = 1 AND a.field_table='product' AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%') AND ((field_with_sub_categories=0 AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories=1 AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%')))AND (field_products="" OR field_products LIKE '%,0,%') ORDER BY a.`field_ordering` ASC WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. WARNING - deprecated JViewLegacy::assignRef is deprecated. Use native PHP syntax. DEBUG - databasequery SELECT * FROM smrt2_wf_profiles WHERE published = 1 ORDER BY ordering ASC DEBUG - databasequery SHOW FULL COLUMNS FROM `smrt2_extensions` DEBUG - databasequery SELECT `extension_id` FROM `smrt2_extensions` WHERE type = 'component' AND element = 'com_hikashop' DEBUG - databasequery SELECT * FROM smrt2_extensions WHERE `extension_id` = '10014' DEBUG - databasequery SELECT `extension_id` FROM `smrt2_extensions` WHERE type = 'plugin' AND folder = 'editors' AND element = 'jce' DEBUG - databasequery SELECT * FROM smrt2_extensions WHERE `extension_id` = '10135' DEBUG - databasequery SELECT `extension_id` FROM `smrt2_extensions` WHERE type = 'component' AND element = 'com_jce' DEBUG - databasequery SELECT * FROM smrt2_extensions WHERE `extension_id` = '10134' DEBUG - databasequery SELECT id, template FROM smrt2_template_styles WHERE client_id = 0 AND home = '1' WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. DEBUG - databasequery SELECT DISTINCT a.id AS value, a.path, a.title AS text, a.level, a.published, a.lft FROM smrt2_tags AS a LEFT JOIN `smrt2_tags` AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE `a`.`lft` > 0 AND a.published IN (0,1) ORDER BY a.lft ASC DEBUG - databasequery SELECT category_id FROM smrt2_hikashop_category WHERE category_parent_id=0 LIMIT 1 DEBUG - databasequery SELECT a.category_name,a.category_id,a.category_namekey FROM smrt2_hikashop_category AS a WHERE a.category_type = 'tax' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC DEBUG - databasequery SELECT category_id FROM smrt2_hikashop_category WHERE category_parent_id=0 LIMIT 1 DEBUG - databasequery SELECT a.category_name,a.category_id,a.category_namekey FROM smrt2_hikashop_category AS a WHERE a.category_type = 'manufacturer' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC WARNING - deprecated JHtmlSelect::optgroup() is deprecated, use JHtmlSelect::groupedList() instead. WARNING - deprecated JHtmlSelect::optgroup() is deprecated, use JHtmlSelect::groupedList() instead. WARNING - deprecated JHtmlSelect::optgroup() is deprecated, use JHtmlSelect::groupedList() instead. WARNING - deprecated JHtmlSelect::optgroup() is deprecated, use JHtmlSelect::groupedList() instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. DEBUG - databasequery SELECT * FROM smrt2_hikashop_currency WHERE currency_id IN (1) WARNING - deprecated JFactory::getACL is deprecated. Use JAccess directly. DEBUG - databasequery SELECT a.*, a.title as text, a.id as value FROM smrt2_usergroups AS a ORDER BY a.lft ASC WARNING - deprecated JFactory::getACL is deprecated. Use JAccess directly. DEBUG - databasequery SELECT a.*, a.title as text, a.id as value FROM smrt2_usergroups AS a ORDER BY a.lft ASC DEBUG - databasequery SELECT * FROM smrt2_hikashop_currency WHERE currency_published=1 OR currency_id IN ('1','1') DEBUG - databasequery SELECT b.*, a.*, c.currency_symbol FROM smrt2_hikashop_shipping AS a LEFT JOIN smrt2_hikashop_shipping_price AS b ON a.shipping_id = b.shipping_id AND b.shipping_price_ref_id = 0 INNER JOIN smrt2_hikashop_currency AS c ON c.currency_id = a.shipping_currency_id WHERE a.shipping_params LIKE '%s:20:\"shipping_per_product\";s:1:\"1\"%' AND (b.shipping_price_ref_id IS NULL OR (b.shipping_price_ref_id = 0 AND b.shipping_price_ref_type = 'product')) ORDER BY a.shipping_id, b.shipping_price_min_quantity WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. DEBUG - databasequery SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM smrt2_modules AS m LEFT JOIN smrt2_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN smrt2_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2015-04-26 09:06:14') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2015-04-26 09:06:14') AND m.access IN (1,1,2,3,6) AND m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY m.position, m.ordering WARNING - deprecated JSubMenuHelper::getEntries() is deprecated. Use JHtmlSidebar::getEntries() instead. WARNING - deprecated JSubMenuHelper::getFilters() is deprecated. Use JHtmlSidebar::getFilters() instead. WARNING - deprecated JSubMenuHelper::getAction() is deprecated. Use JHtmlSidebar::getAction() instead. DEBUG - databasequery SELECT COUNT(*) FROM smrt2_messages WHERE state = 0 AND user_id_to = 645 DEBUG - databasequery SELECT COUNT(session_id) FROM smrt2_session WHERE guest = 0 AND client_id = 1 DEBUG - databasequery SELECT COUNT(session_id) FROM smrt2_session WHERE guest = 0 AND client_id = 0 WARNING - deprecated JButton is deprecated. Use JToolbarButton instead. DEBUG - databasequery SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element FROM smrt2_menu AS m LEFT JOIN smrt2_extensions AS e ON m.component_id = e.extension_id WHERE m.client_id = 1 AND e.enabled = 1 AND m.id > 1 ORDER BY m.lft WARNING - deprecated This method is typehinted to be an array in \Joomla\Utilities\ArrayHelper::toString. WARNING - deprecated JResponse is deprecated. DEBUG - databasequery UPDATE `smrt2_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:23;s:19:\"session.timer.start\";i:1430037924;s:18:\"session.timer.last\";i:1430039167;s:17:\"session.timer.now\";i:1430039174;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.3; WOW64; rv:37.0) Gecko/20100101 Firefox/37.0\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":3:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;}}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":28:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"645\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:7:\"Joomill\";s:5:\"email\";s:15:\"info@joomill.nl\";s:8:\"password\";s:60:\"$2y$10$rrHceO0XIOaO0frNQq.XquOvaHwiOHTGfPBviQ43bft4OvyhirF6m\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2015-04-17 13:11:36\";s:13:\"lastvisitDate\";s:19:\"2015-04-26 07:39:15\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:5:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:6;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"a368232f4345ac7f3a625c68e9ca66cf\";}__wf|a:1:{s:13:\"session.token\";s:32:\"f208c8951e8fac89f36d362711279cf8\";}hikashop_product_data|O:8:\"stdClass\":40:{s:12:\"product_name\";s:4:\"test\";s:11:\"product_url\";s:0:\"\";s:24:\"product_meta_description\";s:0:\"\";s:16:\"product_keywords\";s:0:\"\";s:18:\"product_page_title\";s:0:\"\";s:13:\"product_alias\";s:4:\"test\";s:17:\"product_canonical\";s:0:\"\";s:12:\"product_code\";s:4:\"test\";s:14:\"product_tax_id\";s:2:\"38\";s:23:\"product_manufacturer_id\";s:1:\"0\";s:14:\"product_layout\";s:0:\"\";s:23:\"product_quantity_layout\";s:0:\"\";s:16:\"product_quantity\";s:9:\"Unlimited\";s:21:\"product_min_per_order\";s:1:\"0\";s:21:\"product_max_per_order\";s:9:\"Unlimited\";s:18:\"product_sale_start\";s:0:\"\";s:16:\"product_sale_end\";s:0:\"\";s:12:\"product_msrp\";s:0:\"\";s:20:\"product_warehouse_id\";s:0:\"\";s:14:\"product_weight\";s:0:\"\";s:19:\"product_weight_unit\";s:2:\"kg\";s:14:\"product_length\";s:0:\"\";s:13:\"product_width\";s:0:\"\";s:22:\"product_dimension_unit\";s:1:\"m\";s:14:\"product_height\";s:0:\"\";s:17:\"product_published\";s:1:\"1\";s:14:\"product_access\";s:3:\"all\";s:28:\"product_group_after_purchase\";s:0:\"\";s:12:\"product_type\";s:4:\"main\";s:10:\"categories\";a:2:{i:2;i:2;i:0;N;}s:7:\"related\";a:0:{}s:7:\"options\";a:0:{}s:6:\"images\";a:0:{}s:5:\"files\";a:0:{}s:11:\"imagesorder\";a:0:{}s:6:\"prices\";a:1:{i:0;O:8:\"stdClass\":4:{s:11:\"price_value\";i:0;s:20:\"price_value_with_tax\";i:0;s:17:\"price_currency_id\";s:1:\"1\";s:18:\"price_min_quantity\";i:1;}}s:18:\"oldCharacteristics\";a:0:{}s:19:\"product_description\";s:0:\"\";s:16:\"product_modified\";i:1430039174;s:15:\"product_created\";i:1430039174;}' , `time` = '1430039174' WHERE `session_id` = 'jdu3ahcnk0j1aur4c49nst0u24' WARNING - deprecated JError::getErrors() is deprecated. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. WARNING - deprecated JHtml::getJSObject is deprecated. Use json_encode instead. Last edit: 11 years 6 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile"). Reason: [code] is nice Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODc2NjI2LWVycm9yLXNhdmluZz90bXBsPW1hcmtkb3du) 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: 86358 - Thank you received: 14293 - - 11 years 6 months ago [\#199994](#199994) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error saving](/forum/32-content-creation/876626-error-saving#199994 "-- HikaShop version -- : HikaShop Business: 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.5.17 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : Error Error Saving When i would like to add a product i see "Error saving" I have enabled debug and log message added below. The product-category is empty after saving. I can send you the login when you need. Thanks in advance! Jeroen")* Hi, Click on the "check database" button of the HikaShop configuration and see if that helps. Also, make sure that you provide a product code and that it is unique before saving your new product. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODc2NjI2LWVycm9yLXNhdmluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Joomill](/forum/user/33738-joomill "View Joomill's Profile")** - [![Joomill's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33738.jpg)](/forum/user/33738-joomill "View Joomill's Profile") Topic Author - [ Offline](/forum/user/33738-joomill) Less More - Posts: 224 - Thank you received: 10 - - - [](http://www.joomill.nl) - 11 years 6 months ago - 11 years 6 months ago [\#200035](#200035) by [Joomill](/forum/user/33738-joomill "View Joomill's Profile") Replied by *[Joomill](/forum/user/33738-joomill "View Joomill's Profile")* on topic *[Error saving](/forum/32-content-creation/876626-error-saving#200035 "-- HikaShop version -- : HikaShop Business: 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.5.17 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : Error Error Saving When i would like to add a product i see "Error saving" I have enabled debug and log message added below. The product-category is empty after saving. I can send you the login when you need. Thanks in advance! Jeroen")* Hi Nicolas, Thanks for your answer. The Check database says everything is ok. And even with a unique code, the product is not being saved. I found another error, maybe it has something to do with: When i click the export button: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,,,,,,,,,,,,,,,,,,,,)' at line 1 SQL=SELECT * FROM smrt2_hikashop_product_related AS a WHERE a.product_id IN (,,,,,,,,,,,,,,,,,,,,,,,) Do you have other sugesstions what i can do? Kind regards Last edit: 11 years 6 months ago by [Joomill](/forum/user/33738-joomill "View Joomill's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODc2NjI2LWVycm9yLXNhdmluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Joomill](/forum/user/33738-joomill "View Joomill's Profile")** - [![Joomill's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33738.jpg)](/forum/user/33738-joomill "View Joomill's Profile") Topic Author - [ Offline](/forum/user/33738-joomill) Less More - Posts: 224 - Thank you received: 10 - - - [](http://www.joomill.nl) - 11 years 6 months ago [\#200040](#200040) by [Joomill](/forum/user/33738-joomill "View Joomill's Profile") Replied by *[Joomill](/forum/user/33738-joomill "View Joomill's Profile")* on topic *[Error saving](/forum/32-content-creation/876626-error-saving#200040 "-- HikaShop version -- : HikaShop Business: 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.5.17 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : Error Error Saving When i would like to add a product i see "Error saving" I have enabled debug and log message added below. The product-category is empty after saving. I can send you the login when you need. Thanks in advance! Jeroen")* I Found the problem: In the table _hikashop_product all columns a INT3 and the Auto Increment was missing. I changed it to the values from another Hikashop installation and now everything works again.. Thanks and this thread can be closed. Jeroen Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODc2NjI2LWVycm9yLXNhdmluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & 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)