Page 1 of 1
что-то с тэгами
Posted: Sun Oct 16, 2022 8:55 am
by serge
после апа кое-где появилась подобная ошибка:
2022-10-16 03:51:02 : Mysql error 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 ') GROUP BY tag_id) as B
ON B.tag_id = A.tag_id
SET A.used_counter = B.idc' 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 () )
отображение тэгов (<!--ESCAPED_STRIP_SPECIAL_CHARS_TAG1-->) при этом не работает
Your Build 202210140632 (Current build: 202210140632 ) PHP version 7.2.33 Mysql Version: 5.7.29
Re: что-то с тэгами
Posted: Mon Oct 17, 2022 4:53 am
by rembo1978
Также проблема с созданием тегов с белого списка с галочками на альт, деск и кустом (в полях есть данные).
Но после удаления всех тегов, не запускается пересоздание тегов.
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 ()
Re: что-то с тэгами
Posted: Tue Oct 18, 2022 8:32 am
by admin
да, сорри, это еслинет тагов, поправил в апедйте