Tags don't work on MySQL

[SoloFlighter]

▶ Reproduction steps

1. Select an image
2. edit it through the popup
3. try to add a single tag or multiple tags
4. switch to a different image or refresh the page and return to the original picture

😢 Unexpected result

The popup closes, but none of the tags are saved. I've checked the new explore page, the dashboard and the image in its album and outside of it.

📃 Error log message
UPDATE ITEM
-----
que mierda

 

[Rodolfo]

Thank you for bringing this to my attention. Currently, the tag functionality is only supported with MariaDB. I apologize for the oversight; I underestimated the differences in SQL syntax between MariaDB and MySQL.

I developed the tags feature using MariaDB on my development machine, and I didn't anticipate such significant variations in SQL compatibility.

I appreciate your patience as I work on implementing support for both database types. It will take a few days to resolve this issue.

 

[SoloFlighter]

You've put in so much work already! Thank you and don't forget to take breaks

 

[nsfwupload]

@Rodolfo Sorry I don't have time to post a bug report but can you look into Tags not being able to be edited by an admin.

When I try to edit someone else image to add additional tags, the Tag is not saved.

After some testing it appears that only the image owner is allowed to add / edit tags. Tags should also be able to be edited by an admin...

PS: Tags appear not to be triggered by stop words too. I've had some images uploaded with forbidden words.

Thanks

 

[Rodolfo]

@nsfwupload The tags implementation in v4.2.0 is compatible only with MariaDB. However, the upcoming tags implementation in v4.2.1 (and future versions) will be compatible with both MySQL and MariaDB.

 

[Rodolfo]

Implemented in Chevereto v4.2.1.