getting error on table create on database migration in laravel

your error can be something like this:- Syntax error or access violation:1071 Specified key was too long; max key length is 767 bytes 

 if you facing problem in creating table using database migration in laravel
then follow the steps:-

  1. Go to app -> Providers -> Edit AppServiceProvider.php
  2. Add given below line after use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\Schema;

     3. add this line Schema::defaultStringLength(191);  in this given below function


   public function boot()
    {
        
    }

Now you can run your database migration by this command 😅

php artisan migrate

Popular posts from this blog

Cant use dump() function in twig files or how to enable debug in opencart twig or print_r alternate use dump() in opencart 3.0

if you are facing the following problem. Cant use dump() function in twig files  or  how to enable debug in opencart twig  or  print_r alternate use dump() in opencart 3.0 for fixing this problem follow these steps You can activate dump() function for twig environment by following these steps in opencart 3.0 : Go to system/library/template/Twig/Environment.php Here in the constructor function, you can find $options array . Set 'debug' option to 'true' . Now we need to include debug extension, so add $this->addExtension(new Twig_Extension_Debug()); below. Now you can use  {{ dump(your_variable_name) }} as print_r variable in php That's all 😅😆😛
Read more

maximum execution time error when importing sql data file since php.ini has been already set max execution time 3000

I am trying to import a large SQL data file using PHPMyAdmin in localhost This the config file for php.ini  max_exection_time : 30000 already set. but I still getting this problem. so I follow this step and now the problem has been solved. Solution:   There's a configuration variable within the phpMyAdmin directory that I find in  libraries\config.default.php  called  $cfg['ExecTimeLimit']  that I set according to my requirement now it has been fixed.
Read more

SEO Custom URL in Opencart

If your some URLs not working Seo Friendly in Opencart after SEO enabled in Admin settings and do configuration in HTACCESS file for these URL:- http://[Your Domain.com]/index.php?route=checkout/cart   http://[Your Domain.com]/index.php?route=account/register  http://[Your Domain.com]/index.php?route=account/wishlist  http://[Your Domain.com]/index.php?route=checkout/checkout http://[Your Domain.com]/index.php?route=checkout/success http://[Your Domain.com]/index.php?route=simple_blog/article http://[Your Domain.com]/index.php?route=account/login http://[Your Domain.com]/index.php?route=product/special http://[Your Domain.com]/index.php?route=affiliate/account http://[Your Domain.com]/index.php?route=checkout/voucher http://[Your Domain.com]/index.php?route=product/manufacturer http://[Your Domain.com]/index.php?route=account/newsletter http://[Your Domain.com]/index.php?route=account/order http://[Your Domain.com]/index.php?route=account/account http:...
Read more