QueryException in Connection.php line 729: SQLSTATE[22007]: Invalid datetime format: 7 ERROR: invalid input syntax for type timestamp: "df" (SQL: select count(*) as aggregate from "departments" where "deleted_at" = df)

dwijitsolutions / laraadmin

LaraAdmin is a Open source Laravel Admin Panel / CMS which can be used as Admin Backend, Data Management Tool or CRM boilerplate for Laravel with features like Advanced CRUD Generation, Module Manager, Backups and many more.

http://laraadmin.com

MIT License

1.56k stars 538 forks source link

QueryException in Connection.php line 729: SQLSTATE[22007]: Invalid datetime format: 7 ERROR: invalid input syntax for type timestamp: "df" (SQL: select count(*) as aggregate from "departments" where "deleted_at" = df) #275

Open prajuli940132 opened 6 years ago

prajuli940132 commented 6 years ago

i am encountering this error when i try to add data into departments,employee,role and permission.please help

bobbysiagian commented 6 years ago

did you edit the mysql data type ?

SimonWang2014 commented 6 years ago

I got the same problem, I found the store function in GoodsController generated by the laraadmin, and change

$rules = Module::validateRules("GoodsTypes", $request);

$rules = Module::validateRules("GoodsTypes", $request, true);

just set the third parameter to true(the default is false). then is works, since I did not know whether it had side effects. You can modify your Controller