[Obm] Installation problems

Rodrigo Filgueira rfilgue@cinterfor.org.uy
Wed, 21 Jul 2004 14:07:08 -0300
Previous message: [Obm] utilisation du module documents
Next message: [Obm] Installation problems
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
My config:

- obm is installed in a box with php4, redhat 7.1, apache 1.3.24
- obm database is installed in another box running Postgres 7.4.1.

These are the error messages I get:

1) When running: install_obmdb_0.8.pgsql.sh

Obs -> I modified the script so that psql would use the -h

Default preferences propagation on created users

Warning: main(obminclude/global.inc) [http://www.php.net/function.main]: 
failed to create stream: No
 such file or directory in 
/export/intranet/obm-0.8.3/php/admin_pref/admin_pref_index.php on line 23

Warning: main() [http://www.php.net/function.main]: Failed opening 
'obminclude/global.inc' for inclu
sion (include_path='.:/usr/local/lib/php') in 
/export/intranet/obm-0.8.3/php/admin_pref/admin_pref_i
ndex.php on line 23

Warning: main(obminclude/global_pref.inc) 
[http://www.php.net/function.main]: failed to create strea
m: No such file or directory in 
/export/intranet/obm-0.8.3/php/admin_pref/admin_pref_index.php on li
ne 37

Warning: main() [http://www.php.net/function.main]: Failed opening 
'obminclude/global_pref.inc' for
inclusion (include_path='.:/usr/local/lib/php') in 
/export/intranet/obm-0.8.3/php/admin_pref/admin_p
ref_index.php on line 37
-a -> $action=user_pref_update

Fatal error: Call to undefined function:  debug_level_isset() in 
/export/intranet/obm-0.8.3/php/admi
n_pref/admin_pref_index.php on line 231

---------------------------
2) When accessing: http://obm/time/time_index.php

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: function 
unix_timestamp(timestamp without time zone) does not exist . in 
/export/intranet/obm-0.8.3/obminclude/phplib/db_pgsql.inc on line 82
Database error: Invalid SQL: select timetask_id, 
UNIX_TIMESTAMP(timetask_date) as date_task, 
UNIX_TIMESTAMP(timetask_timeupdate) as date_timeupdate, 
UNIX_TIMESTAMP(timetask_timecreate) as date_timecreate, 
concat(timetask_length,concat('/', 8)) as timetask_length, 
tasktype_label, project_name as timetask_project_name, timetask_label, 
projecttask_label, company_name as timetask_company_name, 
timetask_status, (if (timetask_status != 2, 1, 0)) as test_status, 
SUBSTRING(timetask_date,8,1) as date_parity from ((TimeTask left join 
ProjectTask on timetask_projecttask_id = projecttask_id) left join 
Project on projecttask_project_id = project_id) left join Company on 
project_company_id = company_id, TaskType where timetask_tasktype_id = 
tasktype_id and timetask_date >='20040719' and timetask_date <'20040725' 
and timetask_user_id = 1 order by timetask_date
PostgreSQL Error: 1 (ERROR: function unix_timestamp(timestamp without 
time zone) does not exist )

Warning: pg_numrows(): supplied argument is not a valid PostgreSQL 
result resource in 
/export/intranet/obm-0.8.3/obminclude/phplib/db_pgsql.inc on line 201

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: column 
"timetask.timetask_status" must appear in the GROUP BY clause or be used 
in an aggregate function . in 
/export/intranet/obm-0.8.3/obminclude/phplib/db_pgsql.inc on line 82
Database error: Invalid SQL: select timetask_date, timetask_status from 
TimeTask where timetask_status != 0 and timetask_date >= '20040719' and 
timetask_date <= '20040725' and timetask_user_id = 1 group by timetask_date
PostgreSQL Error: 1 (ERROR: column "timetask.timetask_status" must 
appear in the GROUP BY clause or be used in an aggregate function )

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: column 
"project_company_id" does not exist . in 
/export/intranet/obm-0.8.3/obminclude/phplib/db_pgsql.inc on line 82
Database error: Invalid SQL: select distinct project_id, project_name, 
company_name, project_tasktype_id from Project, ProjectTask, ProjectUser 
left join Company on company_id = project_company_id where 
project_archive='0' and projectuser_projecttask_id = projecttask_id and 
projecttask_project_id = project_id and projectuser_user_id = '1' and 
projectuser_projectedtime != '0' order by project_tasktype_id, 
company_name, project_name
PostgreSQL Error: 1 (ERROR: column "project_company_id" does not exist )

Warning: pg_numrows(): supplied argument is not a valid PostgreSQL 
result resource in 
/export/intranet/obm-0.8.3/obminclude/phplib/db_pgsql.inc on line 201

--------------------------------------------
3) When accessing: 
http://obm/admin_data/admin_data_index.php?mode=html&action=data_show&module=document


Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: syntax error 
at or near "CONCAT" at character 125 . in 
/export/intranet/obm-0.8.3/obminclude/phplib/db_pgsql.inc on line 82
Database error: Invalid SQL: select document_id, document_path, 
document_name, document_kind from Document order by BINARY 
CONCAT(document_path, document_name )
PostgreSQL Error: 1 (ERROR: syntax error at or near "CONCAT" at 
character 125 )

Warning: opendir(/var/www/obm/documents/) [function.opendir]: failed to 
open dir: No such file or directory in 
/export/intranet/obm-0.8.3/php/admin_data/admin_data_query.inc on line 129

Warning: readdir(): supplied argument is not a valid Directory resource 
in /export/intranet/obm-0.8.3/php/admin_data/admin_data_query.inc on 
line 131

Warning: closedir(): supplied argument is not a valid Directory resource 
in /export/intranet/obm-0.8.3/php/admin_data/admin_data_query.inc on 
line 137

Warning: pg_numrows(): supplied argument is not a valid PostgreSQL 
result resource in 
/export/intranet/obm-0.8.3/obminclude/phplib/db_pgsql.inc on line 201

Warning: current() [function.current]: Passed variable is not an array 
or object in 
/export/intranet/obm-0.8.3/php/admin_data/admin_data_display.inc on line 449

Warning: next() [function.next]: Passed variable is not an array or 
object in 
/export/intranet/obm-0.8.3/php/admin_data/admin_data_display.inc on line 560

---------------------------------------------------
4) When accessing: 
http://obm/admin_data/admin_data_index.php?mode=html&action=data_update&module=document


Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: syntax error 
at or near "CONCAT" at character 125 . in 
/export/intranet/obm-0.8.3/obminclude/phplib/db_pgsql.inc on line 82
Database error: Invalid SQL: select document_id, document_path, 
document_name, document_kind from Document order by BINARY 
CONCAT(document_path, document_name )
PostgreSQL Error: 1 (ERROR: syntax error at or near "CONCAT" at 
character 125 )

Warning: opendir(/var/www/obm/documents/) [function.opendir]: failed to 
open dir: No such file or directory in 
/export/intranet/obm-0.8.3/php/admin_data/admin_data_query.inc on line 129

Warning: readdir(): supplied argument is not a valid Directory resource 
in /export/intranet/obm-0.8.3/php/admin_data/admin_data_query.inc on 
line 131

Warning: closedir(): supplied argument is not a valid Directory resource 
in /export/intranet/obm-0.8.3/php/admin_data/admin_data_query.inc on 
line 137

Warning: pg_numrows(): supplied argument is not a valid PostgreSQL 
result resource in 
/export/intranet/obm-0.8.3/obminclude/phplib/db_pgsql.inc on line 201

Warning: current() [function.current]: Passed variable is not an array 
or object in 
/export/intranet/obm-0.8.3/php/admin_data/admin_data_display.inc on line 449

Warning: next() [function.next]: Passed variable is not an array or 
object in 
/export/intranet/obm-0.8.3/php/admin_data/admin_data_display.inc on line 560

---------------------------------------------------
5) When accessing: http://obm/import/import_index.php

Not Found
The requested URL /import/import_index.php was not found on this server.

Apache/1.3.24 Server at obm Port 80

Any ideas?
thank you all

 

Rodrigo Filgueira Prates
IT@CINTERFOR/OIT
http://www.cinterfor.org.uy
Previous message: [Obm] utilisation du module documents
Next message: [Obm] Installation problems
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]