How to solve Invalid default value for ‘created_at’ while adding new column in database.

[Problem:] While adding new column to the table by alter method, I used this sql code   ALTER TABLE investments ADD bank TEXT; ERROR 1067 (42000): Invalid default value for 'created_at'   But An eeror came thought I tried various data type ERROR 1067 (42000): Invalid default value for 'created_at'   [solution] The problem in my database is current mode is in the sql_mode   SO, in the sql I typed and hit the commend set global sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';     and it solved the problem.

4 years ago

HOW TO ADD A NEW COLUMN TO EXISTING DATABASE [LARAVEL]

First of all make a new migration php artisan make:migration add_mobile_to_userinfo 2. put this code in up() function public function…

4 years ago

Allowed memory size of ~ bytes exhausted in Laravel issue in laravel [solved]

1. Open and edit php.ini file. You can find inside xampp/php 2) Search and find memory_limit (control+F) 3) change this…

4 years ago

How to Pass Value from Model to all the views in Laravel ? with video

It is a bit tricky to pass all the values to the view from the model in laravel. First of…

4 years ago

Cant Delete File in Laravel? [SOLUTION]

[Q] I am using laravel and while deleting a file in laravel It got error while code is live but…

4 years ago

Be careful when using Facebook! Photos uploaded to Couple Challenge appeared on the porn sites

Under the recently launched Couple Challenge on the popular social network Facebook, photos uploaded by users with their partners have…

4 years ago

HOW TO FIX LAZY MOUSE PROBLEM?

Hey guys, I tried hard to solve a problem of lazy mouse fridging problem. I tried some ideas found in…

4 years ago

How To Add Facebook Message Box in Your Website?

How To Add Facebook Message Box in Your Website? https://youtu.be/x4eZOfHtR3g How To Add Facebook Message Box in Your Website?

4 years ago

How to recover shift+deleted files and folders in windows?

I accidentally deleted a folder in a desktop which I came to know was very useful to me. I searched…

4 years ago

How to send a data to all views in laravel

It is sometimes necessary to send data or an array to all the views sometimes. but this is the rare…

4 years ago