Prestashop: Sql error on autoupgrade on ps_condition table

[jf-viguier]

Describe the bug

When migrating from ps 1.7.6 to 1.7.7 beta 1 there are sql errors on ps_condition table if gamification module is not installed.

Additional information

• PrestaShop version: 1.7.7 beta 1
• PHP version: 7.1

[prestashop-issue-bot[bot]]

Thanks for opening this issue! We will help you to keep its state consistent

[prestascott]

Hi @jf-viguier, thanks for your report.

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
• debug mode report
• PHP error logs
• apache error log
• Javascript console log
• screenshots

Thank you :)

[PierreRambaud]

@jf-viguier What do you mean by migrating data?

[jf-viguier]

@PierreRambaud I mean upgrading from 1.7.6 to 1.7.7 with autoupgrade module.

[SimonGrn]

What is the exact version you started from ?

[jf-viguier]

version 1.7.6.7

[sarahdib]

Hello @jf-viguier

I was able to reproduce the issue.

Step to reproduce :

1. upgrade prestashop 1.7.6.x to 1.7.7.0 without the module gamification
2. see the error
   

I think this table is related to gamification only, there is no impact on the shop upgraded

Thank you!

[jf-viguier]

That's it, thanks @sarahdib
We always unistall the gamification module because it slow down prestashop.

[ksaandev]

I uninstall gamification too 😁

[Progi1984]

Fixed by #20192