The file GeoLite2-Country.mmdb does not exist or is not readable laravel

 Composer

From the command line run:

$ composer require torann/geoip

Laravel

Once installed you need to register the service provider with the application. Open up config/app.php and find the providers key.

'providers' => [

    \Torann\GeoIP\GeoIPServiceProvider::class,

]

This package also comes with an optional facade, which provides an easy way to call the the class. Open up config/app.php and find the aliases key.

'aliases' => [

    'GeoIP' => \Torann\GeoIP\Facades\GeoIP::class,

];

Publish the configurations

Run this on the command line from the root of your project:

php artisan vendor:publish --provider="Torann\GeoIP\GeoIPServiceProvider" --tag=config

A configuration file will be publish to config/geoip.php.

Configuration

Quick breakdown of the two main options in the configuration file. To find out more simple open the config/geoip.php file.

Service Configuration

To simplify and keep things clean, all third party composer packages, that are needed for a service, are installed separately.

For further configuration options checkout the services page.

Caching Configuration

GeoIP uses Laravel's default caching to store queried IP locations. This is done to reduce the number of calls made to the selected service, as some of them are rate limited.

Options:

• all all location are cached
• some cache only the requesting user
• none caching is completely disable

Solved : Unable to guess the MIME type as no guessers are available (have you enabled the php_fileinfo extension?).

Issues: 

1. Image doesn't load correctly or shows broken

2. File (i.e: csv, xlsx etc.) will not be downloaded or cannot be exported

Solution:

in WHM:

1. Navigate to Software -> EasyApache4
2. Click the button that says Customize next to Currently Installed Packages
3. Click PHP Extensions
4. Search for Fileinfo in the search bar and select the extensions you would like to install
5. Click Review
6. After looking over the proposed changes, scroll to the bottom of the screen and click provision.

In cPanel using PHP Selector (if not works even installed in WHM):

In cPanel using ini file (if not works even installed in WHM):

Other:

1. Install PHP FIleInfo Extension (if not installed)
2. Enable php_fileinfo in php.ini 

extension=php_fileinfo.dll (Windows)

extension=php_fileinfo.so (Linux)

PHP Laravel Artisan commands

 php artisan config:clear

 php artisan config:cache

 php artisan route:clear

 php artisan view:clear

 php artisan view:cache

 php artisan event:clear

 php artisan event:cache

 php artisan cache:clear

 php artisan optimize:clear

Fix laravel SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock

Cause:

his happens when two processes or more are trying to write to the same database table at the exact same time. Solutions can be complicated. Deadlocks are usually an application problem most of the time can either be solved by:

1. changing the logic of your code (e.g. use transactions) or
2. retrying the operation

      php artisan route:list

      php artisan view:clear

      php artisan cache:clear