Loaded7 : Error while creating products class

[mattloaded]

Issue : While creating product Class in admin >> Products >> Setting >> Product Classes. It throws error. Undefined error while creating product Class.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[mattloaded]

Fix : The issue is with no default value set to status column in lc_product_classes table. Run the below query to fix the issue.

ALTER TABLE lc_product_classes CHANGE status status TINYINT( 1 ) NOT NULL DEFAULT '1';

The same needs to be updated in the core install sql for lc_product_classes table.

CREATE TABLE IF NOT EXISTS lc_product_classes (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(128) NOT NULL,
comment varchar(255) DEFAULT NULL,
status tinyint(1) NOT NULL DEFAULT '1',
language_id int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (id)
) ENGINE=MyISAM