View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - database issue - ProjeQtOr
 
 

database issue

More
05 Oct 2022 15:58 #1 by GROUDILLON
database issue was created by GROUDILLON
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

Please Log in or Create an account to join the conversation.

More
07 Oct 2022 16:37 #2 by GROUDILLON
Replied by GROUDILLON on topic database issue
another one in log file
  

 
Attachments:

Please Log in or Create an account to join the conversation.

More
08 Oct 2022 13:20 #3 by babynus
Replied by babynus on topic database issue
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.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.044 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.