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
Hello
do you have any errors in the logs? in your browser console?
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]
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
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 ?
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
I'll check. I'll keep you posted !!
Hello, the ALTER command has solved the issue.
Here is the DESC of the 'meeting' table before the ALTER command :
MariaDB [projeqtor]> DESC meeting; +----------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+------------------+------+-----+---------+----------------+ | id | int(12) unsigned | NO | PRI | NULL | auto_increment | | idProject | int(12) unsigned | YES | MUL | NULL | | | idMeetingType | int(12) unsigned | YES | MUL | NULL | | | meetingDate | date | YES | | NULL | | | name | varchar(100) | YES | | NULL | | | attendees | varchar(4000) | YES | | NULL | | | idUser | int(12) unsigned | YES | MUL | NULL | | | sendTo | varchar(4000) | YES | | NULL | | | idStatus | int(12) unsigned | YES | MUL | NULL | | | idResource | int(12) unsigned | YES | MUL | NULL | | | result | mediumtext | YES | | NULL | | | idle | int(1) unsigned | YES | | 0 | | | idleDate | date | YES | | NULL | | | handled | int(1) unsigned | YES | | 0 | | | handledDate | date | YES | | NULL | | | done | int(1) unsigned | YES | | 0 | | | doneDate | date | YES | | NULL | | | description | mediumtext | YES | | NULL | | | reference | varchar(100) | YES | | NULL | | | externalReference | varchar(100) | YES | | NULL | | | idActivity | int(12) unsigned | YES | | NULL | | | idPeriodicMeeting | int(12) unsigned | YES | MUL | NULL | | | isPeriodic | int(1) unsigned | YES | | 0 | | | periodicOccurence | int(3) unsigned | YES | | NULL | | | cancelled | int(1) unsigned | YES | | 0 | | | meetingStartDateTime | datetime | YES | | NULL | | | meetingEndDateTime | datetime | YES | | NULL | | +----------------------+------------------+------+-----+---------+----------------+
And after the workaround :
MariaDB [projeqtor]> DESC meeting; +----------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+------------------+------+-----+---------+----------------+ | id | int(12) unsigned | NO | PRI | NULL | auto_increment | | idProject | int(12) unsigned | YES | MUL | NULL | | | idMeetingType | int(12) unsigned | YES | MUL | NULL | | | meetingDate | date | YES | | NULL | | | name | varchar(100) | YES | | NULL | | | attendees | varchar(4000) | YES | | NULL | | | idUser | int(12) unsigned | YES | MUL | NULL | | | sendTo | varchar(4000) | YES | | NULL | | | idStatus | int(12) unsigned | YES | MUL | NULL | | | idResource | int(12) unsigned | YES | MUL | NULL | | | result | mediumtext | YES | | NULL | | | idle | int(1) unsigned | YES | | 0 | | | idleDate | date | YES | | NULL | | | handled | int(1) unsigned | YES | | 0 | | | handledDate | date | YES | | NULL | | | done | int(1) unsigned | YES | | 0 | | | doneDate | date | YES | | NULL | | | description | mediumtext | YES | | NULL | | | reference | varchar(100) | YES | | NULL | | | externalReference | varchar(100) | YES | | NULL | | | idActivity | int(12) unsigned | YES | | NULL | | | idPeriodicMeeting | int(12) unsigned | YES | MUL | NULL | | | isPeriodic | int(1) unsigned | YES | | 0 | | | periodicOccurence | int(3) unsigned | YES | | NULL | | | cancelled | int(1) unsigned | YES | | 0 | | | meetingStartDateTime | datetime | YES | | NULL | | | meetingEndDateTime | datetime | YES | | NULL | | | meetingStartTime | time | YES | | NULL | | | meetingEndTime | time | YES | | NULL | | | location | varchar(100) | YES | | NULL | | +----------------------+------------------+------+-----+---------+----------------+ 30 rows in set (0.00 sec)
Regards