SQL error after upgrade V16-->V17

[cacciatorino]

After upgrading from V16 to V17, I have this error when trying to insert a time-sheet:

Database error

Invalid SQL: INSERT INTO egw_timesheet (ts_project,ts_title,ts_description,ts_start,ts_duration,ts_quantity,ts_unitprice,cat_id,ts_owner,ts_modified,ts_modifier,pl_id,ts_status,ts_created) VALUES (‘A170101C5: Macchina Prova Aggraffatura’,‘A170101C5: Macchina Prova Aggraffatura’,NULL,1517655300,6,0.1,25,55,5,1517655697,5,11,NULL,1517655697)
ERRORE: la colonna “ts_created” della relazione “egw_timesheet” non esiste
LINE 1: …,ts_owner,ts_modified,ts_modifier,pl_id,ts_status,ts_created…
__ ^ (-1)__

My environment:
Operating system: Windows Server 2012
SQL Server: Postgressql 9.6
PHP 7.1.0
Apache server 2.4.32

[RalfBecker]

Looks like you somehow missed the update for timesheet from 16.1. You probably got an error during update and ignored it.

Anyway it’s easy to fix:

1. run the following SQL:
   UPDATE egw_applications SET app_version=‘16.1’ WHERE app_name=‘timesheet’;
2. Go to Setup (upper login) >> Applications and run the Timesheet update.

Ralf

[cacciatorino]

Thank you for your feedback. I was able to correct the error using the upgrade wizard.

thank you for your help.