Thanks Teodor
fantastic tutorial very well done, and in fact it worked right.
I just have a little problem that I can’t solve
Everything works as far as tag management is concerned, but the insert page with the category field only saves if I choose a single tag
If I choose more, it blocks and reports an error
Maybe it’s a problem with the action?
Well how is your insert action set up? How do you store categories?
Are you following this:
?
How are you saving the categories? Are you not storing them in a separate table?
Are you following the tutorial with the multi reference i linked above or not?
The categories are in a database table and work, they are read and proposed in the drop-down menu and are added if you create new categories
In the news database the category field is saved with the category number, but only if it is only a chosen category
If I choose two or more it crashes
Sorry Teodor
I have now found that unexpected behavior occurs suddenly. I have to review the procedures because there is obviously a setting error
In practice, if I choose a category from those proposed, the number appears to me and not the category
@Teodor
After reviewing all Tagify procedures and related actions:
Now if I choose a category from the drop-down menu with available categories and then save the record everything works
The “Category” field of the saved record shows the Category ID value
And the creation of a new category not present in the list also works perfectly, which is saved both in the “category” field and in the categories table
It is therefore listed in a new record insert operation
But I still have the problem that if I insert more categories, the record insertion operation stops and returns an error
I really don’t understand why
Ok so can you answer:
categories are regularly saved in a separate “categories” table
it all works when I choose a single category
if I choose for example the category “test1” in the saved record the category field is present the number corresponding to the chosen category
if instead I insert a new category everything is ok for the record and the new category is saved in the “categories” table
the only problem is that only accept single categories and I cannot choose more than one
to be more precise it allows me to choose multiple categories, but then it doesn’t save the record
The tagify extension send the data as an array to the server side. If you are not using a multi reference created in Wappler database manager and a sub table for insert as explained in the docs above then you need a repeat, which repeats the tagify values and a separate insert inside the repeat which saves the categories in the reference table related to the article id.
@Teodor
Sorry i am trying to set it up correctly but i am a little confused
I have two tables already created in the database
The NEWS table that is used by a page with an insertion form, to create new news (newsID - … - category)
The CATEGORIE table (categoriaID - categoria)
As mentioned, everything works if by inserting a new record I associate a single categoria, choosing it from the list, and if necessary creating a new categora that is added to the CATEGORIE table
At this point, if I understand, do I have to create a New Multi References in the NEWS table by taking from the CATEGORIE folder?
To do this, I deleted the categoria field from the NEWS folder, because otherwise I would not be able to associate another field with the same name
I don’t think it’s correct, also because it gives me an error
@Teodor
I’ve tried dozens of times resetting and refreshing each time, but when I try to run “New multi Reference” I can’t save because it gives an error
I do not know what to do
this my table news and table catergory
@Teodor
sorry if i insist, but i should fix this
After many attempts, creating the references between the two tables, when saving it always gives me an error.
However then I see that it still creates a further table with the relations and if I visualize the relative change with the editor, it seems to me that it can still be corrected
The problem is whether it will work correctly or will it cause me errors
You can tell me something?
Maybe you just have a similar issue like here:
so you just need to switch to Advanced in database manager and select your relations from the dropdown if they are missing.
@Teodor
I tried with what is proposed by the movie, but it doesn’t work for me anyway.
Registrazione schermo 2022-04-09 alle 15.51.21
@ Teodor
I’ve tried them all. I no longer know what to invent to be able to create a tagify multi-reference.
Maybe because the site I’m working on is NodeJS or Mac OS?
Or maybe because the mySql database was created in Ubuntu on Hetzner Cloud Server?
or perhaps …
@Teodor
in fact I had some tables imported from another project configured myISAM
I then converted all the tables to InnoDB, but unfortunately the “multi references” problem remains
@Teodor i have same problem as @Marzio has. mine is more simpler, users, roles is table
users has roles(multi reference). I added insertUser action and inputs as stated in tagify exmaple that you did on docs(meetins and attendes). but insert action become success, user added to users table but roles has no user id value and role id value. its empty. no data.
please help , there is no errors.
