<div>Hola, es un problema con las llaves foraneas, cambia en tu migración el tipo de dato por bigIncrements('id') y el unsignedBigInteger('product_id') y en tu modelo agregar el atributo en el protected $fillable = ['product_id', 'url']<br><br> </div>

<div>public function up()</div>

<div>    {</div>

<div>        <em>Schema</em>::create('photos', function (<em>Blueprint</em> $table) {</div>

<div>            $table-&gt;bigIncrements('id');</div>

<div>            $table-&gt;unsignedBigInteger('post_id');</div>

<div>            $table-&gt;string('url');</div>

<div>            $table-&gt;timestamps();</div>

<div>        });</div>

<div>    } <br><br><br></div>

<div>Hola, es un problema con las llaves foraneas, cambia en tu migración el tipo de dato por bigIncrements('id') y el unsignedBigInteger('product_id') y en tu modelo agregar el atributo en el protected $fillable = ['product_id', 'url']<br><br>&nbsp;</div><div>public function up()</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; &nbsp; <em>Schema</em>::create('photos', function (<em>Blueprint</em> $table) {</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $table-&gt;bigIncrements('id');</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $table-&gt;unsignedBigInteger('post_id');</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $table-&gt;string('url');</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $table-&gt;timestamps();</div><div>&nbsp; &nbsp; &nbsp; &nbsp; });</div><div>&nbsp; &nbsp; }&nbsp;<br><br><br></div>

<div>No ha funcionado, el problema lo tengo en el photosController.php creo que esta línea no recoge el id del producto....<br><br>'product_id' =&gt; $product-&gt;id,<br><br>ya que cuando la guarda en la tabla fotos... es Null.</div>

<div>No ha funcionado, el problema lo tengo en el photosController.php creo que esta línea no recoge el id del producto....<br><br>'product_id' =&gt; $product-&gt;id,<br><br>ya que cuando la guarda en la tabla fotos... es Null.</div>

<div>En la vista edit.blade.php hago un {{dd($product-&gt;id)}} y veo bien el product_id del producto, luego en la vista tengo este código:<br> &lt;form method="POST" action="{{ route('admin.products.update', $product) }}"&gt;<br>		            	@method('PUT')<br>		            	@csrf<br>		              &lt;div class="box-body"&gt;<br>		                &lt;div class="form-group {{$errors-&gt;has('title') ? 'has-error' : ''}}"&gt;<br>		                  &lt;label&gt;Title&lt;/label&gt;<br>		                  &lt;input name="title" value="{{old('title', $product-&gt;title)}}" class="form-control" placeholder="Ecribir nombre del producto..."&gt;<br>		                  {!! $errors-&gt;first('title', '&lt;span class="alert-danger"&gt;:message&lt;/span&gt;')!!}<br>		                &lt;/div&gt;<br>		                &lt;div class="form-group {{$errors-&gt;has('description') ? 'has-error' : ''}}"&gt;<br>		                  &lt;label&gt;Extracto&lt;/label&gt;<br>		                  &lt;textarea name="description" class="form-control" placeholder="Introduce un extracto"&gt;{{old('description', $product-&gt;description)}}&lt;/textarea&gt;<br>		                  {!! $errors-&gt;first('description', '&lt;span class="alert-danger"&gt;:message&lt;/span&gt;')!!}<br><br></div>

<div>En la vista edit.blade.php hago un {{dd($product-&gt;id)}} y veo bien el product_id del producto, luego en la vista tengo este código:<br>&nbsp;&lt;form method="POST" action="{{ route('admin.products.update', $product) }}"&gt;<br>		&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 	@method('PUT')<br>		&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 	@csrf<br>		&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class="box-body"&gt;<br>		&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class="form-group {{$errors-&gt;has('title') ? 'has-error' : ''}}"&gt;<br>		&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;Title&lt;/label&gt;<br>		&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input name="title" value="{{old('title', $product-&gt;title)}}" class="form-control" placeholder="Ecribir nombre del producto..."&gt;<br>		&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {!! $errors-&gt;first('title', '&lt;span class="alert-danger"&gt;:message&lt;/span&gt;')!!}<br>		&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;<br>		&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class="form-group {{$errors-&gt;has('description') ? 'has-error' : ''}}"&gt;<br>		&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;Extracto&lt;/label&gt;<br>		&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;textarea name="description" class="form-control" placeholder="Introduce un extracto"&gt;{{old('description', $product-&gt;description)}}&lt;/textarea&gt;<br>		&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {!! $errors-&gt;first('description', '&lt;span class="alert-danger"&gt;:message&lt;/span&gt;')!!}<br><br></div>

<div>Veo que la variable Product declarada en store es NULL cuando hago un dd en PhotosController.php<br><br>namespace App\Http\Controllers\Admin;<br>use App\Photo;<br>use App\Product;<br>use Illuminate\Http\Request;<br>use Illuminate\Support\Facades\Storage;<br>use App\Http\Controllers\Controller;<br><br>class PhotosController extends Controller<br>{<br>    public function store(Product $product)<br>    {<br>    	dd($product-&gt;id);<br>    	$this-&gt;validate(request(), [<br>    		'photo' =&gt; 'required|image|max:2048'<br>    	]);<br><br>    	$photo = request()-&gt;file('photo')-&gt;store('public');<br><br>    	foreach($request-&gt;product as $product) {<br>    	$this-&gt;productStockRepository-&gt;create($product);<br>		}<br><br>    	Photo::create([<br>    		'url' =&gt; Storage::url($photo),<br>    		'product_id' =&gt; $product-&gt;id,<br>    	]);<br>    }<br>}</div>

<div>Veo que la variable Product declarada en store es NULL cuando hago un dd en PhotosController.php<br><br>namespace App\Http\Controllers\Admin;<br>use App\Photo;<br>use App\Product;<br>use Illuminate\Http\Request;<br>use Illuminate\Support\Facades\Storage;<br>use App\Http\Controllers\Controller;<br><br>class PhotosController extends Controller<br>{<br>&nbsp; &nbsp; public function store(Product $product)<br>&nbsp; &nbsp; {<br>&nbsp; &nbsp; 	dd($product-&gt;id);<br>&nbsp; &nbsp; 	$this-&gt;validate(request(), [<br>&nbsp; &nbsp; 		'photo' =&gt; 'required|image|max:2048'<br>&nbsp; &nbsp; 	]);<br><br>&nbsp; &nbsp; 	$photo = request()-&gt;file('photo')-&gt;store('public');<br><br>&nbsp; &nbsp; 	foreach($request-&gt;product as $product) {<br>&nbsp; &nbsp; 	$this-&gt;productStockRepository-&gt;create($product);<br>		}<br><br>&nbsp; &nbsp; 	Photo::create([<br>&nbsp; &nbsp; 		'url' =&gt; Storage::url($photo),<br>&nbsp; &nbsp; 		'product_id' =&gt; $product-&gt;id,<br>&nbsp; &nbsp; 	]);<br>&nbsp; &nbsp; }<br>}</div>

<div>Solucionado!!, era en el archivo web.php tenía Route::post('products/{id}/photos', 'PhotosController@store')-&gt;name('admin.products.photos.store'); en vez de Route::post('products/{product}/photos', 'PhotosController@store')-&gt;name('admin.products.photos.store');, gracias Alex por todo.</div>

<div>Solucionado!!, era en el archivo web.php tenía Route::post('products/{id}/photos', 'PhotosController@store')-&gt;name('admin.products.photos.store'); en vez de Route::post('products/{product}/photos', 'PhotosController@store')-&gt;name('admin.products.photos.store');, gracias Alex por todo.</div>

<div>Migración de Photos<br>&lt;?php<br><br>use Illuminate\Database\Migrations\Migration;<br>use Illuminate\Database\Schema\Blueprint;<br>use Illuminate\Support\Facades\Schema;<br><br>class CreatePhotosTable extends Migration<br>{<br>    /**<br>     * Run the migrations.<br>     *<br>     * @return void<br>     */<br>    public function up()<br>    {<br>        Schema::create('photos', function (Blueprint $table) {<br>            $table-&gt;increments('id');<br>            $table-&gt;unsignedInteger('product_id');<br>            $table-&gt;string('url');<br>            $table-&gt;timestamps();<br>        });<br>    }<br><br><br>PhotosController<br>&lt;?php<br><br>namespace App\Http\Controllers\Admin;<br><br>use App\Product;<br>use App\Photo;<br>use Illuminate\Http\Request;<br>use App\Http\Controllers\Controller;<br>use Illuminate\Support\Facades\Storage;<br><br>class PhotosController extends Controller<br>{<br>    public function store(Product $product)<br>    {<br>    	$this-&gt;validate(request(), [<br>    		'photo' =&gt; 'required|image|max:2048'<br>    	]);<br><br>    	$photo = request()-&gt;file('photo')-&gt;store('public');<br><br>    	Photo::create([<br>    		'url' =&gt; Storage::url($photo),<br>    		'product_id' =&gt; $product-&gt;id,<br>    		]);<br>    }<br>}<br>Model Product<br>   public function photos()<br>  {<br>    return $this-&gt;hasMany(Photo::class);<br>  }<br><br>el error que aparece al guardar es: <br><br></div>

<ol><li>message: "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'product_id' cannot be null (SQL: insert into `photos` (`url`, `product_id`, `updated_at`, `created_at`) .....</li></ol>

<div>Migración de Photos<br>&lt;?php<br><br>use Illuminate\Database\Migrations\Migration;<br>use Illuminate\Database\Schema\Blueprint;<br>use Illuminate\Support\Facades\Schema;<br><br>class CreatePhotosTable extends Migration<br>{<br>&nbsp; &nbsp; /**<br>&nbsp; &nbsp; &nbsp;* Run the migrations.<br>&nbsp; &nbsp; &nbsp;*<br>&nbsp; &nbsp; &nbsp;* @return void<br>&nbsp; &nbsp; &nbsp;*/<br>&nbsp; &nbsp; public function up()<br>&nbsp; &nbsp; {<br>&nbsp; &nbsp; &nbsp; &nbsp; Schema::create('photos', function (Blueprint $table) {<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $table-&gt;increments('id');<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $table-&gt;unsignedInteger('product_id');<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $table-&gt;string('url');<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $table-&gt;timestamps();<br>&nbsp; &nbsp; &nbsp; &nbsp; });<br>&nbsp; &nbsp; }<br><br><br>PhotosController<br>&lt;?php<br><br>namespace App\Http\Controllers\Admin;<br><br>use App\Product;<br>use App\Photo;<br>use Illuminate\Http\Request;<br>use App\Http\Controllers\Controller;<br>use Illuminate\Support\Facades\Storage;<br><br>class PhotosController extends Controller<br>{<br>&nbsp; &nbsp; public function store(Product $product)<br>&nbsp; &nbsp; {<br>&nbsp; &nbsp; 	$this-&gt;validate(request(), [<br>&nbsp; &nbsp; 		'photo' =&gt; 'required|image|max:2048'<br>&nbsp; &nbsp; 	]);<br><br>&nbsp; &nbsp; 	$photo = request()-&gt;file('photo')-&gt;store('public');<br><br>&nbsp; &nbsp; 	Photo::create([<br>&nbsp; &nbsp; 		'url' =&gt; Storage::url($photo),<br>&nbsp; &nbsp; 		'product_id' =&gt; $product-&gt;id,<br>&nbsp; &nbsp; 		]);<br>&nbsp; &nbsp; }<br>}<br>Model Product<br>&nbsp; &nbsp;public function photos()<br>&nbsp; {<br>&nbsp; &nbsp; return $this-&gt;hasMany(Photo::class);<br>&nbsp; }<br><br>el error que aparece al guardar es:&nbsp;<br><br></div><ol><li>message: "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'product_id' cannot be null (SQL: insert into `photos` (`url`, `product_id`, `updated_at`, `created_at`) .....</li></ol>

Carlos Benito

<div>Al guardar la imagen mediante dropzone en la tabla Photos no guarda el id del proudcto, he añadido el campo nullable en la migración de la tabla Photos pero al hacer eso el campo Post_id aparece Null.</div>

<div>Al guardar la imagen mediante dropzone en la tabla Photos no guarda el id del proudcto, he añadido el campo nullable en la migración de la tabla Photos pero al hacer eso el campo Post_id aparece Null.</div>

vídeo 28 del curso desarrollo de un blog con manejo de roles y permisos