Также проблема с созданием тегов с белого списка с галочками на альт, деск и кустом (в полях есть данные).
Но после удаления всех тегов, не запускается пересоздание тегов.
Your Build 202210140632
mysqli_error.log:
2022-10-17 15:58:13 :: 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 ') GROUP BY tag_id) as B
ON B.tag_id = A.tag_id
SET A.used_counter = B....' at line 2 :: UPDATE rot_tags as A INNER JOIN (SELECT tag_id, COUNT(*) as idcount FROM rot_gal2tag WHERE rot_gal2tag.tag_id IN () GROUP BY tag_id) as B ON B.tag_id = A.tag_id SET A.used_counter = B.idcount WHERE A.tag_id IN ()
2022-10-17 15:59:05 :: 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 ') GROUP BY tag_id) as B
ON B.tag_id = A.tag_id
SET A.used_counter = B....' at line 2 :: UPDATE rot_tags as A INNER JOIN (SELECT tag_id, COUNT(*) as idcount FROM rot_gal2tag WHERE rot_gal2tag.tag_id IN () GROUP BY tag_id) as B ON B.tag_id = A.tag_id SET A.used_counter = B.idcount WHERE A.tag_id IN ()
2022-10-17 16:00:05 :: 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 ') GROUP BY tag_id) as B
ON B.tag_id = A.tag_id
SET A.used_counter = B....' at line 2 :: UPDATE rot_tags as A INNER JOIN (SELECT tag_id, COUNT(*) as idcount FROM rot_gal2tag WHERE rot_gal2tag.tag_id IN () GROUP BY tag_id) as B ON B.tag_id = A.tag_id SET A.used_counter = B.idcount WHERE A.tag_id IN ()
2022-10-17 16:01:05 :: 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 ') GROUP BY tag_id) as B
ON B.tag_id = A.tag_id
SET A.used_counter = B....' at line 2 :: UPDATE rot_tags as A INNER JOIN (SELECT tag_id, COUNT(*) as idcount FROM rot_gal2tag WHERE rot_gal2tag.tag_id IN () GROUP BY tag_id) as B ON B.tag_id = A.tag_id SET A.used_counter = B.idcount WHERE A.tag_id IN ()
2022-10-17 16:02:04 :: 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 ') GROUP BY tag_id) as B
ON B.tag_id = A.tag_id
SET A.used_counter = B....' at line 2 :: UPDATE rot_tags as A INNER JOIN (SELECT tag_id, COUNT(*) as idcount FROM rot_gal2tag WHERE rot_gal2tag.tag_id IN () GROUP BY tag_id) as B ON B.tag_id = A.tag_id SET A.used_counter = B.idcount WHERE A.tag_id IN ()
2022-10-17 16:02:36 :: 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 ') GROUP BY tag_id) as B
ON B.tag_id = A.tag_id
SET A.used_counter = B....' at line 2 :: UPDATE rot_tags as A INNER JOIN (SELECT tag_id, COUNT(*) as idcount FROM rot_gal2tag WHERE rot_gal2tag.tag_id IN () GROUP BY tag_id) as B ON B.tag_id = A.tag_id SET A.used_counter = B.idcount WHERE A.tag_id IN ()
2022-10-17 16:03:03 :: 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 ') GROUP BY tag_id) as B
ON B.tag_id = A.tag_id
SET A.used_counter = B....' at line 2 :: UPDATE rot_tags as A INNER JOIN (SELECT tag_id, COUNT(*) as idcount FROM rot_gal2tag WHERE rot_gal2tag.tag_id IN () GROUP BY tag_id) as B ON B.tag_id = A.tag_id SET A.used_counter = B.idcount WHERE A.tag_id IN ()