Hi all, I am trying to do an example of tagging. I have appended my model with the HasTags trait and when I do

        $id = Questions::create([
            'body' => request('title'),
            'skillset_id' => request('skillsetId'),
            'tags' => ['red', 'blue']
        ])->id;

I get:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>'$."en"' = ? and `type` is null limit 1' at line 1 (SQL: select * from `tags` where `name`->'$."en"' = red and `type` is null limit 1)

I am on

• Windows 10
• MariaDB 10.3.2
• MySQL 5.7.19

I have successfully installed and added the migration tables, but the creating of tags is where I fail.

$tag = Tag::findOrCreate('gossip', 'newsTag');
$tag2 = Tag::findOrCreate('headline', 'newsTag');
NewsItem::withAnyTags([$tag, $tag2])->get();

the above code return NewsItem empty

Hi! Thank you for creating such a great package.

I (and many others as I imagine) would like to have the option to disable using translations. Please vote if you need this functionality.

Scopes withAllTags and withAnyTags used to work with strings, it was just an issue with function argument typing. Added test cases.

At the same time I found out that attribute mutator setTagsAttribute was already accepting a tag as string and passing the argument to syncTags which, however, didn't support that. Fixed the test case of adding a single tag by mutator by removing the array brackets and making it fail, then solved by array wrapping the parameter.

This adds two new scopes:

scopeWithAllTagsOfAnyType
scopeWithAnyTagsOfAnyType

and to be clean about it, I added one method to HasTags trait and another to the Tag model to convert given arguments to tags of any type and find tags of any type from strings:

HasTags::convertToTagsOfAnyType
Tag::findFromStringOfAnyType

I also added .idea folder to gitignore :)

the JSON where syntax works just in MySQL - with this fix it's possible to use this package also with other engines like SQLite. If you won't merge this pls let me know - atm I fixed it by overriding the default model and trait.

I just started using this package so I having been fiddeling with it that much but the first method I used didn't work.

//create a model with some tags
$newsItem = Group::find(id)->stories()->create([
   'name' => 'testModel',
   'tags' => ['tag', 'tag2'],
]);

this creates the model correctly but does not attach the tags correctly. Am I missing something ?

Hi there, every time I save a Model with tags, tags are duplicated in the tags table. I'm using $page->syncTags(array_map('trim',explode(',',$request->tags))); Where $request->tags is a comma separated list of tags.

If I use $page->attachTags(array_map('trim',explode(',',$request->tags))); Tags are duplicated as well and, even worst, multiple idenatical tags are attached to the page.

In the Page Model definition I have added public function getTagsAttribute() { return implode(',',$this->tags()->pluck('name')->toArray()); } To create the comma separated list to show in the input form.

This is the (sqlite)DB: 30|{"en":"due tag"}|{"en":"due-tag"}||30|2018-01-17 22:21:44|2018-01-17 22:21:44 31|{"en":"Un tag"}|{"en":"un-tag"}||31|2018-01-17 22:23:02|2018-01-17 22:23:02 32|{"en":"due tag"}|{"en":"due-tag"}||32|2018-01-17 22:23:02|2018-01-17 22:23:02 33|{"en":"Un tag"}|{"en":"un-tag"}||33|2018-01-17 22:23:16|2018-01-17 22:23:16 34|{"en":"due tag"}|{"en":"due-tag"}||34|2018-01-17 22:23:16|2018-01-17 22:23:16 ` As you see the slug is the same several times.

Any idea of how I could solve this issue? Thank you! ...and compliments!

withAnyTags and withAllTags scopes only work when I pass them tag instances, and don't work when I pass them strings.

I have a tag called 'unreliable' which is attached to two Users. but this returns an empty collection:

User::withAnyTags('unreliable')->get();
User::withAnyTags(['unreliable'])->get();

The current locale is not get by app()->getLocale() but by a static function. With this change it is possible to implement custom logic of getting the locale inside of custom Tag. It can also be used to set the locale to a fixed value to "deactivate" the translation functionality.

We currently rely on the package for toggling some features on-of for certain models. This works great. But we're moving to multi-lingual now, causing the issue that tags are only defined in 1 locale. Would love to create a PR to improve the package here, but I'm wondering what the right approach might be.

• We could add a key column to the table. Passing a key by creating (or getting it from the name passed as default), and be able to use this key for methods like withAllTags or withAnyTags would solve the issue.

• We could make the locale getter configurable in the package. By doing this we could enforce one locale being used as a key for example.

• Other ideas?

Sounds straight forward using

$tagIds = DB::table('taggables')
            ->distinct()
            ->select('tag_id')
            ->where('taggable_type', 'App\Models\Video')
            ->orderBy('tag_id', 'asc')
            ->get()->unique()->pluck('tag_id');

$tags = \App\Models\Tag::whereIn('id', $tagIds)->orderBy('name', 'asc')->get();

but then I noticed a bunch of tags beginning with A in the middle of the collection.

Upon inspecting the database, I spotted that new tags seem to be saving as {"en":"Sarah","es":"Sarah"} in the name column whereas tags we've added in the past have been saved as {"en": "Trust"} (note the space after the colon messing with the orderBy).

Not sure if this is intentional or a bug? Not even sure if this is happening here or in the nova-tags-field package.

I'm using PHP 8.1, Laravel 9 and the latest version of this package. I have a fairly complex model called Domain and must paginate my results. A user has the ability to also search and sort by other options.

My $search variable is a string (provided by an input field in my front-end), and then I'm attempting to add the withAnyTags method, I do have tags, one called "client" which when I hard-code into the method, and reload my page it does work, but parsing like this is giving me no results.

What am I missing?

$domains = Domain::query();

if ($search != '') {
    $domains = $domains->withAnyTags((array) $search);
}

$domains = $domains->where('domains.user_id', Auth::id())
                    ->where(function ($sql) use ($search) {
                        $sql->orWhere('domains.domain', 'like', "$search%")
                          ->orWhere('domains.status', 'like', "$search%")
                          ->orWhere('domains.registrar', 'like', "$search%");
                    })
                    ->leftJoin('certificates', 'domains.id', '=', 'certificates.domain_id')
                    ->leftJoin('dns', 'domains.id', '=', 'dns.domain_id')
                    ->leftJoin('blacklists', 'domains.id', '=', 'blacklists.domain_id')
                    ->select('domains.*')
                    ->orderBy($sort[0] ?? 'domains.expires_on', $sort[1] ?? 'desc')
                    ->paginate((int) $perPage);