Here are the debug results when the error message "Message The cart is empty" comes up after selecting "Add to cart" for an item.
Suggestions?
Joomla! Debug Console
Session
__default
Profile Information
Application 0.000 seconds (+0.000); 0.43 MB (+0.431) - afterLoad
Application 0.184 seconds (+0.184); 1.32 MB (+0.888) - afterInitialise
Application 0.271 seconds (+0.086); 2.46 MB (+1.143) - afterRoute
Application 0.459 seconds (+0.188); 3.12 MB (+0.658) - beforeRenderModule mod_hikashop (Associated products listing for category listing menu 162)
Application 0.500 seconds (+0.041); 3.21 MB (+0.092) - afterRenderModule mod_hikashop (Associated products listing for category listing menu 162)
Application 0.501 seconds (+0.001); 3.12 MB (-0.088) - afterDispatch
Application 0.640 seconds (+0.139); 3.76 MB (+0.640) - beforeRenderModule mod_custom (Footer)
Application 0.646 seconds (+0.006); 3.77 MB (+0.005) - afterRenderModule mod_custom (Footer)
Application 0.646 seconds (+0.000); 3.77 MB (-0.001) - beforeRenderModule mod_custom (Specials)
Application 0.647 seconds (+0.000); 3.77 MB (+0.004) - afterRenderModule mod_custom (Specials)
Application 0.647 seconds (+0.000); 3.77 MB (-0.000) - beforeRenderModule mod_custom (Social2)
Application 0.647 seconds (+0.000); 3.77 MB (+0.003) - afterRenderModule mod_custom (Social2)
Application 0.647 seconds (+0.000); 3.77 MB (-0.001) - beforeRenderModule mod_custom (Pay Online)
Application 0.647 seconds (+0.000); 3.78 MB (+0.004) - afterRenderModule mod_custom (Pay Online)
Application 0.647 seconds (+0.000); 3.78 MB (-0.001) - beforeRenderModule mod_menu (Side Menu)
Application 0.662 seconds (+0.015); 3.80 MB (+0.022) - afterRenderModule mod_menu (Side Menu)
Application 0.662 seconds (+0.000); 3.79 MB (-0.004) - beforeRenderModule mod_custom (eWaste)
Application 0.663 seconds (+0.000); 3.80 MB (+0.004) - afterRenderModule mod_custom (eWaste)
Application 0.682 seconds (+0.019); 3.86 MB (+0.066) - afterRender
Memory Usage
3.88 MB (4,073,412 Bytes)
Database Queries
45 Queries Logged
SELECT `data`
FROM `seirrast_session`
WHERE `session_id` = '7e2221c2f15a63198746f8a0abf04a18'
DELETE
FROM `seirrast_session`
WHERE `time` < '1399242049'
SELECT extension_id AS id, element AS "option", params, enabled
FROM seirrast_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT folder AS type, element AS name, params
FROM seirrast_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,5)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM seirrast_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
select id, title, alias
from seirrast_jumi
where published = 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 seirrast_menu AS m
LEFT JOIN seirrast_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 seirrast_template_styles as s
LEFT JOIN seirrast_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 seirrast_hikashop_config
select id, title, alias
from seirrast_jumi
where published = 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM seirrast_extensions
WHERE `type` = 'component'
AND `element` = 'com_hikashop'
SELECT *
FROM seirrast_languages
WHERE published=1
ORDER BY ordering ASC
SELECT *
FROM seirrast_menu
WHERE id = '162'
LIMIT 1
SELECT *
FROM seirrast_modules
WHERE id IN (145);
SELECT *
FROM seirrast_hikashop_category
WHERE category_id = '2'
LIMIT 1
SELECT a.*,b.*
FROM seirrast_hikashop_category AS a
LEFT JOIN seirrast_hikashop_file AS b
ON a.category_id=b.file_ref_id
AND b.file_type='category'
WHERE a.category_id = 2
LIMIT 1
SELECT DISTINCT b.*
FROM seirrast_hikashop_product_category AS a
LEFT JOIN seirrast_hikashop_product AS b
ON a.product_id=b.product_id
WHERE b.product_published=1
AND b.product_type = 'main'
AND a.category_id IN (2)
ORDER BY a.ordering ASC
LIMIT 0, 20
SELECT count( DISTINCT b.product_id)
FROM seirrast_hikashop_product_category AS a
LEFT JOIN seirrast_hikashop_product AS b
ON a.product_id=b.product_id
WHERE b.product_published=1
AND b.product_type = 'main'
AND a.category_id IN (2)
ORDER BY a.ordering ASC
SELECT b.*
FROM seirrast_hikashop_category AS a
LEFT JOIN seirrast_hikashop_category AS b
ON a.category_left >= b.category_left
WHERE b.category_right >= a.category_right
AND a.category_id=2
GROUP BY b.category_id
ORDER BY b.category_left
SELECT *
FROM seirrast_hikashop_field as a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND a.field_table='category'
AND ((field_with_sub_categories=0
AND (field_categories="all" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories=1
AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%')))
ORDER BY a.`field_ordering` ASC
SELECT category_id
FROM seirrast_hikashop_category
WHERE category_type='product'
AND category_parent_id=0
LIMIT 1
SELECT category_id
FROM seirrast_hikashop_category
WHERE category_type='root'
LIMIT 1
SELECT category_id
FROM seirrast_hikashop_category
WHERE category_parent_id=1
AND category_type='0'
LIMIT 1
SELECT a.*,b.*
FROM seirrast_hikashop_category AS a
LEFT JOIN seirrast_hikashop_file AS b
ON a.category_id=b.file_ref_id
AND b.file_type='category'
WHERE a.category_id = 0
LIMIT 1
SELECT DISTINCT b.*
FROM seirrast_hikashop_product_category AS a
LEFT JOIN seirrast_hikashop_product AS b
ON a.product_id=b.product_id
WHERE b.product_published=1
AND b.product_type = 'main'
ORDER BY a.ordering ASC
LIMIT 0, 20
SELECT *
FROM seirrast_hikashop_file
WHERE file_ref_id IN (2)
AND file_type='product'
ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
SELECT variant_product_id
FROM seirrast_hikashop_variant
WHERE variant_product_id IN (2)
SELECT product_id
FROM seirrast_hikashop_product_related
WHERE product_related_type = 'options'
AND product_id IN (2)
SELECT *
FROM seirrast_hikashop_discount
WHERE discount_type='discount'
AND discount_published=1
AND ( discount_quota>discount_used_times OR discount_quota=0 )
AND discount_start < 1399242949
AND ( discount_end > 1399242949 OR discount_end = 0 )
AND ( discount_product_id IN (2) OR discount_product_id=0 )
AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
SELECT currency_id
FROM seirrast_hikashop_currency
WHERE currency_published=1 OR currency_id = 2
SELECT a.*
FROM seirrast_hikashop_price AS a
WHERE a.price_product_id IN (2)
AND a.price_currency_id IN (1,2)
AND (a.price_access = 'all' OR a.price_access LIKE '%,9,%' OR ISNULL(a.price_access))
ORDER BY a.price_value DESC
SELECT b.*,c.*
FROM seirrast_hikashop_category AS a
LEFT JOIN seirrast_hikashop_taxation AS b
ON a.category_namekey=b.category_namekey
LEFT JOIN seirrast_hikashop_tax AS c
ON b.tax_namekey=c.tax_namekey
WHERE a.category_id = 11
AND b.taxation_published=1
AND ( taxation_type = '' OR taxation_type = 'individual' )
AND b.taxation_date_start <= 1399242949
AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1399242949)
SELECT *
FROM seirrast_hikashop_zone
WHERE zone_id = 223
SELECT b.*
FROM seirrast_hikashop_zone_link AS a
LEFT JOIN seirrast_hikashop_zone AS b
ON a.zone_parent_namekey=b.zone_namekey
WHERE a.zone_child_namekey IN ('country_United_States_of_America_223')
AND a.zone_parent_namekey NOT IN ('country_United_States_of_America_223')
AND (b.zone_type IN('state','country') OR ( b.zone_type='tax'
AND b.zone_namekey IN ('') ))
SELECT count( DISTINCT b.product_id)
FROM seirrast_hikashop_product_category AS a
LEFT JOIN seirrast_hikashop_product AS b
ON a.product_id=b.product_id
WHERE b.product_published=1
AND b.product_type = 'main'
ORDER BY a.ordering ASC
SELECT category_id
FROM seirrast_hikashop_product_category
WHERE product_id=2
ORDER BY ordering ASC
SELECT b.*
FROM seirrast_hikashop_category AS a
LEFT JOIN seirrast_hikashop_category AS b
ON a.category_left >= b.category_left
WHERE b.category_right >= a.category_right
AND a.category_id IN (12)
GROUP BY b.category_id
ORDER BY b.category_left
SELECT a.*
FROM seirrast_hikashop_badge AS a
WHERE a.badge_start <= 1399242949
AND ( a.badge_end >= 1399242949 OR a.badge_end =0 )
AND a.badge_published=1
AND (a.badge_quantity='' OR a.badge_quantity=24)
AND (badge_discount_id=0 OR badge_discount_id=0 )
AND ((badge_category_childs = 0
AND (badge_category_id = 0 OR badge_category_id = 12))OR (badge_category_childs = 1
AND (badge_category_id=0 OR badge_category_id = 1 OR badge_category_id = 2 OR badge_category_id = 12)))
ORDER BY a.badge_ordering ASC,a.badge_id ASC
SELECT *
FROM seirrast_hikashop_currency
WHERE currency_id IN (2)
SELECT *
FROM seirrast_hikashop_field as a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND a.field_table='item'
AND ((field_with_sub_categories=0
AND (field_categories="all" OR field_categories LIKE '%,12,%'))OR (field_with_sub_categories=1
AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,12,%')))
ORDER BY a.`field_ordering` ASC
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM seirrast_modules AS m
LEFT JOIN seirrast_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN seirrast_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 <= '2014-05-04 22:35:49')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-05-04 22:35:49')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 162 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM seirrast_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT extension_id AS id, element AS "option", params, enabled
FROM seirrast_extensions
WHERE `type` = 'component'
AND `element` = 'com_contact'
SELECT extension_id AS id, element AS "option", params, enabled
FROM seirrast_extensions
WHERE `type` = 'component'
AND `element` = 'com_weblinks'
UPDATE `seirrast_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:6;s:19:\"session.timer.start\";i:1399242924;s:18:\"session.timer.last\";i:1399242948;s:17:\"session.timer.now\";i:1399242949;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.131 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":2:{s:7:\"cmobile\";O:8:\"stdClass\":3:{s:8:\"ismobile\";b:0;s:8:\"isdevice\";b:0;s:6:\"device\";s:2:\"{}\";}s:12:\"com_hikashop\";O:8:\"stdClass\":9:{s:12:\"ssl_redirect\";i:0;s:7:\"zone_id\";s:3:\"223\";s:8:\"cart_new\";s:1:\"1\";s:15:\"shipping_method\";N;s:11:\"shipping_id\";N;s:13:\"shipping_data\";N;s:14:\"payment_method\";N;s:10:\"payment_id\";N;s:12:\"payment_data\";N;}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}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:\"d823b43948f66bfcbed034baeac22845\";}' , `time` = '1399242949'
WHERE `session_id` = '7e2221c2f15a63198746f8a0abf04a18'
32 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
6 × SELECT extension_id AS id, element AS "option", params, enabled
FROM seirrast_extensions
3 × SELECT category_id
FROM seirrast_hikashop_category
2 × SELECT DISTINCT b.*
FROM seirrast_hikashop_product_category AS a
LEFT JOIN seirrast_hikashop_product AS b
ON a.product_id=b.product_id
2 × SELECT count( DISTINCT b.product_id)
FROM seirrast_hikashop_product_category AS a
LEFT JOIN seirrast_hikashop_product AS b
ON a.product_id=b.product_id
2 × SELECT *
FROM seirrast_hikashop_field as a
2 × SELECT a.*,b.*
FROM seirrast_hikashop_category AS a
LEFT JOIN seirrast_hikashop_file AS b
ON a.category_id=b.file_ref_id
AND b.file_type='category'
2 × SELECT b.*
FROM seirrast_hikashop_category AS a
LEFT JOIN seirrast_hikashop_category AS b
ON a.category_left >= b.category_left
2 × select id, title, alias
from seirrast_jumi
1 × SELECT b.*,c.*
FROM seirrast_hikashop_category AS a
LEFT JOIN seirrast_hikashop_taxation AS b
ON a.category_namekey=b.category_namekey
LEFT JOIN seirrast_hikashop_tax AS c
ON b.tax_namekey=c.tax_namekey
1 × SELECT a.*
FROM seirrast_hikashop_price AS a
1 × SELECT currency_id
FROM seirrast_hikashop_currency
1 × SELECT *
FROM seirrast_hikashop_discount
1 × SELECT *
FROM seirrast_hikashop_zone
1 × SELECT b.*
FROM seirrast_hikashop_zone_link AS a
LEFT JOIN seirrast_hikashop_zone AS b
ON a.zone_parent_namekey=b.zone_namekey
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM seirrast_modules AS m
LEFT JOIN seirrast_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN seirrast_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM seirrast_hikashop_currency
1 × SELECT a.*
FROM seirrast_hikashop_badge AS a
1 × SELECT category_id
FROM seirrast_hikashop_product_category
1 × SELECT product_id
FROM seirrast_hikashop_product_related
1 × SELECT variant_product_id
FROM seirrast_hikashop_variant
1 × SELECT *
FROM seirrast_hikashop_confi
1 × SELECT *
FROM seirrast_hikashop_category
1 × SELECT *
FROM seirrast_modules
1 × SELECT *
FROM seirrast_menu
1 × SELECT id, home, template, s.params
FROM seirrast_template_styles as s
LEFT JOIN seirrast_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
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 seirrast_menu AS m
LEFT JOIN seirrast_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM seirrast_hikashop_file
1 × SELECT folder AS type, element AS name, params
FROM seirrast_extensions
1 × SELECT `data`
FROM `seirrast_session`
1 × SELECT *
FROM seirrast_languages
OTHER Tables:
1 × UPDATE `seirrast_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:6;s:19:\"session.timer.start\";i:1399242924;s:18:\"session.timer.last\";i:1399242948;s:17:\"session.timer.now\";i:1399242949;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.131 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":2:{s:7:\"cmobile\";O:8:\"stdClass\":3:{s:8:\"ismobile\";b:0;s:8:\"isdevice\";b:0;s:6:\"device\";s:2:\"{}\";}s:12:\"com_hikashop\";O:8:\"stdClass\":9:{s:12:\"ssl_redirect\";i:0;s:7:\"zone_id\";s:3:\"223\";s:8:\"cart_new\";s:1:\"1\";s:15:\"shipping_method\";N;s:11:\"shipping_id\";N;s:13:\"shipping_data\";N;s:14:\"payment_method\";N;s:10:\"payment_id\";N;s:12:\"payment_data\";N;}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}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:\"d823b43948f66bfcbed034baeac22845\";}' , `time` = '1399242949'
1 × DELETE
FROM `seirrast_session`