Custom user fields don't save

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)

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`