SEO Audit - Best SEO practices 2023, Incredibly good Module

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

No permission to download
Overview Updates (18) Reviews (3) History Discussion (29)
N
newimage Sergeant Major
Staff member
Moderating
badge id 104 You Are Richer badge id 109 NullPro Uploader
Jun 28, 2020
2,191
5,614
$6,154
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....
 
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...
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
 
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...
Thank you for the reply!

I tried your fix but it doesn't work for me.


SQL: 
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
 
thanks to dear member @theresa updated SEO Audit - Best SEO practices 2021 - Incredibly good Module with a new update entry:

02/08/2023

  • 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...

Read the rest of this update entry...
 
You must log in or register to reply here.

Similar threads

S
SEO Audit - SEO Analytics, Pretty URL, Image & Sitemap 2.7.9
Replies
3
Views
99
Zavjalova
Z
C
Yoast News SEO for Yoast SEO
Replies
0
Views
44
chavez
C
H
SmartKeyword SEO - Search Engine Optimization 5* Module
Replies
2
Views
732
yuan
Y
Y
SEO Optimizer - Advance SEO Expert | Best SEO Practices Module
Replies
2
Views
838
work
W
Y
Improve your SEO and avoid Google penalty using noindex Module
Replies
0
Views
551
yuan
Y
Back
Top