View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - DATABASE UPDATED WITH 2 ERRORS (10.1.1) - ProjeQtOr
 

DATABASE UPDATED WITH 2 ERRORS (10.1.1)

More
28 Sep 2022 08:57 - 29 Sep 2022 09:45 #1 by sharky
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
Attachments:
Last edit: 29 Sep 2022 09:45 by sharky.

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

More
28 Sep 2022 17:24 #2 by babynus
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)

Babynus
Administrator of ProjeQtOr web site

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

More
29 Sep 2022 07:31 - 29 Sep 2022 07:36 #3 by sharky
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', '<div>Remplacer le produit <span class=\"scayt-misspell-word\">PositivID</span> &agrave; la PL</div>', 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', '<div>Remplacer le produit <span class=\"scayt-misspell-word\">PositivID</span> &agrave; la PL</div>', 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, '<div>Serveur : cardexchange01</div>', 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, '<div>Install&eacute; avec Chokri</div>', 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', '<div>Apr&egrave;s les tests, l&#39;offre sera valid&eacute;e pour la mise en production</div>', '2020-11-29', 3, 7, 3, '<div>L&#39;offre a &eacute;t&eacute; sign&eacute;, produit command&eacute;</div>', 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, '<div>L&#39;application virtualis&eacute;e fonctionne sur les VDI</div>\n\n<div>Le serveur de licence avec le client servira &agrave; la mise en production</div>', 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, '<div>Toutes les t&acirc;ches ont &eacute;t&eacute; faites</div>', 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, '<div>Formation effectuer par M. Bucher</div>', 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
Last edit: 29 Sep 2022 07:36 by sharky.

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

More
29 Sep 2022 09:14 #4 by babynus
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)

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: sharky

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

More
29 Sep 2022 09:44 - 29 Sep 2022 09:49 #5 by sharky
It's works !
Thank you
D&D = drag&drop 
Last edit: 29 Sep 2022 09:49 by sharky.

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

More
29 Sep 2022 09:55 #6 by babynus

D&D = drag&drop 

Yes, I stopped playing Dungeons & Dragons many years ago
 ;)

Babynus
Administrator of ProjeQtOr web site

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

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