Hi so here are my relation:
Location:
public function _geoloc()
{
return $this->belongsTo('App\GeoLoc', 'id');
}
Geoloc:
public function locations()
{
return $this->hasOne('App\Location', 'geoloc_id');
}
Controller:
$geoloc = new Geoloc;
$geoloc->lat = $request->input('lat');
$geoloc->lng = $request->input('lng');
$geoloc->save();
$geoloc_id = $geoloc->id;
$location = new Location;
$location->business_id = $business_id;
$location->latitude = $request->input('lat');
$location->longitude = $request->input('lng');
$location->slug = $request->input('name');
$location->geoloc_id = $geoloc_id;
$location->save();
Full error message:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (
liveoldham.locations, CONSTRAINTlocations_geoloc_id_foreignFOREIGN KEY (geoloc_id) REFERENCESgeoloc(id) ON DELETE CASCADE ON UPDATE CASCADE) (SQL: insert intolocations(business_id,latitude,longitude,slug,geoloc_id,updated_at,created_at) values (1, 53.4867546, -2.054066599999942, Live & Now, 94, 2017-06-27 15:22:51, 2017-06-27 15:22:51))
All the values are correct, row is inserted into geoloc but it doesn't get inserted to locations and this is the error I am gettiing, how can that be fixed?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire