Problems after installing Fusionpbx 5

[paulczichos]

Hello, we have been using FusionPBX for quite a while now and are thrilled. I am in the process of preparing a new version for our needs. There are two strange errors that I can't explain, at least not yet. When I create, edit or delete a fax server the FusionPBX page just goes white and nothing else happens. Furthermore, there seems to be a problem with the fax queue function. Every minute when the server checks for new tasks in the fax queue the following error appears in the console:

2023-01-26 10:20:50.131850 99.53% [ERR] mod_pgsql.c:552 Error executing query:
ERROR:  function datetime(unknown, unknown) does not exist
LINE 3: ...xt_time = datetime('now')  where task_lock_time < datetime('...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

2023-01-26 10:20:50.131850 99.53% [ERR] switch_core_sqldb.c:1300 ERR: [select
  t1.fax_task_uuid as uuid,
  t1.fax_uuid as fax_uuid,
  t3.domain_name,
  t3.domain_uuid,
  t1.task_status as status,
  t1.task_uri as uri,
  t1.task_dial_string as dial_string,
  t1.task_dtmf as dtmf,
  t1.task_fax_file as fax_file,
  t1.task_wav_file as wav_file,
  t1.task_reply_address as reply_address,
  t1.task_no_answer_counter as no_answer_counter,
  t1.task_no_answer_retry_counter as no_answer_retry_counter,
  t1.task_retry_counter as retry_counter,
  t2.fax_send_greeting as greeting
from v_fax_tasks t1
  inner join v_fax t2 on t2.fax_uuid = t1.fax_uuid
  inner join v_domains t3 on t2.domain_uuid = t3.domain_uuid
where t1.task_interrupted <> 'true'
and t1.task_status = 0 and t1.task_next_time < datetime('now')and t2.fax_send_channels > (select count(*) from v_fax_tasks as tasks
  where tasks.fax_uuid = t1.fax_uuid and
  tasks.task_status > 0 and tasks.task_status <= 2
)
order by t1.task_next_time
]
[ERROR:  function datetime(unknown) does not exist
LINE 21: and t1.task_status = 0 and t1.task_next_time < datetime('now...
                                                        ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
]
2023-01-26 10:20:50.131850 99.53% [ERR] switch_core_sqldb.c:1300 ERR: [select
  t1.fax_task_uuid as uuid,
  t1.fax_uuid as fax_uuid,
  t3.domain_name,
  t3.domain_uuid,
  t1.task_status as status,
  t1.task_uri as uri,
  t1.task_dial_string as dial_string,
  t1.task_dtmf as dtmf,
  t1.task_fax_file as fax_file,
  t1.task_wav_file as wav_file,
  t1.task_reply_address as reply_address,
  t1.task_no_answer_counter as no_answer_counter,
  t1.task_no_answer_retry_counter as no_answer_retry_counter,
  t1.task_retry_counter as retry_counter,
  t2.fax_send_greeting as greeting
from v_fax_tasks t1
  inner join v_fax t2 on t2.fax_uuid = t1.fax_uuid
  inner join v_domains t3 on t2.domain_uuid = t3.domain_uuid
where t1.task_interrupted <> 'true'
and t1.task_status = 0 and t1.task_next_time < datetime('now')and t2.fax_send_channels > (select count(*) from v_fax_tasks as tasks
  where tasks.fax_uuid = t1.fax_uuid and
  tasks.task_status > 0 and tasks.task_status <= 2
)
order by t1.task_next_time
]
[ERROR:  function datetime(unknown) does not exist
LINE 21: and t1.task_status = 0 and t1.task_next_time < datetime('now...
                                                        ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
]
2023-01-26 10:20:50.131850 99.53% [NOTICE] switch_cpp.cpp:1465 [next_fax_task] No task

According to my investigations the server seems to use a wrong database type in the file /app/scrits/resources/scripts/app/fax/resources/scripts/queue/task.lua. Has anyone had any experience with this ?

 

[paulczichos]

It was the wrong database.type that was used.

This thread can be closed.