Question: 422 Unprocessable Entity Error Sqlstate Hy000

422 Unprocessable Entity Error Sqlstate Hy000

Hello, im trying to install the system, but im getting this error: 422 Unprocessable Entity - "SQL: unable to create tables, SQLSTATE[HY000]: General error: 1709 Index column size too lar

MM

Mario Mazcorro

Asked

Hello, im trying to install the system, but im getting this error:

422 Unprocessable Entity - "SQL: unable to create tables, SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes. "}.

Can you help me?

  • MM

    Mario Mazcorro

    Answered

    Hello. I solved it. For anyone who wonder how to solve this, i ran this commands in MySQL console:

    • mysql> set global innodb_file_format = BARRACUDA;
    • mysql> set global innodb_large_prefix = ON;
    • mysql> set global innodb_default_row_format=DYNAMIC;
  • MS

    Mian Saleem

    Answered

    Hello,

    Thank you very much for sharing your solution. The default index should match the defautl setting on most servers. I will try to check the index name before next update.

    Thanks again

  • Login to Reply