>Форум Mozilla Россия http://forum.mozilla-russia.org/index.php >Bugzilla http://forum.mozilla-russia.org/viewforum.php?id=35 >Оповещения (whine) на Linux http://forum.mozilla-russia.org/viewtopic.php?id=45822 |
small75 > 30-08-2010 14:29:29 |
в кроне добавил строку: крон выводит ошибку: скрытый текст Use of uninitialized value in concatenation (.) or string at Bugzilla/Search.pm line 914. Use of uninitialized value in string eq at Bugzilla/Search.pm line 950. Use of uninitialized value in string eq at Bugzilla/Search.pm line 950. Use of uninitialized value in string eq at Bugzilla/Search.pm line 950. Use of uninitialized value in string eq at Bugzilla/Search.pm line 950. Use of uninitialized value in string eq at Bugzilla/Search.pm line 950. Use of uninitialized value in string eq at Bugzilla/Search.pm line 950. Use of uninitialized value in join or string at Bugzilla/Search.pm line 960. DBD::mysql::st execute failed: 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 'AS rep_platform, SUBSTRING(map_assigned_to.login_name FROM 1 FOR INSTR(CAST(map_' at line 1 [for Statement "SELECT bugs.bug_id AS bug_id, bugs.bug_severity AS bug_severity, bugs.priority AS priority, AS rep_platform, SUBSTRING(map_assigned_to.login_name FROM 1 FOR INSTR(CAST(map_assigned_to.login_name AS BINARY), CAST('@' AS BINARY)) - 1) AS assigned_to, bugs.bug_status AS bug_status, bugs.resolution AS resolution, bugs.short_desc AS short_desc FROM bugs INNER JOIN profiles AS map_assigned_to ON (bugs.assigned_to = map_assigned_to.userid) LEFT JOIN bug_group_map ON bug_group_map.bug_id = bugs.bug_id AND bug_group_map.group_id NOT IN (10,8,18,17) LEFT JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who = 3 WHERE (( bugs.bug_status IN ('NEW','ASSIGNED','REOPENED') )) AND ((bugs.assigned_to = 3)) AND bugs.creation_ts IS NOT NULL AND ((bug_group_map.group_id IS NULL) OR (bugs.reporter_accessible = 1 AND bugs.reporter = 3) OR (bugs.cclist_accessible = 1 AND cc.who IS NOT NULL) OR (bugs.assigned_to = 3) OR (bugs.qa_contact = 3) ) GROUP BY bugs.bug_id"] at ./whine.pl line 449 main::run_queries('HASH(0x863ce7c)') called at ./whine.pl line 317 В чЁм может быть проблема? Параметры сервера. Ubuntu 8 скрытый текст This is perl, v5.8.8 built for i486-linux-gnu-thread-multi --- * Bugzilla 3.4.6 на Perl 5.8.8 Проверка модулей Perl... Проверка установленных модулей Perl DBD... Следующие модули Perl рекомендуются: Подробности здесь |
Tuchka_84 > 31-08-2010 10:19:25 |
Скорей всего проблема именно в DBD-mysql (v4.00) ОК: найден v4.005 .Только почему сама багзила на этот запрос не ругается не знаю. Поищите где в этом запросе вызывается функция , которой нет в 4 -ой версии mysql и попробуйте заменить. Либо попробуйте обновить mysql до 5-ой версии и посмотрите там. |
small75 > 31-08-2010 10:47:36 |
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline |