Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted October 26, 20195 yr sorry @bfarber and @everyone else, no video today (sore throat!), has any one else hit this when trying to uninstall an app? IPS\Db\Exception thrown with message "Truncated incorrect DOUBLE value: 'sockets'" Stacktrace: #9 IPS\Db\Exception in /home/michael/public_html/dev/system/Db/Db.php:671 #8 IPS\_Db:preparedQuery in /home/michael/public_html/dev/system/Db/Db.php:1280 #7 IPS\_Db:delete in /home/michael/public_html/dev/system/Node/Model.php:3082 #6 IPS\Node\_Model:delete in /home/michael/public_html/dev/system/Application/Application.php:4294 #5 IPS\_Application:delete in /home/michael/public_html/dev/applications/core/modules/admin/applications/applications.php:1157 #4 IPS\core\modules\admin\applications\_applications:delete in /home/michael/public_html/dev/system/Dispatcher/Controller.php:85 #3 IPS\Dispatcher\_Controller:execute in /home/michael/public_html/dev/system/Node/Controller.php:62 #2 IPS\Node\_Controller:execute in /home/michael/public_html/dev/applications/core/modules/admin/applications/applications.php:43 #1 IPS\core\modules\admin\applications\_applications:execute in /home/michael/public_html/dev/system/Dispatcher/Dispatcher.php:152 #0 IPS\_Dispatcher:run in /home/michael/public_html/dev/admin/index.php:14 i upgraded to ubuntu 19.10 last week, so it might be the mysql v8 it upgraded me too, so i might end up downgrading back to 5.7 or whatever it was.
October 27, 20195 yr 5 hours ago, CodingJungle said: has any one else hit this when trying to uninstall an app? Yes 5 hours ago, CodingJungle said: so it might be the mysql v8 Yes I have a ticket Screenshot
October 28, 20195 yr Yes, this is a stricter error in MySQL v8. Find out if the query is for your own table or a table in our release. If it's one of your own tables, you're passing a string value to a column that holds an integer. If it's for one of our tables, submit the query/stacktrace from the system log in a ticket or post it here and we can look at resolving the error in a maintenance release.
October 28, 20195 yr 29 minutes ago, bfarber said: If it's for one of our tables, submit the query/stacktrace from the system log in a ticket or post it here and we can look at resolving the error in a maintenance release. On 10/27/2019 at 10:20 AM, newbie LAC said: I have a ticket Screenshot Ticket #1039448
October 28, 20195 yr Author 10 minutes ago, bfarber said: Yes, this is a stricter error in MySQL v8. Find out if the query is for your own table or a table in our release. If it's one of your own tables, you're passing a string value to a column that holds an integer. If it's for one of our tables, submit the query/stacktrace from the system log in a ticket or post it here and we can look at resolving the error in a maintenance release. i did include a stack trace 🙂 the app i tried to uninstall, i had just created it, i was gonna uninstall delete the folder and create it again, as i decided to change the app folder name. so there weren't any tables to it yet.
October 28, 20195 yr Yes, sorry. I believe that's been fixed without checking the specific line number. It would help to see the full query, but I know there were two similar recent fixes when deleting an application.
Archived
This topic is now archived and is closed to further replies.