Module Product Comments PS 1.5.5

[omine]

I noticed the "bug" when i was installing template..

 

The template installation was interrupted caused by mysql warning.

 

Erro about missing column..

 

 

How to fix

 

1. Open file: \modules\productcomments\install.sql

 

2. got to line 68, find this:

 

INSERT INTO `PREFIX_product_comment_criterion` VALUES ('1', '1', '1');

 

replace with

 

INSERT INTO `PREFIX_product_comment_criterion` (`id_product_comment_criterion_type`,`active`,`id_lang`) VALUES ('1', '1', '1');

 

 

 

 

[off]

After solve it, still found another bug, not related, but for others that may face the same problem, i will share

 

The error: Duplicate entry '10-0-1' for key 'PRIMARY'

INSERT INTO `atr_hook_module` (`id_module`, `id_shop`, `id_hook`, `position`)
          VALUES (10, 1, 0, 1)

 

This may happen when you try to install modules bundled with template  that already exists on your PS platform.

Solution: Uninstall the modules that may conflict with your template modules.