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:
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 ?
Bash:
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 ?
Last edited: