Custom user fields don't save

zaratustra27
Topic Author
Offline

13 years 4 months ago #102980 by zaratustra27

Custom user fields don't save was created by zaratustra27

Hi,

I want to create some custom fields for users in Hikashop, the fields were created correctly but when I want to update a profile, it is saved but fields values are not stored at all

The respective column in the DB table is created correctly but no value is stored there.

I'm using HS 2.1.2 business and Joomla 3.1.1 and attach a field settings screen

What am I doing wrong?

Thanks for your help

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

nicolas
Away

13 years 4 months ago #103037 by nicolas

Replied by nicolas on topic Custom user fields don't save

Hi,

We'll need more information.

Can you make sure that the user synchronization plugin of HikaShop is published ?
Could you please turn on the debug mode of the joomla configuration and try again ? Do you get an error message at that point when you save the data ?
If not, could you provide all the queries which are displayed at the bottom of the page after the save ?

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

zaratustra27
Topic Author
Offline

13 years 4 months ago - 13 years 4 months ago #103141 by zaratustra27

Replied by zaratustra27 on topic Custom user fields don't save

User synchronization plugin is on

I also have Community BUilder installed but I am not using it. However, I will

I turned debuggin on and got this when edit profile page (index.php?option=com_users&view=profile&layout=edit) loads:

Code:

Notice: Undefined property: stdClass::$customtext_128_17_09_22 in /home/content/78/9160378/html/_sites/bmi/plugins/system/hikashopuser/hikashopuser.php on line 216 (I created a custom text field without naming it)

These are the queries after saving:

Code:

82 Queries Logged

    SELECT `data`
      FROM `ti5v2_session`
      WHERE `session_id` = 'hlb60obbidflmua9t7jf1hpcs7'
    DELETE
      FROM `ti5v2_session`
      WHERE `time` < '1368143851'
    SELECT folder AS type, element AS name, params
      FROM ti5v2_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1,2,3,6,7,8,9,10)
      ORDER BY ordering
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM ti5v2_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
      FROM ti5v2_menu AS m
      LEFT JOIN ti5v2_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    SELECT id, home, template, s.params
      FROM ti5v2_template_styles as s
      LEFT JOIN ti5v2_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    SELECT *
      FROM ti5v2_hikashop_config
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM ti5v2_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_k2'
    SELECT *
      FROM ti5v2_languages
      WHERE published=1
      ORDER BY ordering ASC
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM ti5v2_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_menus'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM ti5v2_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_rereplacer'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM ti5v2_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
    SHOW FULL COLUMNS
      FROM `ti5v2_users`
    SELECT *
      FROM `ti5v2_users`
      WHERE `id` = 717
    SELECT `g`.`id`,`g`.`title`
      FROM `ti5v2_usergroups` AS g
      INNER JOIN `ti5v2_user_usergroup_map` AS m
      ON m.group_id = g.id
      WHERE `m`.`user_id` = 717
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM ti5v2_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
    SELECT `m`.`tag_id`,`t`.*
      FROM `ti5v2_contentitem_tag_map` AS m
      INNER JOIN `ti5v2_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_users.user.'
      AND `m`.`content_item_id` = 717
      AND `t`.`published` = 1
      AND t.access IN (1,1,2,3,6,7,8,9,10)
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM ti5v2_modules AS m
      LEFT JOIN ti5v2_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN ti5v2_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 <= '2013-05-10 00:12:31')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-05-10 00:12:31')
      AND m.access IN (1,1,2,3,6,7,8,9,10)
      AND m.client_id = 0
      AND (mm.menuid = 0 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    SELECT *
      FROM ti5v2_hikashop_address
      WHERE address_id = '765'
      LIMIT 1
    SELECT *
      FROM ti5v2_hikashop_zone
      WHERE zone_namekey = 'tax_OutsideNewYork_391917487'
      LIMIT 1
    SELECT currency_id
      FROM ti5v2_hikashop_currency
      WHERE currency_published=1 OR currency_id = 2
    SELECT *
      FROM ti5v2_hikashop_address
      WHERE address_id = '765'
      LIMIT 1
    SELECT *
      FROM ti5v2_hikashop_address
      WHERE address_id = '765'
      LIMIT 1
    SELECT a.*
      FROM ti5v2_hikashop_cart AS a
      WHERE (a.user_id = 717 OR a.session_id = 'hlb60obbidflmua9t7jf1hpcs7')
      AND a.cart_type = 'cart'
      ORDER BY a.cart_modified DESC
      LIMIT 1
    SELECT a.id
      FROM ti5v2_user_usergroup_map AS map
      LEFT JOIN ti5v2_usergroups AS a
      ON a.id = map.group_id
      WHERE map.user_id = 717
    SELECT b.*,c.*
      FROM ti5v2_hikashop_cart_product AS b
      LEFT JOIN ti5v2_hikashop_product AS c
      ON b.product_id=c.product_id
      WHERE b.cart_id = 715
      AND b.product_id > 0
      AND (c.product_access = 'all' OR c.product_access LIKE '%,8,%')
      ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
    SELECT *
      FROM ti5v2_hikashop_file
      WHERE file_ref_id IN (2,14,4)
      AND file_type IN( 'product','file')
      ORDER BY file_ref_id ASC, file_ordering ASC
    SELECT a.*,b.*
      FROM ti5v2_hikashop_variant AS a
      LEFT JOIN ti5v2_hikashop_characteristic AS b
      ON a.variant_characteristic_id=b.characteristic_id
      WHERE a.variant_product_id IN (2,14,4)
      ORDER BY a.ordering,b.characteristic_value
    SELECT *
      FROM ti5v2_hikashop_price
      WHERE price_currency_id IN (2)
      AND price_product_id IN (2,14,4)
      AND (price_access = 'all' OR price_access LIKE '%,8,%')
      ORDER BY price_value DESC
    SELECT *
      FROM ti5v2_hikashop_currency
      WHERE currency_id IN (2)
    SELECT *
      FROM ti5v2_hikashop_discount
      WHERE discount_type='discount'
      AND discount_published=1
      AND ( discount_quota>discount_used_times OR discount_quota=0 )
      AND discount_start < 1368144751
      AND ( discount_end > 1368144751 OR discount_end = 0 )
      AND ( discount_product_id IN (2,14,4) OR discount_product_id=0 )
      AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
      AND (discount_access = 'all' OR discount_access LIKE '%,8,%')
    SELECT *
      FROM ti5v2_hikashop_file
      WHERE file_ref_id IN (2,14,4)
      AND file_type='product'
      ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
    SELECT category_id
      FROM ti5v2_hikashop_product_category
      WHERE product_id=2
      ORDER BY ordering ASC
    SELECT b.*
      FROM ti5v2_hikashop_category AS a
      LEFT JOIN ti5v2_hikashop_category AS b
      ON a.category_left >= b.category_left
      WHERE b.category_right >= a.category_right
      AND a.category_id IN (15)
      GROUP BY b.category_id
      ORDER BY b.category_left
    SELECT *
      FROM ti5v2_hikashop_field as a
      WHERE a.`field_published` = 1
      AND a.`field_frontcomp` = 1
      AND a.field_table='product'
      AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%')
      AND ((field_with_sub_categories=0
      AND (field_categories="all" OR field_categories LIKE '%,15,%'))OR (field_with_sub_categories=1
      AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,15,%')))
      ORDER BY a.`field_ordering` ASC
    SELECT a.*
      FROM ti5v2_hikashop_cart AS a
      WHERE (a.cart_id = 715)
      AND a.cart_type = 'cart'
      ORDER BY a.cart_modified DESC
      LIMIT 1
    SELECT category_id, product_id
      FROM ti5v2_hikashop_product_category
      WHERE product_id IN (14,2,4);
    SELECT count(*)
      FROM ti5v2_hikashop_limit AS a
      WHERE (a.limit_published = 1
      AND (limit_start = 0 OR limit_start >= 1368144751)
      AND (limit_end = 0 OR limit_end <= 1368144751)
      AND (a.limit_product_id IN (14) OR limit_category_id IN (14,15,15))
      AND (a.limit_access = 'all' OR a.limit_access LIKE '%,8,%'));
    SELECT category_id, product_id
      FROM ti5v2_hikashop_product_category
      WHERE product_id IN (4,2,14);
    SELECT count(*)
      FROM ti5v2_hikashop_limit AS a
      WHERE (a.limit_published = 1
      AND (limit_start = 0 OR limit_start >= 1368144751)
      AND (limit_end = 0 OR limit_end <= 1368144751)
      AND (a.limit_product_id IN (4,2) OR limit_category_id IN (15,15))
      AND (a.limit_access = 'all' OR a.limit_access LIKE '%,8,%'));
    SELECT *
      FROM ti5v2_hikashop_product
      WHERE product_id = '2'
      LIMIT 1
    SELECT *
      FROM ti5v2_hikashop_discount
      WHERE discount_type='coupon'
      AND discount_published=1
      AND discount_auto_load=1
      AND (discount_access = 'all' OR discount_access LIKE '%,8,%')
      ORDER BY discount_minimum_order DESC, discount_minimum_products DESC
    SELECT *
      FROM ti5v2_hikashop_address
      WHERE address_id = '765'
      LIMIT 1
    SELECT *
      FROM ti5v2_hikashop_field as a
      WHERE a.`field_published` = 1
      AND a.`field_frontcomp` = 1
      AND a.field_table='address'
      AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%')
      ORDER BY a.`field_ordering` ASC
    SELECT a.*
      FROM ti5v2_hikashop_zone_link AS a
      WHERE a.zone_child_namekey IN ('tax_OutsideNewYork_391917487','country_United_States_of_America_223');
    SELECT a.*
      FROM ti5v2_hikashop_zone_link AS a
      WHERE a.zone_child_namekey IN ('state_Florida_4270');
    SELECT a.*
      FROM ti5v2_hikashop_zone_link AS a
      WHERE a.zone_child_namekey IN ('country_United_States_of_America_223');
    SELECT a.*,b.*
      FROM ti5v2_hikashop_variant AS a
      LEFT JOIN ti5v2_hikashop_characteristic AS b
      ON a.variant_characteristic_id=b.characteristic_id
      WHERE a.variant_product_id IN (2,14,4)
      ORDER BY a.ordering ASC,b.characteristic_value ASC
    SELECT *
      FROM ti5v2_hikashop_price
      WHERE price_currency_id IN (2)
      AND price_product_id IN (2,14,4)
      AND (price_access = 'all' OR price_access LIKE '%,8,%')
      ORDER BY price_value DESC
    SELECT *
      FROM ti5v2_hikashop_discount
      WHERE discount_type='discount'
      AND discount_published=1
      AND ( discount_quota>discount_used_times OR discount_quota=0 )
      AND discount_start < 1368144751
      AND ( discount_end > 1368144751 OR discount_end = 0 )
      AND ( discount_product_id IN (2,14,4) OR discount_product_id=0 )
      AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
      AND (discount_access = 'all' OR discount_access LIKE '%,8,%')
    SELECT *
      FROM ti5v2_hikashop_field as a
      WHERE a.`field_published` = 1
      AND a.`field_frontcomp` = 1
      AND a.field_table='item'
      AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%')
      ORDER BY a.`field_ordering` ASC
    SELECT c.*, u.*
      FROM ti5v2_users AS u
      LEFT JOIN ti5v2_comprofiler AS c
      ON c.id = u.id
      WHERE u.id = 717
    SELECT id
      FROM ti5v2_menu
      WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
      AND published = 1
      AND access IN (1,2,3,6,7,8,9,10)
      AND `language` IN ( 'en-GB', '*', '' )
    SELECT i.*,
      CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
      FROM ti5v2_k2_items as i RIGHT JOIN ti5v2_k2_categories c
      ON c.id = i.catid
      WHERE i.published = 1
      AND i.access IN(1,1,2,3,6,7,8,9,10)
      AND i.trash = 0
      AND c.published = 1
      AND c.access IN(1,1,2,3,6,7,8,9,10)
      AND c.trash = 0
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2013-05-10 00:12:31' )
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2013-05-10 00:12:31' )
      AND i.catid IN(2)
      ORDER BY i.id DESC
      LIMIT 0, 5
    SELECT extraFieldsGroup
      FROM ti5v2_k2_categories
      WHERE id=2
    SELECT *
      FROM ti5v2_k2_extra_fields
      WHERE `
      group` = 1
      AND published=1
      AND (id IN (1,3,4) OR `type` = 'header')
      ORDER BY ordering ASC
    SELECT r.*
      FROM ti5v2_rereplacer AS r
      WHERE r.published = 1
      AND (r.area = 'articles')
      ORDER BY r.ordering, r.id
    SELECT extraFieldsGroup
      FROM ti5v2_k2_categories
      WHERE id=2
    SELECT *
      FROM ti5v2_k2_extra_fields
      WHERE `
      group` = 1
      AND published=1
      AND (id IN (1,3,4) OR `type` = 'header')
      ORDER BY ordering ASC
    SELECT extraFieldsGroup
      FROM ti5v2_k2_categories
      WHERE id=2
    SELECT *
      FROM ti5v2_k2_extra_fields
      WHERE `
      group` = 1
      AND published=1
      AND (id IN (1,3,4) OR `type` = 'header')
      ORDER BY ordering ASC
    SELECT extraFieldsGroup
      FROM ti5v2_k2_categories
      WHERE id=2
    SELECT *
      FROM ti5v2_k2_extra_fields
      WHERE `
      group` = 1
      AND published=1
      AND (id IN (1,3,4) OR `type` = 'header')
      ORDER BY ordering ASC
    SELECT extraFieldsGroup
      FROM ti5v2_k2_categories
      WHERE id=2
    SELECT *
      FROM ti5v2_k2_extra_fields
      WHERE `
      group` = 1
      AND published=1
      AND (id IN (1,3,4) OR `type` = 'header')
      ORDER BY ordering ASC
    SELECT DISTINCT MONTH(created) as m, YEAR(created) as y
      FROM ti5v2_k2_items
      WHERE published=1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-10 00:12:31' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-10 00:12:31' )
      AND trash=0
      AND access IN(1,1,2,3,6,7,8,9,10)
      ORDER BY created DESC
      LIMIT 0, 12
    SELECT COUNT(*)
      FROM ti5v2_k2_items
      WHERE MONTH(created)=4
      AND YEAR(created)=2013
      AND published=1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-10 00:12:31' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-10 00:12:31' )
      AND trash=0
      AND access IN(1,1,2,3,6,7,8,9,10)
    SELECT COUNT(*)
      FROM ti5v2_k2_items
      WHERE MONTH(created)=3
      AND YEAR(created)=2013
      AND published=1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-10 00:12:31' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-10 00:12:31' )
      AND trash=0
      AND access IN(1,1,2,3,6,7,8,9,10)
    SELECT COUNT(*)
      FROM ti5v2_k2_items
      WHERE MONTH(created)=2
      AND YEAR(created)=2013
      AND published=1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-10 00:12:31' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-10 00:12:31' )
      AND trash=0
      AND access IN(1,1,2,3,6,7,8,9,10)
    SELECT COUNT(*)
      FROM ti5v2_k2_items
      WHERE MONTH(created)=1
      AND YEAR(created)=2013
      AND published=1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-10 00:12:31' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-10 00:12:31' )
      AND trash=0
      AND access IN(1,1,2,3,6,7,8,9,10)
    SELECT COUNT(*)
      FROM ti5v2_k2_items
      WHERE MONTH(created)=12
      AND YEAR(created)=2012
      AND published=1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-10 00:12:31' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-10 00:12:31' )
      AND trash=0
      AND access IN(1,1,2,3,6,7,8,9,10)
    SELECT COUNT(*)
      FROM ti5v2_k2_items
      WHERE MONTH(created)=11
      AND YEAR(created)=2012
      AND published=1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-10 00:12:31' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-10 00:12:31' )
      AND trash=0
      AND access IN(1,1,2,3,6,7,8,9,10)
    SELECT COUNT(*)
      FROM ti5v2_k2_items
      WHERE MONTH(created)=10
      AND YEAR(created)=2012
      AND published=1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-10 00:12:31' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-10 00:12:31' )
      AND trash=0
      AND access IN(1,1,2,3,6,7,8,9,10)
    SELECT COUNT(*)
      FROM ti5v2_k2_items
      WHERE MONTH(created)=9
      AND YEAR(created)=2012
      AND published=1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-10 00:12:31' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-10 00:12:31' )
      AND trash=0
      AND access IN(1,1,2,3,6,7,8,9,10)
    SELECT COUNT(*)
      FROM ti5v2_k2_items
      WHERE MONTH(created)=8
      AND YEAR(created)=2012
      AND published=1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-10 00:12:31' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-10 00:12:31' )
      AND trash=0
      AND access IN(1,1,2,3,6,7,8,9,10)
    SELECT COUNT(*)
      FROM ti5v2_k2_items
      WHERE MONTH(created)=7
      AND YEAR(created)=2012
      AND published=1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-10 00:12:31' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-10 00:12:31' )
      AND trash=0
      AND access IN(1,1,2,3,6,7,8,9,10)
    SELECT COUNT(*)
      FROM ti5v2_k2_items
      WHERE MONTH(created)=6
      AND YEAR(created)=2012
      AND published=1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-10 00:12:31' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-10 00:12:31' )
      AND trash=0
      AND access IN(1,1,2,3,6,7,8,9,10)
    SELECT COUNT(*)
      FROM ti5v2_k2_items
      WHERE MONTH(created)=5
      AND YEAR(created)=2012
      AND published=1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-10 00:12:31' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-10 00:12:31' )
      AND trash=0
      AND access IN(1,1,2,3,6,7,8,9,10)
    SELECT r.*
      FROM ti5v2_rereplacer AS r
      WHERE r.published = 1
      AND (r.area = 'component')
      ORDER BY r.ordering, r.id
    SELECT r.*
      FROM ti5v2_rereplacer AS r
      WHERE r.published = 1
      AND (r.area = 'body')
      ORDER BY r.ordering, r.id
    SELECT r.*
      FROM ti5v2_rereplacer AS r
      WHERE r.published = 1
      AND (r.area = 'everywhere')
      ORDER BY r.ordering, r.id
    UPDATE `ti5v2_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:55;s:19:\"session.timer.start\";i:1368087820;s:18:\"session.timer.last\";i:1368144750;s:17:\"session.timer.now\";i:1368144751;s:22:\"session.client.browser\";s:65:\"Mozilla/5.0 (Windows NT 6.1; rv:20.0) Gecko/20100101 Firefox/20.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":3:{s:12:\"com_hikashop\";O:8:\"stdClass\":4:{s:7:\"zone_id\";s:4:\"4506\";s:16:\"shipping_address\";s:3:\"765\";s:15:\"billing_address\";s:3:\"765\";s:12:\"ssl_redirect\";i:0;}s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":2:{s:6:\"return\";s:57:\"index.php?option=com_content&view=article&id=26&Itemid=66\";s:4:\"data\";a:0:{}}}}s:9:\"com_users\";O:8:\"stdClass\":1:{s:4:\"edit\";O:8:\"stdClass\":1:{s:7:\"profile\";O:8:\"stdClass\":2:{s:2:\"id\";N;s:4:\"data\";N;}}}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"717\";s:4:\"name\";s:14:\"Elance Project\";s:8:\"username\";s:6:\"elance\";s:5:\"email\";s:18:\"bmiexpress@aol.com\";s:8:\"password\";s:65:\"6427f232dab82750de580f9b98129702:xdv2F6baODzUTHeXW71srw2q3rvx8SyR\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:12:\"registerDate\";s:19:\"2013-04-05 20:52:10\";s:13:\"lastvisitDate\";s:19:\"2013-05-09 08:23:40\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\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\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:9:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:6;i:5;i:7;i:6;i:8;i:7;i:9;i:8;i:10;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"3314398b406ba2f656d747019667089e\";}' , `time` = '1368144757'
      WHERE `session_id` = 'hlb60obbidflmua9t7jf1hpcs7'

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

    12 × SELECT COUNT(*)
      FROM ti5v2_k2_items
    6 × SELECT extension_id AS id, element AS "option", params, enabled
      FROM ti5v2_extensions
    5 × SELECT extraFieldsGroup
      FROM ti5v2_k2_categories
    5 × SELECT *
      FROM ti5v2_k2_extra_fields
    4 × SELECT *
      FROM ti5v2_hikashop_address
    4 × SELECT r.*
      FROM ti5v2_rereplacer AS r
    3 × SELECT *
      FROM ti5v2_hikashop_discount
    3 × SELECT *
      FROM ti5v2_hikashop_field as a
    3 × SELECT a.*
      FROM ti5v2_hikashop_zone_link AS a
    2 × SELECT *
      FROM ti5v2_hikashop_file
    2 × SELECT *
      FROM ti5v2_hikashop_price
    2 × SELECT a.*
      FROM ti5v2_hikashop_cart AS a
    2 × SELECT count(*)
      FROM ti5v2_hikashop_limit AS a
    2 × SELECT category_id, product_id
      FROM ti5v2_hikashop_product_category
    2 × SELECT a.*,b.*
      FROM ti5v2_hikashop_variant AS a
      LEFT JOIN ti5v2_hikashop_characteristic AS b
      ON a.variant_characteristic_id=b.characteristic_id
    1 × SELECT id
      FROM ti5v2_menu
    1 × SELECT c.*, u.*
      FROM ti5v2_users AS u
      LEFT JOIN ti5v2_comprofiler AS c
      ON c.id = u.id
    1 × SELECT *
      FROM ti5v2_languages
    1 × SELECT *
      FROM ti5v2_hikashop_product
    1 × SELECT i.*,
      CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
      FROM ti5v2_k2_items as i RIGHT JOIN ti5v2_k2_categories c
      ON c.id = i.catid
    1 × SELECT *
      FROM ti5v2_hikashop_confi
    1 × SELECT folder AS type, element AS name, params
      FROM ti5v2_extensions
    1 × SELECT DISTINCT MONTH(created) as m, YEAR(created) as y
      FROM ti5v2_k2_items
    1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
      FROM ti5v2_menu AS m
      LEFT JOIN ti5v2_extensions AS e
      ON m.component_id = e.extension_id
    1 × SELECT id, home, template, s.params
      FROM ti5v2_template_styles as s
      LEFT JOIN ti5v2_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
    1 × SELECT *
      FROM `ti5v2_users`
    1 × SELECT `g`.`id`,`g`.`title`
      FROM `ti5v2_usergroups` AS g
      INNER JOIN `ti5v2_user_usergroup_map` AS m
      ON m.group_id = g.id
    1 × SELECT *
      FROM ti5v2_hikashop_zone
    1 × SELECT `data`
      FROM `ti5v2_session`
    1 × SELECT currency_id
      FROM ti5v2_hikashop_currency
    1 × SELECT b.*,c.*
      FROM ti5v2_hikashop_cart_product AS b
      LEFT JOIN ti5v2_hikashop_product AS c
      ON b.product_id=c.product_id
    1 × SELECT *
      FROM ti5v2_hikashop_currency
    1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM ti5v2_modules AS m
      LEFT JOIN ti5v2_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN ti5v2_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
    1 × SELECT `m`.`tag_id`,`t`.*
      FROM `ti5v2_contentitem_tag_map` AS m
      INNER JOIN `ti5v2_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
    1 × SELECT b.*
      FROM ti5v2_hikashop_category AS a
      LEFT JOIN ti5v2_hikashop_category AS b
      ON a.category_left >= b.category_left
    1 × SELECT category_id
      FROM ti5v2_hikashop_product_category
    1 × SELECT a.id
      FROM ti5v2_user_usergroup_map AS map
      LEFT JOIN ti5v2_usergroups AS a
      ON a.id = map.group_id

OTHER Tables:

    1 × UPDATE `ti5v2_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:55;s:19:\"session.timer.start\";i:1368087820;s:18:\"session.timer.last\";i:1368144750;s:17:\"session.timer.now\";i:1368144751;s:22:\"session.client.browser\";s:65:\"Mozilla/5.0 (Windows NT 6.1; rv:20.0) Gecko/20100101 Firefox/20.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":3:{s:12:\"com_hikashop\";O:8:\"stdClass\":4:{s:7:\"zone_id\";s:4:\"4506\";s:16:\"shipping_address\";s:3:\"765\";s:15:\"billing_address\";s:3:\"765\";s:12:\"ssl_redirect\";i:0;}s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":2:{s:6:\"return\";s:57:\"index.php?option=com_content&view=article&id=26&Itemid=66\";s:4:\"data\";a:0:{}}}}s:9:\"com_users\";O:8:\"stdClass\":1:{s:4:\"edit\";O:8:\"stdClass\":1:{s:7:\"profile\";O:8:\"stdClass\":2:{s:2:\"id\";N;s:4:\"data\";N;}}}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"717\";s:4:\"name\";s:14:\"Elance Project\";s:8:\"username\";s:6:\"elance\";s:5:\"email\";s:18:\"bmiexpress@aol.com\";s:8:\"password\";s:65:\"6427f232dab82750de580f9b98129702:xdv2F6baODzUTHeXW71srw2q3rvx8SyR\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:12:\"registerDate\";s:19:\"2013-04-05 20:52:10\";s:13:\"lastvisitDate\";s:19:\"2013-05-09 08:23:40\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\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\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:9:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:6;i:5;i:7;i:6;i:8;i:7;i:9;i:8;i:10;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"3314398b406ba2f656d747019667089e\";}' , `time` = '1368144757'
    1 × SHOW FULL COLUMNS
      FROM `ti5v2_users
    1 × DELETE
      FROM `ti5v2_session`

I removed the custom text field and Notice message dissapeared but saving error continues

Thank you!

Last edit: 13 years 4 months ago by Jerome.

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

nicolas
Away

13 years 4 months ago #103159 by nicolas

Replied by nicolas on topic Custom user fields don't save

Hi,

Can you give a link to a profile page with a test user account with the issue so that we can see the problem please ?

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

zaratustra27
Topic Author
Offline

13 years 4 months ago #103161 by zaratustra27

Replied by zaratustra27 on topic Custom user fields don't save

Just sent the info you asked

It's a registered lvl account. Do you need higher access?

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

nicolas
Away

13 years 4 months ago #103261 by nicolas

Replied by nicolas on topic Custom user fields don't save

That's fine thanks !

Can you change the line:
$formData = JRequest::getVar('user', array(), '', 'array');

to:
$formData = JRequest::getVar('data', array(), '', 'array');

in the file plugins/system/hikashopuser/hikashopuser.php and try again ?

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

zaratustra27
Topic Author
Offline

13 years 4 months ago - 13 years 4 months ago #103457 by zaratustra27

Replied by zaratustra27 on topic Custom user fields don't save

I'm sorry, it didn't work. I repeat messages below:

When loading edit user page:

Notice: Undefined property: stdClass::$customtext_128_17_09_22 in /home/content/78/9160378/html/_sites/bmi/plugins/system/hikashopuser/hikashopuser.php on line 216

After saving changes:

SQL queries removed by a moderator
There was no "UPDATE" on the hikashop_table. No relevant data.

Thanks for your efforts,

Last edit: 13 years 4 months ago by Jerome.

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

Jerome
Offline
HikaShop core developer

13 years 4 months ago #103461 by Jerome

Replied by Jerome on topic Custom user fields don't save

Hi,

I just tried to patch and the problem is fixed on my side.
Without the patch, the data was not stored. With the patch, data is stored correctly.

Please be sure that you do not have warning message like "password mismatch" during saving.
If you have a joomla message, it has to effect to do not call the triggers so HikaShop can't load and store data.

About the custom text problem, you can replace the line

Code:

$data .= $fieldsClass->display($oneExtraField,$user->$fieldName,'data[user]['.$fieldName.']',false,' '.$onWhat.'="hikashopToggleFields(this.value,\''.$fieldName.'\',\'user\',0);"');

By:

Code:

$data .= $fieldsClass->display($oneExtraField,@$user->$fieldName,'data[user]['.$fieldName.']',false,' '.$onWhat.'="hikashopToggleFields(this.value,\''.$fieldName.'\',\'user\',0);"');

It will remove the notice.

Please use "[ quote ]" or "[ code ]" tags for big log data, it makes the forum more readable.

Thanks !

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

The following user(s) said Thank You: zaratustra27

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

zaratustra27
Topic Author
Offline

13 years 4 months ago #103465 by zaratustra27

Replied by zaratustra27 on topic Custom user fields don't save

Thanks, you were right, I forgot to update psswd too, but form didn't force me to do it. Is there a way to make psswd field mandatory in this form?

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

Jerome
Offline
HikaShop core developer

13 years 4 months ago #103468 by Jerome

Replied by Jerome on topic Custom user fields don't save

Hi,

You can leave password fields empty to not update the password.
After that, it is a Joomla view, there is no more link with HikaShop than our plugin can do (add some content).

Regards,

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

zaratustra27
Topic Author
Offline

13 years 4 months ago #103471 by zaratustra27

Replied by zaratustra27 on topic Custom user fields don't save

When I leave pssws field blank, it doesn't save the other data

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

Jerome
Offline
HikaShop core developer

13 years 4 months ago #103478 by Jerome

Replied by Jerome on topic Custom user fields don't save

Hi,

I tried with Joomla 2.5 and Joomla 3.0 and it works fine.
You didn't have any error message ?

Regards,

The following user(s) said Thank You: zaratustra27

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

zaratustra27
Topic Author
Offline

13 years 4 months ago #103622 by zaratustra27

Replied by zaratustra27 on topic Custom user fields don't save

You were right, everything works fine now.

Thanks a lot! 5 stars as always!

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

Time to create page: 0.248 seconds