View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - v7.0.9 the calendar on/off feature does not work - ProjeQtOr
 

v7.0.9 the calendar on/off feature does not work

More
16 Aug 2018 17:23 #1 by piadm
v7.0.9 the calendar on/off feature does not work was created by piadm
Hi,

As already reported in this issue the calendar on/off feature does not work when you click on a date.

A quick analysis makes me think the problem comes from the switchDay() function in tool/saveCalendar.php that uses getSingleSqlElementFromCriteria() but the calendar table itself contains one more row for each click on the same day:
select * from calendar where calendardate='2018-08-15';
 id | name | isoffday | calendardate |   day    |  week  | month  | year | idle | idcalendardefinition
----+------+----------+--------------+----------+--------+--------+------+------+----------------------
 27 |      |        1 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    2
 29 |      |        1 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
 37 |      |        1 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
 44 |      |        0 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
 45 |      |        0 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
 46 |      |        0 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
 47 |      |        0 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
 48 |      |        0 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
 49 |      |        0 | 2018-08-15   | 20180815 | 201833 | 201808 | 2018 |    0 |                    1
(9 rows)

In fact an admin closed the default standard calendar (id=1) and the only other one available as well. That was a mistake of course as it was not possible to create resources anymore. I unticked the "close" option for the default calendar and it seems that blindly inserted the rows 37 to 43 in the calendar table... but there was already a row 29 for the date 2018-08-15' in the default calendar. Starting from that time there were 2 rows in the calendar table and each click on that date adds one more.

So the problem is probably not coming from the switchDay() function but from these duplicate rows. As un-closing a calendardefinition insert rows in the calendar table (default rows?), closing a calendar should remove them, but that apparently did not happen.

Question: To fix this can I just delete the calendar rows 37 to 49?

Please Log in or Create an account to join the conversation.

More
17 Aug 2018 09:19 #2 by babynus
Replied by babynus on topic v7.0.9 the calendar on/off feature does not work
Yes, you can delete rows in the table.
This one is a simple one.

This will just remove off days from the calendar.
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
17 Aug 2018 15:55 #3 by piadm
Replied by piadm on topic v7.0.9 the calendar on/off feature does not work
Done.

Thank you for your help Babynus.

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.041 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.

Login Form