Question: Hi Sql Error When Installing

Hi Sql Error When Installing

I am installing on cpanel and getting this error SQL: unable to create tables, SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 byt

M

mnusae

Asked

I am installing on cpanel and getting this error

SQL: unable to create tables, SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

My database name is : howsae_ab PHP Version 7.4.11 MySQL Version 10.3.27-MariaDB

  • MS

    Mian Saleem

    Answered

    Hello,

    The issue was the database session table field length was 255, MariaDB MyISAM engine only support 191 that was causing the issue. This is already fixed, you won’t have this issue again.

    Thank you

  • MS

    Mian Saleem

    Answered

    Hello,

    I think that is not due to email or sms. Please try to enable Enable PayU India Payments (₹) and then give any random text to biz key and biz salt, then you can uncheck this. I should resolve the issue and won’t cause again.

    I will fix this in next update.

    Thank you

  • Login to Reply