Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
hhcscott Posted August 24, 2022 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
Marc Posted August 24, 2022 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.
hhcscott Posted August 24, 2022 Author 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
hhcscott Posted August 24, 2022 Author 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.
Marc Posted August 24, 2022 Posted August 24, 2022 I have created a ticket on this for you. Someone will be in contact as soon as possible
hhcscott Posted August 24, 2022 Author 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.
Marc Posted August 25, 2022 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
hhcscott Posted October 8, 2022 Author 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.
Marc Posted October 10, 2022 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
hhcscott Posted October 12, 2022 Author 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?
Marc Posted October 12, 2022 Posted October 12, 2022 Urgent issues would indeed be looked at as soon as possible. Are you around at the moment to do this?
hhcscott Posted October 12, 2022 Author 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
Marc Posted October 12, 2022 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
hhcscott Posted October 21, 2022 Author 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
Solution Miss_B Posted October 21, 2022 Solution 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
hhcscott Posted October 21, 2022 Author 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
Gary Posted October 21, 2022 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
Recommended Posts