Prestashop: Cannot install product comments module

[blahapeta]

Cannot install Product Comments module

To Reproduce
Steps to reproduce the behavior:

1. Go to modules->module catalog->Product Comments
2. Click on Install
3. See error

DEBUG:
Exception thrown by module productcomments on install. Column count doesn\'t match value count at row 1INSERT IGNORE INTO ps_product_comment_criterion VALUES (\'1\', \'1\', \'1\')

Firefox developer console:
{"productcomments":{"status":false,"msg":"Cannot install module productcomments. Unfortunately, the module did not return additional details."}}

Screenshots

Additional information
PrestaShop version: 1.7.6
PHP version: 7.2

[mariem-abid]

Hi @blahapeta,

Could you please provide us with more info? We need more details to understand how we can reproduce your issue:

• host
• server setup and configuration
• PrestaShop version (source)
• debug mode report
• PHP error logs
• apache error log
• javascript console log
• screenshots

Don't you know how to get this information? Please read the following article:
http://build.prestashop.com/howtos/misc/how-to-create-bug-report/

Thanks!

[blahapeta]

Hi @mariem-abid ,
i have solved it.

Problem was in my database. There was one extra row in my table. After removing it i was able to install module.

ALTER TABLE ps_product_comment_criterion DROP COLUMN id_shop;

I had Mypresta product comment module i installed previously. It probably altered this db table.
https://mypresta.eu/modules/advertising-and-marketing/free-product-reviews-comments.html

Thanks!

[khouloudbelguith]

Hi @blahapeta,

As it's not a module provided by Prestashop, we can't do anything with this.
You should contact the module author via your addons.prestashop.com account, they are the only ones to help you with it.
Thanks!

[Stampa-Stampa]

ALTER TABLE ps_product_comment

I also have the same problem and had previously installed the same module from mypresta...
Can you be more specific as to how to resolve this\?

[blahapeta]

My Prestashop is totally broken now, have to reinstall. Not sure why. Only thing i can recommend it to do not do changes by hand like me. Hope Mypresta and official Prestashop will communicate about this matter and resolve it

[shnslmz]

@Stampa-Stampa and @blahapeta
You can remove vikea's module tables on phpMyadmin manually.

--
@khouloudbelguith

Why this module can be just/min. usable for +1.7.6.0?

//$this->ps_versions_compliancy = array('min' => '1.7.6', 'max' => _PS_VERSION_);

It needs which changes to be avaible for 1.7.4.4?

Thanks!

[khouloudbelguith]

Hi @shnslmz,

It is compatible with PrestaShop from PS1.7.6.0.
You can change this line
$this->ps_versions_compliancy = array('min' => '1.7.6', 'max' => PS_VERSION);
by this
$this->ps_versions_compliancy = array('min' => '1.7.4', 'max' => PS_VERSION);
But, it is not official this change, it can provide you issues because it is not compatible.

Thanks!

[shnslmz]

Hi @shnslmz,

It is compatible with PrestaShop from PS1.7.6.0.
You can change this line
$this->ps_versions_compliancy = array('min' => '1.7.6', 'max' => PS_VERSION);
by this
$this->ps_versions_compliancy = array('min' => '1.7.4', 'max' => PS_VERSION);
But, it is not official this change, it can provide you issues because it is not compatible.

Thanks!

Hi @khouloudbelguith ,

Yes.
This is exactly what I want to ask:
"But, it is not official this change, it can provide you issues because it is not compatible."

Is there any big changes between this two versions, at this point, do you have any info?

Thanks!

[khouloudbelguith]

@shnslmz, you can follow this link & check the changelog between each version.

Thanks!

[photinia73]

Hi @mariem-abid ,
i have solved it.

Problem was in my database. There was one extra row in my table. After removing it i was able to install module.

ALTER TABLE ps_product_comment_criterion DROP COLUMN id_shop;

I had Mypresta product comment module i installed previously. It probably altered this db table.
https://mypresta.eu/modules/advertising-and-marketing/free-product-reviews-comments.html

Thanks!

The same situation )) Thanks for SQL query )