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.