Posted in Solutions

ERROR: Invalid default value for ‘created_at’ [solution]

I got a problem while adding a new column in the database as well as editing the column. The error says invalid default value for…

Continue Reading
Posted in Solutions

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.

Continue Reading
Posted in Solutions

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 in recycle Bin but could…

Continue Reading