Cart empty error message

  • Posts: 6
  • Thank you received: 0
11 years 1 month ago #154435

-- url of the page with the problem -- : www.sierrastorage.com/services/onlinesto...tegory/12-locks.html
-- HikaShop version -- : latest web download from HikaShop
-- Joomla version -- : 3.2.4
-- PHP version -- : x.x.x
-- Browser(s) name and version -- : Chrome ver 34 (confirmed as latest version)
-- Error-message(debug-mod must be tuned on) -- : Error_message

To test the cart from the above page I select "Add to cart" then get an error message "Message the cart is empty" displayed across the entire screen.

Suggestions?

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

  • Posts: 83992
  • Thank you received: 13604
  • MODERATOR
11 years 1 month ago #154481

Hi,

Please turn on the error reporting and debug mode options of the Joomla configuration and try again. That might display an error message with more information on why this is happening.

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

  • Posts: 6
  • Thank you received: 0
11 years 1 month ago #154487

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`

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

  • Posts: 6
  • Thank you received: 0
11 years 1 month ago #155186

We still have not managed to correct our cart error. I'd still like to evaluate Hika Shop for our store, but until this error is resolved we cannot move forward with Hika. We are now evaluating another ecommerce package and have as such moved the Hika package to a new address; www.sierrastorage.com/services/hikashop.html .

It has been our intent to upgrade Hika after completing a successful evaluation. At this point we cannot move forward.

What other info do you require to assist us?

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

  • Posts: 83992
  • Thank you received: 13604
  • MODERATOR
11 years 1 month ago #155280

Hi,

The trace you provided doesn't show any error.
So all I can conclude is that the system is displaying that message because there is some kind of limit configured on the shop which prevents it from adding the product to the cart.
Did you try with another product ?
Maybe you could just drop all the tables of HikaShop from your database via phpmyadmin, do an install again and try again. That way, all the settings will be reset and you shouldn't get that error anymore.

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

  • Posts: 6
  • Thank you received: 0
11 years 1 month ago #155792

We ended up doing an upgrade to Joomla 3.3. This resolved the cart issue. Apparently our upgrade th 3.2.4 had not gone well and was causing a few issues with some extensions.

Thanks for the suggestions.

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

  • Posts: 13201
  • Thank you received: 2322
11 years 1 month ago #155886

Hi,

Thanks to have shared your solution. That can help people having problems like you.

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

Time to create page: 0.080 seconds
Powered by Kunena Forum