Giter Club home page Giter Club logo

Comments (6)

tomolimo avatar tomolimo commented on August 16, 2024

Hello @Riesuu,
Could check that support for large prefix is ON?
show global variables like 'innodb_lar%';
And if yes, could you post the results of show global variables like 'innodb_fil%';
And also the result of show global variables like 'innodb_default%';
Thank you,
Regards,
Tomolimo

from mailanalyzer.

Riesuu avatar Riesuu commented on August 16, 2024

Sure!

MariaDB [(none)]> show global variables like 'innodb_lar%';
Empty set (0.001 sec)

MariaDB [(none)]> show global variables like 'innodb_fil%';
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| innodb_file_per_table | ON    |
| innodb_fill_factor    | 100   |
+-----------------------+-------+
2 rows in set (0.001 sec)

MariaDB [(none)]> show global variables like 'innodb_default%';
+----------------------------------+---------+
| Variable_name                    | Value   |
+----------------------------------+---------+
| innodb_default_encryption_key_id | 1       |
| innodb_default_row_format        | compact |
+----------------------------------+---------+
2 rows in set (0.001 sec)

from mailanalyzer.

tomolimo avatar tomolimo commented on August 16, 2024

Hello @Riesuu
That's strange, you showed the results for MariaDB but in the GLPI system info it shows: Server Software: MySQL Community Server (GPL) Server Version: 5.7.40
What SQL server GLPI is using? MariaDB or MySQL?
Thank you
Regards,
Tomolimo

from mailanalyzer.

Riesuu avatar Riesuu commented on August 16, 2024

My bad, im using wamp and i'm not familiar

mysql> show global variables like 'innodb_lar%';
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| innodb_large_prefix | ON    |
+---------------------+-------+
1 row in set (0.00 sec)

mysql> show global variables like 'innodb_fil%';
+--------------------------+-----------+
| Variable_name            | Value     |
+--------------------------+-----------+
| innodb_file_format       | Barracuda |
| innodb_file_format_check | ON        |
| innodb_file_format_max   | Barracuda |
| innodb_file_per_table    | ON        |
| innodb_fill_factor       | 100       |
+--------------------------+-----------+
5 rows in set (0.00 sec)

mysql> show global variables like 'innodb_default%';
+---------------------------+---------+
| Variable_name             | Value   |
+---------------------------+---------+
| innodb_default_row_format | compact |
+---------------------------+---------+
1 row in set (0.00 sec)

from mailanalyzer.

tomolimo avatar tomolimo commented on August 16, 2024

Hello,

Then the solution is to change the innodb_default_row_format from compact to dynamic
You may try this: SET GLOBAL innodb_default_row_format = DYNAMIC;

Then you should be able to add the plugin :)

Thank you,
Regards,
Tomolimo

from mailanalyzer.

Riesuu avatar Riesuu commented on August 16, 2024

Good morning,
thanks a lot it working !

from mailanalyzer.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.