Failed to run query: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'MoneyMethod' cannot be null

 The 'field name' in form and the column name of database was different. My problem was:
      "Integrity constraint violation: 1048 Column 'MoneyMethod' cannot be null".
My form input tag:
 {!! Form::select("MoneyMethod", $MoneymethodInfo, null,["class"=>"form-control MoneyMethod required","id"=>"MoneyMethod"]) !!}
Nnotice the spelling of 'MoneyMethod' and in my database table
$table->string('MoneyMethod', 100); 
the spelling of 'MoneyMethod' is same as form but in my controller
$riskfund->Moneymethod  = Input::get('Moneymethod');
look carefully the spelling of 'Moneymethod' differs from my form and database table column. After correcting the spelling, it is working now.
So, please check the spelling of the spelling of the field  in form, controller, database table for which you are facing the problem. it may help you.

Comments

Post a Comment

Popular posts from this blog

composer installation on aws ec2 instance ami ubuntu 18.04

Image
Introduction:                        Composer is not a package manager like yum/apt, it is a tool for dependency management in php. It allows to declare the libraries that your project depends on and it will manage 'install/update' the libraries for your project. Now you are thinking that it's not dealing with packages? yes it deals with 'packages' and 'libraries' and it manages all packages and libraries per project basis, installing them into a directory  (as for vendor) inside your project. Actually it doesn't install anything globally that's why it is a dependency manager. Tech Details:                       aws ec2, amazon machine image ubuntu 18.04, Nginx(1.14), php(7.3). Requirement: 1. aws account access 2. running ec2 instance 3. accessing the ec2 instance, if can't access please visit  blogspot  or  medium 4. nginx installation, if not...
Read more

nginx installation on aws ec2 instance ami ubuntu 18.04

Image
Introduction:                     Nginx is an open source software for web serving, proxying, caching, media streaming, load balancing and more. This is the fastest web server. Most server administrator like Nginx. We also choose nginx for our web deployment on aws. Requirement: 1. aws account access 2. running ec2 instance 3. accessing the ec2 instance, to create ec2 please visit  https://zrshishir.blogspot.com/2019/10/how-to-create-ec2-instance-on-aws.html or  https://medium.com/@zrshishir/how-to-create-ec2-instance-on-aws-amazon-web-service-ami-ubuntu-18-04-abff3b7fd922 Step1: Installation of nginx using terminal. open up your terminal and execute the following command    $ sudo apt update    $ sudo apt install nginx Step2: Adjusting ubuntu firewall (ufw), if you think it is needed to install then you can work with this step. Firstly you should show the ufw list with the execution foll...
Read more

PHP7.3 installation on aws ec2 instance ami ubuntu 18.04

Image
Introduction:                        No need any kind of introduction about php. php7.3 version has been released on 6th December  2018. This is the latest version of php. We will install php7.3 on our ec2 instance whose os is ubuntu 18.04. Requirements: 1. aws account access 2. running ec2 instance 3. accessing the ec2 instance, if can't access please visit  blogspot  or  medium 4. nginx installation, if not installed please visit  blogspot  or  medium Step1: open your terminal and run the command: $ sudo apt update $ sudo apt upgrade Step2: Installation python software properties, software properties common and adding ondrej ppa with required packages. while installing software properties press 'ok' two times and while installing ondrej then click on enter button $ sudo apt install software-properties-common $ sudo apt-add-repository ppa:ondrej/php $ sudo apt update Step3...
Read more