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