DATABASE UPDATED WITH 2 ERRORS (10.1.1)

Start
Prev
1
Next
End

sharky
Topic Author
Offline
Junior Member

28 Sep 2022 08:57 - 29 Sep 2022 09:45 #1 by sharky

DATABASE UPDATED WITH 2 ERRORS (10.1.1) was created 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

Last edit: 29 Sep 2022 09:45 by sharky.

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

babynus
Offline
Administrator
Moderator

28 Sep 2022 17:24 #2 by babynus

Replied by babynus on topic DATABASE UPDATED WITH 2 ERRORS (10.1.1)

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.

sharky
Topic Author
Offline
Junior Member

29 Sep 2022 07:31 - 29 Sep 2022 07:36 #3 by sharky

Replied by sharky on topic DATABASE UPDATED WITH 2 ERRORS (10.1.1)

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.

babynus
Offline
Administrator
Moderator

29 Sep 2022 09:14 #4 by babynus

Replied by babynus on topic DATABASE UPDATED WITH 2 ERRORS (10.1.1)

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.

sharky
Topic Author
Offline
Junior Member

29 Sep 2022 09:44 - 29 Sep 2022 09:49 #5 by sharky

Replied by sharky on topic DATABASE UPDATED WITH 2 ERRORS (10.1.1)

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.

babynus
Offline
Administrator
Moderator

29 Sep 2022 09:55 #6 by babynus

Replied by babynus on topic DATABASE UPDATED WITH 2 ERRORS (10.1.1)

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.

Start
Prev
1
Next
End

Moderators: babynus, protion

Time to create page: 0.058 seconds

DATABASE UPDATED WITH 2 ERRORS (10.1.1)

Attachments:

Cookies settings

Functional Cookies

Session

Other cookies

DATABASE UPDATED WITH 2 ERRORS (10.1.1)

Attachments:

Cookies settings

Functional Cookies

Session

Other cookies

Login Form