abobader

Thanks Miss_B, you always give great help, will read that.

Hi Jim, Really, all tables are utf8mb4, but when I use this command: Where to fix this? Thanks

That what kill the test site since Saturday:

Hi Marc, The live site still on 4.7.20. The test site I upgrade it from 4.7.20 to v5, thing was going fine till last patch "about paypal" or something did this issue. Yes, the test site is a copy from the live site from the past. You can login to the test site and see. Thanks.

The DB is already UTF8MB4 from the IPS v4

Here what I have at uploads\logs for this: Sat, 08 Feb 2025 15:35:30 +0000 IPS\Db\Exception::1366 Incorrect string value: '\xED\xA0\xBD\xED\xB8\x82' for column 'mt_title' at row 14192 #0 /home/******/web/******/public_html/community/system/Db/Db.php(2224): IPS\Db->query() #1 /home/******/web/******/public_html/community/system/Application/Application.php(1765): IPS\Db->dropColumn() #2 /home/******/web/******/public_html/community/applications/core/sources/Setup/Upgrade.php(565): IPS\Application->installDatabaseUpdates() #3 /home/******/web/******/public_html/community/applications/core/sources/Setup/Upgrade.php(369): IPS\core\Setup\Upgrade->step1() #4 /home/******/web/******/public_html/community/applications/core/modules/setup/upgrade/upgrade.php(60): IPS\core\Setup\Upgrade->process() #5 /home/******/web/******/public_html/community/system/Helpers/MultipleRedirect/MultipleRedirect.php(104): IPS\core\modules\setup\upgrade\upgrade->IPS\core\modules\setup\upgrade\{closure}() #6 /home/******/web/******/public_html/community/applications/core/modules/setup/upgrade/upgrade.php(45): IPS\Helpers\MultipleRedirect->__construct() #7 /home/******/web/******/public_html/community/system/Dispatcher/Controller.php(139): IPS\core\modules\setup\upgrade\upgrade->manage() #8 /home/******/web/******/public_html/community/system/Dispatcher/Setup.php(261): IPS\Dispatcher\Controller->execute() #9 /home/******/web/******/public_html/community/admin/upgrade/index.php(38): IPS\Dispatcher\Setup->run() #10 {main} ------------- Sat, 08 Feb 2025 15:38:04 +0000 IPS\Db\Exception::1366 Incorrect string value: '\xED\xA0\xBD\xED\xB8\x82' for column 'mt_title' at row 14192 #0 /home/******/web/******/public_html/community/system/Db/Db.php(2224): IPS\Db->query() #1 /home/******/web/******/public_html/community/system/Application/Application.php(1765): IPS\Db->dropColumn() #2 /home/******/web/******/public_html/community/applications/core/sources/Setup/Upgrade.php(565): IPS\Application->installDatabaseUpdates() #3 /home/******/web/******/public_html/community/applications/core/sources/Setup/Upgrade.php(369): IPS\core\Setup\Upgrade->step1() #4 /home/******/web/******/public_html/community/applications/core/modules/setup/upgrade/upgrade.php(60): IPS\core\Setup\Upgrade->process() #5 /home/******/web/******/public_html/community/system/Helpers/MultipleRedirect/MultipleRedirect.php(104): IPS\core\modules\setup\upgrade\upgrade->IPS\core\modules\setup\upgrade\{closure}() #6 /home/******/web/******/public_html/community/applications/core/modules/setup/upgrade/upgrade.php(45): IPS\Helpers\MultipleRedirect->__construct() #7 /home/******/web/******/public_html/community/system/Dispatcher/Controller.php(139): IPS\core\modules\setup\upgrade\upgrade->manage() #8 /home/******/web/******/public_html/community/system/Dispatcher/Setup.php(261): IPS\Dispatcher\Controller->execute() #9 /home/******/web/******/public_html/community/admin/upgrade/index.php(38): IPS\Dispatcher\Setup->run() #10 {main} ------------- Sat, 08 Feb 2025 15:40:15 +0000 IPS\Db\Exception::1366 Incorrect string value: '\xED\xA0\xBD\xED\xB8\x82' for column 'mt_title' at row 14192 #0 /home/******/web/******/public_html/community/system/Db/Db.php(2224): IPS\Db->query() #1 /home/******/web/******/public_html/community/system/Application/Application.php(1765): IPS\Db->dropColumn() #2 /home/******/web/******/public_html/community/applications/core/sources/Setup/Upgrade.php(565): IPS\Application->installDatabaseUpdates() #3 /home/******/web/******/public_html/community/applications/core/sources/Setup/Upgrade.php(369): IPS\core\Setup\Upgrade->step1() #4 /home/******/web/******/public_html/community/applications/core/modules/setup/upgrade/upgrade.php(60): IPS\core\Setup\Upgrade->process() #5 /home/******/web/******/public_html/community/system/Helpers/MultipleRedirect/MultipleRedirect.php(104): IPS\core\modules\setup\upgrade\upgrade->IPS\core\modules\setup\upgrade\{closure}() #6 /home/******/web/******/public_html/community/applications/core/modules/setup/upgrade/upgrade.php(45): IPS\Helpers\MultipleRedirect->__construct() #7 /home/******/web/******/public_html/community/system/Dispatcher/Controller.php(139): IPS\core\modules\setup\upgrade\upgrade->manage() #8 /home/******/web/******/public_html/community/system/Dispatcher/Setup.php(261): IPS\Dispatcher\Controller->execute() #9 /home/******/web/******/public_html/community/admin/upgrade/index.php(38): IPS\Dispatcher\Setup->run() #10 {main} ------------- Sat, 08 Feb 2025 15:40:20 +0000 IPS\Db\Exception::1366 Incorrect string value: '\xED\xA0\xBD\xED\xB8\x82' for column 'mt_title' at row 14192 #0 /home/******/web/******/public_html/community/system/Db/Db.php(2224): IPS\Db->query() #1 /home/******/web/******/public_html/community/system/Application/Application.php(1765): IPS\Db->dropColumn() #2 /home/******/web/******/public_html/community/applications/core/sources/Setup/Upgrade.php(565): IPS\Application->installDatabaseUpdates() #3 /home/******/web/******/public_html/community/applications/core/sources/Setup/Upgrade.php(369): IPS\core\Setup\Upgrade->step1() #4 /home/******/web/******/public_html/community/applications/core/modules/setup/upgrade/upgrade.php(60): IPS\core\Setup\Upgrade->process() #5 /home/******/web/******/public_html/community/system/Helpers/MultipleRedirect/MultipleRedirect.php(104): IPS\core\modules\setup\upgrade\upgrade->IPS\core\modules\setup\upgrade\{closure}() #6 /home/******/web/******/public_html/community/applications/core/modules/setup/upgrade/upgrade.php(45): IPS\Helpers\MultipleRedirect->__construct() #7 /home/******/web/******/public_html/community/system/Dispatcher/Controller.php(139): IPS\core\modules\setup\upgrade\upgrade->manage() #8 /home/******/web/******/public_html/community/system/Dispatcher/Setup.php(261): IPS\Dispatcher\Controller->execute() #9 /home/******/web/******/public_html/community/admin/upgrade/index.php(38): IPS\Dispatcher\Setup->run() #10 {main} ------------- Sat, 08 Feb 2025 15:56:35 +0000 IPS\Db\Exception::1366 Incorrect string value: '\xED\xA0\xBD\xED\xB8\x82' for column 'mt_title' at row 14192 #0 /home/******/web/******/public_html/community/system/Db/Db.php(2224): IPS\Db->query() #1 /home/******/web/******/public_html/community/system/Application/Application.php(1765): IPS\Db->dropColumn() #2 /home/******/web/******/public_html/community/applications/core/sources/Setup/Upgrade.php(565): IPS\Application->installDatabaseUpdates() #3 /home/******/web/******/public_html/community/applications/core/sources/Setup/Upgrade.php(369): IPS\core\Setup\Upgrade->step1() #4 /home/******/web/******/public_html/community/applications/core/modules/setup/upgrade/upgrade.php(60): IPS\core\Setup\Upgrade->process() #5 /home/******/web/******/public_html/community/system/Helpers/MultipleRedirect/MultipleRedirect.php(104): IPS\core\modules\setup\upgrade\upgrade->IPS\core\modules\setup\upgrade\{closure}() #6 /home/******/web/******/public_html/community/applications/core/modules/setup/upgrade/upgrade.php(45): IPS\Helpers\MultipleRedirect->__construct() #7 /home/******/web/******/public_html/community/system/Dispatcher/Controller.php(139): IPS\core\modules\setup\upgrade\upgrade->manage() #8 /home/******/web/******/public_html/community/system/Dispatcher/Setup.php(261): IPS\Dispatcher\Controller->execute() #9 /home/******/web/******/public_html/community/admin/upgrade/index.php(38): IPS\Dispatcher\Setup->run() #10 {main} ------------- Sat, 08 Feb 2025 16:15:06 +0000 IPS\Db\Exception::1366 Incorrect string value: '\xED\xA0\xBD\xED\xB8\x82' for column 'mt_title' at row 14192 #0 /home/******/web/******/public_html/community/system/Db/Db.php(2224): IPS\Db->query() #1 /home/******/web/******/public_html/community/system/Application/Application.php(1765): IPS\Db->dropColumn() #2 /home/******/web/******/public_html/community/applications/core/sources/Setup/Upgrade.php(565): IPS\Application->installDatabaseUpdates() #3 /home/******/web/******/public_html/community/applications/core/sources/Setup/Upgrade.php(369): IPS\core\Setup\Upgrade->step1() #4 /home/******/web/******/public_html/community/applications/core/modules/setup/upgrade/upgrade.php(60): IPS\core\Setup\Upgrade->process() #5 /home/******/web/******/public_html/community/system/Helpers/MultipleRedirect/MultipleRedirect.php(104): IPS\core\modules\setup\upgrade\upgrade->IPS\core\modules\setup\upgrade\{closure}() #6 /home/******/web/******/public_html/community/applications/core/modules/setup/upgrade/upgrade.php(45): IPS\Helpers\MultipleRedirect->__construct() #7 /home/******/web/******/public_html/community/system/Dispatcher/Controller.php(139): IPS\core\modules\setup\upgrade\upgrade->manage() #8 /home/******/web/******/public_html/community/system/Dispatcher/Setup.php(261): IPS\Dispatcher\Controller->execute() #9 /home/******/web/******/public_html/community/admin/upgrade/index.php(38): IPS\Dispatcher\Setup->run() #10 {main} ------------- Sat, 08 Feb 2025 16:15:13 +0000 IPS\Db\Exception::1366 Incorrect string value: '\xED\xA0\xBD\xED\xB8\x82' for column 'mt_title' at row 14192 #0 /home/******/web/******/public_html/community/system/Db/Db.php(2224): IPS\Db->query() #1 /home/******/web/******/public_html/community/system/Application/Application.php(1765): IPS\Db->dropColumn() #2 /home/******/web/******/public_html/community/applications/core/sources/Setup/Upgrade.php(565): IPS\Application->installDatabaseUpdates() #3 /home/******/web/******/public_html/community/applications/core/sources/Setup/Upgrade.php(369): IPS\core\Setup\Upgrade->step1() #4 /home/******/web/******/public_html/community/applications/core/modules/setup/upgrade/upgrade.php(60): IPS\core\Setup\Upgrade->process() #5 /home/******/web/******/public_html/community/system/Helpers/MultipleRedirect/MultipleRedirect.php(104): IPS\core\modules\setup\upgrade\upgrade->IPS\core\modules\setup\upgrade\{closure}() #6 /home/******/web/******/public_html/community/applications/core/modules/setup/upgrade/upgrade.php(45): IPS\Helpers\MultipleRedirect->__construct() #7 /home/******/web/******/public_html/community/system/Dispatcher/Controller.php(139): IPS\core\modules\setup\upgrade\upgrade->manage() #8 /home/******/web/******/public_html/community/system/Dispatcher/Setup.php(261): IPS\Dispatcher\Controller->execute() #9 /home/******/web/******/public_html/community/admin/upgrade/index.php(38): IPS\Dispatcher\Setup->run() #10 {main}

Hi Miss_B, Here it is: Thanks.

I used recovery mod to access the admincp for now.

Hi, Today at the test site I saw patch update, when thing start I got error, I did upload the files and tried manual upgrade, same thing. Thanks. Now the admincp is broke

Great news for our loved software since day one. Well done IPS team

Thanks Matt, well done!

Same as changing the height of the logo. Please move this to the bug section, thanks.

Hi, 1 - If you change the header colors, you will lose the logo. 2 - You can not set for both light and dark themes, you setup for light, you will lose the logo for dark and same for dark. Thanks.

Yes, it sending me to sign page, then after I put the user/pass is return to same page and need to re enter it again.

Hi Marc, Thanks for the reply, I already inform the server admin about what I think casing this problem.

Hi, Our server admin expended our storage for the forum and when using symbolic for the uploads folder after sync it, I see this error at ACP: He undo it to confirm here if this supported it. Thanks.

Good one indeed. @Como & @SoloInter Nice one indeed!

Great one Jimi, well done!

Jim, you make me cough from laughing 🙂 Well done.

Yes, Jimi doing great design, he always had.

Hi Jim, Yes deleted them from the ACP, so I guess only way to add them back by like manually update the attachment table at the DB. Restore the DB is not an option any more. Thanks for the reply Jim.

Hi, We deleted files for some years back, since we have backup for the uploads folder that can cover the deleted one. After uploading these files, what the next steps? Thanks in advance.

Jim, will we get "extra" free one month for this? 🙂

Same thing with me, no notify or any thing regarding update patch, just the warning matters.