Editorn Posted March 8, 2023 Share Posted March 8, 2023 Hi, When upgrading our test install from 4.7.7 to 4.7.8 we are presented with the error message: Truncated incorrect DECIMAL value: '' /[...]/public_html/applications/core/setup/upg_107640/upgrade.php::50 where [...] is omitted path name. Any idea what this is about and how to fix it? Since the upgrade need to complete before accessing the admin pages again, we don't dare to install the update on our main install yet. Thanks in advance. Link to comment Share on other sites More sharing options...
Jim M Posted March 8, 2023 Share Posted March 8, 2023 Did you restore your community? It looks like there is not an upgrade currently present. Please note we would require the issue present to investigate. Link to comment Share on other sites More sharing options...
Stuart Silvester Posted March 8, 2023 Share Posted March 8, 2023 If you haven't restored your database, you can have a look in the 'core_log' table for the system log (or you may still be able to get there from the AdminCP). It'll likely be one of the most recent logs, but we'll want to see the message from the 'message' column. We don't have any decimal values in columns in the default software where this query is running, so it would be interesting to see if this is coming from a third party application or not. Link to comment Share on other sites More sharing options...
Editorn Posted March 8, 2023 Author Share Posted March 8, 2023 @Jim M The issue still persists, and there is indeed an upgrade in progress - which I can't complete. Please note that the issues is in our test install environment (which has a public address too). @Stuart Silvester Unfortunately I can't access the AdminCP since the upgrade is in progress. And when I continue the upgrade the error message in the first page reappears. I'll try finding info in the core_log table tomorrow morning and I touch base again then. Cheers! SeNioR- 1 Link to comment Share on other sites More sharing options...
Martin A. Posted March 8, 2023 Share Posted March 8, 2023 We're having the same issue on your test install as well. Backtrace doesn't show much #0 /home/nginx/domains/<domain>>/public/applications/core/sources/Setup/Upgrade.php(1254): IPS\_Db->query() #1 /home/nginx/domains/<domain>>/public/applications/core/setup/upg_107640/upgrade.php(50): IPS\core\Setup\_Upgrade::runManualQueries() #2 /home/nginx/domains/<domain>>/public/applications/core/sources/Setup/Upgrade.php(594): IPS\core\setup\upg_107640\_Upgrade->step1() #3 /home/nginx/domains/<domain>>/public/applications/core/sources/Setup/Upgrade.php(326): IPS\core\Setup\_Upgrade->step1() #4 /home/nginx/domains/<domain>>/public/applications/core/modules/setup/upgrade/upgrade.php(47): IPS\core\Setup\_Upgrade->process() #5 /home/nginx/domains/<domain>>/public/system/Helpers/MultipleRedirect/MultipleRedirect.php(93): IPS\core\modules\setup\upgrade\_upgrade->IPS\core\modules\setup\upgrade\{closure}() #6 /home/nginx/domains/<domain>>/public/applications/core/modules/setup/upgrade/upgrade.php(77): IPS\Helpers\_MultipleRedirect->__construct() #7 /home/nginx/domains/<domain>>/public/system/Dispatcher/Controller.php(118): IPS\core\modules\setup\upgrade\_upgrade->manage() #8 /home/nginx/domains/<domain>>/public/system/Dispatcher/Setup.php(220): IPS\Dispatcher\_Controller->execute() #9 /home/nginx/domains/<domain>>/public/panel/upgrade/index.php(34): IPS\Dispatcher\_Setup->run() #10 {main} But since I'm awesome, I got you the queries it's running as well. array ( 0 => array ( 'table' => 'core_polls', 'query' => 'UPDATE core_polls SET poll_item_class=\'IPS\\\\forums\\\\Topic\' WHERE pid in( SELECT poll_state FROM forums_topics WHERE poll_state IS NOT NULL)', ), 1 => array ( 'table' => 'core_polls', 'query' => 'UPDATE core_polls SET poll_item_class=\'IPS\\\\blog\\\\Entry\' WHERE pid in( SELECT entry_poll_state FROM blog_entries WHERE entry_poll_state IS NOT NULL)', ), ) SeNioR- and Editorn 1 1 Link to comment Share on other sites More sharing options...
Martin A. Posted March 8, 2023 Share Posted March 8, 2023 That "open" value is coming from some really old topics Stuart Silvester, Editorn and SeNioR- 1 2 Link to comment Share on other sites More sharing options...
Solution Stuart Silvester Posted March 9, 2023 Solution Share Posted March 9, 2023 We've deployed a fix for this issue. If you have a stuck upgrade, download the files from the Client Area and manually upload to your community. Then continue the upgrade at <url>/admin/upgrade . If you have upgraded yet, there's nothing to worry about. This fix is included in all future upgrades. SeNioR- and Editorn 1 1 Link to comment Share on other sites More sharing options...
Editorn Posted March 9, 2023 Author Share Posted March 9, 2023 Fantastic @Stuart Silvester - I'll try the updated installer in a minute. Thanks. Link to comment Share on other sites More sharing options...
Editorn Posted March 9, 2023 Author Share Posted March 9, 2023 Update: Thanks all for your help. The issue is resolved and both our test install and public servers are updated 👍 Cheers Link to comment Share on other sites More sharing options...
Marc Posted March 9, 2023 Share Posted March 9, 2023 Thank you for the confirmation, Editorn 🙂 Link to comment Share on other sites More sharing options...
Recommended Posts