После обновления перестал работать Tickets
Добрый день.
Обновил Tickets и у меня перестали выводится секции тикетов.
Вызов совершенно стандартный:
Обновил Tickets и у меня перестали выводится секции тикетов.
Вызов совершенно стандартный:
[[!getTicketsSections?]]
В результате showLog выдает такую штуку:0.0110729: Query parameters are prepared.В журнале ошибок MODX следующее:
0.0001209: xPDO query object created
0.0046761: leftJoined TicketTotal as Total
0.0000100: Grouped by TicketsSection.id
0.0001552: Added selection of TicketsSection: SQL_CALC_FOUND_ROWS `id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `richtext`, `template`, `menuindex`, `searchable`, `cacheable`, `createdby`, `createdon`, `editedby`, `editedon`, `deleted`, `deletedon`, `deletedby`, `publishedon`, `publishedby`, `menutitle`, `donthit`, `privateweb`, `privatemgr`, `content_dispo`, `hidemenu`, `class_key`, `context_key`, `content_type`, `uri`, `uri_override`, `hide_children_in_tree`, `show_in_tree`, `properties`
0.0001960: Added selection of TicketTotal: `tickets`, `comments`, `views`, `stars`, `rating`, `rating_plus`, `rating_minus`
0.0019131: Processed additional conditions
0.0025828: Added where condition: class_key=TicketsSection, TicketsSection.parent:IN(231), TicketsSection.published=1, TicketsSection.hidemenu=0, TicketsSection.deleted=0
0.0001230: Sorted by views, DESC
0.0000110: Limited to 10, offset 0
0.0005600: SQL prepared «SELECT SQL_CALC_FOUND_ROWS `TicketsSection`.`id`, `TicketsSection`.`type`, `TicketsSection`.`contentType`, `TicketsSection`.`pagetitle`, `TicketsSection`.`longtitle`, `TicketsSection`.`description`, `TicketsSection`.`alias`, `TicketsSection`.`link_attributes`, `TicketsSection`.`published`, `TicketsSection`.`pub_date`, `TicketsSection`.`unpub_date`, `TicketsSection`.`parent`, `TicketsSection`.`isfolder`, `TicketsSection`.`introtext`, `TicketsSection`.`richtext`, `TicketsSection`.`template`, `TicketsSection`.`menuindex`, `TicketsSection`.`searchable`, `TicketsSection`.`cacheable`, `TicketsSection`.`createdby`, `TicketsSection`.`createdon`, `TicketsSection`.`editedby`, `TicketsSection`.`editedon`, `TicketsSection`.`deleted`, `TicketsSection`.`deletedon`, `TicketsSection`.`deletedby`, `TicketsSection`.`publishedon`, `TicketsSection`.`publishedby`, `TicketsSection`.`menutitle`, `TicketsSection`.`donthit`, `TicketsSection`.`privateweb`, `TicketsSection`.`privatemgr`, `TicketsSection`.`content_dispo`, `TicketsSection`.`hidemenu`, `TicketsSection`.`class_key`, `TicketsSection`.`context_key`, `TicketsSection`.`content_type`, `TicketsSection`.`uri`, `TicketsSection`.`uri_override`, `TicketsSection`.`hide_children_in_tree`, `TicketsSection`.`show_in_tree`, `TicketsSection`.`properties`, `Total`.`tickets`, `Total`.`comments`, `Total`.`views`, `Total`.`stars`, `Total`.`rating`, `Total`.`rating_plus`, `Total`.`rating_minus` FROM `modx_site_content` AS `TicketsSection` LEFT JOIN `modx_tickets_totals` `Total` ON WHERE ( `TicketsSection`.`class_key` = 'TicketsSection' AND `TicketsSection`.`parent` IN (231) AND `TicketsSection`.`published` = 1 AND `TicketsSection`.`hidemenu` = 0 AND `TicketsSection`.`deleted` = 0 ) GROUP BY TicketsSection.id ORDER BY views DESC LIMIT 10 „
0.0003810: Could not process query, error #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 'WHERE ( `TicketsSection`.`class_key` = 'TicketsSection' AND `TicketsSection`.`p' at line 1
0.0000110: Returning processed chunks
0.0214300: Total time
9 699 328: Memory usage
(ERROR @ /index.php) [pdoTools] Error 42000: 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 'WHERE ( `TicketsSection`.`class_key` = 'TicketsSection' AND `TicketsSection`.`p' at line 1
Комментарии: 2
может сюда глянь <a href="https://modx.pro/help/10054/">
Проблема решена. Помогло удаление pdoTools и Tickets, потом чистая установка заново.
Авторизуйтесь или зарегистрируйтесь, чтобы оставлять комментарии.