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
- MSAnswered
Hello,
Please try any of the following solution.
Solution 1
Please try to add the following line to
boot
method ofapp/Providers/AppServiceProvider.php
around line no 66\Illuminate\Support\Facades\Schema::defaultStringLength(191);
Solution 2
Please set default mysql engine to
InnoDB
inconfig/database.php
around line no 58'engine' => 'InnoDB',
Solution 3
Change the default
charset
&collation
inconfig/database.php
around line no 53 & 54'charset' => 'utf8', 'collation' => 'utf8_unicode_ci',
After change, try to install again. Let me know if you still have issue.
Thank you
- MAnswered
Not working,
Solution 1 didn’t work, it broke the code. Solution 2 & 3 both used individually or both changes together getting this error below
SQL: unable to create tables, SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘accounts’ already exists
- MSAnswered
Hello,
Please install with empty database OR delete all the tables before trying again.
Thank you
- MAnswered
Hi Now I am getting this error, I have emptied the DB and used Solution 2 & 3
SQL: unable to create tables, SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes
- MSAnswered
Hello,
Please let me know your server details in private reply so that I can check.
Thank you
- MAnswered
You mean you want me to me you email you at [email protected], or how to send a private reply on https://tecdiary.net/support
- MAnswered
I have just emailed you at [email protected].
- MSAnswered
Hello,
I am so sorry, the solution I shared are only after install 😦
If you want to use the your default database engine, you can reset the files.
I have fixed the issue, please try to install now and let me if you still have issue.
You can add private reply here by enabling the
PRIVATE for Staff only
at top right of reply section.Thank you
- MAnswered
Hello,
Thanks , what was the issue, as I will be moving this to another domain and deleting it from here. Let me know so that I can have a smooth move. Thanks.
- MAnswered
Even after putting all details in the settings page, I am getting this error.
How to disable the EMAIL & SMS COMPLETLY.
There are 2 form errors. Please make sure that you have filled all Mail & Nexmo settings correctly before enabling the notifications.
- Login to Reply