Skip to main content

error when saving product

More
14 years 6 months ago #42985 by sjolte
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 or Create an account to join the conversation.

More
14 years 6 months ago #43111 by nicolas
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.

More
14 years 6 months ago #43320 by troywhatcott
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.

More
14 years 6 months ago #43483 by nicolas
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.

More
14 years 6 months ago #44638 by troywhatcott


This is the error I get with Debug enabled.

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

More
14 years 6 months ago #44786 by nicolas
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.

More
14 years 4 months ago - 14 years 4 months ago #50130 by troywhatcott
Last edit: 14 years 4 months ago by troywhatcott.

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

More
14 years 4 months ago #50174 by nicolas
Where you able to solve your problem ?

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

Time to create page: 0.213 seconds
Powered by Kunena Forum