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

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

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

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

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!