Hi,
Right click on icon as select "inspect".
Check url of image.
Then check that the corresponding image exists.
NB : the location of the image must be on the web root (check configuration for report files), otherwise images cannot be displayed
Hi,
As a test, we installed projeQtOr again and we saw that in this way the error that appeared in the reports could be solved, we also did it because when we wanted to update to the new version we also had problems.
Now, since these errors have been fixed, we want to migrate all the data that we have in the production environment to this new instance that has no errors. Is there a safe way to do this?
We understand that a complete copy of the binaries cannot be because it would bring the errors that were corrected in this new installation that was made.
Thanks!
Just export (dump) the database and reimport into new instance.
Hi,
Thanks for your answer.
We did the projeqtor update and we also did the steps that you mentioned in the previous post for the database; the update and load of the database was done correctly, it did not show us any errors.
We use these commands to make the copy of the database:
mysqldump -u root -p --all-databases > /home/opc/projeqtor.dump
mysql -u root -p < /home/opc/projeqtor.dump
The problem we now have is that when we see the list of projects, some of the names are not there (As you can see in the image), the same happens with the name of some activities, with the resources, with the dedications.
Do you know why this happens? What has to be done to solve this problem?
I also attach the detail of the log file2021-11-19 15:46:59.403 ===== TRACE ===== NEW CONNECTED USER 'admin'
2021-11-19 15:56:02.205 ===== TRACE ===== DISCONNECTED USER 'admin'
2021-11-19 15:56:03.496 ===== TRACE ===== NEW CONNECTED USER 'admin' (using remember me feature)
2021-11-19 15:56:26.376 ===== TRACE ===== DISCONNECTED USER 'admin'
2021-11-19 15:57:15.597 ===== TRACE ===== NEW CONNECTED USER 'admin'
2021-11-19 15:57:36.797 ===== TRACE ===== DISCONNECTED USER 'admin'
2021-11-19 16:00:47.104 ===== TRACE =====
2021-11-19 16:00:47.104 ===== TRACE ===== =====================================
2021-11-19 16:00:47.104 ===== TRACE =====
2021-11-19 16:00:47.104 ===== TRACE ===== DataBase actual Version = V9.1.2
2021-11-19 16:00:47.104 ===== TRACE ===== ProjeQtOr actual Version = V9.3.2
2021-11-19 16:00:47.104 ===== TRACE =====
2021-11-19 16:00:47.104 ===== TRACE ===== =====================================
2021-11-19 16:00:47.104 ===== TRACE =====
2021-11-19 16:00:47.104 ===== TRACE ===== VERSION V9.2.0
2021-11-19 16:00:47.104 ===== TRACE =====
2021-11-19 16:00:47.107 ===== TRACE ===== 3 lines inserted into table "parameter".
2021-11-19 16:00:47.114 ===== TRACE ===== Table "type" altered.
2021-11-19 16:00:47.165 ===== TRACE ===== Table "activity" altered.
2021-11-19 16:00:47.178 ===== TRACE ===== Table "statusperiod" created.
2021-11-19 16:00:47.180 ===== TRACE ===== 6 lines inserted into table "habilitationother".
2021-11-19 16:00:47.182 ===== TRACE ===== 5 lines inserted into table "habilitationother".
2021-11-19 16:00:47.184 ===== TRACE ===== 1 lines updated into table "status".
2021-11-19 16:00:47.188 ===== TRACE ===== Table "delay" altered.
2021-11-19 16:00:47.194 ===== TRACE ===== Table "project" altered.
2021-11-19 16:00:47.203 ===== TRACE ===== Table "activityworkunit" created.
2021-11-19 16:00:47.204 ===== TRACE ===== 0 lines inserted into table "activityworkunit".
2021-11-19 16:00:47.207 ===== TRACE ===== Table "planningelement" altered.
2021-11-19 16:00:47.213 ===== TRACE ===== Table "planningelementbaseline" altered.
2021-11-19 16:00:47.216 ===== TRACE ===== Table "workcommanddone" altered.
2021-11-19 16:00:47.217 ===== TRACE ===== 0 lines updated into table "planningelement".
2021-11-19 16:00:47.217 ===== TRACE ===== 0 lines deleted from table "workcommanddone".
2021-11-19 16:00:47.218 ===== TRACE ===== 0 lines inserted into table "workcommanddone".
2021-11-19 16:00:47.309 ===== TRACE ===== Table "planningelement" altered.
2021-11-19 16:00:47.381 ===== TRACE ===== Table "planningelement" altered.
2021-11-19 16:00:47.467 ===== TRACE ===== Table "planningelement" altered.
2021-11-19 16:00:47.520 ===== TRACE ===== Table "planningelement" altered.
2021-11-19 16:00:47.584 ===== TRACE ===== Table "planningelementbaseline" altered.
2021-11-19 16:00:47.616 ===== TRACE ===== Table "planningelementbaseline" altered.
2021-11-19 16:00:47.675 ===== TRACE ===== Table "planningelementbaseline" altered.
2021-11-19 16:00:47.710 ===== TRACE ===== Table "planningelementbaseline" altered.
2021-11-19 16:00:47.713 ===== TRACE ===== Table "ticket" altered.
2021-11-19 16:00:47.716 ===== TRACE ===== Table "ticket" altered.
2021-11-19 16:00:47.719 ===== TRACE ===== Table "type" altered.
2021-11-19 16:00:47.721 ===== TRACE ===== 1 lines inserted into table "menu".
2021-11-19 16:00:47.723 ===== TRACE ===== 1 lines inserted into table "navigation".
2021-11-19 16:00:47.725 ===== TRACE ===== 3 lines inserted into table "habilitation".
2021-11-19 16:00:47.728 ===== TRACE ===== Table "documentdirectory" altered.
2021-11-19 16:00:47.731 ===== TRACE ===== Table "documentdirectory" altered.
2021-11-19 16:00:47.772 ===== TRACE ===== Index "documentdirectoryResource" created.
2021-11-19 16:00:47.781 ===== TRACE ===== Index "documentdirectoryUser" created.
2021-11-19 16:00:47.784 ===== TRACE ===== 13 lines updated into table "documentdirectory".
2021-11-19 16:00:47.788 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:47.797 ===== TRACE ===== Table "documentright" created.
2021-11-19 16:00:47.800 ===== TRACE ===== 143 lines inserted into table "documentright".
2021-11-19 16:00:47.803 ===== TRACE ===== 3 lines updated into table "type".
2021-11-19 16:00:47.805 ===== TRACE ===== 5 lines inserted into table "report".
2021-11-19 16:00:47.806 ===== TRACE ===== 5 lines inserted into table "habilitationreport".
2021-11-19 16:00:47.809 ===== TRACE ===== 26 lines inserted into table "reportparameter".
2021-11-19 16:00:47.810 ===== TRACE ===== 5 lines inserted into table "modulereport".
2021-11-19 16:00:47.821 ===== TRACE ===== Table "macrostatus" created.
2021-11-19 16:00:47.867 ===== TRACE ===== 3 lines inserted into table "macrostatus".
2021-11-19 16:00:47.869 ===== TRACE ===== 3 lines deleted from table "accessright".
2021-11-19 16:00:47.873 ===== TRACE ===== Table "subtask" altered.
2021-11-19 16:00:47.910 ===== TRACE ===== Table "workcommanddone" altered.
2021-11-19 16:00:47.991 ===== TRACE ===== Table "workcommandbilled" altered.
2021-11-19 16:00:48.027 ===== TRACE ===== Table "workcommand" altered.
2021-11-19 16:00:48.089 ===== TRACE ===== Table "workcommand" altered.
2021-11-19 16:00:48.124 ===== TRACE ===== Table "workcommand" altered.
2021-11-19 16:00:48.191 ===== TRACE ===== Table "workcommand" altered.
2021-11-19 16:00:48.227 ===== TRACE ===== Table "workcommand" altered.
2021-11-19 16:00:48.284 ===== TRACE ===== Table "workcommand" altered.
2021-11-19 16:00:48.318 ===== TRACE ===== Table "workcommand" altered.
2021-11-19 16:00:48.321 ===== TRACE ===== Table "asset" altered.
2021-11-19 16:00:48.331 ===== TRACE ===== Table "kpivaluerequest" created.
2021-11-19 16:00:48.366 ===== TRACE ===== Index "kpivaluerequestReference" created.
2021-11-19 16:00:48.367 ===== TRACE ===== 1 lines inserted into table "cronexecution".
2021-11-19 16:00:48.369 ===== TRACE ===== 1 lines inserted into table "parameter".
2021-11-19 16:00:48.379 ===== TRACE ===== Table "pokercomplexity" created.
2021-11-19 16:00:48.389 ===== TRACE ===== Table "pokersession" created.
2021-11-19 16:00:48.399 ===== TRACE ===== Table "pokerresource" created.
2021-11-19 16:00:48.413 ===== TRACE ===== Table "pokeritem" created.
2021-11-19 16:00:48.422 ===== TRACE ===== Table "pokervote" created.
2021-11-19 16:00:48.424 ===== TRACE ===== 4 lines inserted into table "menu".
2021-11-19 16:00:48.426 ===== TRACE ===== 4 lines inserted into table "navigation".
2021-11-19 16:00:48.428 ===== TRACE ===== 11 lines inserted into table "pokercomplexity".
2021-11-19 16:00:48.430 ===== TRACE ===== 2 lines inserted into table "type".
2021-11-19 16:00:48.432 ===== TRACE ===== 1 lines inserted into table "module".
2021-11-19 16:00:48.434 ===== TRACE ===== 4 lines inserted into table "modulemenu".
2021-11-19 16:00:48.435 ===== TRACE ===== 9 lines inserted into table "habilitation".
2021-11-19 16:00:48.438 ===== TRACE ===== 11 lines inserted into table "habilitation".
2021-11-19 16:00:48.466 ===== TRACE ===== 16 lines inserted into table "accessright".
2021-11-19 16:00:48.469 ===== TRACE ===== Table "workunit" altered.
2021-11-19 16:00:48.472 ===== TRACE ===== 6 lines inserted into table "cronexecution".
2021-11-19 16:00:48.476 ===== TRACE ===== Table "navigation" altered.
2021-11-19 16:00:48.478 ===== TRACE ===== 1 lines updated into table "navigation".
2021-11-19 16:00:48.481 ===== TRACE ===== 1 lines updated into table "navigation".
2021-11-19 16:00:48.483 ===== TRACE ===== 4 lines inserted into table "menu".
2021-11-19 16:00:48.485 ===== TRACE ===== 4 lines inserted into table "habilitation".
2021-11-19 16:00:48.487 ===== TRACE ===== 3 lines inserted into table "accessright".
2021-11-19 16:00:48.489 ===== TRACE ===== 1 lines inserted into table "module".
2021-11-19 16:00:48.490 ===== TRACE ===== 3 lines inserted into table "modulemenu".
2021-11-19 16:00:48.504 ===== TRACE ===== Table "localizationtranslator" created.
2021-11-19 16:00:48.514 ===== TRACE ===== Table "localizationtranslatorlanguage" created.
2021-11-19 16:00:48.523 ===== TRACE ===== Table "languageskilllevel" created.
2021-11-19 16:00:48.525 ===== TRACE ===== 1 lines inserted into table "menu".
2021-11-19 16:00:48.526 ===== TRACE ===== 1 lines inserted into table "habilitation".
2021-11-19 16:00:48.528 ===== TRACE ===== 1 lines inserted into table "accessright".
2021-11-19 16:00:48.530 ===== TRACE ===== 1 lines inserted into table "menu".
2021-11-19 16:00:48.532 ===== TRACE ===== 1 lines inserted into table "habilitation".
2021-11-19 16:00:48.574 ===== TRACE ===== Table "localizationrequest" created.
2021-11-19 16:00:48.576 ===== TRACE ===== Table "type" altered.
2021-11-19 16:00:48.587 ===== TRACE ===== Table "localizationItem" created.
2021-11-19 16:00:48.590 ===== TRACE ===== 1 lines inserted into table "menu".
2021-11-19 16:00:48.592 ===== TRACE ===== 1 lines inserted into table "habilitation".
2021-11-19 16:00:48.595 ===== TRACE ===== 2 lines inserted into table "mailable".
2021-11-19 16:00:48.599 ===== TRACE ===== Table "type" altered.
2021-11-19 16:00:48.602 ===== TRACE ===== 13 lines inserted into table "navigation".
2021-11-19 16:00:48.604 ===== TRACE ===== 1 lines updated into table "navigation".
2021-11-19 16:00:48.606 ===== TRACE ===== 1 lines updated into table "navigation".
2021-11-19 16:00:48.608 ===== TRACE ===== 3 lines inserted into table "modulemenu".
2021-11-19 16:00:48.611 ===== TRACE ===== 3 lines inserted into table "languageskilllevel".
2021-11-19 16:00:48.613 ===== TRACE ===== 3 lines inserted into table "type".
2021-11-19 16:00:48.616 ===== TRACE ===== 2 lines inserted into table "eventformail".
2021-11-19 16:00:48.617 ===== TRACE ===== 2 lines inserted into table "parameter".
2021-11-19 16:00:48.619 ===== TRACE ===== 1 lines inserted into table "mailable".
2021-11-19 16:00:48.621 ===== TRACE ===== 1 lines updated into table "report".
2021-11-19 16:00:48.623 ===== TRACE ===== 1 lines updated into table "report".
2021-11-19 16:00:48.625 ===== TRACE ===== 1 lines updated into table "report".
2021-11-19 16:00:48.627 ===== TRACE ===== 1 lines updated into table "report".
2021-11-19 16:00:48.628 ===== TRACE ===== 1 lines updated into table "navigation".
2021-11-19 16:00:48.630 ===== TRACE ===== 1 lines updated into table "navigation".
2021-11-19 16:00:48.633 ===== TRACE ===== Table "message" altered.
2021-11-19 16:00:48.665 ===== TRACE ===== Table "message" altered.
2021-11-19 16:00:48.667 ===== TRACE ===== 11 lines inserted into table "reportparameter".
2021-11-19 16:00:48.680 ===== TRACE ===== Index "indicatorvalueType" created.
2021-11-19 16:00:48.681 ===== TRACE =====
2021-11-19 16:00:48.681 ===== TRACE ===== DATABASE UPDATED
2021-11-19 16:00:48.681 ===== TRACE ===== WITH NO ERROR
2021-11-19 16:00:48.681 ===== TRACE =====
2021-11-19 16:00:48.681 ===== TRACE ===== =====================================
2021-11-19 16:00:48.681 ===== TRACE =====
2021-11-19 16:00:48.681 ===== TRACE ===== VERSION V9.2.1
2021-11-19 16:00:48.681 ===== TRACE =====
2021-11-19 16:00:48.683 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.683 ===== TRACE =====
2021-11-19 16:00:48.683 ===== TRACE ===== DATABASE UPDATED
2021-11-19 16:00:48.683 ===== TRACE ===== WITH NO ERROR
2021-11-19 16:00:48.683 ===== TRACE =====
2021-11-19 16:00:48.683 ===== TRACE ===== =====================================
2021-11-19 16:00:48.683 ===== TRACE =====
2021-11-19 16:00:48.683 ===== TRACE ===== VERSION V9.3.0
2021-11-19 16:00:48.683 ===== TRACE =====
2021-11-19 16:00:48.687 ===== TRACE ===== Table "pokeritem" altered.
2021-11-19 16:00:48.691 ===== TRACE ===== Table "pokersession" altered.
2021-11-19 16:00:48.694 ===== TRACE ===== Table "pokersession" altered.
2021-11-19 16:00:48.697 ===== TRACE ===== Table "pokersession" altered.
2021-11-19 16:00:48.790 ===== TRACE ===== Table "pokersession" altered.
2021-11-19 16:00:48.864 ===== TRACE ===== Table "pokersession" altered.
2021-11-19 16:00:48.897 ===== TRACE ===== Table "pokersession" altered.
2021-11-19 16:00:48.934 ===== TRACE ===== Table "pokersession" altered.
2021-11-19 16:00:48.965 ===== TRACE ===== Table "pokercomplexity" altered.
2021-11-19 16:00:48.967 ===== TRACE ===== 1 lines updated into table "module".
2021-11-19 16:00:48.969 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.971 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.973 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.975 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.977 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.979 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.981 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.983 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:48.986 ===== TRACE ===== Table "pokerresource" altered.
2021-11-19 16:00:48.989 ===== TRACE ===== 1 lines inserted into table "planningmode".
2021-11-19 16:00:48.990 ===== TRACE ===== 4 lines inserted into table "accessright".
2021-11-19 16:00:48.993 ===== TRACE ===== 1 lines updated into table "navigation".
2021-11-19 16:00:48.995 ===== TRACE ===== 3 lines updated into table "navigation".
2021-11-19 16:00:48.996 ===== TRACE ===== 1 lines inserted into table "navigation".
2021-11-19 16:00:49.006 ===== TRACE ===== Table "highlight" created.
2021-11-19 16:00:49.008 ===== TRACE ===== 1 lines inserted into table "cronexecution".
2021-11-19 16:00:49.010 ===== TRACE ===== Table "module" altered.
2021-11-19 16:00:49.066 ===== TRACE ===== Table "module" altered.
2021-11-19 16:00:49.069 ===== TRACE ===== 6 lines inserted into table "module".
2021-11-19 16:00:49.071 ===== TRACE ===== 1 lines updated into table "module".
2021-11-19 16:00:49.073 ===== TRACE ===== 1 lines updated into table "module".
2021-11-19 16:00:49.075 ===== TRACE ===== 1 lines updated into table "module".
2021-11-19 16:00:49.076 ===== TRACE ===== 1 lines updated into table "module".
2021-11-19 16:00:49.078 ===== TRACE ===== 1 lines updated into table "module".
2021-11-19 16:00:49.080 ===== TRACE ===== 1 lines updated into table "module".
2021-11-19 16:00:49.082 ===== TRACE ===== 2 lines updated into table "module".
2021-11-19 16:00:49.084 ===== TRACE ===== 2 lines updated into table "module".
2021-11-19 16:00:49.086 ===== TRACE ===== 2 lines inserted into table "modulemenu".
2021-11-19 16:00:49.099 ===== TRACE ===== Index "historyarchiveRef" created.
2021-11-19 16:00:49.101 ===== TRACE ===== Table "messagelegal" altered.
2021-11-19 16:00:49.103 ===== TRACE ===== 1 lines inserted into table "copyable".
2021-11-19 16:00:49.106 ===== TRACE ===== Table "command" altered.
2021-11-19 16:00:49.109 ===== TRACE ===== Table "inputmailbox" altered.
2021-11-19 16:00:49.111 ===== TRACE ===== 1 lines inserted into table "notifiable".
2021-11-19 16:00:49.111 ===== TRACE =====
2021-11-19 16:00:49.111 ===== TRACE ===== DATABASE UPDATED
2021-11-19 16:00:49.111 ===== TRACE ===== WITH NO ERROR
2021-11-19 16:00:49.111 ===== TRACE =====
2021-11-19 16:00:49.111 ===== TRACE ===== =====================================
2021-11-19 16:00:49.111 ===== TRACE =====
2021-11-19 16:00:49.111 ===== TRACE ===== VERSION V9.3.1
2021-11-19 16:00:49.111 ===== TRACE =====
2021-11-19 16:00:49.114 ===== TRACE ===== 2 lines updated into table "reportparameter".
2021-11-19 16:00:49.114 ===== TRACE =====
2021-11-19 16:00:49.114 ===== TRACE ===== DATABASE UPDATED
2021-11-19 16:00:49.114 ===== TRACE ===== WITH NO ERROR
2021-11-19 16:00:49.114 ===== TRACE =====
2021-11-19 16:00:49.114 ===== TRACE ===== =====================================
2021-11-19 16:00:49.114 ===== TRACE =====
2021-11-19 16:00:49.114 ===== TRACE ===== VERSION V9.3.2
2021-11-19 16:00:49.114 ===== TRACE =====
2021-11-19 16:00:49.117 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:49.165 ===== TRACE ===== 1 lines updated into table "menu".
2021-11-19 16:00:49.165 ===== TRACE =====
2021-11-19 16:00:49.165 ===== TRACE ===== DATABASE UPDATED
2021-11-19 16:00:49.165 ===== TRACE ===== WITH NO ERROR
2021-11-19 16:00:49.165 ===== TRACE =====
2021-11-19 16:00:49.167 ===== TRACE ===== update workCommandDone [9.2.0]
2021-11-19 16:00:49.480 ===== TRACE ===== => 0 to update
2021-11-19 16:00:49.482 ===== TRACE ===== => 0 workCommandDone updated
2021-11-19 16:00:49.482 ===== TRACE ===== update project [9.2.0]
2021-11-19 16:00:49.482 ===== TRACE ===== => 1 project updated
2021-11-19 16:00:50.069 ===== TRACE ===== =====================================
2021-11-19 16:00:50.069 ===== TRACE =====
2021-11-19 16:00:50.069 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V9.3.2
2021-11-19 16:00:50.069 ===== TRACE =====
2021-11-19 16:00:50.069 ===== TRACE ===== =====================================
2021-11-19 16:00:50.069 ===== TRACE =====
2021-11-19 16:01:16.811 ===== TRACE ===== NEW CONNECTED USER 'admin'
2021-11-19 17:10:34.173 ===== TRACE ===== DISCONNECTED USER 'admin'
2021-11-19 17:10:35.602 ===== TRACE ===== NEW CONNECTED USER 'admin' (using remember me feature)
2021-11-19 17:19:53.798 ===== TRACE ===== NEW CONNECTED USER 'admin'
You have encoding issue.
I guess names that do not appear have accentued characters.
ProjeQtOr expects data in UTF-8.
The dump you export / import may not have correct charset.
Hi,
Sorry for the delay, we have been doing some tests and testing with some commands so that the records that are not shown appear, which are indeed the records that are accented, unfortunately we have not been able to make them appear again.
These are the commands we use:
- The first command
mysqldump -u root -p h3_projeqtor -r utf8.dump
- The second command
mysql -u root -p --default-character-set=utf8 h3_projeqtor
SET names 'utf8'
SOURCE utf8.dump;
- And this is the third command
SELECT default_character_set_name FROM information_schema.SCHEMATA
WHERE schema_name = "h3_projeqtor";
It is also important to mention that the origin is in UTF-8
MariaDB [(none)]> SELECT default_character_set_name FROM information_schema.SCHEMATA
-> WHERE schema_name = "h3_projeqtor";
+----------------------------+
| default_character_set_name |
+----------------------------+
| utf8 |
+----------------------------+
1 row in set (0.000 sec)
Is there anything else that can be done? Or is there some other way to make accented records appear?
Thanks!
First, ensure that exported dump (utf8.dump) is really in UTF-8.
It may happen that even if default charset is in UTF-8, dump exported is not.
If all is OK and data in DB is in UTF-8, ensure you have in projeqtor configurartion file parameters.php
$enforceUTF8 = '1';