Sluggable posts appears more than once

@snapey

What causes a duplicate? They don't appear on their own?

When you EDIT a post, are you sure you are calling the update method and not the store method in your form?

I call the store when creating the post <form action="{{route('news.store')}}" id="postform" method="post">

and the duplicate happens after i create the posts not during edit

How can it be a duplicate? Surely its whatever you entered when you created it.

@snapey Let me explain well to you, I have a topic which is "How to make a website" on the news tag. So to make the post on that topic i go to create the post and after i click on Publish, the post appears on the homepage as a single post but on the news tag it appears more than once sometimes it appears like 5 times on that category page but not homepage.

Here is the link to what i am talking about http://7e4010a7.ngrok.io/category/news the post "Sluggable posts appears more than once" appears 4 times with same slug

but on the homepage http://7e4010a7.ngrok.io/ it appears once. How can i solve this 4 times appearance problem?

@snapey the posts i made on Entertainment category appears on the news Category which is wrong

Can anyone help with this?

Are you sure the extra posts wasn't accidentally inserted while programming all of this.

It was not because it is not appearing more than once in the database

Any solution from anyone?

What controller method extracts the data from the database?

How do you present it in the view?

@snapey i loop to get it.

<div class="main-body">
            <div class="clearfix">   
                <div class="main-body-post">
                    <div class="home-main"><h3>Latest {{$category}} Updates</h3></div>
                       @foreach($news as $new)
                        <div class="post-real">
                             <a href="{{route('news.show',$new->slug)}}">{{$new->subject}}</a> 
                            <br>
                            <br>
                        </div>  
                        @endforeach               
                </div> 
            </div>             
        </div>

Like that and the controller method is Index

with or without tag?

I show it on the view without Tag i guess

so as you just load all posts, I guess they must be duplicated in the database.

@snapey yes in the news_tag table which contains news_id and tag_id in my database, it duplicates it. I really do not know why it duplicates.

news_id is the news id tag_id is that tag id

if a news have ID of 1 and tag has ID of 1 it duplicates inside the database

Instead of creating the news will the all the request data, try creating it with just the data you need and see if thats where the duplication is happening.

$news=auth()->user()->news()->create($request->except(['tags']));

I show it on the view without Tag i guess

If that the case, then the tag pivot is not relevant. Are you sure you do not pass tag to index?

@mware This did not solve it...

@snapey I did not, so how do you suggest i store it so that it will not get duplicated?

Is there a model observer on News that fires when news is created? It's sounds like the attach method is being called twice? Just throwing out thoughts as to why this is happening.

I think the problem is with the Store method, There is a table that joins the Tag and News Together. On the table the news Id is different from the actual news ID made.

If the News ID is 20 Tag ID is 1

on the news_tag the News ID is 2 and Tag ID is 1.

If i should change the ID of the news tag to 0 instead of 1 and make a post under it, then it appears once and not duplicated.

Did you define the pivot table name on the News and Tag models? It may be looking for a new_tag table. The documentation refers to a role_user table for a many-to-many relationship for roles and users.

@mware

News.php

public function tags()
    {
        return $this->belongsToMany(Tag::class);
    }

Tags.php

public function news()
    {
        return $this->belongsToMany(News::class);
    }

Theres a few things going on here. Maybe its a typo, but hopefully Tags.php is actually Tag.php. And then you can try this for your relationships:

News.php

public function tags(){
    return $this->belongsToMany(Tag::class, 'news_tag');

}

Tags.php

public function news(){
    return $this->belongsToMany(News::class, 'news_tag');

}

@mware Using this, the post appears once, let me try to post few things to be sure.

@mware it still does not work

It was supposed to take the ID of the current news which it is not doing instead it is creating another ID for news in the news_tag table.