SEO Audit - Best SEO practices 2023, Incredibly good Module 2.9.7

Damdam said:

Hello,

I try to install the module and i get this error:

Code:

Exception retournée par le module ets_seo pour reset. Erreur lors de la réinitialisation du module ets_seo. Index column size too large. The maximum column size is 767 bytes.
CREATE INDEX ets_seo_rr ON `ps_meta_lang`(url_rewrite)

Mysql version is 5.7 and i don't know how to change max column size. If someone can help me with this....

Click to expand...

mysql -uYourUser  -pYourPassword
 SET GLOBAL innodb_file_format=Barracuda;
   SET GLOBAL innodb_file_per_table=On;
   SET GLOBAL innodb_large_prefix=On;
 SET GLOBAL innodb_default_row_format=dynamic

McClure Dessie said:

1. backup your database
2.change mysql cnf innodb_large_prefix innodb_file_format innodb_file_per_table innodb_default_row_format.
3.how to change?

SQL:

mysql -uYourUser  -pYourPassword
 SET GLOBAL innodb_file_format=Barracuda;
   SET GLOBAL innodb_file_per_table=On;
   SET GLOBAL innodb_large_prefix=On;
 SET GLOBAL innodb_default_row_format=dynamic

Click to expand...

Erreur
Analyse statique :
5 erreurs trouvées lors de l'analyse.
    Début d'énoncé inattendu. (near "mysql" at position 0)
    Début d'énoncé inattendu. (near "u" at position 7)
    Début d'énoncé inattendu. (near "XXXX" at position 9)
    Début d'énoncé inattendu. (near "p" at position 27)
    Début d'énoncé inattendu. (near "XXXX" at position 29)
Requête SQL : Copier
mysql -u XXXX -p XXXX SET GLOBAL innodb_file_format=Barracuda;
MySQL a répondu : Documentation
#1064 - Erreur de syntaxe près de 'mysql -u XXXX  -p XXXX
SET GLOBAL innodb_file_format=Barracuda' à la ligne 1

no change log for this version

Click to expand...

• New features: 1. Automate the task of adding the ALT and Title tags to the images
• New features: 2. Automatically submit sitemaps to the Google Search Console via cronjob
• New features: 3. 404 Monitor: include a 404 monitor to record the URLs on which visitors & search engines run into 404 Errors
• New features: 4. Schema test for structured data: support for the structured data, which adds Schema code to the website, resulting in rich search results, better CTR, and more...

Click to expand...