Forum

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.

Issue upgrading to ...
 
Notifications
Clear all

Issue upgrading to 11.2.3

3 Posts
3 Users
0 Reactions
1,079 Views
(@mika095)
Posts: 9
Active Member
Topic starter
 
[#9465]

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


 
Posted : 26 May 2024 15H11
Maxca
(@maxime)
Posts: 274
Active Member Admin
 

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


 
Posted : 27 May 2024 13H34
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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.

 


 
Posted : 27 May 2024 22H19
Share:

Scroll to Top