После установки плагина [XFA] Tournament - XF2 возникла ошибка: #1052 - Column 'title' in where clause is ambiguous
Проблема связана с запросом к базе данных:
Отключается форум:
Журнал ошибок сервера:
Данные сервера:
Проблема связана с запросом к базе данных:
Код:
SELECT `xf_thread`.`thread_id`
FROM `xf_thread`
LEFT JOIN `xfa_tourn_tournament` AS `xfa_tourn_tournament_Tournament_1` ON (`xfa_tourn_tournament_Tournament_1`.`discussion_thread_id` = `xf_thread`.`thread_id`)
WHERE (title RLIKE '[[:<:]]test[[:>:]]') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` \>= 0\) AND \(`xf_thread`.`thread_id` <> 9) AND ((`xf_thread`.`node_id` = 5)) AND (1)
ORDER BY `xf_thread`.`post_date` DESC
Отключается форум:
Код:
XF\Db\Exception: MySQL statement prepare error [1052]: Column 'title' in where clause is ambiguous in src/XF/Db/AbstractStatement.php at line 228
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1423
XF\Mvc\Entity\Finder->fetchRaw() in src/XF/Mvc/Entity/Finder.php at line 1438
XF\Mvc\Entity\Finder->fetchColumns() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 219
Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/UW/FCS/Extend/Pub/Controller/Thread.php at line 87
UW\FCS\Extend\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
XFMG\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2326
XF\App->run() in src/XF.php at line 488
XF::runApp() in index.php at line 20
Журнал ошибок сервера:
Код:
XF\Db\Exception: MySQL statement prepare error [1052]: Column 'title' in where clause is ambiguous src/XF/Db/AbstractStatement.php:228
Трассировка стека
SELECT `xf_thread`.`thread_id`
FROM `xf_thread`
LEFT JOIN `xfa_tourn_tournament` AS `xfa_tourn_tournament_Tournament_1` ON (`xfa_tourn_tournament_Tournament_1`.`discussion_thread_id` = `xf_thread`.`thread_id`)
WHERE (title RLIKE '[[:<:]]123[[:>:]]') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 6) AND ((`xf_thread`.`node_id` = 8)) AND (1)
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 50
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1052, '23000')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1052, '23000')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Mvc/Entity/Finder.php(1423): XF\Db\AbstractAdapter->query('
SELECT `xf_...')
#5 src/XF/Mvc/Entity/Finder.php(1438): XF\Mvc\Entity\Finder->fetchRaw(Array)
#6 src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php(302): XF\Mvc\Entity\Finder->fetchColumns(Array)
#7 src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php(54): Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads(8, 6, '123')
#8 src/addons/UW/FCS/Extend/Pub/Controller/Thread.php(87): Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#9 src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php(11): UW\FCS\Extend\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#10 src/addons/XFMG/XF/Pub/Controller/Thread.php(11): XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(350): XFMG\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Index', Object(XF\Mvc\RouteMatch), Object(SV\AdvancedBbCodesPack\XF\Pub\Controller\Thread), NULL)
#13 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\AdvancedBbCodesPack\XF\Pub\Controller\Thread), NULL)
#14 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#15 src/XF/App.php(2326): XF\Mvc\Dispatcher->run()
#16 src/XF.php(488): XF\App->run()
#17 index.php(20): XF::runApp('XF\\Pub\\App')
#18 {main}
Данные сервера:
Код:
Версия PHP 7.4.14
Версия MySQL 5.7.27 (5.7.27-30)
Программное обеспечение сервера Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips mod_fcgid/2.3.9 Phusion_Passenger/5.3.7
PHP memory_limit 1024M
PHP post_max_size 128M
PHP upload_max_filesize 128M
PHP max_input_vars 10000
PHP max_execution_time 300
Версия cURL 7.69.1
Версия cURL SSL OpenSSL/1.0.2k-fips
Версия OpenSSL OpenSSL 1.0.2k 26 Jan 2017
Suhosin включён Нет
Поддержка Imagick Да
Поддержка EXIF Да
Поддержка GZip Да
Поддержка mbstring Да
Поддержка gmp Да
Поддержка ZipArchive Да