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
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
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.