Skip to main content

Coping product with options broken

More
15 years 2 days ago #25990 by Rickhavoc
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.

More
15 years 1 day ago #25996 by nicolas
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.

More
14 years 8 months ago #34248 by randam
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.
Code:
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.&nbsp; 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.&nbsp; Glass Wick Holders are available as an optional extra for this item (see below for more info).&nbsp;&nbsp; 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 &amp; 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.

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

More
14 years 8 months ago #34254 by randam
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.

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

More
14 years 8 months ago #34261 by randam
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.

More
14 years 8 months ago #34265 by randam
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.

Time to create page: 0.205 seconds
Powered by Kunena Forum