What is the function of the ps_advice and ps_condition tables

[musicmaster]

Does anyone know the function of the ps_advice and ps_condition tables in the Prestashop database?

Edited February 17, 2018 by musicmaster (see edit history)

[Guest]

Did you find out?

[bnadauld]

what is it for can it be truncated?

[rrataj]

I'm pretty sure that these tables are not part of prestashop core, or any default modules.

So either it's leftover from some old modules you used in the past, or it's a table that some of your existing modules use. Once you check that none of your modules use these tables you can delete them.

You can also do a backup of the content and structure before removing, just to be safe.

[elenaso]

I had the same doubt with ps_condition. This table is used by Gamification module.

[bnadauld]

On 11/19/2020 at 5:43 PM, elenaso said:

I had the same doubt with ps_condition. This table is used by Gamification module.

so it can be truncated. Did you do that?

[elenaso]

 

On 11/23/2020 at 8:16 AM, bnadauld said:

so it can be truncated. Did you do that?

I am sorry @bnadauld! I did not see your notification! :S

I desactivated the Gamification module and the table dissapeared. I think it is better solution than to truncate, because if you still have Gamification module, I do not know how this module work without his table.

[bnadauld]

thanks for the help!. I cant even see the Gamification module in my 1.7 Prestashop site. Does it def show up as this in 1.7 modules and services section of the backoffice?

I suspect that i might have already removed it..

[elenaso]

8 hours ago, bnadauld said:

thanks for the help!. I cant even see the Gamification module in my 1.7 Prestashop site. Does it def show up as this in 1.7 modules and services section of the backoffice?

I suspect that i might have already removed it..

Hi @bnadauld, I have PrestaShop in Spanish and I see it like "Experiencia minorista" in Administration tab. In any case, if I search "gami" in search tab of "Modules Manager" section, I only see gamification module. I see it like that (maybe to see the logo help you):

[musicmaster]

3 hours ago, elenaso said:

Hi @bnadauld, I have PrestaShop in Spanish and I see it like "Experiencia minorista" in Administration tab. In any case, if I search "gami" in search tab of "Modules Manager" section, I only see gamification module. I see it like that (maybe to see the logo help you):

That is easy to find out:

 - when you search in modules it accepts the English name.  So searching for Gamification will turn up the module - even if its Spanish name is different.

 - you can also move your mouse over the word "configure". That will show a link at the bottom of the page that includes the module name.

[bnadauld]

thanks for the help!