Abandoned / Live Carts Problem

Store Builder in detail Issues & Troubleshooting
#1

I got very strange problem that I cannot re create on demo site.

I am adding product to cart from front end, I see it in admin Abandoned / Live carts, now I delete it from cart by deleting one or clearing cart. Cart is empty, however cart is still shown in admin Abandoned / Live carts while in demo it is removed..

Same happens for anonymous and registered customers. Site is SSL fully SSL enabled if this changes anything, php7...

I need a pointer where to start looking, asked support but no outcome for few days now..

#2

Checked cscart_user_session_products table and it has about 1300lines of saved carts. While admin Abandoned / Live carts shows only 290 records. In db some links are held as http some as https. Earlier I have switched from http to https, maybe http information help somehow interferes with new data?

#3

OK I have figured out the problem.

Problem cart cscart_user_session_products had this

DROP TABLE IF EXISTS cscart_user_session_products;

CREATE TABLE cscart_user_session_products (

user_id int(11) unsigned NOT NULL DEFAULT ‘0’,

timestamp int(11) unsigned NOT NULL DEFAULT ‘0’,

type char(1) NOT NULL DEFAULT ‘C’,

user_type char(1) NOT NULL DEFAULT ‘R’,

item_id int(11) unsigned NOT NULL DEFAULT ‘0’,

item_type char(1) NOT NULL DEFAULT ‘P’,

product_id mediumint(8) unsigned NOT NULL DEFAULT ‘0’,

amount mediumint(8) unsigned NOT NULL DEFAULT ‘1’,

price decimal(12,2) NOT NULL DEFAULT ‘0.00’,

extra text NOT NULL,

session_id varchar(34) NOT NULL DEFAULT ‘’,

ip_address varchar(15) NOT NULL DEFAULT ‘’,

order_id mediumint(8) unsigned NOT NULL DEFAULT ‘0’,

company_id int(11) unsigned NOT NULL,

PRIMARY KEY (user_id,type,user_type,item_id,company_id),

KEY timestamp (timestamp,user_type),

KEY session_id (session_id)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

while fresh install looks like

DROP TABLE IF EXISTS cscart_user_session_products;

CREATE TABLE cscart_user_session_products (

user_id int(11) unsigned NOT NULL DEFAULT ‘0’,

timestamp int(11) unsigned NOT NULL DEFAULT ‘0’,

type char(1) NOT NULL DEFAULT ‘C’,

user_type char(1) NOT NULL DEFAULT ‘R’,

item_id int(11) unsigned NOT NULL DEFAULT ‘0’,

item_type char(1) NOT NULL DEFAULT ‘P’,

product_id mediumint(8) unsigned NOT NULL DEFAULT ‘0’,

amount mediumint(8) unsigned NOT NULL DEFAULT ‘1’,

price decimal(12,2) NOT NULL DEFAULT ‘0.00’,

extra text,

session_id varchar(64) NOT NULL DEFAULT ‘’,

ip_address varbinary(40) NOT NULL DEFAULT ‘’,

order_id mediumint(8) unsigned NOT NULL DEFAULT ‘0’,

company_id int(11) unsigned NOT NULL,

PRIMARY KEY (user_id,type,user_type,item_id,company_id),

KEY timestamp (timestamp,user_type),

KEY session_id (session_id)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Can somebody explain what is the difference in these lines

`extra` text NOT NULL,
`session_id` varchar(34) NOT NULL DEFAULT '',
`ip_address` varchar(15) NOT NULL DEFAULT '',

vs

`extra` text,
`session_id` varchar(64) NOT NULL DEFAULT '',
`ip_address` varbinary(40) NOT NULL DEFAULT '',

When I imported empty cscart_user_session_products table taken from fresh install Abandoned / Live carts works as intended. But I lost all user contents.

What can happen if I would use these correct lines

`extra` text,
`session_id` varchar(64) NOT NULL DEFAULT '',
`ip_address` varbinary(40) NOT NULL DEFAULT '',

with my db saved cart content, is there any risk?

#4

.