View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] New Meeting : no time sélection possible - Page 2 - ProjeQtOr
 

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

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