A weird log report…

JavierNS · September 30, 2010, 3:42am

Hi, we’re using dhtmlxScheduler in a small app with a postgresql, and we had a problem as soon as we mount it in a CENTOS 5.5. server. I address the issue in deep in this post:
http://forum.dhtmlx.com/viewtopic.php?f=6&t=14886&start=0&hilit=centos (feel free to join both posts) and Stanislav, very kindly, recommend me to enable the log so I can have a better view of what its going on, so, I did it and this is the resulting LOG:

====================================
Log started, 29/09/2010 12:09:43
====================================

SELECT  * FROM tcitas WHERE  userid = 12

Done in 0.013514995575s



====================================
Log started, 29/09/2010 12:09:49
====================================

DataProcessor object initialized
5_id => 5
5_start_date => 2010-08-27 14:35
5_end_date => 2010-08-27 19:20
5_text => Nuevo evento
5_userid => 12
5_doctor => 9
5_sucursal => 2
5_nombre => null
5_tipo => 4
5_fchcreada => Fri Aug 27 2010 18:51:17 GMT-0500
5_asist => f
5_comentarios => 
5_!nativeeditor_status => updated
ids => 5

Row data [5]
event_id => 5
start_date => 2010-08-27 14:35
end_date => 2010-08-27 19:20
text => Nuevo evento
userid => 12
doctor => 9
sucursal => 2
nombre => null
tipo => 4
fchcreada => Fri Aug 27 2010 18:51:17 GMT-0500
asist => f
comentarios => 
!nativeeditor_status => updated

change value of: userid as: 12

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

UPDATE tcitas SET start_date='',end_date='',text='',userid='',doctor='',sucursal='',nombre='',tipo='',fchcreada='',asist='',comentarios='' WHERE event_id='' AND ( userid = 12)

pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR:  invalid input syntax for integer: &quot;&quot; at character 155 at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 9

Edit operation finished
0 => Object id #8

Done in 0.0156180858612s



====================================
Log started, 29/09/2010 12:09:15
====================================

SELECT  * FROM tcitas WHERE  userid = 12

Done in 0.00673913955688s



====================================
Log started, 29/09/2010 12:09:41
====================================

DataProcessor object initialized
1285780042445_start_date => 2010-09-29 07:20
1285780042445_end_date => 2010-09-29 08:20
1285780042445_text => descrip
1285780042445_id => 1285780042445
1285780042445_doctor => 8
1285780042445_sucursal => 2
1285780042445_tipo => 7
1285780042445_location => confirma
1285780042445_nombre => confirma
1285780042445_asist => true
1285780042445_comentarios => comentarios
1285780042445_fchcreada => Wed Sep 29 2010 12:07:27 GMT-0500
1285780042445_!nativeeditor_status => inserted
ids => 1285780042445

Row data [1285780042445]
start_date => 2010-09-29 07:20
end_date => 2010-09-29 08:20
text => descrip
event_id => 1285780042445
doctor => 8
sucursal => 2
tipo => 7
location => confirma
nombre => confirma
asist => true
comentarios => comentarios
fchcreada => Wed Sep 29 2010 12:07:27 GMT-0500
!nativeeditor_status => inserted

change value of: userid as: 12

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

pg_escape_string() expects exactly 1 parameter, 2 given at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 37

INSERT INTO tcitas(start_date,end_date,text,userid,doctor,sucursal,nombre,tipo,fchcreada,asist,comentarios) VALUES ('','','','','','','','','','','')

pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR:  invalid input syntax for integer: &quot;&quot; at character 126 at /var/www/html/app2/dentalnet/citas/codebase/connector/db_postgre.php line 9

Edit operation finished
0 => Object id #8

Done in 0.00807094573975s

Can someone please tell me what its going on there? its not very clear if the problem its postgresql, the php conector, or the scheduler connection with the app…
Any help will be appreciated.

Thanks a lot in advance.

Stanislav · September 30, 2010, 8:27am

It seems that you are using php 5.0 or php 5.1 - those versions of php have different format of PostgreSQL commands

Try to update the db_postgre.php and base_connector.php with ones from the attached package.
temp.zip (6.07 KB)

JavierNS · October 3, 2010, 10:06pm

Stanislav, you were right from the beginning, when I asked my friend in charge of the server, he told me that everything had the last version, so that couldn’t be the problem, and I believe him, but I ask him to check the php version again, and it seems that even when you say to centos to update php, it just take leave it in the 5.1, if you want to move up to 5.3 it has to be done manually… so, after all the struggle, it was a version problem, we upgrade to php 5.3 and everything its running perfectly.
Thanks a lot Stanislav for all the help. Awesome support.