[Skip to main content](#vessel-content) # error when saving product ## - **[sjolte](/forum/user/6638-sjolte "View sjolte's Profile")** - [![sjolte's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6638-sjolte "View sjolte's Profile") Topic Author - [ Offline](/forum/user/6638-sjolte) Less More - Posts: 1 - Thank you received: 0 - - 14 years 7 months ago [\#42985](#42985) by [sjolte](/forum/user/6638-sjolte "View sjolte's Profile") *[error when saving product](/forum/3-bug-report/42985-error-when-saving-product#42985 "Hi Hikashop I get a "error saving red bar" when adding a new product. I use hikashop start version. 1.5.6 with joomla 1.5.25 The log file is: SELECT * FROM jos_session WHERE session_id = '47659fb1b63add8c8f8c827800ab71d7' DELETE FROM jos_session WHERE ( TIME = 1 AND access = 2 ORDER BY odering SELECT * FROM jos_hikashop_config SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.`field_backend` = 1 AND a.`field_core` = 0 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT category_id FROM jos_hikashop_category WHERE category_type='root' LIMIT 1 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=1 AND category_type='product' LIMIT 1 INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_manufacturer_id`,`product_sale_start`,`product_sale_end`,`product_layout`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Tænk dig Sund','','','','Taenk_dig_Sund','11','0','','','','-1','0','0','','kg','','','m','','1','main','0','twetwetw wt  wet wet wewetwet','1331635473','1331635473' ) SELECT product_id FROM jos_hikashop_product WHERE product_code = 'Taenk_dig_Sund' LIMIT 1 SELECT template FROM jos_templates_menu WHERE client_id = 1 AND menuid = 0 SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT * FROM jos_jce_groups WHERE published = 1 ORDER BY ordering ASC SELECT params FROM jos_plugins WHERE element = 'jce' AND folder = 'editors' AND published = 1 LIMIT 1 SELECT name FROM jos_jce_plugins WHERE TYPE = 'command' AND published = 0 SELECT name FROM jos_jce_plugins WHERE published = 1 AND TYPE = 'plugin' AND id IN (1,2,3,4,5,6,20,21,36,37,38,39,40,41,48,49,50,51,52,53,54,56,57) SELECT id, icon FROM jos_jce_plugins WHERE published = 1 AND id IN (6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,30,31,32,35,47,36,37,38,39,40,41,42,43,44,45,46,48,49,50,51,52,53,54,56,57) SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'tax' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'manufacturer' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT * FROM jos_hikashop_currency WHERE currency_published=1 OR currency_id IN ('47','47') SELECT id, title, module, POSITION, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access = 2 AND m.client_id = 1 ORDER BY POSITION, ordering SELECT COUNT(*) FROM jos_messages WHERE state = 0 AND user_id_to = 62 SELECT COUNT( session_id ) FROM jos_session WHERE guest 1 Indlæste sprogfiler /home/englebutik/public_html/administrator/language/da-DK/da-DK.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_cdscriptegrator.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_system_cdscriptegrator.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_debug.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.com_hikashop.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.com_hikashop.ini /home/englebutik/public_html/language/da-DK/da-DK.com_hikashop.ini 1 /home/englebutik/public_html/language/overrides/da-DK.override.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_editors_jce.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_editors_jce.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.tpl_khepri.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_title.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_toolbar.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_menu.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_status.ini 1 Ikke oversatte strnge diagnostik Ingen Ikke oversatte strenge designer Ingen ----- Kind regards from Martin")* was created by *[sjolte](/forum/user/6638-sjolte "View sjolte's Profile")* Hi Hikashop I get a "error saving red bar" when adding a new product. I use hikashop start version. 1.5.6 with joomla 1.5.25 The log file is: SELECT * FROM jos_session WHERE session_id = '47659fb1b63add8c8f8c827800ab71d7' DELETE FROM jos_session WHERE ( TIME < '1331631872' ) SELECT * FROM jos_session WHERE session_id = '47659fb1b63add8c8f8c827800ab71d7' UPDATE `jos_session` SET `time`='1331635472',`userid`='62',`usertype`='Super Administrator',`username`='englebutik',`gid`='25',`guest`='0',`client_id`='1',`data`='CNnrZdiCCSEjFDzG7xgA17L65-hiVb9qZ7SMaRstS_XeVbJHFO3ebecRoyMZ4jrqm17RapnhuSmjam5G5u0-twP27NClEIS7evIrHKHYPCyqlc3Anl7WMY0aiIgIAgFA0PhfKM8edWyznzRNvcFDSnH5C_ttCE9Z-MWILsQIIiQkbbo8BtADdPXzCShEFeFu7di-OqdSeq_SWKq1mfVf6741fcLM0cMjZRlUVZHMjKhupjbneSBqcagJxpJ_kEq6zU1baKDgY52r6uOvHrtH5eCAX-ZAqv8-TZYaNKonYj422tqPNoVbVM_bN1BbKr4gVJJ5RXvooob4d14y46LZQcVCa2clSOiRDbBFO2KodJAmZe0OnjPHk0efGcA56UtNMsnNpvbvAyJ_pxOiBjOnqYVG_T8KP-zuQs5wZ7QSwrZ78h5MVsLjw6aKelW6mR7ny96LGRXmbxMj5Kmr6t9NP_npaaTJPjcOFqJSYDDV9pWCm-swSY7n5XjR8iOhtJ723LMU-PlML5eyVD44aSv6ExQcVpqX_NLNi-lW4h4To2T5glCe8fRQ8Zud3G88C3SYxHlTuFaMJYATSh7A_sbBQA0txghrBSyEZmSJtjnfPafXLcy6E0qjEXYgqS4G9zzLzZ_VcY0uvSTCn0chJFzZItiqwtNEO-hpp5Mn7lrFYA73oLWwPEVcEYvyj9H0Kd_P9ByrIS8e8XM5x2I58OxN6YEordms2ahsvTIio0aAOUbBRDPT1nQ3k5Df34eGEmKS9QwMXamQpvS9Ev11Qn3snR00Yxja2vUqrdUr8OxCh0mcPIXD6MOOvkXw3SohV23unea4bzckUY9Q23kK1qDkvJg5OFROfx6yd8I88veTvy2LsGCf_tVGLBFIUE1nnOGl4X238spoz5YQqsDfM1kmqtG2pUjOJKOaYkBsgkacYvbTlULFX66UlznFVgT9-ELU6nnKcO8617J0IGOhGL11FCVpf_hnarZzTKo9v1XoK463lYkx1mwypWqUT8w1vszTYxpjS9jDs07TNQeUr44D99BrApGH5CgDqoz66P8-3CCYXkU4vmcIGZKvGtKbSGJZZMXszD6qmJ7Jjq2xe54OLMq-NnuJXXXOVwFN8zFJ7hm4JXpRmja5HJqT8LNdoLt-sJ4roLkUQca8S3_4RG8ypuNSvoy2gAxByvFaj_UqaDZ9s2PAcga4L4tkg6nczq-8xXRH4Zftav6BiFEbvJajbriNRDSXtaxlE9ZSO5pcrsggnwl1lTnarrmlFgEiEuv5CHX5PjOFy9iT4C7x9fLW2RfQIhzbJmrZ3HrK9_boR6EfxynetmPixoV_pwlIyfybNIdpUX4332zq2C1-Y29y_Caoz2a3DuxfFPANgFdjgLh_AsGO-J-IpVQNtqoWaQuPFHhUooq36pmL6QqOPJUMtdA6SO9VSgvBayU1Xd8d1XxfHJJlwFg9Hzs4nIyrutbatNGBOV3evycBijEXeXhZcGQU9iemzOm66w-Pg-6l1g3UEKLyc4oBMVNHLVvUjk8anBjnBxLo2jLM8S7DXBzuuyEWjRWHGOWyLv8F1wu05sCr-TrajzPEb7643HhjNrx69kuU7TJG50l_LSoku7n0n_1EqlyX5O0pNZP8dzC4GoJ9Ax1d35sokFlbL7dqtBmbL7LhWmlLRreuifwYqusRfnigjP0RwAqGlUneLWh41e3_Thcc5gRVUJVl9dWM9Asmam0g4WFnOyHyVLGQsIClTsGABRcSlW7UYHspw9xMNLlosysPFnf1mrqHk2ssyamrsMi5ITvhM1vkrfdV10UlxDnlhr-yOx5xGEgUW05QRL0YzPFI1Fo9eszUEqxHMDJkiIE7_HarieAH-iSk3JEXwnB9tfYH9lLoSflWK0RmUcXCySlSvyixhb8ix4krU8vX-p3Np2v2hYROnBGo5x3gItIbSoLB5rAju043RqUvJLSCS18ZXQkAVsykWQSiguhUP0QNn2doF93lw6pqzM0Ntg7wlqsRxs4xSBzbTeu21_eB_Kg7AoRpYrHnrhd8kiclFwyJYPTeFAnSHKB8On8dBqmlEkViDfA179cj_IWlZ-VisFEuMfc_qGQd92iZQV6gjjfkClNNn95qqJNblwJLttPYSWin_MquifTPDzC8Yy1V5FnAe9c357MOYUnFcGFuTviFsNECqUqpe7nRfBJ5DpCX1qjIqdXMNdPA1zbdNMVTPxbOJxLnD9iCfefRHUpYHXlO7GE2nhSur6h4uPU9vw..' WHERE session_id='47659fb1b63add8c8f8c827800ab71d7' SELECT * FROM jos_components WHERE parent = 0 SELECT folder AS TYPE, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 2 ORDER BY ordering SELECT * FROM jos_hikashop_config SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.`field_backend` = 1 AND a.`field_core` = 0 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT category_id FROM jos_hikashop_category WHERE category_type='root' LIMIT 1 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=1 AND category_type='product' LIMIT 1 INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_manufacturer_id`,`product_sale_start`,`product_sale_end`,`product_layout`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Tænk dig Sund','','','','Taenk_dig_Sund','11','0','','','','-1','0','0','','kg','','','m','','1','main','0','twetwetw wt &nbsp;wet wet wewetwet','1331635473','1331635473' ) SELECT product_id FROM jos_hikashop_product WHERE product_code = 'Taenk_dig_Sund' LIMIT 1 SELECT template FROM jos_templates_menu WHERE client_id = 1 AND menuid = 0 SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT * FROM jos_jce_groups WHERE published = 1 ORDER BY ordering ASC SELECT params FROM jos_plugins WHERE element = 'jce' AND folder = 'editors' AND published = 1 LIMIT 1 SELECT name FROM jos_jce_plugins WHERE TYPE = 'command' AND published = 0 SELECT name FROM jos_jce_plugins WHERE published = 1 AND TYPE = 'plugin' AND id IN (1,2,3,4,5,6,20,21,36,37,38,39,40,41,48,49,50,51,52,53,54,56,57) SELECT id, icon FROM jos_jce_plugins WHERE published = 1 AND id IN (6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,30,31,32,35,47,36,37,38,39,40,41,42,43,44,45,46,48,49,50,51,52,53,54,56,57) SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'tax' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'manufacturer' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT * FROM jos_hikashop_currency WHERE currency_published=1 OR currency_id IN ('47','47') SELECT id, title, module, POSITION, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 2 AND m.client_id = 1 ORDER BY POSITION, ordering SELECT COUNT(*) FROM jos_messages WHERE state = 0 AND user_id_to = 62 SELECT COUNT( session_id ) FROM jos_session WHERE guest <> 1 Indlæste sprogfiler /home/englebutik/public_html/administrator/language/da-DK/da-DK.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_cdscriptegrator.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_system_cdscriptegrator.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_debug.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.com_hikashop.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.com_hikashop.ini /home/englebutik/public_html/language/da-DK/da-DK.com_hikashop.ini 1 /home/englebutik/public_html/language/overrides/da-DK.override.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_editors_jce.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_editors_jce.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.tpl_khepri.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_title.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_toolbar.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_menu.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_status.ini 1 Ikke oversatte strnge diagnostik Ingen Ikke oversatte strenge designer Ingen --- Kind regards from Martin Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80Mjk4NS1lcnJvci13aGVuLXNhdmluZy1wcm9kdWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 14 years 7 months ago [\#43111](#43111) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: error when saving product](/forum/3-bug-report/42985-error-when-saving-product#43111 "Hi Hikashop I get a "error saving red bar" when adding a new product. I use hikashop start version. 1.5.6 with joomla 1.5.25 The log file is: SELECT * FROM jos_session WHERE session_id = '47659fb1b63add8c8f8c827800ab71d7' DELETE FROM jos_session WHERE ( TIME = 1 AND access = 2 ORDER BY odering SELECT * FROM jos_hikashop_config SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.`field_backend` = 1 AND a.`field_core` = 0 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT category_id FROM jos_hikashop_category WHERE category_type='root' LIMIT 1 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=1 AND category_type='product' LIMIT 1 INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_manufacturer_id`,`product_sale_start`,`product_sale_end`,`product_layout`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Tænk dig Sund','','','','Taenk_dig_Sund','11','0','','','','-1','0','0','','kg','','','m','','1','main','0','twetwetw wt  wet wet wewetwet','1331635473','1331635473' ) SELECT product_id FROM jos_hikashop_product WHERE product_code = 'Taenk_dig_Sund' LIMIT 1 SELECT template FROM jos_templates_menu WHERE client_id = 1 AND menuid = 0 SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT * FROM jos_jce_groups WHERE published = 1 ORDER BY ordering ASC SELECT params FROM jos_plugins WHERE element = 'jce' AND folder = 'editors' AND published = 1 LIMIT 1 SELECT name FROM jos_jce_plugins WHERE TYPE = 'command' AND published = 0 SELECT name FROM jos_jce_plugins WHERE published = 1 AND TYPE = 'plugin' AND id IN (1,2,3,4,5,6,20,21,36,37,38,39,40,41,48,49,50,51,52,53,54,56,57) SELECT id, icon FROM jos_jce_plugins WHERE published = 1 AND id IN (6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,30,31,32,35,47,36,37,38,39,40,41,42,43,44,45,46,48,49,50,51,52,53,54,56,57) SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'tax' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'manufacturer' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT * FROM jos_hikashop_currency WHERE currency_published=1 OR currency_id IN ('47','47') SELECT id, title, module, POSITION, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access = 2 AND m.client_id = 1 ORDER BY POSITION, ordering SELECT COUNT(*) FROM jos_messages WHERE state = 0 AND user_id_to = 62 SELECT COUNT( session_id ) FROM jos_session WHERE guest 1 Indlæste sprogfiler /home/englebutik/public_html/administrator/language/da-DK/da-DK.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_cdscriptegrator.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_system_cdscriptegrator.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_debug.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.com_hikashop.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.com_hikashop.ini /home/englebutik/public_html/language/da-DK/da-DK.com_hikashop.ini 1 /home/englebutik/public_html/language/overrides/da-DK.override.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_editors_jce.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_editors_jce.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.tpl_khepri.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_title.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_toolbar.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_menu.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_status.ini 1 Ikke oversatte strnge diagnostik Ingen Ikke oversatte strenge designer Ingen ----- Kind regards from Martin")* Hi, Please make sure that you don't have already another product with the product code 'Taenk_dig_Sund'. Maybe you could try to change the product code before saving ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80Mjk4NS1lcnJvci13aGVuLXNhdmluZy1wcm9kdWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[troywhatcott](/forum/user/6247-troywhatcott "View troywhatcott's Profile")** - [![troywhatcott's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6247-troywhatcott "View troywhatcott's Profile") - [ Offline](/forum/user/6247-troywhatcott) Less More - Posts: 4 - Thank you received: 0 - - 14 years 7 months ago [\#43320](#43320) by [troywhatcott](/forum/user/6247-troywhatcott "View troywhatcott's Profile") Replied by *[troywhatcott](/forum/user/6247-troywhatcott "View troywhatcott's Profile")* on topic *[Re: error when saving product](/forum/3-bug-report/42985-error-when-saving-product#43320 "Hi Hikashop I get a "error saving red bar" when adding a new product. I use hikashop start version. 1.5.6 with joomla 1.5.25 The log file is: SELECT * FROM jos_session WHERE session_id = '47659fb1b63add8c8f8c827800ab71d7' DELETE FROM jos_session WHERE ( TIME = 1 AND access = 2 ORDER BY odering SELECT * FROM jos_hikashop_config SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.`field_backend` = 1 AND a.`field_core` = 0 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT category_id FROM jos_hikashop_category WHERE category_type='root' LIMIT 1 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=1 AND category_type='product' LIMIT 1 INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_manufacturer_id`,`product_sale_start`,`product_sale_end`,`product_layout`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Tænk dig Sund','','','','Taenk_dig_Sund','11','0','','','','-1','0','0','','kg','','','m','','1','main','0','twetwetw wt  wet wet wewetwet','1331635473','1331635473' ) SELECT product_id FROM jos_hikashop_product WHERE product_code = 'Taenk_dig_Sund' LIMIT 1 SELECT template FROM jos_templates_menu WHERE client_id = 1 AND menuid = 0 SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT * FROM jos_jce_groups WHERE published = 1 ORDER BY ordering ASC SELECT params FROM jos_plugins WHERE element = 'jce' AND folder = 'editors' AND published = 1 LIMIT 1 SELECT name FROM jos_jce_plugins WHERE TYPE = 'command' AND published = 0 SELECT name FROM jos_jce_plugins WHERE published = 1 AND TYPE = 'plugin' AND id IN (1,2,3,4,5,6,20,21,36,37,38,39,40,41,48,49,50,51,52,53,54,56,57) SELECT id, icon FROM jos_jce_plugins WHERE published = 1 AND id IN (6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,30,31,32,35,47,36,37,38,39,40,41,42,43,44,45,46,48,49,50,51,52,53,54,56,57) SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'tax' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'manufacturer' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT * FROM jos_hikashop_currency WHERE currency_published=1 OR currency_id IN ('47','47') SELECT id, title, module, POSITION, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access = 2 AND m.client_id = 1 ORDER BY POSITION, ordering SELECT COUNT(*) FROM jos_messages WHERE state = 0 AND user_id_to = 62 SELECT COUNT( session_id ) FROM jos_session WHERE guest 1 Indlæste sprogfiler /home/englebutik/public_html/administrator/language/da-DK/da-DK.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_cdscriptegrator.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_system_cdscriptegrator.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_debug.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.com_hikashop.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.com_hikashop.ini /home/englebutik/public_html/language/da-DK/da-DK.com_hikashop.ini 1 /home/englebutik/public_html/language/overrides/da-DK.override.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_editors_jce.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_editors_jce.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.tpl_khepri.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_title.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_toolbar.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_menu.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_status.ini 1 Ikke oversatte strnge diagnostik Ingen Ikke oversatte strenge designer Ingen ----- Kind regards from Martin")* I am getting this same error. I tried narrowing it down by disabling some other plugins, changing my editor. I did recently update Joomla to 2.5.3. I get the error when saving a new product, and when I try to edit an existing product saying that the product code exists. I try changing the code to a new one, but I still get the same problem. Help! Thanks, Troy Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80Mjk4NS1lcnJvci13aGVuLXNhdmluZy1wcm9kdWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 14 years 7 months ago [\#43483](#43483) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: error when saving product](/forum/3-bug-report/42985-error-when-saving-product#43483 "Hi Hikashop I get a "error saving red bar" when adding a new product. I use hikashop start version. 1.5.6 with joomla 1.5.25 The log file is: SELECT * FROM jos_session WHERE session_id = '47659fb1b63add8c8f8c827800ab71d7' DELETE FROM jos_session WHERE ( TIME = 1 AND access = 2 ORDER BY odering SELECT * FROM jos_hikashop_config SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.`field_backend` = 1 AND a.`field_core` = 0 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT category_id FROM jos_hikashop_category WHERE category_type='root' LIMIT 1 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=1 AND category_type='product' LIMIT 1 INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_manufacturer_id`,`product_sale_start`,`product_sale_end`,`product_layout`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Tænk dig Sund','','','','Taenk_dig_Sund','11','0','','','','-1','0','0','','kg','','','m','','1','main','0','twetwetw wt  wet wet wewetwet','1331635473','1331635473' ) SELECT product_id FROM jos_hikashop_product WHERE product_code = 'Taenk_dig_Sund' LIMIT 1 SELECT template FROM jos_templates_menu WHERE client_id = 1 AND menuid = 0 SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT * FROM jos_jce_groups WHERE published = 1 ORDER BY ordering ASC SELECT params FROM jos_plugins WHERE element = 'jce' AND folder = 'editors' AND published = 1 LIMIT 1 SELECT name FROM jos_jce_plugins WHERE TYPE = 'command' AND published = 0 SELECT name FROM jos_jce_plugins WHERE published = 1 AND TYPE = 'plugin' AND id IN (1,2,3,4,5,6,20,21,36,37,38,39,40,41,48,49,50,51,52,53,54,56,57) SELECT id, icon FROM jos_jce_plugins WHERE published = 1 AND id IN (6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,30,31,32,35,47,36,37,38,39,40,41,42,43,44,45,46,48,49,50,51,52,53,54,56,57) SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'tax' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'manufacturer' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT * FROM jos_hikashop_currency WHERE currency_published=1 OR currency_id IN ('47','47') SELECT id, title, module, POSITION, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access = 2 AND m.client_id = 1 ORDER BY POSITION, ordering SELECT COUNT(*) FROM jos_messages WHERE state = 0 AND user_id_to = 62 SELECT COUNT( session_id ) FROM jos_session WHERE guest 1 Indlæste sprogfiler /home/englebutik/public_html/administrator/language/da-DK/da-DK.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_cdscriptegrator.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_system_cdscriptegrator.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_debug.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.com_hikashop.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.com_hikashop.ini /home/englebutik/public_html/language/da-DK/da-DK.com_hikashop.ini 1 /home/englebutik/public_html/language/overrides/da-DK.override.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_editors_jce.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_editors_jce.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.tpl_khepri.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_title.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_toolbar.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_menu.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_status.ini 1 Ikke oversatte strnge diagnostik Ingen Ikke oversatte strenge designer Ingen ----- Kind regards from Martin")* Could you try to turn on the debug option of the configuration of joomla and try again ? Do you get another error ? Could you do a screenshot of the problem ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80Mjk4NS1lcnJvci13aGVuLXNhdmluZy1wcm9kdWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[troywhatcott](/forum/user/6247-troywhatcott "View troywhatcott's Profile")** - [![troywhatcott's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6247-troywhatcott "View troywhatcott's Profile") - [ Offline](/forum/user/6247-troywhatcott) Less More - Posts: 4 - Thank you received: 0 - - 14 years 7 months ago [\#44638](#44638) by [troywhatcott](/forum/user/6247-troywhatcott "View troywhatcott's Profile") Replied by *[troywhatcott](/forum/user/6247-troywhatcott "View troywhatcott's Profile")* on topic *[Re: error when saving product](/forum/3-bug-report/42985-error-when-saving-product#44638 "Hi Hikashop I get a "error saving red bar" when adding a new product. I use hikashop start version. 1.5.6 with joomla 1.5.25 The log file is: SELECT * FROM jos_session WHERE session_id = '47659fb1b63add8c8f8c827800ab71d7' DELETE FROM jos_session WHERE ( TIME = 1 AND access = 2 ORDER BY odering SELECT * FROM jos_hikashop_config SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.`field_backend` = 1 AND a.`field_core` = 0 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT category_id FROM jos_hikashop_category WHERE category_type='root' LIMIT 1 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=1 AND category_type='product' LIMIT 1 INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_manufacturer_id`,`product_sale_start`,`product_sale_end`,`product_layout`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Tænk dig Sund','','','','Taenk_dig_Sund','11','0','','','','-1','0','0','','kg','','','m','','1','main','0','twetwetw wt  wet wet wewetwet','1331635473','1331635473' ) SELECT product_id FROM jos_hikashop_product WHERE product_code = 'Taenk_dig_Sund' LIMIT 1 SELECT template FROM jos_templates_menu WHERE client_id = 1 AND menuid = 0 SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT * FROM jos_jce_groups WHERE published = 1 ORDER BY ordering ASC SELECT params FROM jos_plugins WHERE element = 'jce' AND folder = 'editors' AND published = 1 LIMIT 1 SELECT name FROM jos_jce_plugins WHERE TYPE = 'command' AND published = 0 SELECT name FROM jos_jce_plugins WHERE published = 1 AND TYPE = 'plugin' AND id IN (1,2,3,4,5,6,20,21,36,37,38,39,40,41,48,49,50,51,52,53,54,56,57) SELECT id, icon FROM jos_jce_plugins WHERE published = 1 AND id IN (6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,30,31,32,35,47,36,37,38,39,40,41,42,43,44,45,46,48,49,50,51,52,53,54,56,57) SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'tax' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'manufacturer' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT * FROM jos_hikashop_currency WHERE currency_published=1 OR currency_id IN ('47','47') SELECT id, title, module, POSITION, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access = 2 AND m.client_id = 1 ORDER BY POSITION, ordering SELECT COUNT(*) FROM jos_messages WHERE state = 0 AND user_id_to = 62 SELECT COUNT( session_id ) FROM jos_session WHERE guest 1 Indlæste sprogfiler /home/englebutik/public_html/administrator/language/da-DK/da-DK.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_cdscriptegrator.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_system_cdscriptegrator.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_debug.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.com_hikashop.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.com_hikashop.ini /home/englebutik/public_html/language/da-DK/da-DK.com_hikashop.ini 1 /home/englebutik/public_html/language/overrides/da-DK.override.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_editors_jce.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_editors_jce.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.tpl_khepri.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_title.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_toolbar.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_menu.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_status.ini 1 Ikke oversatte strnge diagnostik Ingen Ikke oversatte strenge designer Ingen ----- Kind regards from Martin")* [ ![Untitled-1.jpg](/forum/attachment/3218) ](/forum/attachment/3218 "Untitled-1.jpg") This is the error I get with Debug enabled. - [ ![Untitled-1.jpg](/forum/attachment/3218) ](/forum/attachment/3218 "Untitled-1.jpg") [ ](/forum/attachment/3218?download=1 "Untitled-1.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80Mjk4NS1lcnJvci13aGVuLXNhdmluZy1wcm9kdWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 14 years 7 months ago [\#44786](#44786) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: error when saving product](/forum/3-bug-report/42985-error-when-saving-product#44786 "Hi Hikashop I get a "error saving red bar" when adding a new product. I use hikashop start version. 1.5.6 with joomla 1.5.25 The log file is: SELECT * FROM jos_session WHERE session_id = '47659fb1b63add8c8f8c827800ab71d7' DELETE FROM jos_session WHERE ( TIME = 1 AND access = 2 ORDER BY odering SELECT * FROM jos_hikashop_config SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.`field_backend` = 1 AND a.`field_core` = 0 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT category_id FROM jos_hikashop_category WHERE category_type='root' LIMIT 1 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=1 AND category_type='product' LIMIT 1 INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_manufacturer_id`,`product_sale_start`,`product_sale_end`,`product_layout`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Tænk dig Sund','','','','Taenk_dig_Sund','11','0','','','','-1','0','0','','kg','','','m','','1','main','0','twetwetw wt  wet wet wewetwet','1331635473','1331635473' ) SELECT product_id FROM jos_hikashop_product WHERE product_code = 'Taenk_dig_Sund' LIMIT 1 SELECT template FROM jos_templates_menu WHERE client_id = 1 AND menuid = 0 SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT * FROM jos_jce_groups WHERE published = 1 ORDER BY ordering ASC SELECT params FROM jos_plugins WHERE element = 'jce' AND folder = 'editors' AND published = 1 LIMIT 1 SELECT name FROM jos_jce_plugins WHERE TYPE = 'command' AND published = 0 SELECT name FROM jos_jce_plugins WHERE published = 1 AND TYPE = 'plugin' AND id IN (1,2,3,4,5,6,20,21,36,37,38,39,40,41,48,49,50,51,52,53,54,56,57) SELECT id, icon FROM jos_jce_plugins WHERE published = 1 AND id IN (6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,30,31,32,35,47,36,37,38,39,40,41,42,43,44,45,46,48,49,50,51,52,53,54,56,57) SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'tax' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'manufacturer' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT * FROM jos_hikashop_currency WHERE currency_published=1 OR currency_id IN ('47','47') SELECT id, title, module, POSITION, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access = 2 AND m.client_id = 1 ORDER BY POSITION, ordering SELECT COUNT(*) FROM jos_messages WHERE state = 0 AND user_id_to = 62 SELECT COUNT( session_id ) FROM jos_session WHERE guest 1 Indlæste sprogfiler /home/englebutik/public_html/administrator/language/da-DK/da-DK.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_cdscriptegrator.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_system_cdscriptegrator.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_debug.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.com_hikashop.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.com_hikashop.ini /home/englebutik/public_html/language/da-DK/da-DK.com_hikashop.ini 1 /home/englebutik/public_html/language/overrides/da-DK.override.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_editors_jce.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_editors_jce.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.tpl_khepri.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_title.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_toolbar.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_menu.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_status.ini 1 Ikke oversatte strnge diagnostik Ingen Ikke oversatte strenge designer Ingen ----- Kind regards from Martin")* Hi, You're getting that error because you updated at one point HikaShop and that either your hosting does not allow ALTER queries for the MySQL user of your website, or because there was a problem on the MySQL server during the update process. We have a documentation page which explains what to do in those cases here: [ www.hikashop.com/en/support/documentatio...lity-issues.html#SQL](http://www.hikashop.com/en/support/documentation/61-hikashop-compatibility-issues.html#SQL) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80Mjk4NS1lcnJvci13aGVuLXNhdmluZy1wcm9kdWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[troywhatcott](/forum/user/6247-troywhatcott "View troywhatcott's Profile")** - [![troywhatcott's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6247-troywhatcott "View troywhatcott's Profile") - [ Offline](/forum/user/6247-troywhatcott) Less More - Posts: 4 - Thank you received: 0 - - 14 years 5 months ago - 14 years 5 months ago [\#50130](#50130) by [troywhatcott](/forum/user/6247-troywhatcott "View troywhatcott's Profile") Replied by *[troywhatcott](/forum/user/6247-troywhatcott "View troywhatcott's Profile")* on topic *[Re: error when saving product](/forum/3-bug-report/42985-error-when-saving-product#50130 "Hi Hikashop I get a "error saving red bar" when adding a new product. I use hikashop start version. 1.5.6 with joomla 1.5.25 The log file is: SELECT * FROM jos_session WHERE session_id = '47659fb1b63add8c8f8c827800ab71d7' DELETE FROM jos_session WHERE ( TIME = 1 AND access = 2 ORDER BY odering SELECT * FROM jos_hikashop_config SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.`field_backend` = 1 AND a.`field_core` = 0 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT category_id FROM jos_hikashop_category WHERE category_type='root' LIMIT 1 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=1 AND category_type='product' LIMIT 1 INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_manufacturer_id`,`product_sale_start`,`product_sale_end`,`product_layout`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Tænk dig Sund','','','','Taenk_dig_Sund','11','0','','','','-1','0','0','','kg','','','m','','1','main','0','twetwetw wt  wet wet wewetwet','1331635473','1331635473' ) SELECT product_id FROM jos_hikashop_product WHERE product_code = 'Taenk_dig_Sund' LIMIT 1 SELECT template FROM jos_templates_menu WHERE client_id = 1 AND menuid = 0 SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT * FROM jos_jce_groups WHERE published = 1 ORDER BY ordering ASC SELECT params FROM jos_plugins WHERE element = 'jce' AND folder = 'editors' AND published = 1 LIMIT 1 SELECT name FROM jos_jce_plugins WHERE TYPE = 'command' AND published = 0 SELECT name FROM jos_jce_plugins WHERE published = 1 AND TYPE = 'plugin' AND id IN (1,2,3,4,5,6,20,21,36,37,38,39,40,41,48,49,50,51,52,53,54,56,57) SELECT id, icon FROM jos_jce_plugins WHERE published = 1 AND id IN (6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,30,31,32,35,47,36,37,38,39,40,41,42,43,44,45,46,48,49,50,51,52,53,54,56,57) SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'tax' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'manufacturer' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT * FROM jos_hikashop_currency WHERE currency_published=1 OR currency_id IN ('47','47') SELECT id, title, module, POSITION, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access = 2 AND m.client_id = 1 ORDER BY POSITION, ordering SELECT COUNT(*) FROM jos_messages WHERE state = 0 AND user_id_to = 62 SELECT COUNT( session_id ) FROM jos_session WHERE guest 1 Indlæste sprogfiler /home/englebutik/public_html/administrator/language/da-DK/da-DK.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_cdscriptegrator.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_system_cdscriptegrator.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_debug.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.com_hikashop.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.com_hikashop.ini /home/englebutik/public_html/language/da-DK/da-DK.com_hikashop.ini 1 /home/englebutik/public_html/language/overrides/da-DK.override.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_editors_jce.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_editors_jce.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.tpl_khepri.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_title.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_toolbar.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_menu.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_status.ini 1 Ikke oversatte strnge diagnostik Ingen Ikke oversatte strenge designer Ingen ----- Kind regards from Martin")* - Last edit: 14 years 5 months ago by [troywhatcott](/forum/user/6247-troywhatcott "View troywhatcott's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80Mjk4NS1lcnJvci13aGVuLXNhdmluZy1wcm9kdWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 14 years 5 months ago [\#50174](#50174) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: error when saving product](/forum/3-bug-report/42985-error-when-saving-product#50174 "Hi Hikashop I get a "error saving red bar" when adding a new product. I use hikashop start version. 1.5.6 with joomla 1.5.25 The log file is: SELECT * FROM jos_session WHERE session_id = '47659fb1b63add8c8f8c827800ab71d7' DELETE FROM jos_session WHERE ( TIME = 1 AND access = 2 ORDER BY odering SELECT * FROM jos_hikashop_config SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.`field_backend` = 1 AND a.`field_core` = 0 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT category_id FROM jos_hikashop_category WHERE category_type='root' LIMIT 1 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=1 AND category_type='product' LIMIT 1 INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_manufacturer_id`,`product_sale_start`,`product_sale_end`,`product_layout`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Tænk dig Sund','','','','Taenk_dig_Sund','11','0','','','','-1','0','0','','kg','','','m','','1','main','0','twetwetw wt  wet wet wewetwet','1331635473','1331635473' ) SELECT product_id FROM jos_hikashop_product WHERE product_code = 'Taenk_dig_Sund' LIMIT 1 SELECT template FROM jos_templates_menu WHERE client_id = 1 AND menuid = 0 SELECT * FROM jos_hikashop_field AS a WHERE a.`field_published` = 1 AND a.field_table='product' ORDER BY a.`field_ordering` ASC SELECT * FROM jos_jce_groups WHERE published = 1 ORDER BY ordering ASC SELECT params FROM jos_plugins WHERE element = 'jce' AND folder = 'editors' AND published = 1 LIMIT 1 SELECT name FROM jos_jce_plugins WHERE TYPE = 'command' AND published = 0 SELECT name FROM jos_jce_plugins WHERE published = 1 AND TYPE = 'plugin' AND id IN (1,2,3,4,5,6,20,21,36,37,38,39,40,41,48,49,50,51,52,53,54,56,57) SELECT id, icon FROM jos_jce_plugins WHERE published = 1 AND id IN (6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,30,31,32,35,47,36,37,38,39,40,41,42,43,44,45,46,48,49,50,51,52,53,54,56,57) SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'tax' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT category_id FROM jos_hikashop_category WHERE category_parent_id=0 LIMIT 1 SELECT a.category_name,a.category_id,a.category_namekey FROM jos_hikashop_category AS a WHERE a.category_type = 'manufacturer' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC SELECT * FROM jos_hikashop_currency WHERE currency_published=1 OR currency_id IN ('47','47') SELECT id, title, module, POSITION, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access = 2 AND m.client_id = 1 ORDER BY POSITION, ordering SELECT COUNT(*) FROM jos_messages WHERE state = 0 AND user_id_to = 62 SELECT COUNT( session_id ) FROM jos_session WHERE guest 1 Indlæste sprogfiler /home/englebutik/public_html/administrator/language/da-DK/da-DK.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_cdscriptegrator.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_system_cdscriptegrator.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_system_debug.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.com_hikashop.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.com_hikashop.ini /home/englebutik/public_html/language/da-DK/da-DK.com_hikashop.ini 1 /home/englebutik/public_html/language/overrides/da-DK.override.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.plg_editors_jce.ini /home/englebutik/public_html/administrator/language/en-GB/en-GB.plg_editors_jce.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.tpl_khepri.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_title.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_toolbar.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_menu.ini 1 /home/englebutik/public_html/administrator/language/da-DK/da-DK.mod_status.ini 1 Ikke oversatte strnge diagnostik Ingen Ikke oversatte strenge designer Ingen ----- Kind regards from Martin")* Where you able to solve your problem ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80Mjk4NS1lcnJvci13aGVuLXNhdmluZy1wcm9kdWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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.093 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)