Level 73
Does it store the slug in the database or is the slug field null?
Mar 1, 2022
25
Level 5
Slug not working
I am storing the blog as follows :
controller :
Blog::insert([
'category_id' => $request->categoryid,
'post_title' => $request->post_title,
'slug' => Str::slug($request->post_title, '-'),
'post_image' => $save_url,
'post_details' => $request->post_details,
'created_at' => Carbon::now(),
blade
<a href="{{ route('post.details',[$item->id, $item->slug]) }}" class="blog-post">
But strangely first few blogs were working with slug, but now new blogs are not working ?
Level 5
Yes it stores the slug. Initially 3 blogs slug worked perfectly. But I think 4th was having a duplicate 'title' which I deleted. I presume that after that slug stopped working .
Level 102
Explain what it means that it does not work. Error? Wrong page? Can you show the route and an example of a url that does not work.
1 like
Level 5
Not working means error page 404.
The slug is stored properly in the database. Now the url "http://127.0.0.1:8000/post/details/27/first-blog" giving 404 error.
The slug field has the value "first-blog".
Level 5
Route::get('/post/details/{id}/{slug}', [BlogController::class, 'DetailsBlogPost'])->name('post.details');
Level 102
@FounderStartup you aren't binding anything it seems so it shouldn't break like that. Can you show the controller method?
1 like
Level 102
@FounderStartup in the route the method is named DetailsBlogPost ?
1 like
Level 5
public function DetailsBlogPost($id , $slug){
$blogcategory = BlogCategory::latest()->get();
$blogpost = Blog::findOrFail($id);
$trendingblogs = Blog::where('views', '>', 0)->take(2)->get();
$relatedblogs = Blog::with('category')->where('views', '>', 0)->take(2)->get();
Blog::find($id)->increment('views');
$blogcategoryspecific = BlogCategory::findOrFail($id);
$blogcomments = BlogComment::with('user')->where('blog_id',$id)->where('status', '1')->get();
$blogcommentscount = BlogComment::where('blog_id',$id)->where('status', '1')->count();
return view('frontend.blog_details',compact('relatedblogs','blogcommentscount','trendingblogs','blogcomments','blogpost','blogcategory', 'blogcategoryspecific' ));
}
Level 102
@FounderStartup good. Now you ignore slug so we just need to make sure you did this endpoint
dd($id);
1 like
Level 5
@Sinnbeck You mean remove 'slug' from route and controller ?
Level 5
Level 102
@FounderStartup no I just mean, you don't use it for anything in the controller. So just make sure the id is correct
1 like
Level 5
This is the url showing in browser :
http://127.0.0.1:8000/post/details/30/dfgdf-df-gdfgdf
30 is the id of the blog and is correct. But getting 404 error.
Level 102
Try moving to route to the top in web.php. Maybe another route interfere with it
1 like
Level 102
@FounderStartup yeah you can write anything as the slug and it should work
1 like
Level 5
@Sinnbeck Yes I tried that. Still 404 error.
Level 102
@FounderStartup and the dd is on the first line?
public function DetailsBlogPost($id , $slug){
dd($id);
1 like
Level 5
@Sinnbeck Yes I tried that. It is showing correct id. Do I need to do add something in the model ? Or some specific type of slug field ?
Level 102
@FounderStartup oh so that worked. Exelent. Now we can start debugging
Try this then
public function DetailsBlogPost($id , $slug){
dd(Blog::find($id));
Level 102
I think I just spotted the error. You are using the same ID for looking up both blog and category?
Blog::findOrFail($id);
BlogCategory::findOrFail($id);
1 like
Level 5
@Sinnbeck OMG :) Yes now it worked !!!!! Thanks a ton. You are a genius !!!
Level 102
@FounderStartup well sometimes it helps to get other eyes on the code :)
1 like
Level 5
@Sinnbeck Yes. The bug is in front of me but could not see that :)
Level 102
@FounderStartup Yeah. Often you will think that the error is related to one thing (slug) and it is actually related to something totally different (findOrFail using wrong id), so your brain only looks for issues with what you think is the problem. It is quite common :)
1 like
Level 5
@Sinnbeck True. I searched the net for bugs in 'slug' and kept looking for it. never thought for the 'id' issue :).
Please or to participate in this conversation.