Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

database issue
 
Notifications
Clear all

database issue

3 Posts
2 Users
0 Reactions
1,396 Views
(@groudillon)
Posts: 22
Active Member
Topic starter
 
[#8546]

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


 
Posted : 05 Oct 2022 17H58
(@groudillon)
Posts: 22
Active Member
Topic starter
 

another one in log file
  

 


 
Posted : 07 Oct 2022 18H37
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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.


 
Posted : 08 Oct 2022 15H20
Share:

Scroll to Top