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?