hi.
my projeqtor instance works fine for the moment, but i have some issue with database. it looks like database schema is not complete. i had some logs for missing files (like Risk) the i created it manually, using empty schema from a new projeqtor instance (on the same version)
Now, i have some missing columns...
All update were done using same method : installing update files, then connect admin for database upgrade.
please, is there a way too check and repair database schema ?
i have this error : 2022-10-05 10:21:02.314 ** ERROR ** [V10.0.6] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'meeting.meetingStartTime' in 'field list'
2022-10-05 10:21:02.319 ** ERROR ** [V10.0.6] For query : select meeting.id as id, T1.name as nameProject, T2.name as nameMeetingType, meeting.meetingDate as meetingDate, meeting.meetingStartTime as meetingStartTime, meeting.name as name, convert(concat(COALESCE(T3.sortOrder,''),'#split#',T3.name,'#split#',COALESCE(T3.color,'')) using utf8mb4) as colorNameStatus,meeting.idProject as idproject from meeting left join project as T1 on meeting.idProject = T1.id left join type as T2 on meeting.idMeetingType = T2.id left join status as T3 on meeting.idStatus = T3.id where meeting.idle=0 and ( (((meeting.idProject in (0, 3, 8, 10)) or ((meeting.idResource=8) and meeting.idProject in (0) ) or ((meeting.idUser=8) and meeting.idProject in (0) )) and (meeting.idProject not in (0) or meeting.idProject is null )) ) order by meeting.id desc
Sure you have issue with the DB.
The column meeting.meetingStartTime was created on V2.2.
there is no internal DB check utility.
Only solution is to install fresh new instance and compare DBs.
