View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - database issue - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

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 Connexion 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 Connexion 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 Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.051 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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