Is there an easy way to migrate my tags from the package rtconner/laravel-tagging to this package? The author of the other package has abandoned the package and composer suggests using the package from Spatie.

The only problem is the migration of the existing tags. Before I start writing a migration command I would like to know if someone has already written such a feature.

In short:

protected static function convertToTags
from HasTags.php

uses

if ($value instanceof Tag)

Well I use my own Tag Model and this test does not pass... so when I have Tag instances and pass them to the withAnyTag Scope for example, they are not recognized and therefore ...

Please change this place to:

if ($value instanceof $className)

Full code to replace for your convinience:

protected static function convertToTags($values, $type = null, $locale = null)
    {
        return collect($values)->map(function ($value) use ($type, $locale) {
            $className = static::getTagClassName();
            if ($value instanceof $className) {
                if (isset($type) && $value->type != $type) {
                    throw new InvalidArgumentException("Type was set to {$type} but tag is of type {$value->type}");
                }

                return $value;
            }


            return $className::findFromString($value, $type, $locale);
        });
    }

L.S.,

I wonder how to query Tag:: in order to get all the tags attached to a specific model.

Or maybe a function like: Model::existingTags()

Kind regards,

Will this package work with MariaDB's json datatype in 10.2+ ? Currently we're running mariadb 10.1 and want to see if upgrading to 10.2 is worth it.

I'm running Laravel 5.3 on Valet on Mac OSX Sierra with MariaDB 10.1.16 and am encountering the following error when trying to run migration:

"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 'json not null, slug json not null, type varchar(255) null, order_column in' at line 1"

As far as I can tell from reading various posts and MariaDB docs, it seems (somehow) that MariaDB only supports JSON with "CONNECT" engine. My current work-around is to make the following changes:

from

$table->json('name');
$table->json('slug');

to

$table->text('name');
$table->text('slug');

Will this change have an adverse effect anywhere else in the package code?

TIA,
-martin.

Here's the code from my controller:

...
$tags = explode(',',$request->input('tags'));
$userid = (int)\Auth::user()->id;
$url = \App\URL::where('id', '=', $id)->where('user_id', '=', $userid)->orderBy('updated_at', 'desc')->first();
$url->syncTags(['test1']);
$url->save();
return redirect('/l/'.\Hashids::encode($url->id));
...

my model implements the trait

class URL extends Model
{
use \Spatie\Tags\HasTags;
...

and I receive this error when attempting to execute syncTags() for the first time after running the migration

PDOException
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>'$."en"' = ? and type is null limit 1' at line 1

Is there a function where i can get all tags attached to a record ?

For example lets get first article $article = Article::find(1)->get();
How to get all tags attached to $article ?

At this url https://docs.spatie.be/laravel-tags/v1/advanced-usage/sorting-tags

At these codes

//get all tags sorted on `order_column`
$orderedTags = Tags::ordered()->get(); 

//set a new order entirely
Tags::setNewOrder($arrayWithTagIds);

$myModel->moveOrderUp();
$myModel->moveOrderDown();

//move the tag to the first or last position
$myModel->moveToStart();
$myModel->moveToEnd();

$tag->swapOrder($anotherTag);

Do$myModelmeans Post Model (Just example for post it can be book or any) Instance or \Spatie\Tags\Tag Model instance??

I think $myModel should be $tagModel .

And in previous part of documentation we used $myModel for another thing like Post Model, isn't it ?

Or i am confused :(?

When I try to create a tag manually as written here, it will give me this error:

Type error: Return value of Spatie\Tags\Tag::getTranslations() must be of the type array, string returned

which is related to HasSlug.php class on line 12.

I also can't make an eloquent factory because of this error and must set attributes within array like this:

$factory->define(App\Tag::class, function (Faker\Generator $faker) {

    return [
        'name' => [$faker->word]
    ];
});

First of all, thank you so much for all the amazing packages. I am just learning Laravel and I am having a hard time getting the tags package to work. I followed all the installation steps but I am not really sure how I can add tags on the front end with a view. Are the sample code snippets supposed to be added in the model or should they be in the controller under their respective method (create, delete, etc)?
Also, I was looking at a turorial on Laravel News (https://laravel-news.com/how-to-add-tagging-to-your-laravel-app) and they are using javascript (Selectivize) in the views to attach the tags. Does that work the same with this package? Is there a repo with a sample project using that where I can see how everything is put together?
Sorry about all the confusion, I am still trying to learn my way around Laravel.

Hi,

maybe I am just missing something, but as far as I see, the following example code from the docs is invalid:

$tag = Tag::create('gossip', 'newsTag');
$tag2 = Tag::create('headline', 'newsTag');

Since the Tag model does not overwrite the create method from the eloquent model you have to write something like this instead:

$tag = Tag::create([
            'name' => 'gossip', 
            'type' => 'newsTag'
]);
$tag2 = Tag::create([
            'name' => 'headline', 
            'type' => 'newsTag'
]);

Hi,

I am wondering how I could make both your packages work together without modifying Vendor files.
For example, logging when a user creates a tag.

What would be the best / cleanest approach to make these packages observe each other after pulling them in?

I would appreciate if you could give me some advice on this.

Hi!
As you may know, HasSlug trait will generate slug for tags just using str_slug method that will be used just for English and left-to-right languages but not anyone's native language is English.

So I've added the ability to choose which method to use when generating slugs, in #14 PR

Hi,

First of all thanks for the package. But now i got a issue/question.
I got the following inputs.

array:7 [▼
  "_token" => "a2r5e8ehAzyeu67kq2YPPM785hFgI1tokurBVMw3"
  "publish_date" => "2017-12-06"
  "is_published" => "Y"
  "title" => array:3 [▼
    "nl" => "dfqsdfsqdf"
    "fr'" => null
    "en" => null
  ]
  "categories" => array:3 [▼
    "nl" => "test, test"
    "fr" => "test,test"
    "en" => "test,test"
  ]
  "message" => array:3 [▼
    "nl" => "<p>dfsdfdsqfqdsf</p>"
    "fr" => null
    "en" => null
  ]
  "article_image" => UploadedFile {#456 ▶}
]

And the following controller:

public function store(NewsValidator $input): RedirectResponse
    {
        $input->merge(['author_id' => $input->user()->id]);

        if ($article = $this->newsRepository->create($input->except(['_token']))) {
            $article->addMedia($input->file('article_image'))->toMediaCollection('images');

            // Tags attachment.
            empty($input->categories['nl']) ?: array_map('trim', explode(',', $input->categories['nl']));

            flash("Het nieuws bericht is opgeslagen in het systeem.")->success();
        }

        return redirect()->route('news.admin.index');
    }

How can i integrate my tags with the needed translations. Into the my article logic? Because the docs look unclear to me.

I am new in Laravel as well as i am first time using your Service Provider I have a questions table in my MySQL database where every question belongs To many tags. I setup and config your provider properly. Here is my code.

in App\Question

class Question extends Model
{
    use HasTags;


}

in App\Http\Controller

class QuestionsController extends Controller
{
    ......
    public function store() {
        // create and save tags in tags table properly.
    }

}

in Terminal

>> $questions = App\Question::all();
=> Illuminate\Database\Eloquent\Collection {#833
     all: [
       App\Question {#805
         id: 1,
         title: "This is my development first question",
         slug: "this-is-my-development-first-question",
         details: "<p><strong>Lorem Ipsum</strong> is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's s
tandard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</p>",
         approved: 0,
         created_at: "2017-12-16 06:54:10",
         updated_at: "2017-12-16 06:54:10",
       },
       App\Question {#750
         id: 2,
         title: "This is my development first question",
         slug: "this-is-my-development-first-question",
         details: "<p>This package offers taggable behaviour for your models. After the package is installed the only thing you have to do is to add th
e <code>HasTags</code> trait to an Eloquent model to make it taggable.</p>",
         approved: 0,
         created_at: "2017-12-16 08:25:29",
         updated_at: "2017-12-16 08:25:29",
       },

// no associate tags return
>> $q[0]->tagsWithType('App\Question');
=> Illuminate\Database\Eloquent\Collection {#825
     all: [],
   }

How This will return all the tags that belongs to the given Entity Namespace. like https://cartalyst.com/manual/tags/2.0#get-all-the-tags-from-an-entity-namespace this Provider

Thank you

Hey Spatie -- thanks for all the awesome packages first off. Quick question for you: is compatibility between spatie/laravel-binary-uuid and spatie/laravel-tags on the roadmap?

Is there any reason to use this package in laravel-tags ?

Question: how to create a tag from a slug "examlpe-a" and not from string "Example A"

Is there an easy way to check if a model currently has a tag? Something like $model->hasTag('')?

As mentioned in the Docs,

This package requires Laravel 5.3 or higher, PHP 7.0 or higher and a database that supports json fields such as MySQL 5.7 or higher.

My php version is 7.1.2 operating laravel 5.4 with Mysql database 5.7. When i head to install the package via composer command : composer require spatie/larave-tags it resulted in a dependency error.

As shown in the error log, it requires illuminate/database ~5.5.0 which is i think operates with Laravel 5.5.

I am using version 1.4
On my dev machine it works like a charm, but today I deployed it to my acceptation server and
now I am getting the error message mentioned in the title of this issue, while using Tag::findOrCreate.

When I copy and past the sql statement in the query runner of SequelPro I still get an error message
But when I put quotes around the 'testtag' word, the query run's perfectly

I am using Mysql version 5.7.19 on my dev machine an 5.7.18-6 on my acceptation server
I am using php7.0.10 on my dev machine and php7.0.20 on my dev acceptation server

Another difference I can see is that on my dev machine mysqlnd is loaded, but not on the acceptation server.

Please advice.

Kind regards

Hi there,

Boy I feel kinda stupid for asking this.. specially since there's already two other issues opened regarding extending the tag model and using your own.

So I have my own Tag model to which I want to add all the functionality of your tag model. So that model extends Spatie\Tags\Tag

All good so far

Then, you say "All you need to do is override the getTagClassName method from the HasTags trait."

Sounds simple enough. My question is, since I don't want to edit a vendor file. Does that mean I should create my own trait, so I can extend it with Spatie\Tags\HasTags, and in that trait I should override the

    public static function getTagClassName(): string
    {
        return Tag::class;
    }

method and have it return my custom tag model that extends Spatie\Tags\Tag ?

That's what I would do.. but was wondering if there was another way of overriding the getTagClassName method of the HasTags trait without creating a trait of my own.

Guess I just haven't done a lot of overriding like this in the past.

Thanks!

Perhaps this isn't a bug, but I'm having problems with the format of the tags table. I exported the entire site database in a sql dump. Then I tried to import that file into a staging database. The import goes well until it hits the tags table. Then this error is thrown.

Cannot create a JSON value from a string with CHARACTER SET 'binary'.

I haven't worked with JSON in MySQL before this package. So, I'm sure I'm missing something. Does anyone have experience with this?

withAnyTags and withAllTags returns empty collection when you don't specify $type param, in case Tag has type set. Possibly same problem as in #28

Is this the intended behavior? It doesn't seem to be because I didn't notice any tests for it.

The problem is in

    public static function findFromString(string $name, string $type = null, string $locale = null)
    {
        $locale = $locale ?? app()->getLocale();
        return static::query()
            ->where("name->{$locale}", $name)
            ->where('type', $type)
            ->first();
    }

shouldnt it be?

    public static function findFromString(string $name, string $type = null, string $locale = null)
    {
        $locale = $locale ?? app()->getLocale();
        return static::query()
            ->withType($type)
            ->where("name->{$locale}", $name)
            ->first();
    }

because scopeWithType ignores $type when null

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.

Hi,

Awesome package, but I am having trouble using the types. There is one thing that don't seem to work:

$tag = Tag::create($characteristic, 'beerCharacteristicTag');

returns the following error:

[Symfony\Component\Debug\Exception\FatalThrowableError]

Type error: Argument 1 passed to Illuminate\Database\Eloquent\Model::create() must be of the type array, string given, called in /home/vagrant/Code/beer/app/Console/Commands/ScrapeBeers.php on line 121

where as $tag = Tag::findOrCreate($characteristic, 'beerCharacteristicTag'); works just like it should.

PS. There is a small typo in the documentation. Double colon instead of semi.

$tagWithType = Tag::create('headline', 'newsTag'):

Hello,

I'm suprised deleting the model does not cascade deleting its taggable relationship (like media-library does, for example)

Is it a forgotten feature or is there a real reason (I didn't get yet) for not dropping those orphan relationships ?

Best,

Laurent

Getting this error:
Can't locate path: </home/vagrant/my-project/vendor/spatie/laravel-tags/src/../database/migrations/_create_tag_tables.php.stub>

I suspect the path is incorrect in the service provider?

First of all, thanks for the great work.

While searching for tags i noticed you can only search for the name, not the slug.
Since the slug is normalized it would be easier to search for the slug.

For example i have a tag with the name: Hello.
Model::withAnyTags(['hello'])->get();
Model is not found because the tag contains a uppercase H.

So Hello & hello are not the same.
It would be easier to search for a normalized tag, so uppercase doesn't matter.

Hi,

Apparently we needed to upgrade to php7.1 from 7.0.20 to get mysqlnd working.
But now the csrf token verification is not working anymore.
TokenMismatchException in VerifyCsrfToken.php line 68:

Did you encounter such a error?

thx

Kind Regards

Would you accept a PR that added two new scopes, withoutAnyTags and withoutAllTags?

I'm trying to update a tag, but I'm missing something.

$tag = Tag::findOrFail($id);
$tag->name = $request->name;
$tag->type = $request->type;
$tag->save();

But that throws this

Type error: Return value of Spatie\Tags\Tag::getTranslations() must be of the type array, string returned

I might be doing something wrong here, but the documentation references using your own tag model. I've overridden the get TagClassName method:

use Illuminate\Database\Eloquent\Model;

class YourModel extends Model
{
   public static function getTagClassName(): string
   {
       return YourTagModel::class;
   }
}

However, in the tags method the code still refers to the Tag::class:

public function tags(): MorphToMany
{
        return $this
            ->morphToMany(Tag::class, 'taggable')
            ->orderBy('order_column');
}

Is this intentional and I need to override this method as well or should it use my custom Tag Model?

Thanks

MySQL: 5.7.20
Laravel: 5.5.21
PHP: 7.1.3

Every time I try to add tags I receive this error

Call to undefined method Illuminate\Database\Query\Builder::syncWithoutDetaching()

I've tried using attachTags(), syncTags() and attachTag(), and all give the same error.

$post->attachTags(['one', 'two']);
$post->syncTags(['one', 'two']);
$post->attachTag('tag 1');

I'm attempting to attach tags right after creating a $post

Hi guys,

This one always reset slug, so we couldn't set custom slugs:
https://github.com/spatie/laravel-tags/blob/master/src/HasSlug.php#L12

What do you think about this?

Is it possible to add locale as an optional parameter to pass when calling WithAnyTags or WithAllTags, for that matter, so it can pass it to convertToTags ? Or is there some other way and I'm doing something wrong.

Cheers.

I would appreciate some help with the following problem:
I need to toggle (attach/detach) a tag to a model but to leave any other tags alone.

Consider the following:
There are 4 tags in the DB Tag1, Tag2, Tag3, Tag4
$model has Tag1, Tag2 and Tag3 attached.

I want to call something like a 'toggleTag' function and see the following behaviour:

• $model->toggleTag('Tag1') // $model now has Tag2 & Tag3.
• $model->toggleTag(['Tag3', 'Tag4']) // $model now has Tag2, & Tag4
• $model->toggleTag(['Tag1', 'Tag5']) // $model now has Tag1, Tag2, Tag4 & Tag5 (Tag5 is created, and with type if passed).

I am also doing all this using tag types so I need to allow for that as well.

I must be missing something but I'm struggling to see whether or not a given tag exits on a model (which will allow me to attach, detach or create and attach).

Thanks,

The title says it all.

I'm not sure if this is a bug but on a fresh setup and migration when I try and add an array of tags like:

//I'm using Laravel 5.4.30 with mariadb.

$tags = ['foo', 'bar', 'baz'];
$story-> attachTags($tags); //also tried syncTags

I keep getting the following mysql error:

  [Illuminate\Database\QueryException]
  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"' = foo and `type` is null limit 1)

  [PDOException]
  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

I'm not sure what could be causing this but it looks like it might have something to do with the translation feature? Although I'm not using that and just wanted english tags. It looks like it has something to do with an empty $ variable?

I also get the same issue when trying to add a single tag.

Thanks for your help, the package seems really useful!

Hi

Can you confirm that migrations won't work with current MariaDB because of JSON type that does not exist in Maria ?

Regards

Hi,

Ive set up this package and its been very easy to install and use, so thank you for building it and sharing it 👍

I have gone through the docs on extending the model for this package, but I am not sure how it would actually be implemented. Can you provide more details in the example (here or in the docs) ?

My objective is to extend the tags so the user can add a "color" for each tag (color makes it easy to identify tags, similar to gmail). So If I have a tag for "finance" the color could be could be #0000ff and tag for "medical" could have a color value of #00ff00 etc.
Would this be possible using this package?

I have created a migration to extend the DB fields to add a color field, but where to I keep my custom tag model and how do I reference it in my other models.

I would appreciate it if you can point me in the right direction!

Any easy way to implement soft deletes?

Unless I'm mistaken, there doesn't appear to be any way to sync tags when using 'types' to categorise tags.

Is there a strategy for syncing tags when using the types feature, or any plans to implement this functionality?

Seems like attachTag is acting strangely. It seems to create an additional line, which includes the data for the whole model, not just the tag.

foreach ($characteristics as $characteristic) {
    $tag = Tag::findOrCreate($characteristic);
    $beer->attachTag($tag);
}

Using $beer->syncTags($characteristics); is the workaround but I would like to attach typed tags and you cannot use syncTags for that one.

Thanks for sharing such a great library! I needed a way retrieve a summary of tag usage as an associative array (name => total), but I didn't see an easy way to do this in the library. I added the function below as a helper to my model, but I'm sure there's a more elegant way to do it :).

    public static function getAllTags()
    {
        $tags = DB::table('taggables')
            ->selectRaw('name, count(tag_id) as total')
            ->join('tags', 'tags.id', '=', 'taggables.tag_id')
            ->groupBy('tag_id')
            ->orderBy('name', 'asc')
            ->get();

        // create an associate array as [name => total]
        $tagArray = [];

        foreach($tags as $tag) {
            $name = json_decode($tag->name);
            $tagArray[$name->en] = $tag->total;
        };

        ksort($tagArray); // sort the tags alphabetically by the name key

        return $tagArray;
    }

So I have quite a few tags that I created like this.

$tag = Tag::findOrCreate($request->name, $request->type);

For example:

$request->name = 'web development';
$request->type = 'primary';

The tag gets created. That seems to work fine. Woohoo.
Then, on another page, I tried to attach a model to the tag. I would do this:

$company->syncTags($all_tags);

If "web development" was one of the tags in the $all_tags array, it doesn't get recognized. Instead, another new tag gets created with the exact same name and slug except it has an empty type.

Why does it ignore the tag that already exists?

Might be user error, so bear with me.

Create a new model, Resource in my case:

Then attach a tag (which auto-creates the tag):
Correction: Screenshot shows Resource->attachTags which is incorrect. I just didn't take a new screenshot using correct attachTag('test').

Verify tag was created:

Attempt to retrieve model just created and tagged:

My expected result would be a collection with my one Resource in it. Again, it might be user error too.

Thanks!

Hi,

I'm trying to create a tag with this code: Tag::create(['name' => 'my tag']).

But when I tun the code I get this error: Type error: Return value of Spatie\Tags\Tag::getTranslations() must be of the type array, string returned. I'm using tinker to quickly create a tag.

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

the above code return NewsItem empty