Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Notifications
Clear all
Topic starter
Hello,
I have updated to 10.1.1 from 10.1.0 and I have the following error:
2022-09-28 08:21:33.933 ===== TRACE ===== ===================================== 2022-09-28 08:21:33.933 ===== TRACE ===== 2022-09-28 08:21:33.933 ===== TRACE ===== DataBase actual Version = V10.1.0 2022-09-28 08:21:33.933 ===== TRACE ===== ProjeQtOr actual Version = V10.1.1 2022-09-28 08:21:33.933 ===== TRACE ===== 2022-09-28 08:21:33.934 ===== TRACE ===== ===================================== 2022-09-28 08:21:33.934 ===== TRACE ===== 2022-09-28 08:21:33.935 ===== TRACE ===== VERSION V10.1.1 2022-09-28 08:21:33.935 ===== TRACE ===== 2022-09-28 08:21:33.936 ** ERROR ** [V10.1.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'projets_iwc.criticalresources' 2022-09-28 08:21:33.936 ** ERROR ** [V10.1.0] For query : DROP TABLE criticalresources; 2022-09-28 08:21:33.937 ** ERROR ** [V10.1.0] Strack trace : 2022-09-28 08:21:33.937 ** ERROR ** [V10.1.0] #0 Sql->query called at [/mypath/db/maintenanceFunctions.php:72] 2022-09-28 08:21:33.937 ** ERROR ** [V10.1.0] #1 runScript called at [/mypath/db/maintenance.php:140] 2022-09-28 08:21:33.937 ** ERROR ** [V10.1.0] #2 include called at [/mypath/tool/loginCheck.php:144] 2022-09-28 08:21:33.938 ===== TRACE ===== 2022-09-28 08:21:33.938 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V10.1.1 (see above message) 2022-09-28 08:21:33.938 ===== TRACE ===== 2022-09-28 08:21:33.938 ===== TRACE ===== ********************************************** 2022-09-28 08:21:33.938 ===== TRACE ===== 2022-09-28 08:21:33.939 ** ERROR ** [V10.1.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'projets_iwc.criticalresourcesprojects' 2022-09-28 08:21:33.939 ** ERROR ** [V10.1.0] For query : DROP TABLE criticalresourcesprojects; 2022-09-28 08:21:33.939 ** ERROR ** [V10.1.0] Strack trace : 2022-09-28 08:21:33.939 ** ERROR ** [V10.1.0] #0 Sql->query called at [/mypath/db/maintenanceFunctions.php:72] 2022-09-28 08:21:33.940 ** ERROR ** [V10.1.0] #1 runScript called at [/mypath/db/maintenance.php:140] 2022-09-28 08:21:33.940 ** ERROR ** [V10.1.0] #2 include called at [/mypath/tool/loginCheck.php:144] 2022-09-28 08:21:33.940 ===== TRACE ===== 2022-09-28 08:21:33.940 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V10.1.1 (see above message) 2022-09-28 08:21:33.941 ===== TRACE ===== 2022-09-28 08:21:33.941 ===== TRACE ===== ********************************************** 2022-09-28 08:21:33.941 ===== TRACE ===== 2022-09-28 08:21:33.941 ===== TRACE ===== 2022-09-28 08:21:33.941 ===== TRACE ===== DATABASE UPDATED 2022-09-28 08:21:33.942 ===== TRACE ===== WITH 2 ERRORS 2022-09-28 08:21:33.942 ===== TRACE ===== 2022-09-28 08:21:34.163 ===== TRACE ===== ===================================== 2022-09-28 08:21:34.163 ===== TRACE ===== 2022-09-28 08:21:34.163 ===== TRACE ===== 2 ERRORS DURING UPGRADE TO VERSION V10.1.1 2022-09-28 08:21:34.164 ===== TRACE ===== 2022-09-28 08:21:34.164 ===== TRACE ===== ===================================== 2022-09-28 08:21:34.164 ===== TRACE ===== 2022-09-28 08:21:40.883 ===== TRACE ===== NEW CONNECTED USER 'admin'
I also have this long-standing error that doesn't seem to be fixed automatically.
Thanks for your help
Posted : 28 Sep 2022 10H57
The two errors are minor, don't bother about them : we drop tables, that are not on your instance.
It seems your instance was already set to 10.1.1.
About the WBS issue, just try to mode the concerned project with D&D (or change its parent)
Posted : 28 Sep 2022 19H24
Topic starter
Hello,
Thank you for your feedback.
For the second point, I tried to reopen the project, to look for the parent, but I didn't find one.
Project 3: OK
WBS 00002 ??
You say : with D&D ? what is D&D ?
INSERT INTO `qtor_project` (`id`, `name`, `description`, `idClient`, `projectCode`, `contractCode`, `color`, `idProject`, `idle`, `idUser`, `done`, `idleDate`, `doneDate`, `idContact`, `sortOrder`, `idProjectType`, `codeType`, `idRecipient`, `paymentDelay`, `longitude`, `latitude`, `idStatus`, `idHealth`, `fixPlanning`, `clientCode`, `idOverallProgress`, `cancelled`, `idQuality`, `idTrend`, `idSponsor`, `creationDate`, `objectives`, `idResource`, `isUnderConstruction`, `lastUpdateDateTime`, `idOrganization`, `organizationInherited`, `organizationElementary`, `idCategory`, `handled`, `handledDate`, `excludeFromGlobalPlanning`, `fixPerimeter`, `isLeaveMngProject`, `commandOnValidWork`, `allowReduction`, `paused`, `startAM`, `endAM`, `startPM`, `endPM`, `idCatalogUO`, `strength`, `weakness`, `opportunity`, `threats`, `strategicvalue`, `idRiskLevel`, `benefitValue`) VALUES (3, 'Cardechange', 'Remplacer le produit PositivID à la PL', 2, '20-0040', NULL, NULL, NULL, 1, 3, 1, '2022-09-23', '2022-09-23', NULL, '00002', 48, 'OPE', NULL, NULL, '0.000000000000', '0.000000000000', 7, 2, 0, NULL, 7, 0, 1, 2, NULL, '2020-11-29', 'Remplacer le produit PositivID à la PL', 3, 0, '2022-09-23 11:18:41', 19, 0, 0, NULL, 1, '2022-09-23', 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), INSERT INTO `qtor_activity` (`id`, `idProject`, `idActivityType`, `name`, `description`, `creationDate`, `idUser`, `idStatus`, `idResource`, `result`, `comment`, `idle`, `idActivity`, `done`, `idleDate`, `doneDate`, `handled`, `handledDate`, `idVersion`, `reference`, `externalReference`, `idContact`, `cancelled`, `idComponent`, `idProduct`, `isPlanningActivity`, `lastUpdateDateTime`, `idComponentVersion`, `idMilestone`, `fixPlanning`, `paused`, `workOnRealTime`) VALUES (3, 3, 26, 'Création d'un serveur', NULL, '2020-11-29', 3, 7, 9, 'Serveur : cardexchange01', NULL, 1, 6, 1, '2020-11-29', '2020-10-30', 1, '2020-10-26', NULL, '20-00400001', NULL, 3, 0, NULL, NULL, 0, '2022-04-02 15:27:10', NULL, NULL, 0, 0, 0), (4, 3, 26, 'Installer SQLexpress', NULL, '2020-11-29', 3, 7, 3, 'Installé avec Chokri', NULL, 1, NULL, 1, '2020-11-29', '2020-11-05', 1, '2020-11-05', NULL, '20-00400002', NULL, 16, 0, NULL, NULL, 0, '2022-04-02 15:27:10', NULL, NULL, 0, 0, 0), (5, 3, 26, 'Valider l'offre', 'Après les tests, l'offre sera validée pour la mise en production', '2020-11-29', 3, 7, 3, 'L'offre a été signé, produit commandé', NULL, 1, 6, 1, '2020-11-29', '2020-11-06', 1, '2020-11-03', NULL, '20-00400003', NULL, 16, 0, NULL, NULL, 0, '2022-04-02 15:27:10', NULL, NULL, 0, 0, 0), (6, 3, 26, 'Test sur VDI', NULL, '2020-11-29', 3, 7, 3, 'L'application virtualisée fonctionne sur les VDInnLe serveur de licence avec le client servira à la mise en production', NULL, 1, NULL, 1, '2020-11-27', '2020-11-29', 1, '2020-11-29', NULL, '20-00400004', NULL, NULL, 0, NULL, NULL, 0, '2022-04-02 15:27:11', NULL, NULL, 0, 0, 0), (8, 3, 22, 'Mise en production', NULL, '2020-11-29', 3, 7, 3, 'Toutes les tâches ont été faites', NULL, 1, NULL, 1, '2020-11-29', '2020-11-29', 1, '2020-11-16', NULL, '20-00400005', NULL, 16, 0, NULL, NULL, 0, '2022-04-02 15:27:11', NULL, NULL, 0, 0, 0), (9, 3, 26, 'Formation', NULL, '2020-11-29', 3, 7, 3, 'Formation effectuer par M. Bucher', NULL, 1, 8, 1, '2020-11-29', '2020-11-29', 1, '2020-11-29', NULL, '20-00400006', NULL, NULL, 0, NULL, NULL, 0, '2022-04-02 15:27:11', NULL, NULL, 0, 0, 0),
Thank you
Posted : 29 Sep 2022 9H31
change de parent project, then move back your project to root, and possibly move it back to its place (with drag and drop on plannong view)
Posted : 29 Sep 2022 11H14
Topic starter
It's works !
Thank you
D&D = drag&drop 
Posted : 29 Sep 2022 11H44
D&D = drag&drop
Yes, I stopped playing Dungeons & Dragons many years ago
😉
Posted : 29 Sep 2022 11H55