error when saving product

  • Posts: 1
  • Thank you received: 0
12 years 8 months ago #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 < '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  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 or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
12 years 8 months ago #43111

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

  • Posts: 4
  • Thank you received: 0
12 years 8 months ago #43320

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
12 years 8 months ago #43483

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

  • Posts: 4
  • Thank you received: 0
12 years 8 months ago #44638



This is the error I get with Debug enabled.

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
12 years 7 months ago #44786

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

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

  • Posts: 4
  • Thank you received: 0
12 years 6 months ago #50130

-

Last edit: 12 years 6 months ago by troywhatcott.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
12 years 6 months ago #50174

Where you able to solve your problem ?

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

Time to create page: 0.082 seconds
Powered by Kunena Forum