HIKASHOP ESSENTIAL 60€The basic version. With the main features for a little shop.
HIKAMARKETAdd-on Create a multivendor platform. Enable many vendors on your website.
HIKASERIALAdd-on Sale e-tickets, vouchers, gift certificates, serial numbers and more!
MARKETPLACEPlugins, modules and other kinds of integrations for HikaShop
When trying to copy a product with options from the backend it just copys the first option on the list of option and nothing else...
Please Log in or Create an account to join the conversation.
I just tried on my end and it's working. Could you try the same operation after activating the debug mode of joomla and then give the debug information at the bottom of the page when you click on the copy button for a product with options ?
Please Log in or Create an account to join the conversation.
I am having the same problem as the person who started this thread. If I try to copy a product that does not have any options, it copies perfectly. However, if I try and copy a product that DOES have an option, it does not copy, I get a message "Successfully Saved" and all that has been saved is a copy of the OPTION, not the product.
I am providing the debug info as you requested of the other person.
Profile Information
Application 0.002 seconds (+0.002); 0.84 MB (+0.844) - afterLoad
Application 0.076 seconds (+0.074); 5.83 MB (+4.991) - afterInitialise
Application 0.076 seconds (+0.000); 5.83 MB (+0.000) - afterRoute
Application 0.215 seconds (+0.139); 14.31 MB (+8.472) - afterDispatch
Application 0.223 seconds (+0.008); 14.68 MB (+0.377) - beforeRenderModule mod_submenu (Admin Submenu)
Application 0.229 seconds (+0.006); 14.73 MB (+0.049) - afterRenderModule mod_submenu (Admin Submenu)
Application 0.229 seconds (+0.000); 14.73 MB (-0.002) - beforeRenderModule mod_title (Title)
Application 0.234 seconds (+0.005); 14.74 MB (+0.010) - afterRenderModule mod_title (Title)
Application 0.235 seconds (+0.000); 14.74 MB (+0.003) - beforeRenderModule mod_toolbar (Toolbar)
Application 0.242 seconds (+0.008); 14.89 MB (+0.143) - afterRenderModule mod_toolbar (Toolbar)
Application 0.243 seconds (+0.000); 14.89 MB (-0.002) - beforeRenderModule mod_status (User Status)
Application 0.249 seconds (+0.007); 14.89 MB (+0.007) - afterRenderModule mod_status (User Status)
Application 0.249 seconds (+0.000); 14.89 MB (-0.003) - beforeRenderModule mod_menu (Admin Menu)
Application 0.307 seconds (+0.058); 15.40 MB (+0.507) - afterRenderModule mod_menu (Admin Menu)
Application 0.311 seconds (+0.004); 15.60 MB (+0.199) - afterRender
Memory Usage
15.64 MB (16,401,152 Bytes)
44 Queries Logged
SELECT `data`
FROM `jos_session`
WHERE `session_id` = 'a705c5d0a80d533a417bfa8159c2db81'
DELETE
FROM `jos_session`
WHERE `time` < 1325550413
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 = 42
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 (311)
SELECT *
FROM jos_hikashop_product
WHERE product_id IN (311,305) OR product_parent_id IN (311,305)
ORDER BY product_parent_id ASC, product_id ASC
SHOW TABLES LIKE 'jos_jf_content'
SELECT *
FROM jos_hikashop_product_category
WHERE product_id IN (305,311)
ORDER BY ordering ASC
SELECT *
FROM jos_hikashop_price
WHERE price_product_id IN (305,311)
SELECT *
FROM jos_hikashop_file
WHERE file_ref_id IN (305,311)
AND file_type IN ('product','file')
ORDER BY file_id ASC
SELECT *
FROM jos_hikashop_variant
WHERE variant_product_id IN (305,311)
ORDER BY ordering ASC
SELECT *
FROM jos_hikashop_product
WHERE product_code IN ('wick_holder_copy1799577696')
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`, `product_waitlist`)
VALUES ('0.000','<p>Transform our hand painted glass bottles into beautiful oil lamp candles by adding a glass wick holder
and wick.</p>','','11','','12','','','kg','m','0.000','0.000','0.000','','Add Wick Holder & Wick?','1','wick_holder_copy1799577696','1325551313','1325551313','','','main','-1',NULL,'','','','all','','','0','','','')
SELECT product_code, product_id
FROM jos_hikashop_product
WHERE product_code IN ('wick_holder_copy1799577696')
INSERT IGNORE INTO jos_hikashop_price (`price_value`,`price_currency_id`,`price_min_quantity`,`price_product_id`,`price_access`)
VALUES ('3.00000',2,0,324,'all')
INSERT IGNORE INTO jos_hikashop_file (`file_name`,`file_description`,`file_path`,`file_type`,`file_ref_id`)
VALUES ('Wick_holder','','il_570xn.252464861.jpg','product',324),('Wick_holder','','il_570xn.252422930.jpg','product',324),('Wick_holder','','il_570xn.252464877.jpg','product',324)
INSERT IGNORE INTO jos_hikashop_product_category (`category_id`,`product_id`,`ordering`)
VALUES (56,324,1)
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=16
AND b.product_type = 'main'
ORDER BY a.ordering asc
LIMIT 0, 100
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=16
AND b.product_type = 'main'
SELECT *
FROM jos_hikashop_price
WHERE price_product_id IN (304,306,307,308,311)
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=16
ORDER BY b.category_left
SELECT a.*
FROM jos_hikashop_category AS a
WHERE a.category_parent_id IN (1,2,14,16)
AND a.category_type IN ('product','root')
ORDER BY a.category_name ASC
LIMIT 0, 500
SHOW TABLES LIKE 'jos_jf_content'
SELECT a.*
FROM jos_hikashop_category AS a
WHERE a.category_type IN ('product','root')
ORDER BY a.category_parent_id ASC, a.category_ordering ASC
SELECT *
FROM jos_hikashop_currency
WHERE currency_id IN (2)
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 <= '2012-01-03 00:41:53')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-01-03 00:41:53')
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 = 42
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
SELECT id
FROM jos_users
WHERE username = ''
LIMIT 0, 1
UPDATE `jos_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:60;s:19:\"session.timer.start\";i:1325549619;s:18:\"session.timer.last\";i:1325551307;s:17:\"session.timer.now\";i:1325551313;s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20100101 Firefox/8.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:12:\"com_hikashop\";O:8:\"stdClass\":3:{s:7:\"zone_id\";s:4:\"4287\";s:7:\"product\";O:8:\"stdClass\":9:{s:10:\"limitstart\";i:0;s:9:\"filter_id\";s:2:\"16\";s:12:\"filter_order\";s:10:\"a.ordering\";s:16:\"filter_order_Dir\";s:3:\"asc\";s:6:\"search\";s:0:\"\";s:10:\"list_limit\";s:3:\"100\";s:11:\"filter_type\";i:0;s:19:\"filter_product_type\";s:4:\"main\";s:16:\"filter_published\";i:0;}s:23:\"product_related_options\";O:8:\"stdClass\":2:{s:10:\"limitstart\";i:0;s:9:\"filter_id\";s:2:\"56\";}}s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:14:\"Miranda Jordan\";s:8:\"username\";s:9:\"wolfadmin\";s:5:\"email\";s:22:\"miranda@randam-art.com\";s:8:\"password\";s:65:\"ae69fc3c0e9699a611712fa5f2914435:rbu2425blvozjguwvlw2xygmdxlvqeek\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-10-29 00:10:48\";s:13:\"lastvisitDate\";s:19:\"2012-01-03 00:13:21\";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:\"4fae129b864be9cc07f7ab1f9bb567db\";}__wf|a:1:{s:13:\"session.token\";s:32:\"bbda5de93868d925c066adb9c046d67d\";}hikashop_product_data|O:8:\"stdClass\":33:{s:12:\"product_name\";s:4:\"test\";s:11:\"product_url\";s:52:\"http://www.randam-art.com/showcase/art-painted-glass\";s:24:\"product_meta_description\";s:0:\"\";s:16:\"product_keywords\";s:0:\"\";s:12:\"product_code\";s:21:\"HPB2001_copy657478836\";s:14:\"product_tax_id\";s:2:\"11\";s:23:\"product_manufacturer_id\";s:2:\"12\";s:18:\"product_sale_start\";s:0:\"\";s:16:\"product_sale_end\";s:0:\"\";s:16:\"product_waitlist\";s:1:\"0\";s:16:\"product_quantity\";s:1:\"1\";s:21:\"product_min_per_order\";s:1:\"0\";s:21:\"product_max_per_order\";i:0;s:14:\"product_weight\";s:5:\"0.880\";s:19:\"product_weight_unit\";s:2:\"lb\";s:14:\"product_length\";s:5:\"0.000\";s:13:\"product_width\";s:5:\"0.000\";s:22:\"product_dimension_unit\";s:1:\"m\";s:14:\"product_height\";s:5:\"0.000\";s:17:\"product_published\";s:1:\"1\";s:14:\"product_access\";s:3:\"all\";s:28:\"product_group_after_purchase\";s:0:\"\";s:12:\"product_type\";s:4:\"main\";s:10:\"product_id\";i:322;s:10:\"categories\";a:1:{i:16;i:16;}s:7:\"related\";a:0:{}s:7:\"options\";a:1:{i:305;O:8:\"stdClass\":2:{s:18:\"product_related_id\";s:3:\"305\";s:24:\"product_related_ordering\";i:0;}}s:6:\"images\";a:0:{}s:5:\"files\";a:0:{}s:6:\"prices\";a:2:{i:0;O:8:\"stdClass\":5:{s:11:\"price_value\";s:8:\"16.99000\";s:17:\"price_currency_id\";i:2;s:18:\"price_min_quantity\";i:0;s:12:\"price_access\";s:3:\"all\";s:8:\"price_id\";i:305;}s:2:\"##\";O:8:\"stdClass\":3:{s:11:\"price_value\";d:0;s:17:\"price_currency_id\";i:2;s:18:\"price_min_quantity\";i:0;}}s:18:\"oldCharacteristics\";a:0:{}s:19:\"product_description\";s:2244:\"<p>Hand Painted glass bottle with yellow, blue
and gold colors with blue wire wrap
and a glass bauble decoration. Bottle is square at base. Cork stopper.</p>\r\n<p><em><strong>Size is approximately 5.5 inch tall x 2 inch wide.</strong></em></p>\r\n<p>Beautiful piece of art décor. Place it
on a window ledge or near any light source to catch the light through this pretty one-of-a-kind bottle. This item can be used as an oil reed diffuser or oil lamp candle by adding a Glass Wick Holder
and Wick, or Reeds
and fragrance. Glass Wick Holders are available as an optional extra for this item (see below for more info). Reeds
and fragrance is readily available
from local department stores
and supermarkets.</p>\r\n<p>Each bottle is a one of a kind, hand painted piece of art decor</p>\r\n<p><span style=\"color: #333399; font-size: 12pt;\"><strong><img style=\"margin: 10px; float: right;\" src=\"images/il_570xn.252464861.jpg\" alt=\"Glass wick Holder
and wick\" height=\"128\" width=\"186\" /><span style=\"color: #000000;\">Transform our Hand Painted Glass Bottles into Beautiful Oil Lamp Candles by Adding a Glass Wick Holder
and Wick.</span></strong></span></p>\r\n<ul>\r\n<li>1 5/8\" Long Glass Wick Holder great for use with Randam Art Original hand painted bottles.</li>\r\n<li>Flange is 3/4\" wide & 1 5/8\" long.</li>\r\n<li>Comes with 1/8\" Woven fiberglass wick.</li>\r\n<li>Length will be appropriate for the size of the bottles you wish to use the wick with.</li>\r\n</ul>\r\n<p><strong><span style=\"color: #800080;\"><br /></span></strong></p>\r\n<p><span style=\"color: #000000;\"><strong>What are Reed Diffusers
and Oil Lamp Candles?</strong></span></p>\r\n<p>Reed diffusers
and oil candles both provide an effective air freshener. These simple, yet elegant hand painted bottles are both useful,
and attractive. Add either reeds
and fragrance oil for a flameless option, or a wick holder
and wick for a refillable oil candle.</p>\r\n<p>Reed diffusers work by placing the fragrance oil
and reeds into the bottle,
where the oil travels up through the reeds
and is dispersed evenly into the surrounding air. Reed Diffusers are perfect for the office or dorm room
where candles cannot be lit. Oil candles are a cleaner alternative to basic candles.</p>\";s:16:\"product_modified\";i:1325550943;}', `time` = 1325551313
WHERE `session_id` = 'a705c5d0a80d533a417bfa8159c2db81'
35 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
3 × SELECT category_id FROM jos_hikashop_category
2 × SELECT * FROM jos_hikashop_field as a
2 × SELECT * FROM jos_hikashop_price
2 × SELECT COUNT(session_id) FROM jos_session
2 × SELECT a.* FROM jos_hikashop_category AS a
2 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jos_extensions
2 × SELECT * FROM jos_hikashop_product
1 × SELECT * FROM jos_hikashop_currency
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 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(*) FROM jos_messages
1 × SELECT id FROM jos_users
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 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 * FROM jos_hikashop_file
1 × SELECT a.id FROM jos_user_usergroup_map AS map LEFT JOIN jos_usergroups AS a ON a.id = map.group_id
1 × SELECT * FROM jos_hikashop_confi
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 folder AS type, element AS name, params FROM jos_extensions
1 × SELECT * FROM jos_hikashop_characteristic
1 × SELECT * FROM jos_hikashop_product_related AS a
1 × SELECT * FROM jos_hikashop_variant
1 × SELECT `data` FROM `jos_session`
1 × SELECT * FROM jos_hikashop_product_category
1 × SELECT product_code, product_id FROM jos_hikashop_product
OTHER Tables:
2 × SHOW TABLES LIKE 'jos_jf_content
1 × INSERT IGNORE INTO jos_hikashop_product_category (`category_id`,`product_id`,`ordering`) VALUES (56,324,1
1 × UPDATE `jos_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:60;s:19:\"session.timer.start\";i:1325549619;s:18:\"session.timer.last\";i:1325551307;s:17:\"session.timer.now\";i:1325551313;s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20100101 Firefox/8.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:12:\"com_hikashop\";O:8:\"stdClass\":3:{s:7:\"zone_id\";s:4:\"4287\";s:7:\"product\";O:8:\"stdClass\":9:{s:10:\"limitstart\";i:0;s:9:\"filter_id\";s:2:\"16\";s:12:\"filter_order\";s:10:\"a.ordering\";s:16:\"filter_order_Dir\";s:3:\"asc\";s:6:\"search\";s:0:\"\";s:10:\"list_limit\";s:3:\"100\";s:11:\"filter_type\";i:0;s:19:\"filter_product_type\";s:4:\"main\";s:16:\"filter_published\";i:0;}s:23:\"product_related_options\";O:8:\"stdClass\":2:{s:10:\"limitstart\";i:0;s:9:\"filter_id\";s:2:\"56\";}}s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:14:\"Miranda Jordan\";s:8:\"username\";s:9:\"wolfadmin\";s:5:\"email\";s:22:\"miranda@randam-art.com\";s:8:\"password\";s:65:\"ae69fc3c0e9699a611712fa5f2914435:rbu2425blvozjguwvlw2xygmdxlvqeek\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-10-29 00:10:48\";s:13:\"lastvisitDate\";s:19:\"2012-01-03 00:13:21\";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:\"4fae129b864be9cc07f7ab1f9bb567db\";}__wf|a:1:{s:13:\"session.token\";s:32:\"bbda5de93868d925c066adb9c046d67d\";}hikashop_product_data|O:8:\"stdClass\":33:{s:12:\"product_name\";s:4:\"test\";s:11:\"product_url\";s:52:\"http://www.randam-art.com/showcase/art-painted-glass\";s:24:\"product_meta_description\";s:0:\"\";s:16:\"product_keywords\";s:0:\"\";s:12:\"product_code\";s:21:\"HPB2001_copy657478836\";s:14:\"product_tax_id\";s:2:\"11\";s:23:\"product_manufacturer_id\";s:2:\"12\";s:18:\"product_sale_start\";s:0:\"\";s:16:\"product_sale_end\";s:0:\"\";s:16:\"product_waitlist\";s:1:\"0\";s:16:\"product_quantity\";s:1:\"1\";s:21:\"product_min_per_order\";s:1:\"0\";s:21:\"product_max_per_order\";i:0;s:14:\"product_weight\";s:5:\"0.880\";s:19:\"product_weight_unit\";s:2:\"lb\";s:14:\"product_length\";s:5:\"0.000\";s:13:\"product_width\";s:5:\"0.000\";s:22:\"product_dimension_unit\";s:1:\"m\";s:14:\"product_height\";s:5:\"0.000\";s:17:\"product_published\";s:1:\"1\";s:14:\"product_access\";s:3:\"all\";s:28:\"product_group_after_purchase\";s:0:\"\";s:12:\"product_type\";s:4:\"main\";s:10:\"product_id\";i:322;s:10:\"categories\";a:1:{i:16;i:16;}s:7:\"related\";a:0:{}s:7:\"options\";a:1:{i:305;O:8:\"stdClass\":2:{s:18:\"product_related_id\";s:3:\"305\";s:24:\"product_related_ordering\";i:0;}}s:6:\"images\";a:0:{}s:5:\"files\";a:0:{}s:6:\"prices\";a:2:{i:0;O:8:\"stdClass\":5:{s:11:\"price_value\";s:8:\"16.99000\";s:17:\"price_currency_id\";i:2;s:18:\"price_min_quantity\";i:0;s:12:\"price_access\";s:3:\"all\";s:8:\"price_id\";i:305;}s:2:\"##\";O:8:\"stdClass\":3:{s:11:\"price_value\";d:0;s:17:\"price_currency_id\";i:2;s:18:\"price_min_quantity\";i:0;}}s:18:\"oldCharacteristics\";a:0:{}s:19:\"product_description\";s:2244:\"
Hand Painted glass bottle with yellow, blue and gold colors with blue wire wrap and a glass bauble decoration. Bottle is square at base. Cork stopper.
\r\n
Size is approximately 5.5 inch tall x 2 inch wide.
\r\n
Beautiful piece of art décor. Place it on a window ledge or near any light source to catch the light through this pretty one-of-a-kind bottle. This item can be used as an oil reed diffuser or oil lamp candle by adding a Glass Wick Holder and Wick, or Reeds and fragrance. Glass Wick Holders are available as an optional extra for this item (see below for more info). Reeds and fragrance is readily available from local department stores and supermarkets.
\r\n
Each bottle is a one of a kind, hand painted piece of art decor
\r\n
\"GlassTransform our Hand Painted Glass Bottles into Beautiful Oil Lamp Candles by Adding a Glass Wick Holder and Wick.
\r\n
\r\n
1 5/8\" Long Glass Wick Holder great for use with Randam Art Original hand painted bottles.
\r\n
Flange is 3/4\" wide & 1 5/8\" long.
\r\n
Comes with 1/8\" Woven fiberglass wick.
\r\n
Length will be appropriate for the size of the bottles you wish to use the wick with.
\r\n\r\n
\r\n
What are Reed Diffusers and Oil Lamp Candles?
\r\n
Reed diffusers and oil candles both provide an effective air freshener. These simple, yet elegant hand painted bottles are both useful, and attractive. Add either reeds and fragrance oil for a flameless option, or a wick holder and wick for a refillable oil candle.
\r\n
Reed diffusers work by placing the fragrance oil and reeds into the bottle,
1 × INSERT IGNORE INTO jos_hikashop_file (`file_name`,`file_description`,`file_path`,`file_type`,`file_ref_id`) VALUES ('Wick_holder','','il_570xn.252464861.jpg','product',324),('Wick_holder','','il_570xn.252422930.jpg','product',324),('Wick_holder','','il_570xn.252464877.jpg','product',324
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`, `product_waitlist`) VALUES ('0.000','
Transform our hand painted glass bottles into beautiful oil lamp candles by adding a glass wick holder and wick.
','','11','','12','','','kg','m','0.000','0.000','0.000','','Add Wick Holder & Wick?','1','wick_holder_copy1799577696','1325551313','1325551313','','','main','-1',NULL,'','','','all','','','0','','',''
1 × SHOW FULL COLUMNS FROM `jos_hikashop_product
1 × DELETE FROM `jos_session`
1 × INSERT IGNORE INTO jos_hikashop_price (`price_value`,`price_currency_id`,`price_min_quantity`,`price_product_id`,`price_access`) VALUES ('3.00000',2,0,324,'all'Please Log in or Create an account to join the conversation.
It sounds like you have the same problem as on this thread:
www.hikashop.com/en/support/forum/3-bug-...-template.html#33798
The solution proposed there should solve your problem.
Please Log in or Create an account to join the conversation.
I found that threat first, and already tried it. It didn't work, which is why I kept looking for an answer - then I found this thread. 
Please Log in or Create an account to join the conversation.
Looking at your debug, you have the same problem as on the other thread and thus the solution is the same.
Maybe you didn't do the modification properly. Please double check it.
Please Log in or Create an account to join the conversation.
I tried it 3 times before I even posted in this topic. If I am doing something wrong, I can't imagine what it is.
I will try it one more time and see.
Please Log in or Create an account to join the conversation.
I figured out what was wrong. The fix WAS correct - but I was making the change in notepad and then dropping it into my file on the server. For some reason, when I saved the file it was adding spaces where it *thought* there should have been line breaks in the notepad document. So, I found the line and removed it directly from the file on the server, saved that file and - then it worked.
Thank you for your assistance. 
Please Log in or Create an account to join the conversation.
