Yes you have many recurring errors :

1) calling Projeqtor servers to check last version fails as allow_url_fopen is Off on your php serveur.
Disable check version in global parameters to avoid this error

2) smtp configuration may be wrong or smtp server xas temporary closed.

3) you have deadlocks on your DB.
This is quite rare and often show inconsistency of DB.
Try and restart yur db and check integrity of db.

Thank you for your comeback,
The first point has been resolved.
The second has to be solved but it is known.
For the third we will perform a restart of the DB and check its integrity.

Hello,

Following the analysis of the database, we noticed that the problem venerate waiting between two command on the same table, the first performs (therefore reserves the table) which prevents the second to be done.

Is there a fix for the problem ?

Thank You,

Maybe configuration of your db is wrong.
It should not lock the whole table, but only lines.

Hello,

Our verification of the DB returns us no error quoted engine DBMS, by against side model of data and data it is possible.

Do you have a solution to check for any errors ?

Best Regards,

Hi,

is it a new installation of v6.4.4 or an upgraded one?

Reason to ask:
There are several errors caused by missing fields in db structure.

Check db structure in case of having an upgraded system in correlation with version being first installation and multiple sql files performing upgrades for each version in between. You will find those files in directory /db.

I had similar problems with an upgraded installation and solved them this way.

cu, diri

Hello Diri,

This is a first installation of ProjeQtOr.
In this case, it does not suit your solution.
Thanks for your help

Hi,

you're welcome.

Nevertheless it looks like you are missing some fields (field not found). Otherwise those errors should not occure.

This could also happen when you had trouble with db connection during installation. Are you able to perform a second installation to be able to compare dbs?

cu, diri

Hello,

It's quite strange as problem, the application has been installed directly on version 6.4.4
This should have warned us of error after installation if there are missing fields ?

The problem is also that the errors did not appear until 2 months after installation.

We will have to scan the whole log file to find all the missing fields, to remember this file weighs 270 MB.
Is not it going to take us some time, unless you have another solution ?

Best Regards,

As I already wrote - I encountered similar problems and thought they are caused by incomplete upgrades being caused by system or whatever. It's a setup for tests with only one very small project.

Short excerpt from log when running upgrade from 6.4.4 to 6.50:
2017-12-08 05:38:42.991 ** ERROR ** [V6.4.4] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 05:38:43.125 ** ERROR ** [V6.4.4] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-12-08 05:38:43.13
...
2017-12-08 05:38:43.710 ** ERROR ** [V6.4.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxxx.pro_delivery' doesn't exist
...
And many more.

You have a problem with missing fields at least at first installation.

I did not dive into installation procedure to see how db is created at installation time. Now it looks like there is a basic structure created and modified with multiple update scripts. For me there is no other explanation for error messages like "field xyz not found" in your situation.

A fast way to determine missing tables would be running grep or awk against log file to find missing fields and / or such exceptions being caused by missing tables. When using Windows there is findstr or powershell. If you encounter exceptions most probably there are missing tables in your db.

I'm sorry to not to be able to provide further help.