hhcscott Posted August 24, 2022 Share Posted August 24, 2022 Cannot proceed past this point. Please help. Truncated incorrect DOUBLE value: '' /home/nginx/domains/huskerhoopscentral.com/public/applications/core/sources/Setup/Upgrade.php::594 Link to comment Share on other sites More sharing options...
Marc Posted August 24, 2022 Share Posted August 24, 2022 We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you. Link to comment Share on other sites More sharing options...
hhcscott Posted August 24, 2022 Author Share Posted August 24, 2022 5 minutes ago, Marc Stridgen said: We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you. I think I have it properly updated now Link to comment Share on other sites More sharing options...
hhcscott Posted August 24, 2022 Author Share Posted August 24, 2022 1 hour ago, hhcscott said: I think I have it properly updated now @Marc Stridgen To be clear, I have my credentials updated, not the site which is still broken. Link to comment Share on other sites More sharing options...
Marc Posted August 24, 2022 Share Posted August 24, 2022 I have created a ticket on this for you. Someone will be in contact as soon as possible Link to comment Share on other sites More sharing options...
hhcscott Posted August 24, 2022 Author Share Posted August 24, 2022 To update for anyone who might have a similar issue: I restored from a backup so not didn't get this figured out. Link to comment Share on other sites More sharing options...
Marc Posted August 25, 2022 Share Posted August 25, 2022 Please let us know if you attempt this again and have the same issue. At that point, we would of course need to look into it Link to comment Share on other sites More sharing options...
hhcscott Posted October 8, 2022 Author Share Posted October 8, 2022 On 8/25/2022 at 3:47 AM, Marc Stridgen said: Please let us know if you attempt this again and have the same issue. At that point, we would of course need to look into it Had the same issue with 4.7.2. Seems to be some sort of issue updating the database. I restored again so it's in a working form to investigate. Please re-open the ticket. Link to comment Share on other sites More sharing options...
Marc Posted October 10, 2022 Share Posted October 10, 2022 Please do not restore. You need to report this with the issue in place, in order for us to take a look at the problem. As soon as it breaks, do nothing else with the site other than report it to ourselves. We can then get the problem resolved for you Link to comment Share on other sites More sharing options...
hhcscott Posted October 12, 2022 Author Share Posted October 12, 2022 On 10/10/2022 at 3:13 AM, Marc Stridgen said: Please do not restore. You need to report this with the issue in place, in order for us to take a look at the problem. As soon as it breaks, do nothing else with the site other than report it to ourselves. We can then get the problem resolved for you I understand what you're saying here but I don't know how busy support will be at any time and thus I'm gambling on how long my site will be down when I go through a process that I know will break the site. Given that the upgrade process takes less than a minute to break couldn't I get a ticket opened up and part of addressing it is support just running the upgrade process? Link to comment Share on other sites More sharing options...
Marc Posted October 12, 2022 Share Posted October 12, 2022 Urgent issues would indeed be looked at as soon as possible. Are you around at the moment to do this? Link to comment Share on other sites More sharing options...
hhcscott Posted October 12, 2022 Author Share Posted October 12, 2022 10 hours ago, Marc Stridgen said: Urgent issues would indeed be looked at as soon as possible. Are you around at the moment to do this? I'm going to plan to run this first thing tomorrow morning as that seems to line up with when you post. Hopefully around 7am EST Link to comment Share on other sites More sharing options...
Marc Posted October 12, 2022 Share Posted October 12, 2022 Im in the UK personally, so if you run at that time, it will be around midday here. I will be around. Just to note, I just noticed you asked if I was around in PM. Always ask in the ticket as there will have been other people around when you mentioned you wanted to get it going there. hhcscott 1 Link to comment Share on other sites More sharing options...
hhcscott Posted October 21, 2022 Author Share Posted October 21, 2022 On 10/12/2022 at 2:54 PM, Marc Stridgen said: Im in the UK personally, so if you run at that time, it will be around midday here. I will be around. Just to note, I just noticed you asked if I was around in PM. Always ask in the ticket as there will have been other people around when you mentioned you wanted to get it going there. Ran through the upgrade again. Site once again down. Please help. Cannot proceed past this point Truncated incorrect DECIMAL value: '' /home/nginx/domains/huskerhoopscentral.com/public/applications/core/sources/Setup/Upgrade.php::594 Link to comment Share on other sites More sharing options...
Solution Miss_B Posted October 21, 2022 Solution Share Posted October 21, 2022 (edited) Do you have strict sql mode enabled? Somewhere an empty string '' is being passed as a value for decimal fields in the insert query. If strict sql mode is enabled and an invalid data is inserted into a column, it throws an error rather than providing a warning. I 've come this across before. I fixed it by changing the INSERT query to add the IGNORE command. i.e. from INSERT INTO table_name to INSERT IGNORE INTO table_name Hope it helps. Edited October 21, 2022 by Miss_B hhcscott 1 Link to comment Share on other sites More sharing options...
hhcscott Posted October 21, 2022 Author Share Posted October 21, 2022 13 minutes ago, Miss_B said: Do you have strict sql mode enabled? Somewhere an empty string '' is being passed as a value for decimal fields in the insert query. If strict sql mode is enabled and an invalid data is inserted into a column, it throws an error rather than providing a warning. I do. By disabling I was able to move past the error. Thank you very much. Miss_B 1 Link to comment Share on other sites More sharing options...
Gary Posted October 21, 2022 Share Posted October 21, 2022 Hi @hhcscott, I’m glad to hear your issue has been resolved. Thanks @Miss_B for assisting. hhcscott and Miss_B 1 1 Link to comment Share on other sites More sharing options...
Miss_B Posted October 21, 2022 Share Posted October 21, 2022 Happy to have been of help. Link to comment Share on other sites More sharing options...
Recommended Posts