Can't copy products or import with template

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

I was using 1.5.2 and everything worked properly. I was importing pictures from a file using templates with options. It does not work now that I have upgraded to 1.5.4. Now when I import from file using a template it doesn't use the template I selected. And when I try and copy a product it does not copy. It says copy successfull but the product is not copied.

I am including the debug information from the bottom of the page with joomla debug mode turned on. I am using joomla 1.7 and Hikashop Business 1.5.4 I logged in using a temporary test account.

This is the debug from when I try and copy a product from the backend.


Profile Information
Application 0.002 seconds (+0.002); 0.35 MB (+0.351) - afterLoad
Application 0.056 seconds (+0.054); 3.34 MB (+2.991) - afterInitialise
Application 0.056 seconds (+0.000); 3.34 MB (+0.000) - afterRoute
Application 0.173 seconds (+0.117); 8.22 MB (+4.876) - afterDispatch
Application 0.180 seconds (+0.006); 8.45 MB (+0.229) - beforeRenderModule mod_submenu (Admin Submenu)
Application 0.183 seconds (+0.003); 8.47 MB (+0.027) - afterRenderModule mod_submenu (Admin Submenu)
Application 0.183 seconds (+0.000); 8.47 MB (-0.001) - beforeRenderModule mod_title (Title)
Application 0.186 seconds (+0.003); 8.48 MB (+0.003) - afterRenderModule mod_title (Title)
Application 0.186 seconds (+0.000); 8.47 MB (-0.001) - beforeRenderModule mod_toolbar (Toolbar)
Application 0.192 seconds (+0.006); 8.56 MB (+0.081) - afterRenderModule mod_toolbar (Toolbar)
Application 0.192 seconds (+0.000); 8.55 MB (-0.001) - beforeRenderModule mod_status (User Status)
Application 0.196 seconds (+0.004); 8.56 MB (+0.004) - afterRenderModule mod_status (User Status)
Application 0.196 seconds (+0.000); 8.56 MB (-0.002) - beforeRenderModule mod_menu (Admin Menu)
Application 0.239 seconds (+0.043); 8.86 MB (+0.301) - afterRenderModule mod_menu (Admin Menu)
Application 0.241 seconds (+0.002); 8.91 MB (+0.054) - afterRender
Memory Usage
8.94 MB (9,375,808 Bytes)
45 Queries Logged

SELECT `data`
FROM `jos_session`
WHERE `session_id` = '6323e516732a47d40f946c9b5ab11bc0'
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params
FROM jos_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
SELECT template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_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
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_hikashop'
SELECT *
FROM jos_hikashop_config
SELECT a.id
FROM jos_user_usergroup_map AS map
LEFT JOIN jos_usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 45
SELECT *
FROM jos_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,%')
ORDER BY a.`field_ordering` ASC
SHOW FULL COLUMNS
FROM `jos_hikashop_product`
SELECT *
FROM jos_hikashop_characteristic
ORDER BY characteristic_parent_id 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
SELECT category_id
FROM jos_hikashop_category
WHERE category_parent_id=1
AND category_type='manufacturer'
LIMIT 1
SELECT *
FROM jos_hikashop_product_related AS a
WHERE a.product_id IN (323)
SELECT *
FROM jos_hikashop_product
WHERE product_id IN (323,132,236,239,242,245,248,251,254,257,260,263,266,269,272,275,278,281,284,287,290,293,296,299,302,305,308) OR product_parent_id IN (323,132,236,239,242,245,248,251,254,257,260,263,266,269,272,275,278,281,284,287,290,293,296,299,302,305,308)
ORDER BY product_parent_id ASC
SHOW TABLES LIKE 'jos_jf_content'
SELECT *
FROM jos_hikashop_product_category
WHERE product_id IN (308,305,302,299,296,293,323,290,287,284,281,278,275,272,269,266,263,260,257,254,251,248,132,245,242,239,236)
ORDER BY ordering ASC
SELECT *
FROM jos_hikashop_price
WHERE price_product_id IN (308,305,302,299,296,293,323,290,287,284,281,278,275,272,269,266,263,260,257,254,251,248,132,245,242,239,236,312,313,314,315,134,316,562,238,240,241,244,243,247,246,250,249,253,252,255,256,259,258,262,261,265,264,268,267,271,270,273,274,276,277,280,279,282,283,286,285,289,288,322,318,319,320,321,291,561,294,295,298,297,301,300,304,303,307,306,309,310)
SELECT *
FROM jos_hikashop_file
WHERE file_ref_id IN (308,305,302,299,296,293,323,290,287,284,281,278,275,272,269,266,263,260,257,254,251,248,132,245,242,239,236,312,313,314,315,134,316,562,238,240,241,244,243,247,246,250,249,253,252,255,256,259,258,262,261,265,264,268,267,271,270,273,274,276,277,280,279,282,283,286,285,289,288,322,318,319,320,321,291,561,294,295,298,297,301,300,304,303,307,306,309,310)
AND file_type IN ('product','file')
ORDER BY file_id ASC
SELECT *
FROM jos_hikashop_variant
WHERE variant_product_id IN (308,305,302,299,296,293,323,290,287,284,281,278,275,272,269,266,263,260,257,254,251,248,132,245,242,239,236,312,313,314,315,134,316,562,238,240,241,244,243,247,246,250,249,253,252,255,256,259,258,262,261,265,264,268,267,271,270,273,274,276,277,280,279,282,283,286,285,289,288,322,318,319,320,321,291,561,294,295,298,297,301,300,304,303,307,306,309,310)
ORDER BY ordering ASC
SELECT *
FROM jos_hikashop_product
WHERE product_code IN ('Options_copy491125618_copy1949383967')
REPLACE INTO jos_hikashop_product (`product_weight`, `product_description`, `product_meta_description`, `product_tax_id`, `product_vendor_id`, `product_manufacturer_id`, `product_url`, `product_keywords`, `product_weight_unit`, `product_dimension_unit`, `product_width`, `product_length`, `product_height`, `product_max_per_order`, `product_name`, `product_published`, `product_code`, `product_created`, `product_modified`, `product_sale_start`, `product_sale_end`, `product_type`, `product_quantity`, `product_id`, `product_parent_id`, `product_hit`, `product_delay_id`, `product_access`, `product_group_after_purchase`, `product_min_per_order`, `product_contact`, `product_last_seen_date`, `product_sales`)
VALUES ('0.000','<p>Options</p>','','0','','','','','kg','m','0.000','0.000','0.000','','Options','0','Options_copy491125618_copy1949383967','1317853054','1317853054','','','main','-1',NULL,'','','','all','','','0','','')
SELECT product_code, product_id
FROM jos_hikashop_product
WHERE product_code IN ('Options_copy491125618_copy1949383967')
SELECT *
FROM jos_hikashop_product
WHERE product_code IN ('Prints_8_copy1441438309_copy273767734_copy538381790','Prints_7_copy770164576_copy1816155363_copy786494696')
REPLACE INTO jos_hikashop_product (`product_weight`, `product_description`, `product_meta_description`, `product_tax_id`, `product_vendor_id`, `product_manufacturer_id`, `product_url`, `product_keywords`, `product_weight_unit`, `product_dimension_unit`, `product_width`, `product_length`, `product_height`, `product_max_per_order`, `product_name`, `product_published`, `product_code`, `product_created`, `product_modified`, `product_sale_start`, `product_sale_end`, `product_type`, `product_quantity`, `product_parent_id`, `product_id`, `product_hit`, `product_delay_id`, `product_access`, `product_group_after_purchase`, `product_min_per_order`, `product_contact`, `product_last_seen_date`, `product_sales`)
VALUES ('0.000','','','0','0','0','','','kg','m','0.000','0.000','0.000','0','20x30','1','Prints_8_copy1441438309_copy273767734_copy538381790','1310716938','1310717034','0','0','variant','-1','738',NULL,'0','0','all','','0','0','0','0'),('0.000','','','0','0','0','','','kg','m','0.000','0.000','0.000','0','5x7','1','Prints_7_copy770164576_copy1816155363_copy786494696','1310716938','1310717002','0','0','variant','-1','738',NULL,'0','0','all','','0','0','0','0')
SELECT product_code, product_id
FROM jos_hikashop_product
WHERE product_code IN ('Prints_8_copy1441438309_copy273767734_copy538381790','Prints_7_copy770164576_copy1816155363_copy786494696')
DELETE
FROM jos_hikashop_variant
WHERE variant_product_id IN (738,739,740)
INSERT IGNORE INTO jos_hikashop_variant (`variant_characteristic_id`,`variant_product_id`)
VALUES (8,738),(9,738),(8,739),(7,740)
DELETE
FROM jos_hikashop_price
WHERE price_product_id IN (739,740)
INSERT IGNORE INTO jos_hikashop_price (`price_value`,`price_currency_id`,`price_min_quantity`,`price_product_id`,`price_access`)
VALUES ('50.99000',2,0,739,'all'),('16.99000',2,0,740,'all')
INSERT IGNORE INTO jos_hikashop_product_category (`category_id`,`product_id`,`ordering`)
VALUES (14,738,126),(14,739,126),(14,740,126)
SELECT *
FROM jos_hikashop_field as a
WHERE a.`field_published` = 1
AND a.`field_backend_listing` = 1
AND a.field_table='product'
AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%')
ORDER BY a.`field_ordering` ASC
SELECT a.ordering, b.*
FROM jos_hikashop_product_category AS a
LEFT JOIN jos_hikashop_product AS b
ON a.product_id=b.product_id
WHERE a.category_id=13
AND b.product_type = 'main'
ORDER BY a.ordering asc
LIMIT 0, 20
SELECT COUNT(DISTINCT(b.product_id))
FROM jos_hikashop_product_category AS a
LEFT JOIN jos_hikashop_product AS b
ON a.product_id=b.product_id
WHERE a.category_id=13
AND b.product_type = 'main'
SELECT *
FROM jos_hikashop_price
WHERE price_product_id IN (323)
SELECT DISTINCT b.*
FROM jos_hikashop_category AS a
LEFT JOIN jos_hikashop_category AS b
ON a.category_left >= b.category_left
WHERE b.category_right >= a.category_right
AND a.category_id=13
ORDER BY b.category_left
SELECT a.*
FROM jos_hikashop_category AS a
WHERE a.category_parent_id IN (1,2,13)
AND a.category_type IN ('product','root')
ORDER BY a.category_name ASC
LIMIT 0, 500
SHOW TABLES LIKE 'jos_jf_content'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_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 <= '2011-10-05 22:17:34')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-10-05 22:17:34')
AND m.access IN (1,1,2,3)
AND m.client_id = 1
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT COUNT(*)
FROM jos_messages
WHERE state = 0
AND user_id_to = 45
SELECT COUNT(session_id)
FROM jos_session
WHERE guest = 0
AND client_id = 1
SELECT COUNT(session_id)
FROM jos_session
WHERE guest = 0
AND client_id = 0
SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM jos_menu_types AS a
LEFT JOIN jos_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN jos_languages AS l
ON l.lang_code = language
WHERE (b.client_id = 0 OR b.client_id IS NULL)
GROUP BY a.id
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM jos_menu AS m
LEFT JOIN jos_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
UPDATE `jos_session`
SET `data` = '__default|a:8:{s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1\";s:15:\"session.counter\";i:6;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:7:\"product\";O:8:\"stdClass\":8:{s:12:\"filter_order\";s:10:\"a.ordering\";s:16:\"filter_order_Dir\";s:3:\"asc\";s:10:\"limitstart\";i:0;s:6:\"search\";s:0:\"\";s:10:\"list_limit\";i:20;s:11:\"filter_type\";i:0;s:9:\"filter_id\";s:2:\"13\";s:19:\"filter_product_type\";s:4:\"main\";}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"45\";s:4:\"name\";s:6:\"tester\";s:8:\"username\";s:6:\"tester\";s:5:\"email\";s:20:\"tester@tester.com\";s:8:\"password\";s:65:\"aeb80fd5ceb817019b3d47f0853d84ad:1h13OBg95PPSSbG3jvauMxR0KwR04kIS\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:12:\"registerDate\";s:19:\"2011-06-01 15:51:11\";s:13:\"lastvisitDate\";s:19:\"2011-10-05 21:57:04\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"8aff7b5f1a3bdfa80acb2f038db1c684\";s:19:\"session.timer.start\";i:1317853005;s:18:\"session.timer.last\";i:1317853038;s:17:\"session.timer.now\";i:1317853054;}', `time` = 1317853054
WHERE `session_id` = '6323e516732a47d40f946c9b5ab11bc0'

35 Query Types Logged, Sorted by Occurrences.
SELECT Tables:

3 × SELECT category_id FROM jos_hikashop_category
3 × SELECT * FROM jos_hikashop_product
2 × SELECT product_code, product_id FROM jos_hikashop_product
2 × SELECT COUNT(session_id) FROM jos_session
2 × SELECT * FROM jos_hikashop_field as a
2 × SELECT * FROM jos_hikashop_price
2 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jos_extensions
1 × SELECT a.* FROM jos_hikashop_category AS a
1 × SELECT DISTINCT b.* FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_category AS b ON a.category_left >= b.category_left
1 × SELECT COUNT(DISTINCT(b.product_id)) FROM jos_hikashop_product_category AS a LEFT JOIN jos_hikashop_product AS b ON a.product_id=b.product_id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT COUNT(*) FROM jos_messages
1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element FROM jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id
1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native FROM jos_menu_types AS a LEFT JOIN jos_menu AS b ON b.menutype = a.menutype AND b.home != 0 LEFT JOIN jos_languages AS l ON l.lang_code = language
1 × SELECT a.ordering, b.* FROM jos_hikashop_product_category AS a LEFT JOIN jos_hikashop_product AS b ON a.product_id=b.product_id
1 × SELECT folder AS type, element AS name, params FROM jos_extensions
1 × SELECT * FROM jos_hikashop_product_related AS a
1 × SELECT * FROM jos_hikashop_confi
1 × SELECT * FROM jos_hikashop_characteristic
1 × SELECT template, s.params FROM jos_template_styles as s LEFT JOIN jos_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id
1 × SELECT * FROM jos_hikashop_product_category
1 × SELECT * FROM jos_hikashop_variant
1 × SELECT * FROM jos_hikashop_file
1 × SELECT `data` FROM `jos_session`
1 × SELECT a.id FROM jos_user_usergroup_map AS map LEFT JOIN jos_usergroups AS a ON a.id = map.group_id

OTHER Tables:

2 × SHOW TABLES LIKE 'jos_jf_content
1 × INSERT IGNORE INTO jos_hikashop_price (`price_value`,`price_currency_id`,`price_min_quantity`,`price_product_id`,`price_access`) VALUES ('50.99000',2,0,739,'all'),('16.99000',2,0,740,'all'
1 × INSERT IGNORE INTO jos_hikashop_product_category (`category_id`,`product_id`,`ordering`) VALUES (14,738,126),(14,739,126),(14,740,126
1 × UPDATE `jos_session` SET `data` = '__default|a:8:{s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1\";s:15:\"session.counter\";i:6;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:7:\"product\";O:8:\"stdClass\":8:{s:12:\"filter_order\";s:10:\"a.ordering\";s:16:\"filter_order_Dir\";s:3:\"asc\";s:10:\"limitstart\";i:0;s:6:\"search\";s:0:\"\";s:10:\"list_limit\";i:20;s:11:\"filter_type\";i:0;s:9:\"filter_id\";s:2:\"13\";s:19:\"filter_product_type\";s:4:\"main\";}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"45\";s:4:\"name\";s:6:\"tester\";s:8:\"username\";s:6:\"tester\";s:5:\"email\";s:20:\"tester@tester.com\";s:8:\"password\";s:65:\"aeb80fd5ceb817019b3d47f0853d84ad:1h13OBg95PPSSbG3jvauMxR0KwR04kIS\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:12:\"registerDate\";s:19:\"2011-06-01 15:51:11\";s:13:\"lastvisitDate\";s:19:\"2011-10-05 21:57:04\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"8aff7b5f1a3bdfa80acb2f038db1c684\";s:19:\"session.timer.start\";i:1317853005;s:18:\"session.timer.last\";i:1317853038;s:17:\"session.timer.now\";i:1317853054;}', `time` = 1317853054
1 × DELETE FROM jos_hikashop_price
1 × DELETE FROM jos_hikashop_variant
1 × REPLACE INTO jos_hikashop_product (`product_weight`, `product_description`, `product_meta_description`, `product_tax_id`, `product_vendor_id`, `product_manufacturer_id`, `product_url`, `product_keywords`, `product_weight_unit`, `product_dimension_unit`, `product_width`, `product_length`, `product_height`, `product_max_per_order`, `product_name`, `product_published`, `product_code`, `product_created`, `product_modified`, `product_sale_start`, `product_sale_end`, `product_type`, `product_quantity`, `product_id`, `product_parent_id`, `product_hit`, `product_delay_id`, `product_access`, `product_group_after_purchase`, `product_min_per_order`, `product_contact`, `product_last_seen_date`, `product_sales`) VALUES ('0.000','

Options
','','0','','','','','kg','m','0.000','0.000','0.000','','Options','0','Options_copy491125618_copy1949383967','1317853054','1317853054','','','main','-1',NULL,'','','','all','','','0','',''
1 × REPLACE INTO jos_hikashop_product (`product_weight`, `product_description`, `product_meta_description`, `product_tax_id`, `product_vendor_id`, `product_manufacturer_id`, `product_url`, `product_keywords`, `product_weight_unit`, `product_dimension_unit`, `product_width`, `product_length`, `product_height`, `product_max_per_order`, `product_name`, `product_published`, `product_code`, `product_created`, `product_modified`, `product_sale_start`, `product_sale_end`, `product_type`, `product_quantity`, `product_parent_id`, `product_id`, `product_hit`, `product_delay_id`, `product_access`, `product_group_after_purchase`, `product_min_per_order`, `product_contact`, `product_last_seen_date`, `product_sales`) VALUES ('0.000','','','0','0','0','','','kg','m','0.000','0.000','0.000','0','20x30','1','Prints_8_copy1441438309_copy273767734_copy538381790','1310716938','1310717034','0','0','variant','-1','738',NULL,'0','0','all','','0','0','0','0'),('0.000','','','0','0','0','','','kg','m','0.000','0.000','0.000','0','5x7','1','Prints_7_copy770164576_copy1816155363_copy786494696','1310716938','1310717002','0','0','variant','-1','738',NULL,'0','0','all','','0','0','0','0'
1 × SHOW FULL COLUMNS FROM `jos_hikashop_product
1 × INSERT IGNORE INTO jos_hikashop_variant (`variant_characteristic_id`,`variant_product_id`) VALUES (8,738),(9,738),(8,739),(7,740

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

  • Posts: 81509
  • Thank you received: 13064
  • MODERATOR
12 years 6 months ago #26762

Hi,

Your debug looks normal, I can see the queries creating the copy of the product. I just tried a copy and an import from folder with a product template on the 1.5.4 version and it's working great.

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

  • Posts: 272
  • Thank you received: 3
12 years 6 months ago #27038

Same issue here. Business 1.5.3 and 1.5.4. I copy a product. I get the message that the product has been successfully been copied but nothing shows up in the product listings. I checked with the database product table and nothing gets added there. I have been meaning to look into this issue but I have not had time yet. Hopefully this week I can report back.

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

  • Posts: 81509
  • Thank you received: 13064
  • MODERATOR
12 years 6 months ago #27043

Ok. Let us know what you find as we are still unable to reproduce the problem on our end.

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

  • Posts: 272
  • Thank you received: 3
12 years 6 months ago #27301

Tested with the final version of Business 1.5.4 and everything is copying correctly again.

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

  • Posts: 81509
  • Thank you received: 13064
  • MODERATOR
12 years 6 months ago #27302

That's strange as we didn't change anything on that end since 1.5.3. Anyway, if it works, it's all good :)

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

  • Posts: 32
  • Thank you received: 0
12 years 3 months ago #33753

Hi!
I have 1.5.5, Business ver.
Then try to copy product, product is not copied, but is copied one from several options of this product (all options created in other category of course).
Something bad :-(

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

  • Posts: 81509
  • Thank you received: 13064
  • MODERATOR
12 years 3 months ago #33768

Hi,

Could you explain a bit more clearly the problem as I didn't understand exactly what it is ?
Could you do some screenshots maybe ?

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

  • Posts: 32
  • Thank you received: 0
12 years 3 months ago #33783

I have:
Category "Transport", with product "Car". Product "Car" has some options.
Category "Options", with options of product "Car" (and other products).
Then try to make copy of product "Car" in category "Transport", product is not copied, but is copied his option (first one) in category "Options".
Nothing to screenshoting :-)

Do you have any idea?

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

  • Posts: 81509
  • Thank you received: 13064
  • MODERATOR
12 years 3 months ago #33798

I can see that it might come from a modification we made for the export of products with options.

Could you remove the line:
if($rel->product_related_type=='options' && !in_array($rel->product_related_id,$ids)) $ids[]=$rel->product_related_id;
in the file administrator/components/com_hikashop/classes/product.php and try again ?

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

  • Posts: 32
  • Thank you received: 0
12 years 3 months ago #33821

Thank you!
With this modification, now is working!

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

  • Posts: 13
  • Thank you received: 0
12 years 3 months ago #34190

Removed that line still failing to import.

Error message

JFolder::create: Could not create directory

The folder /images/galleries/warehouse/accessories/ is not writable

Chown and Chmod are correct.

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

  • Posts: 81509
  • Thank you received: 13064
  • MODERATOR
12 years 3 months ago #34203

Your error is not related to this thread.

That error indicates that there is an access rights issue on that folder. So it must come from that...
What permissions did you set, and for which user ? Do you use the FTP layer of joomla or not ?

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

  • Posts: 13
  • Thank you received: 0
12 years 3 months ago #34252

Thanks Nicolas.

Problem solved.

FYI

do not put a forward slash in front of the images folder
/images/galleries/warehouse/accessories/

should be

images/galleries/warehouse/accessories/

Cheers

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

  • Posts: 81509
  • Thank you received: 13064
  • MODERATOR
12 years 3 months ago #34253

Ah yes, if you put a / at the beginning the system will assume that you're providing the full path to the upload folder like that: /home/user/www/images/upload/
And since that folder /images/galleries/warehouse/accessories/ does not exists, it will try to create it and won't be allowed by your server to write a new folder in the root directory and will thus display that error.

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

Time to create page: 0.096 seconds
Powered by Kunena Forum