View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] New Meeting : no time sélection possible - ProjeQtOr

Prochaines Sessions

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

[SOLVED] New Meeting : no time sélection possible

More
02 Sep 2022 08:48 #1 by matthieu.froment
Hello,
With a freshly installed 10.0.5 instance, I try to create a meeting but I run into a problem: it is not possible to select the time slot.

On the Projeqtor demo, I can see this kind of thing: demo.png
However, on my side, no choice is possible neither when clicking nor when typing. : issue.png

I have tried with an admin account and same issue.
How to investigate the problem ? Is it a mistake on my part or a problem with the tool?

Regards,
Matthieu
Attachments:

Please Connexion or Create an account to join the conversation.

More
02 Sep 2022 09:05 #2 by Arkhanje
Hello

do you have any errors in the logs? in your browser console?

Please Connexion or Create an account to join the conversation.

More
02 Sep 2022 10:21 - 02 Sep 2022 10:22 #3 by matthieu.froment
Yes, some errors are present (seems so !) :

2022-09-02 10:17:10.269 ===== TRACE ===== NEW CONNECTED USER 'admin'
2022-09-02 10:17:13.360 ***** ERROR ***** [V10.0.5] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2022-09-02 10:17:13.360 ***** ERROR ***** [V10.0.5] For query : select idproject, done, idle, count(*) as cpt from risk where idProject in (0, 2, 4, 6, 22, 16, 11, 10, 21, 12, 9, 24, 8, 14, 15, 17, 18, 19, 7, 23) group by idproject, done, idle
2022-09-02 10:17:13.360 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-02 10:17:13.360 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:3159]
2022-09-02 10:17:13.360 ***** ERROR ***** [V10.0.5] #1 SqlElement->countGroupedSqlElementsFromCriteria called at [/var/www/projeqtor/view/today.php:68]
2022-09-02 10:17:13.360 ***** ERROR ***** [V10.0.5] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.issue' doesn't exist
2022-09-02 10:17:13.360 ***** ERROR ***** [V10.0.5] For query : select idproject, done, idle, count(*) as cpt from issue where idProject in (0, 2, 4, 6, 22, 16, 11, 10, 21, 12, 9, 24, 8, 14, 15, 17, 18, 19, 7, 23) group by idproject, done, idle
2022-09-02 10:17:13.360 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-02 10:17:13.361 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:3159]
2022-09-02 10:17:13.361 ***** ERROR ***** [V10.0.5] #1 SqlElement->countGroupedSqlElementsFromCriteria called at [/var/www/projeqtor/view/today.php:68]
2022-09-02 10:17:13.435 ***** ERROR ***** [V10.0.5] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2022-09-02 10:17:13.435 ***** ERROR ***** [V10.0.5] For query : select * from risk where 1=0 LIMIT 101
2022-09-02 10:17:13.435 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-02 10:17:13.435 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2913]
2022-09-02 10:17:13.435 ***** ERROR ***** [V10.0.5] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/view/today.php:1091]
2022-09-02 10:17:13.436 ***** ERROR ***** [V10.0.5] #2 showActivitiesList called at [/var/www/projeqtor/view/today.php:1001]
2022-09-02 10:17:13.436 ***** ERROR ***** [V10.0.5] #3 showAssignedTasks called at [/var/www/projeqtor/view/today.php:400]
2022-09-02 10:17:13.436 ***** ERROR ***** [V10.0.5] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.opportunity' doesn't exist
2022-09-02 10:17:13.436 ***** ERROR ***** [V10.0.5] For query : select * from opportunity where 1=0 LIMIT 101
2022-09-02 10:17:13.436 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-02 10:17:13.436 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2913]
2022-09-02 10:17:13.436 ***** ERROR ***** [V10.0.5] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/view/today.php:1094]
2022-09-02 10:17:13.436 ***** ERROR ***** [V10.0.5] #2 showActivitiesList called at [/var/www/projeqtor/view/today.php:1001]
2022-09-02 10:17:13.436 ***** ERROR ***** [V10.0.5] #3 showAssignedTasks called at [/var/www/projeqtor/view/today.php:400]
2022-09-02 10:17:13.438 ***** ERROR ***** [V10.0.5] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.issue' doesn't exist
2022-09-02 10:17:13.438 ***** ERROR ***** [V10.0.5] For query : select * from issue where 1=0 LIMIT 101
2022-09-02 10:17:13.438 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-02 10:17:13.438 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2913]
2022-09-02 10:17:13.438 ***** ERROR ***** [V10.0.5] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/view/today.php:1111]
2022-09-02 10:17:13.438 ***** ERROR ***** [V10.0.5] #2 showActivitiesList called at [/var/www/projeqtor/view/today.php:1001]
2022-09-02 10:17:13.438 ***** ERROR ***** [V10.0.5] #3 showAssignedTasks called at [/var/www/projeqtor/view/today.php:400]
2022-09-02 10:17:13.474 ***** ERROR ***** [V10.0.5] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.risk' doesn't exist
2022-09-02 10:17:13.474 ***** ERROR ***** [V10.0.5] For query : select * from risk where (idUser='1') and idle=0 and done=0 LIMIT 101
2022-09-02 10:17:13.474 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-02 10:17:13.474 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2913]
2022-09-02 10:17:13.474 ***** ERROR ***** [V10.0.5] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/view/today.php:1091]
2022-09-02 10:17:13.474 ***** ERROR ***** [V10.0.5] #2 showActivitiesList called at [/var/www/projeqtor/view/today.php:1041]
2022-09-02 10:17:13.474 ***** ERROR ***** [V10.0.5] #3 showIssuerRequestorTasks called at [/var/www/projeqtor/view/today.php:415]
2022-09-02 10:17:13.475 ***** ERROR ***** [V10.0.5] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.opportunity' doesn't exist
2022-09-02 10:17:13.475 ***** ERROR ***** [V10.0.5] For query : select * from opportunity where (idUser='1') and idle=0 and done=0 LIMIT 101
2022-09-02 10:17:13.475 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-02 10:17:13.475 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2913]
2022-09-02 10:17:13.475 ***** ERROR ***** [V10.0.5] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/view/today.php:1094]
2022-09-02 10:17:13.475 ***** ERROR ***** [V10.0.5] #2 showActivitiesList called at [/var/www/projeqtor/view/today.php:1041]
2022-09-02 10:17:13.475 ***** ERROR ***** [V10.0.5] #3 showIssuerRequestorTasks called at [/var/www/projeqtor/view/today.php:415]
2022-09-02 10:17:13.476 ***** ERROR ***** [V10.0.5] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.issue' doesn't exist
2022-09-02 10:17:13.476 ***** ERROR ***** [V10.0.5] For query : select * from issue where (idUser='1') and idle=0 and done=0 LIMIT 101
2022-09-02 10:17:13.476 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-02 10:17:13.476 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2913]
2022-09-02 10:17:13.476 ***** ERROR ***** [V10.0.5] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/view/today.php:1111]
2022-09-02 10:17:13.477 ***** ERROR ***** [V10.0.5] #2 showActivitiesList called at [/var/www/projeqtor/view/today.php:1041]
2022-09-02 10:17:13.477 ***** ERROR ***** [V10.0.5] #3 showIssuerRequestorTasks called at [/var/www/projeqtor/view/today.php:415]
2022-09-02 10:17:13.480 ***** ERROR ***** [V10.0.5] Error on SqlElement to get 'meetingStartTime' for Class 'Meeting' : field 'meetingStartTime' not found in Database.
2022-09-02 10:17:13.480 ***** ERROR ***** [V10.0.5] Error on SqlElement to get 'meetingEndTime' for Class 'Meeting' : field 'meetingEndTime' not found in Database.
2022-09-02 10:17:13.480 ***** ERROR ***** [V10.0.5] Error on SqlElement to get 'location' for Class 'Meeting' : field 'location' not found in Database.
2022-09-02 10:18:45.050 ***** ERROR ***** [V10.0.5] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'meeting.meetingStartTime' in 'field list'

2022-09-02 10:18:45.050 ***** ERROR ***** [V10.0.5] 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, 2) and ( ((meeting.idProject not in (0) or meeting.idProject is null ) and (meeting.idProject not in (0) or meeting.idProject is null or (meeting.idResource=1) ) and (meeting.idProject not in (0) or meeting.idProject is null or (meeting.idUser=1) )) ) order by meeting.id desc
2022-09-02 10:18:45.050 ***** ERROR ***** [V10.0.5] Strack trace :
2022-09-02 10:18:45.050 ***** ERROR ***** [V10.0.5] #0 Sql->query called at [/var/www/projeqtor/tool/jsonQuery.php:794]

Last edit: 02 Sep 2022 10:22 by matthieu.froment.

Please Connexion or Create an account to join the conversation.

More
02 Sep 2022 10:25 #4 by matthieu.froment
To add more information on the history :
- server installed with 10.0.0 and the issue was present
- upgraded yesterday to 10.0.5 and the issue is still here

Please Connexion or Create an account to join the conversation.

More
02 Sep 2022 11:25 #5 by babynus
You have an issue on your table meeting.
What is the first version of projeqtor that you installed ?
Can you you the DESC of table meeting ?

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
02 Sep 2022 16:04 #6 by babynus
Hi,
Another user had same issue.
Executing this script fixed the issue
ALTER TABLE `meeting` ADD COLUMN `meetingStartTime` time,
ADD COLUMN `meetingEndTime` time,
ADD COLUMN `location` varchar(100);

It is strange as this script is quite old (V2.2.0) and noone pointed aout an issue

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.060 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.