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 - Page 2 - 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 20:40 #7 by matthieu.froment
I'll check. I'll keep you posted !!

Please Connexion or Create an account to join the conversation.

More
05 Sep 2022 10:56 #8 by matthieu.froment
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
 

Please Connexion or Create an account to join the conversation.

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