Abandoned / Live Carts Problem

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..

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?

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?

.