Laravel mysql migrate error

If you found error something like below while doing migration,

Illuminate\Database\QueryException : SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' (SQL: select * from information_schema.tables where table_schema = fisica and table_name = migrations)

In the config/database.php, Add My MySQL array ended up like this:

'mysql' => [
'driver' => 'mysql',
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '3306'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'unix_socket' => env('DB_SOCKET', ''),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'strict' => true,
'engine' => null,
'modes' => [
'ONLY_FULL_GROUP_BY',
'STRICT_TRANS_TABLES',
'NO_ZERO_IN_DATE',
'NO_ZERO_DATE',
'ERROR_FOR_DIVISION_BY_ZERO',
'NO_ENGINE_SUBSTITUTION',
],
],

Then, it works like a charm.

Toggle Show or Hide Divs through jquery

Toggle is one of the best function in jQuery, here we can update about how to handle html sections by hide or show through this jquery toggle function.

here we go for an easy example,

HTML block

<ul id=”list”>
<li>
<a href=”#” class=”togglelink”>America</a>
<div class=”toggle” style=”display: block;”>
<p>America – USA – the States</p>
</div>
</li>
</ul>Read More »