Coping product with options broken

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

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.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
12 years 6 months ago #25996

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.

  • Posts: 10
  • Thank you received: 0
12 years 2 months ago #34248

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.&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.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
12 years 2 months ago #34250

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.

  • Posts: 10
  • Thank you received: 0
12 years 2 months ago #34254

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.

  • Posts: 81361
  • Thank you received: 13037
  • MODERATOR
12 years 2 months ago #34256

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.

  • Posts: 10
  • Thank you received: 0
12 years 2 months ago #34261

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.

  • Posts: 10
  • Thank you received: 0
12 years 2 months ago #34265

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.077 seconds
Powered by Kunena Forum