View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Issue upgrading to 11.2.3 - ProjeQtOr
 

Issue upgrading to 11.2.3

More
26 May 2024 13:11 #1 by mika095
Good morning

I tried updating from version 11.2.3 to 11.2.3. It failed. The logs indicate this

2024-05-26 12:59:20.814 ***** ERROR ***** [V11.1.5] Exception-[42S01] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'waitingupdate' already exists
2024-05-26 12:59:20.814 ***** ERROR ***** [V11.1.5]    For query: CREATE TABLE `waitingupdate` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT COMMENT '12',
`idUser` int(12) unsigned COMMENT '12',
`scope` varchar(100) DEFAULT NULL,
`itemId` int(12) unsigned COMMENT '12',
`parameter` varchar(100) DEFAULT NULL,
`storeDateTime` datetime,
PRIMARY KEY (`id`)
) ENGINE=innoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci ;
2024-05-26 12:59:20.814 ***** ERROR ***** [V11.1.5]    Strack trace:
2024-05-26 12:59:20.815 ***** ERROR ***** [V11.1.5] #0 Sql->query called at [/home/toak2365/xxx.yyyy.fr/db/maintenanceFunctions. php:72]
2024-05-26 12:59:20.815 ***** ERROR ***** [V11.1.5] #1 runScript called at [/home/toak2365/xxx.yyyy.fr/db/maintenance.php:178 ]
2024-05-26 12:59:20.815 ***** ERROR ***** [V11.1.5] #2 include called at [/home/toak2365/xxx.yyyy.fr/tool/loginCheck.php:144 ]

It still in v11.2.3.

If you have a solution, I'm interested.

THANKS

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

More
27 May 2024 11:34 #2 by maxca
Replied by maxca on topic Issue upgrading to 11.2.3
Hello,

"I tried updating from version 11.2.3 to 11.2.3." ? Installed working version? Upgrade wanted?
What DB do you use ?MySql or PostgreSql ?PHP? Which version ?
Have a nice day

Maxca

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

More
27 May 2024 20:19 #3 by babynus
Replied by babynus on topic Issue upgrading to 11.2.3

I tried updating from version 11.2.3 to 11.2.3. It failed. The logs indicate this

Your logs show you migrate from 11.1.5...
And says table already exists.
This may occur if you migrate from 11.1.5 to 11.2.3 (OK) then back to 11.1.5 (without restoring the DB) then again to 11.2.3.
ProjeQtOr has no revert process so when you revert ot 11.1.5, tables created for 11.2.3 still exist.
So when you get back to 11.2.3, they already exist.

This is not a major issue, you just have errors in logs, but applicaiton will work.

 

Babynus
Administrator of ProjeQtOr web site

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

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