Ошибка отображения Infolog для EGW 1.6

classic Classic list List threaded Threaded
1 message Options
ekurensky ekurensky
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Ошибка отображения Infolog для EGW 1.6

This post has NOT been accepted by the mailing list yet.
Ошибка появляется при добавлении ссылки из календаря на запись в журнале:

[Wed Feb 15 11:53:30.792584 2017] [:error] [pid 4098] [client 95.156.85.58:39822] An error happened (PDOException): SQLSTATE[22P02]: Invalid text representation: 7 \xd0\x9e\xd0\xa8\xd0\x98\xd0\x91\xd0\x9a\xd0\x90:  \xd0\xbd\xd0\xb5\xd0\xb2\xd0\xb5\xd1\x80\xd0\xbd\xd0\xbe\xd0\xb5 \xd0\xb7\xd0\xbd\xd0\xb0\xd1\x87\xd0\xb5\xd0\xbd\xd0\xb8\xd0\xb5 \xd0\xb4\xd0\xbb\xd1\x8f \xd1\x86\xd0\xb5\xd0\xbb\xd0\xbe\xd0\xb3\xd0\xbe \xd1\x87\xd0\xb8\xd1\x81\xd0\xbb\xd0\xb0: "#bf0418097486f92a1ad0036a530555d8", referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792669 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #0 /usr/share/egroupware/api/src/Vfs/Sqlfs/StreamWrapper.php(812): PDOStatement->execute(Array), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792679 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #1 [internal function]: EGroupware\\Api\\Vfs\\Sqlfs\\StreamWrapper->rmdir('links://default...', 8), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792688 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #2 /usr/share/egroupware/api/src/Vfs/StreamWrapper.php(693): rmdir('links://default...'), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792696 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #3 /usr/share/egroupware/api/src/Vfs.php(767): EGroupware\\Api\\Vfs\\StreamWrapper->rmdir('links://default...', 0), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792704 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #4 [internal function]: EGroupware\\Api\\Vfs::_rm_rmdir('links://default...', Array), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792711 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #5 /usr/share/egroupware/api/src/Vfs.php(595): call_user_func_array('EGroupware\\Api\\...', Array), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792719 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #6 /usr/share/egroupware/api/src/Vfs.php(749): EGroupware\\Api\\Vfs::find('links://default...', Array, 'EGroupware\\Api\\...'), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792727 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #7 /usr/share/egroupware/api/src/Link.php(1272): EGroupware\\Api\\Vfs::remove('links://default...', true), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792735 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #8 /usr/share/egroupware/api/src/Link.php(669): EGroupware\\Api\\Link::delete_attached('calendar', '443'), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792742 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #9 /usr/share/egroupware/api/src/Link.php(632): EGroupware\\Api\\Link::unlink2(0, 'calendar', '443', 0, '', '', false), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792750 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #10 /usr/share/egroupware/api/src/Link.php(822): EGroupware\\Api\\Link::unlink(0, 'calendar', '443'), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792758 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #11 /usr/share/egroupware/api/src/Link.php(865): EGroupware\\Api\\Link::title('calendar', '443'), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792787 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #12 /usr/share/egroupware/api/src/Link.php(567): EGroupware\\Api\\Link::titles('calendar', Array), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792795 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #13 /usr/share/egroupware/infolog/inc/class.infolog_ui.inc.php(459): EGroupware\\Api\\Link::get_links_multiple('infolog', Array, true, '', 'link_lastmod DE...', true), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792803 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #14 /usr/share/egroupware/api/src/Etemplate/Widget/Nextmatch.php(605): infolog_ui->get_rows(Array, Array, Array), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792810 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #15 /usr/share/egroupware/api/src/Etemplate/Widget/Nextmatch.php(185): EGroupware\\Api\\Etemplate\\Widget\\Nextmatch::call_get_rows(Array, Array, Array, NULL, NULL, Object(EGroupware\\Api\\Etemplate\\Widget\\Nextmatch)), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792819 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #16 [internal function]: EGroupware\\Api\\Etemplate\\Widget\\Nextmatch->beforeSendToClient('', Array), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792826 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #17 /usr/share/egroupware/api/src/Etemplate/Widget.php(512): call_user_func_array(Array, Array), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792833 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #18 /usr/share/egroupware/api/src/Etemplate/Widget/Nextmatch.php(1127): EGroupware\\Api\\Etemplate\\Widget->run('beforeSendToCli...', Array, false), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792840 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #19 /usr/share/egroupware/api/src/Etemplate/Widget/Grid.php(150): EGroupware\\Api\\Etemplate\\Widget\\Nextmatch->run('beforeSendToCli...', Array, false, Array), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792848 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #20 /usr/share/egroupware/api/src/Etemplate/Widget/Grid.php(150): EGroupware\\Api\\Etemplate\\Widget\\Grid->run('beforeSendToCli...', Array, false, Array), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792855 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #21 /usr/share/egroupware/api/src/Etemplate/Widget/Grid.php(150): EGroupware\\Api\\Etemplate\\Widget\\Grid->run('beforeSendToCli...', Array, false, Array), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792863 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #22 /usr/share/egroupware/api/src/Etemplate/Widget.php(518): EGroupware\\Api\\Etemplate\\Widget\\Grid->run('beforeSendToCli...', Array, false), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792870 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #23 /usr/share/egroupware/api/src/Etemplate/Widget/Template.php(264): EGroupware\\Api\\Etemplate\\Widget->run('beforeSendToCli...', Array, false), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792877 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #24 /usr/share/egroupware/api/src/Etemplate.php(162): EGroupware\\Api\\Etemplate\\Widget\\Template->run('beforeSendToCli...', Array), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792885 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #25 /usr/share/egroupware/infolog/inc/class.infolog_ui.inc.php(1007): EGroupware\\Api\\Etemplate->exec('infolog.infolog...', Array, Array, Array, Array, 0), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792899 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #26 /usr/share/egroupware/api/src/Framework/Ajax.php(1007): infolog_ui->index(), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792907 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #27 [internal function]: EGroupware\\Api\\Framework\\Ajax->ajax_exec('index.php?menua...'), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792914 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #28 /usr/share/egroupware/api/src/Json/Request.php(179): call_user_func_array(Array, Array), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792921 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #29 /usr/share/egroupware/api/src/Json/Request.php(91): EGroupware\\Api\\Json\\Request->handleRequest('infolog.jdots_f...', Array), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792928 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #30 /usr/share/egroupware/json.php(119): EGroupware\\Api\\Json\\Request->parseRequest('infolog.jdots_f...', '{"request":{"pa...'), referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792936 2017] [:error] [pid 4098] [client 95.156.85.58:39822] #31 {main}, referer: https://egw.novaris.ru/egroupware/index.php?cd=yes
[Wed Feb 15 11:53:30.792958 2017] [:error] [pid 4098] [client 95.156.85.58:39822] # Instance=default, User=kur, Request=POST https://egw.novaris.ru?menuaction=infolog.infolog_ui.index&ajax=true, User-agent=Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:51.0) Gecko/20100101 Firefox/51.0, referer: https://egw.novaris.ru/egroupware/index.php?cd=yes




При этом в БД:

< 2017-02-15 11:53:30.790 +07 >ОШИБКА:  неверное значение для целого числа: "#bf0418097486f92a1ad0036a530555d8"
< 2017-02-15 11:53:30.790 +07 >ОПЕРАТОР:  SELECT COUNT(*) FROM egw_sqlfs WHERE fs_dir=$1



Как временное решение выполнил проверку на номер:

в файле: /usr/share/egroupware/api/src/Vfs/Sqlfs/StreamWrapper.php

                }
# стр 811. проверка на номер!
                if (!is_numeric($stat['ino'])) {
                        return 0;
                }
#
                $stmt = self::$pdo->prepare('SELECT COUNT(*) FROM '.self::TABLE.' WHERE fs_dir=?');
                $stmt->execute(array($stat['ino']));


Информация по установленной системе:

Версия EGroupware 16.1.20170203
БД: postgresql-9.4.11
ОС: CentOS Linux release 7.3.1611 (Core) Linux egw.novaris.ru 3.10.0-514.6.1.el7.x86_64 #1 SMP Wed Jan 18 13:06:36 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux

Кому сообщить можно о проблеме?


Loading...