search

loadedcommerce / loaded7

Loaded Commerce 7 Public Repository
www.loaded7.com
GNU General Public License v2.0
19 stars 26 forks source link

Loaded7 : Error while creating products class #703

Open mattloaded opened 9 years ago

mattloaded commented 9 years ago

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 commented 9 years ago

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