MyISAM engine to InnoDB

[RCTSH]

A module I have installed to test and that I have deleted because to use it you need to be super , has told me that my installation has 51 tables with MyISAM engine. It is recommended to change the engine to InnoDB to increase the performance.

He also told me that of the 51 there are 2 that are native and can not touch each other ps_configuration.

 

Have you ever done this? with the module I can't do it because I need to be a super user.

can it be done locally?

I also have these 4 errors

The table ps_wasato_category_keywords is missing.

The following table has a relational integrity data error:
ps_address
ps_specific_price_priority
ps_stock_mvt

thank you very much in advance

[Mediacom87]

Hi,

This is an option my module offers, to switch tables from MyISAM to InnoDB with a single click, but my module also requires SuperAdmin status on the PrestaShop backoffice, a choice made to prevent unauthorized users from causing damage to the database.

You can of course make this kind of change with dedicated database management tools such as phpMyadmin or Adminer.

As for the missing table, it must correspond to a module named wasato. You'll need to find this module and how the table is declared during installation, or simply uninstall this module if it's no longer required.

[RCTSH]

Thank you very much for your kind reply
I am on a shared host but I have 5 gb of ram and 4 processors but I can not be super, so I'm looking to do it from cpanel or local and then upload it but I am not an expert in databases, I know just enough.

about the module wasato neither is installed nor I find in modules the name. as I qwuito it from above do I have to install it to uninstall it again to see if it solves the problem?

Translated with DeepL.com (free version)

[Mediacom87]

Il y a 2 heures, RCTSH a dit :

Thank you very much for your kind reply
I am on a shared host but I have 5 gb of ram and 4 processors but I can not be super, so I'm looking to do it from cpanel or local and then upload it but I am not an expert in databases, I know just enough.

about the module wasato neither is installed nor I find in modules the name. as I qwuito it from above do I have to install it to uninstall it again to see if it solves the problem?

Translated with DeepL.com (free version)

As far as my module is concerned, as I said, I'm talking about the employee's SuperAdmin status in the PrestaShop backoffice, nothing else, nothing to do with your server.

As for the wasato table, if it's there and you don't have a module attached to it, it's probably because the module was poorly developed and deleting it didn't delete the table as it should have.

[RCTSH]

thanks  i have super admin on prestashop, as you says but no on cpanel .

thanks a lot