Log file error

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.