что-то с тэгами

Post Reply
serge
Posts: 929
Joined: Mon Mar 14, 2011 7:53 am

что-то с тэгами

Post 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
rembo1978
Posts: 540
Joined: Thu Jul 26, 2012 5:12 am

Re: что-то с тэгами

Post 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 ()
admin
Site Admin
Posts: 37994
Joined: Wed Sep 10, 2008 11:43 am

Re: что-то с тэгами

Post by admin »

да, сорри, это еслинет тагов, поправил в апедйте
Don't forget to run script update
Post Reply