[Obm] Re: OBM

[Pierre Baudracco]

Salut Samuel,

c'est normal, il reste 2 modules non portes sous Postgres :
- le time management (accede par defaut lorsqu'on clique sur l'onglet production)
- les documents

meme quand tu vois cette erreur, tu peux cliquer sur les autres modules de la 
section production et la tout marchera.

Si ca t'ennuies tu peux changer le module par defaut de la section Production.
Dans le fichier obminclude/global_pref.inc change les lignes (1 seule ligne a 
changer) :

---
if ($cgp_show["section"]["prod"]) {
   $sections["PROD"] = array('Name' => $l_header_prod,
                             'Url'  => "$path/time/time_index.php",
                             'Right'=> $cright_read);
}
---
par
---
if ($cgp_show["section"]["prod"]) {
   $sections["PROD"] = array('Name' => $l_header_prod,
                             'Url'  => "$path/project/project_index.php",
                             'Right'=> $cright_read);
}
---

A bientot,


CHABOISSEAU Samuel wrote:
> Salut Pierre,
> 
> Je sais que tu as eu Cyril aujourd'hui au tél. et que vous avez, entre autre, 
> discuté des problèmes OBM.
> 
> Pour ma part tout marche très bien sauf dans le module PRODUCTION, il fait 
> appel à une fonction "unix_timestamp" qui n'existe pas. Je tourne sous 
> postgresql. Si tu as un moyen de contournement cela me serait très utile. 
> 
> Voici l'errreur :
> Warning: pg_exec(): Query failed: ERROR: function unix_timestamp(timestamp 
> without time zone) does not exist HINT: No function matches the given name 
> and argument types. You may need to add explicit type casts. . 
> in /var/www/obm-0.8.0/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 >='20040322' and 
> timetask_date <'20040328' and timetask_user_id = 4 order by timetask_date
> PostgreSQL Error: 1 (ERROR: function unix_timestamp(timestamp without time 
> zone) does not exist HINT: No function matches the given name and argument 
> types. You may need to add explicit type casts. )
> 
> Warning: pg_numrows(): supplied argument is not a valid PostgreSQL result 
> resource in /var/www/obm-0.8.0/obminclude/phplib/db_pgsql.inc on line 201
> 
> Warning: pg_exec(): Query failed: ERROR: column "timetask.timetask_status" 
> must appear in the GROUP BY clause or be used in an aggregate function . 
> in /var/www/obm-0.8.0/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 >= '20040322' and 
> timetask_date <= '20040328' and timetask_user_id = 4 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(): Query failed: ERROR: column "project_company_id" does not 
> exist . in /var/www/obm-0.8.0/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 = '4' 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 /var/www/obm-0.8.0/obminclude/phplib/db_pgsql.inc on line 201



-- 
------------------------------------------------------------------------------
Pierre Baudracco - pierre.baudracco@aliacom.fr
ALIACOM - www.aliacom.fr - Toulouse : 05 62 19 24 91 - Paris : 01 48 25 53 13