Date and time wrong.

Time examples.

Hi apmari how are you?

Apparently, the problem seems to be only with presentation layer. I think you do NOT need to rewrite all data again.

The column "Start" shows the creation date of table PROJECT. Do you remember exactly what table did you modified?

Thank you!

Ciao Alberto,
i modified the status of the projects, from closed to open.
Something like:
mysql> update project set project_status_id=replace(project_status_id,'3','1') where name = "test alfano";
Thanks,
apm

Hi,

could you perform the querys below and send the result?

select id, project_status_id from project;

select id, name, state_machine_order from project_status;

Thank you!

mysql> select id, project_status_id from project;
+-----+-------------------+
| id | project_status_id |
+-----+-------------------+
| 0 | |
| 208 | 1 |
| 210 | 1 |
| 230 | 1 |
| 231 | 1 |
| 232 | 1 |
| 233 | 1 |
| 234 | 1 |
| 235 | 1 |
| 236 | 1 |
| 237 | 1 |
| 238 | 1 |
| 241 | 1 |
| 268 | 1 |
| 273 | 1 |
| 274 | 1 |
| 275 | 1 |
| 276 | 1 |
| 285 | 1 |
| 286 | 1 |
| 287 | 1 |
| 289 | 1 |
| 306 | 1 |
+-----+-------------------+
23 rows in set (0.00 sec)

mysql> select id, name, state_machine_order from project_status;
+----+---------+---------------------+
| id | name | state_machine_order |
+----+---------+---------------------+
| 1 | Open | 1 |
| 2 | Closed | 3 |
| 3 | Aborted | 3 |
| 4 | on-Hold | 2 |
+----+---------+---------------------+
4 rows in set (0.00 sec)

mysql>

Hi,

I don't know if we found the real cause but the project with id="0" do not contain any status. This could be a problem eventually. The project with id="0" is a hidden project considered only internally by the tool. All projects are a child node (directly or indirectly) from this project. Then, it is important fix it using the sql below.

update project set project_status_id=1 where id=0;

Ciao.

calendar

Ciao Alberto,
changing the status of the project id=0 gave good results.
Now i can assign the dates with the correct values.
Last issues are in the calendar application. As i attached in the file calendar, the arrow with incremen or decrement the monts, doesn't work, the double arrow for the years work.
Last request, is possible to change the language from portugese to english?
Thanks Alberto.

Hi apmari, how are you?

1) about the calendar month button: It's strange...this button seems to be OK. Could you go to Plandora Demo Version and check if you can reproduce this bug? This bug happen in all calendars or in some specific form?

2) about the internationalization of calendar form: in fact, the labels of this form will be fixed at new Plandora release. For while, try the workaround: edit the file [YOUR_TOMCAT]\webapps\pandora\jscript\calendar.html

Thank you!

Ciao Alberto,
thanks again for your support.
I customized the file [YOUR_TOMCAT]\webapps\pandora\jscript\calendar.html .
Now it looks perfect.
For the main issue, always the calendar, the problem still exist.
If i click on the arrows of forward or backward of the month, it doesn't work.
The years arrows works.
The function in your demo pandora is working.
Check the attach and compare.
Thanks again,
apm

Month Arrows