SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long.How can i fix?

Perfect
edited November -1 in Bug/Issue Reports

when i upload a script i go this error:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes
How can i fix?

Comments

  • prouser
    edited November -1

    @Perfect said:
    when i upload a script i go this error:
    SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes
    How can i fix?

    Can you please share your website and describe exactly what you did when you receive this error. also share the screenshot of error if possible.

  • ChrisPAR
    edited November -1

    @Perfect said:
    when i upload a script i go this error:
    SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes
    How can i fix?

    This error is probably caused because your script requires the InnoDB engine, which is not available on free hosting.

    To get InnoDB support or increased max length key support, you should upgrade to Premium Hosting