[Time Sheet] Error calling time sheet list

Old eGW-users
1

When I try to open the general time-sheet list from the left-panel menu, I get this error:

An error happened

SQLSTATE[22P02]: Invalid text representation: 7 ERRORE: sintassi di input non valida per il tipo integer: “#f80b718aaae9446ae677373055973f02”

This is the apache log error file:

[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] An error happened (PDOException): SQLSTATE[22P02]: Invalid text representation: 7 ERRORE: sintassi di input non valida per il tipo integer: “#f80b718aaae9446ae677373055973f02”, referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #0 D:\sti\www\htdocs\egroupware\api\src\Vfs\Sqlfs\StreamWrapper.php(812): PDOStatement->execute(Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #1 [internal function]: EGroupware\Api\Vfs\Sqlfs\StreamWrapper->rmdir(‘links://default…’, 8), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #2 D:\sti\www\htdocs\egroupware\api\src\Vfs\StreamWrapper.php(693): rmdir(‘links://default…’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #3 D:\sti\www\htdocs\egroupware\api\src\Vfs.php(767): EGroupware\Api\Vfs\StreamWrapper->rmdir(‘links://default…’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #4 [internal function]: EGroupware\Api\Vfs::_rm_rmdir(‘links://default…’, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #5 D:\sti\www\htdocs\egroupware\api\src\Vfs.php(595): call_user_func_array(‘EGroupware\\Api\\…’, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #6 D:\sti\www\htdocs\egroupware\api\src\Vfs.php(749): EGroupware\Api\Vfs::find(Array, Array, ‘EGroupware\\Api\\…’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #7 D:\sti\www\htdocs\egroupware\api\src\Link.php(1272): EGroupware\Api\Vfs::remove(‘links://default…’, true), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #8 D:\sti\www\htdocs\egroupware\api\src\Link.php(669): EGroupware\Api\Link::delete_attached(‘projectmanager’, ‘5’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #9 D:\sti\www\htdocs\egroupware\api\src\Link.php(632): EGroupware\Api\Link::unlink2(0, ‘projectmanager’, ‘5’, 0, ‘’, ‘’, false), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #10 D:\sti\www\htdocs\egroupware\api\src\Link.php(822): EGroupware\Api\Link::unlink(0, ‘projectmanager’, ‘5’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #11 D:\sti\www\htdocs\egroupware\timesheet\inc\class.timesheet_bo.inc.php(960): EGroupware\Api\Link::title(‘projectmanager’, ‘5’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #12 D:\sti\www\htdocs\egroupware\api\src\Storage\Base.php(1106): timesheet_bo->db2data(Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #13 D:\sti\www\htdocs\egroupware\api\src\Storage.php(430): EGroupware\Api\Storage\Base->search(Array, false, ‘ORDER BY ts_sta…’, Array, ‘’, false, ‘AND’, 0, Array, ‘’, false), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #14 D:\sti\www\htdocs\egroupware\timesheet\inc\class.timesheet_bo.inc.php(537): EGroupware\Api\Storage->search(Array, false, ‘ts_start DESC’, Array, ‘’, false, ‘AND’, Array, Array, ‘’, false), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #15 D:\sti\www\htdocs\egroupware\api\src\Storage\Base.php(1509): timesheet_bo->search(Array, false, ‘ts_start DESC’, Array, ‘’, false, ‘AND’, Array, Array, ‘’, false), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #16 D:\sti\www\htdocs\egroupware\api\src\Storage.php(375): EGroupware\Api\Storage\Base->get_rows(Array, Array, ‘’, false, false, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #17 D:\sti\www\htdocs\egroupware\timesheet\inc\class.timesheet_ui.inc.php(704): EGroupware\Api\Storage->get_rows(Array, Array, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #18 D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget\Nextmatch.php(605): timesheet_ui->get_rows(Array, Array, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #19 D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget\Nextmatch.php(185): EGroupware\Api\Etemplate\Widget\Nextmatch::call_get_rows(Array, Array, Array, Object(timesheet_ui), ‘get_rows’, Object(EGroupware\Api\Etemplate\Widget\Nextmatch)), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #20 [internal function]: EGroupware\Api\Etemplate\Widget\Nextmatch->beforeSendToClient(’’, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #21 D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget.php(512): call_user_func_array(Array, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #22 D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget\Nextmatch.php(1127): EGroupware\Api\Etemplate\Widget->run(‘beforeSendToCli…’, Array, false), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #23 D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget.php(518): EGroupware\Api\Etemplate\Widget\Nextmatch->run(‘beforeSendToCli…’, Array, false), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #24 D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget\Template.php(264): EGroupware\Api\Etemplate\Widget->run(‘beforeSendToCli…’, Array, false), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #25 D:\sti\www\htdocs\egroupware\api\src\Etemplate.php(162): EGroupware\Api\Etemplate\Widget\Template->run(‘beforeSendToCli…’, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #26 D:\sti\www\htdocs\egroupware\timesheet\inc\class.timesheet_ui.inc.php(971): EGroupware\Api\Etemplate->exec(‘timesheet.times…’, Array, Array, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #27 D:\sti\www\htdocs\egroupware\api\src\Framework\Ajax.php(1007): timesheet_ui->index(), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #28 [internal function]: EGroupware\Api\Framework\Ajax::ajax_exec(‘index.php?menua…’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #29 D:\sti\www\htdocs\egroupware\api\src\Json\Request.php(179): call_user_func_array(Array, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #30 D:\sti\www\htdocs\egroupware\api\src\Json\Request.php(91): EGroupware\Api\Json\Request->handleRequest(‘timesheet.jdots…’, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #31 D:\sti\www\htdocs\egroupware\json.php(119): EGroupware\Api\Json\Request->parseRequest(‘timesheet.jdots…’, ‘{“request”:{"pa…’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] #32 {main}, referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client 192.168.0.101:53887] # Instance=default, User=STI-AM, Request=POST http://x.y.z.w?menuaction=timesheet.timesheet_ui.index&ajax=true, User-agent=Mozilla/5.0 (Windows NT 6.1; WOW64; rv:50.0) Gecko/20100101 Firefox/50.0, referer: http://x.y.z.w/egroupware/index.php?cd=yes

2

Hi,

can you post the line above, it should contain the SQL statement.

Ralf

When I try to open the general time-sheet list from the left-panel menu, I
get this error:

/An error happened

SQLSTATE[22P02]: Invalid text representation: 7 ERRORE: sintassi di input
non valida per il tipo integer: “#f80b718aaae9446ae677373055973f02”/

This is the apache log error file:

/[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] An error happened (PDOException): SQLSTATE[22P02]:
Invalid text representation: 7 ERRORE: sintassi di input non valida per il
tipo integer: “#f80b718aaae9446ae677373055973f02”, referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #0
D:\sti\www\htdocs\egroupware\api\src\Vfs\Sqlfs\StreamWrapper.php(812):
PDOStatement->execute(Array), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #1 [internal function]:
EGroupware\Api\Vfs\Sqlfs\StreamWrapper->rmdir(‘links://default…’, 8),
referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #2
D:\sti\www\htdocs\egroupware\api\src\Vfs\StreamWrapper.php(693):
rmdir(‘links://default…’), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #3
D:\sti\www\htdocs\egroupware\api\src\Vfs.php(767):
EGroupware\Api\Vfs\StreamWrapper->rmdir(‘links://default…’), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #4 [internal function]:
EGroupware\Api\Vfs::_rm_rmdir(‘links://default…’, Array), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #5
D:\sti\www\htdocs\egroupware\api\src\Vfs.php(595):
call_user_func_array(‘EGroupware\\Api\\…’, Array), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #6
D:\sti\www\htdocs\egroupware\api\src\Vfs.php(749):
EGroupware\Api\Vfs::find(Array, Array, ‘EGroupware\\Api\\…’),
referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #7
D:\sti\www\htdocs\egroupware\api\src\Link.php(1272):
EGroupware\Api\Vfs::remove(‘links://default…’, true), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #8
D:\sti\www\htdocs\egroupware\api\src\Link.php(669):
EGroupware\Api\Link::delete_attached(‘projectmanager’, ‘5’), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #9
D:\sti\www\htdocs\egroupware\api\src\Link.php(632):
EGroupware\Api\Link::unlink2(0, ‘projectmanager’, ‘5’, 0, ‘’, ‘’, false),
referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #10
D:\sti\www\htdocs\egroupware\api\src\Link.php(822):
EGroupware\Api\Link::unlink(0, ‘projectmanager’, ‘5’), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #11
D:\sti\www\htdocs\egroupware\timesheet\inc\class.timesheet_bo.inc.php(960):
EGroupware\Api\Link::title(‘projectmanager’, ‘5’), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #12
D:\sti\www\htdocs\egroupware\api\src\Storage\Base.php(1106):
timesheet_bo->db2data(Array), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #13
D:\sti\www\htdocs\egroupware\api\src\Storage.php(430):
EGroupware\Api\Storage\Base->search(Array, false, ‘ORDER BY ts_sta…’,
Array, ‘’, false, ‘AND’, 0, Array, ‘’, false), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #14
D:\sti\www\htdocs\egroupware\timesheet\inc\class.timesheet_bo.inc.php(537):
EGroupware\Api\Storage->search(Array, false, ‘ts_start DESC’, Array, ‘’,
false, ‘AND’, Array, Array, ‘’, false), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #15
D:\sti\www\htdocs\egroupware\api\src\Storage\Base.php(1509):
timesheet_bo->search(Array, false, ‘ts_start DESC’, Array, ‘’, false, ‘AND’,
Array, Array, ‘’, false), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #16
D:\sti\www\htdocs\egroupware\api\src\Storage.php(375):
EGroupware\Api\Storage\Base->get_rows(Array, Array, ‘’, false, false,
Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #17
D:\sti\www\htdocs\egroupware\timesheet\inc\class.timesheet_ui.inc.php(704):
EGroupware\Api\Storage->get_rows(Array, Array, Array), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #18
D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget\Nextmatch.php(605):
timesheet_ui->get_rows(Array, Array, Array), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #19
D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget\Nextmatch.php(185):
EGroupware\Api\Etemplate\Widget\Nextmatch::call_get_rows(Array, Array,
Array, Object(timesheet_ui), ‘get_rows’,
Object(EGroupware\Api\Etemplate\Widget\Nextmatch)), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #20 [internal function]:
EGroupware\Api\Etemplate\Widget\Nextmatch->beforeSendToClient(’’,
Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #21
D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget.php(512):
call_user_func_array(Array, Array), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #22
D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget\Nextmatch.php(1127):
EGroupware\Api\Etemplate\Widget->run(‘beforeSendToCli…’, Array, false),
referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #23
D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget.php(518):
EGroupware\Api\Etemplate\Widget\Nextmatch->run(‘beforeSendToCli…’,
Array, false), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #24
D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget\Template.php(264):
EGroupware\Api\Etemplate\Widget->run(‘beforeSendToCli…’, Array, false),
referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #25
D:\sti\www\htdocs\egroupware\api\src\Etemplate.php(162):
EGroupware\Api\Etemplate\Widget\Template->run(‘beforeSendToCli…’,
Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #26
D:\sti\www\htdocs\egroupware\timesheet\inc\class.timesheet_ui.inc.php(971):
EGroupware\Api\Etemplate->exec(‘timesheet.times…’, Array, Array, Array),
referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #27
D:\sti\www\htdocs\egroupware\api\src\Framework\Ajax.php(1007):
timesheet_ui->index(), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #28 [internal function]:
EGroupware\Api\Framework\Ajax::ajax_exec(‘index.php?menua…’), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #29
D:\sti\www\htdocs\egroupware\api\src\Json\Request.php(179):
call_user_func_array(Array, Array), referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #30
D:\sti\www\htdocs\egroupware\api\src\Json\Request.php(91):
EGroupware\Api\Json\Request->handleRequest(‘timesheet.jdots…’, Array),
referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #31 D:\sti\www\htdocs\egroupware\json.php(119):
EGroupware\Api\Json\Request->parseRequest(‘timesheet.jdots…’,
’{“request”:{"pa…’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] #32 {main}, referer:
http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 14:21:54.981758 2017] [php7:notice] [pid 5924:tid 992] [client
192.168.0.101:53887] # Instance=default, User=STI-AM, Request=POST
http://x.y.z.w?menuaction=timesheet.timesheet_ui.index&ajax=true,
User-agent=Mozilla/5.0 (Windows NT 6.1; WOW64; rv:50.0) Gecko/20100101
Firefox/50.0, referer: http://x.y.z.w/egroupware/index.php?cd=yes/

–
View this message in context: http://egroupware.219119.n3.nabble.com/Time-Sheet-Error-calling-time-sheet-list-tp4014879.html
Sent from the egroupware-users mailing list archive at Nabble.com.

Check out the vibrant tech community on one of the world’s most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

–
Ralf Becker
EGroupware GmbH [www.egroupware.org]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 631 31657-0

3

Ok, I started the apache web server, call the function and stopped the server, this is the whole error log file:

(PostgresSql, Php7, Windows Server 2012).

Starting the ‘Apache2.4’ service
The ‘Apache2.4’ service is running.
sl:warn] [pid 5992:tid 460] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Jan 20 15:41:34.194883 2017] [mpm_winnt:notice] [pid 5992:tid 460] AH00455: Apache/2.4.23 (Win32) OpenSSL/1.0.2j PHP/7.1.0 configured – resuming normal operations
[Fri Jan 20 15:41:34.210476 2017] [mpm_winnt:notice] [pid 5992:tid 460] AH00456: Server built: Sep 30 2016 20:35:27
[Fri Jan 20 15:41:34.210476 2017] [core:notice] [pid 5992:tid 460] AH00094: Command line: ‘D:\sti\www\bin\httpd.exe -d D:/sti/www’
[Fri Jan 20 15:41:34.210476 2017] [mpm_winnt:notice] [pid 5992:tid 460] AH00418: Parent: Created child process 5428
[Fri Jan 20 15:41:34.913608 2017] [ssl:warn] [pid 5428:tid 356] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Jan 20 15:41:34.944860 2017] [mpm_winnt:notice] [pid 5428:tid 356] AH00354: Child: Starting 64 worker threads.
[Fri Jan 20 15:41:47.117896 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; boexport has a deprecated constructor in D:\sti\www\htdocs\egroupware\news_admin\inc\class.boexport.inc.php on line 17, referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:47.117896 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; soexport has a deprecated constructor in D:\sti\www\htdocs\egroupware\news_admin\inc\class.soexport.inc.php on line 15, referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:47.117896 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; uiexport has a deprecated constructor in D:\sti\www\htdocs\egroupware\news_admin\inc\class.uiexport.inc.php on line 15, referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] An error happened (PDOException): SQLSTATE[22P02]: Invalid text representation: 7 ERRORE: sintassi di input non valida per il tipo integer: “#f80b718aaae9446ae677373055973f02”, referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #0 D:\sti\www\htdocs\egroupware\api\src\Vfs\Sqlfs\StreamWrapper.php(812): PDOStatement->execute(Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #1 [internal function]: EGroupware\Api\Vfs\Sqlfs\StreamWrapper->rmdir(‘links://default…’, 8), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #2 D:\sti\www\htdocs\egroupware\api\src\Vfs\StreamWrapper.php(693): rmdir(‘links://default…’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #3 D:\sti\www\htdocs\egroupware\api\src\Vfs.php(767): EGroupware\Api\Vfs\StreamWrapper->rmdir(‘links://default…’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #4 [internal function]: EGroupware\Api\Vfs::_rm_rmdir(‘links://default…’, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #5 D:\sti\www\htdocs\egroupware\api\src\Vfs.php(595): call_user_func_array(‘EGroupware\\Api\\…’, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #6 D:\sti\www\htdocs\egroupware\api\src\Vfs.php(749): EGroupware\Api\Vfs::find(Array, Array, ‘EGroupware\\Api\\…’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #7 D:\sti\www\htdocs\egroupware\api\src\Link.php(1272): EGroupware\Api\Vfs::remove(‘links://default…’, true), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #8 D:\sti\www\htdocs\egroupware\api\src\Link.php(669): EGroupware\Api\Link::delete_attached(‘projectmanager’, ‘5’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #9 D:\sti\www\htdocs\egroupware\api\src\Link.php(632): EGroupware\Api\Link::unlink2(0, ‘projectmanager’, ‘5’, 0, ‘’, ‘’, false), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #10 D:\sti\www\htdocs\egroupware\api\src\Link.php(822): EGroupware\Api\Link::unlink(0, ‘projectmanager’, ‘5’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #11 D:\sti\www\htdocs\egroupware\timesheet\inc\class.timesheet_bo.inc.php(960): EGroupware\Api\Link::title(‘projectmanager’, ‘5’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #12 D:\sti\www\htdocs\egroupware\api\src\Storage\Base.php(1106): timesheet_bo->db2data(Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #13 D:\sti\www\htdocs\egroupware\api\src\Storage.php(430): EGroupware\Api\Storage\Base->search(Array, false, ‘ORDER BY ts_sta…’, Array, ‘’, false, ‘AND’, 0, Array, ‘’, false), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #14 D:\sti\www\htdocs\egroupware\timesheet\inc\class.timesheet_bo.inc.php(537): EGroupware\Api\Storage->search(Array, false, ‘ts_start DESC’, Array, ‘’, false, ‘AND’, Array, Array, ‘’, false), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #15 D:\sti\www\htdocs\egroupware\api\src\Storage\Base.php(1509): timesheet_bo->search(Array, false, ‘ts_start DESC’, Array, ‘’, false, ‘AND’, Array, Array, ‘’, false), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #16 D:\sti\www\htdocs\egroupware\api\src\Storage.php(375): EGroupware\Api\Storage\Base->get_rows(Array, Array, ‘’, false, false, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #17 D:\sti\www\htdocs\egroupware\timesheet\inc\class.timesheet_ui.inc.php(704): EGroupware\Api\Storage->get_rows(Array, Array, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #18 D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget\Nextmatch.php(605): timesheet_ui->get_rows(Array, Array, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #19 D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget\Nextmatch.php(185): EGroupware\Api\Etemplate\Widget\Nextmatch::call_get_rows(Array, Array, Array, Object(timesheet_ui), ‘get_rows’, Object(EGroupware\Api\Etemplate\Widget\Nextmatch)), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #20 [internal function]: EGroupware\Api\Etemplate\Widget\Nextmatch->beforeSendToClient(’’, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #21 D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget.php(512): call_user_func_array(Array, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #22 D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget\Nextmatch.php(1127): EGroupware\Api\Etemplate\Widget->run(‘beforeSendToCli…’, Array, false), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #23 D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget.php(518): EGroupware\Api\Etemplate\Widget\Nextmatch->run(‘beforeSendToCli…’, Array, false), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #24 D:\sti\www\htdocs\egroupware\api\src\Etemplate\Widget\Template.php(264): EGroupware\Api\Etemplate\Widget->run(‘beforeSendToCli…’, Array, false), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #25 D:\sti\www\htdocs\egroupware\api\src\Etemplate.php(162): EGroupware\Api\Etemplate\Widget\Template->run(‘beforeSendToCli…’, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #26 D:\sti\www\htdocs\egroupware\timesheet\inc\class.timesheet_ui.inc.php(971): EGroupware\Api\Etemplate->exec(‘timesheet.times…’, Array, Array, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #27 D:\sti\www\htdocs\egroupware\api\src\Framework\Ajax.php(1007): timesheet_ui->index(), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #28 [internal function]: EGroupware\Api\Framework\Ajax::ajax_exec(‘index.php?menua…’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #29 D:\sti\www\htdocs\egroupware\api\src\Json\Request.php(179): call_user_func_array(Array, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #30 D:\sti\www\htdocs\egroupware\api\src\Json\Request.php(91): EGroupware\Api\Json\Request->handleRequest(‘timesheet.jdots…’, Array), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #31 D:\sti\www\htdocs\egroupware\json.php(119): EGroupware\Api\Json\Request->parseRequest(‘timesheet.jdots…’, ‘{“request”:{"pa…’), referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] #32 {main}, referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:41:57.746401 2017] [php7:notice] [pid 5428:tid 992] [client 192.168.0.101:55248] # Instance=default, User=STI-AM, Request=POST http://x.y.z.w?menuaction=timesheet.timesheet_ui.index&ajax=true, User-agent=Mozilla/5.0 (Windows NT 6.1; WOW64; rv:50.0) Gecko/20100101 Firefox/50.0, referer: http://x.y.z.w/egroupware/index.php?cd=yes
[Fri Jan 20 15:42:06.150648 2017] [mpm_winnt:notice] [pid 5992:tid 460] AH00422: Parent: Received shutdown signal – Shutting down the server.
[Fri Jan 20 15:42:08.186217 2017] [mpm_winnt:notice] [pid 5428:tid 356] AH00364: Child: All worker threads have exited.
[Fri Jan 20 15:42:08.217466 2017] [mpm_winnt:notice] [pid 5992:tid 460] AH00430: Parent: Child process 5428 exited successfully.

4

I insert
error_log("STAT ino ".$stat[‘ino’]);
in StreamWrapper.php for check. But not undestand error. May be numeric name of directory create sql error.

5

A little bit more info that I discovered right now:

The problem arises only with my account, belonging to Admins group. Logging in with “Default group” account it is possible to see time sheets of current user.