Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted Wednesday at 01:35 PM4 days For some reason I got this error this morning on our forum. Not sure why it started happening. Cannot access the entire forum or the admin panel. How would I go about correct this and being able to access my site again?It is a 3rd party application I was using in IC4, but I've disabled it in IC5 and IC5 was working fine with it disabled. I did not enable it, but now I'm getting this error. Edited Wednesday at 01:40 PM4 days by NAWAC
Wednesday at 01:52 PM4 days Author Also, running on PHP 8.1.32 and mysqlnd 8.3.15 on AlmaLinux 9 with Apache 2.
Wednesday at 01:56 PM4 days Community Expert If you have FTP access, attach the IPS\topicsview\Application.php and I’ll make it compatible with IPS5 then the error will go away. Edited Wednesday at 01:56 PM4 days by Adriano Faria
Wednesday at 01:59 PM4 days Author @Adriano Faria Here you go... Application.php Edited Wednesday at 02:00 PM4 days by NAWAC
Wednesday at 02:05 PM4 days Community Expert Application.phpYou need to update the app to IPS5 if it keeps identifying incompatible files.
Wednesday at 02:06 PM4 days Community Expert For some reason I got this error this morning on our forum. Not sure why it started happening. Cannot access the entire forum or the admin panel. How would I go about correct this and being able to access my site again?It is a 3rd party application I was using in IC4, but I've disabled it in IC5 and IC5 was working fine with it disabled. I did not enable it, but now I'm getting this error.This is my app, Who Viewed Topics, which isn't compatible with Ips 5. You will have to uninstall it. On a side note, I do plan to update it for Ips 5 soon. Edited Wednesday at 02:06 PM4 days by Miss_B
Wednesday at 02:15 PM4 days Author Ok, I got the new Applications.php file uploaded and it's not showing that error now. However, in the Admin Panel it said I need to upgrade to 5.0.4, so I started the upgrade, now I have the following error during the upgrade and it says the following. I don't know what happened, I didn't change anything on my server, now these problems this morning!#0 /var/www/vhosts/mysite.com/applications/core/sources/Setup/Upgrade.php(846): IPS\Application::load() #1 /var/www/vhosts/mysite.com/applications/core/sources/Setup/Upgrade.php(433): IPS\core\Setup\Upgrade->IPS\core\Setup\{closure}() #2 /var/www/vhosts/mysite.com/applications/core/sources/Setup/Upgrade.php(896): IPS\core\Setup\Upgrade->appLoop() #3 /var/www/vhosts/mysite.com/applications/core/sources/Setup/Upgrade.php(369): IPS\core\Setup\Upgrade->step3() #4 /var/www/vhosts/mysite.com/applications/core/modules/setup/upgrade/upgrade.php(60): IPS\core\Setup\Upgrade->process() #5 /var/www/vhosts/mysite.com/system/Helpers/MultipleRedirect/MultipleRedirect.php(104): IPS\core\modules\setup\upgrade\upgrade->IPS\core\modules\setup\upgrade\{closure}() #6 /var/www/vhosts/mysite.com/applications/core/modules/setup/upgrade/upgrade.php(90): IPS\Helpers\MultipleRedirect->__construct() #7 /var/www/vhosts/mysite.com/system/Dispatcher/Controller.php(139): IPS\core\modules\setup\upgrade\upgrade->manage() #8 /var/www/vhosts/mysite.com/system/Dispatcher/Setup.php(261): IPS\Dispatcher\Controller->execute() #9 /var/www/vhosts/mysite.com/admin/upgrade/index.php(38): IPS\Dispatcher\Setup->run() #10 {main} /var/www/vhosts/mysite.com/system/Application/Application.php::317 Edited Wednesday at 02:18 PM4 days by NAWAC
Wednesday at 02:35 PM4 days Author To go along with this, I see this in the Admin Logs...Error (1146) Table 'mysite.topicsview_log' doesn't exist: changeColumnsAndIndexes ["topicsview_log",{"view_date":{"name":"read_time","type":"INT","length":null,"decimals":null,"values":null,"allow_null":false,"default":"0","comment":"","unsigned":false,"auto_increment":false},"read_time":{"name":"view_time","type":"INT","length":null,"decimals":null,"values":null,"allow_null":false,"default":"0","comment":"","unsigned":false,"auto_increment":false}}]and this...Error: Table 'mysite.topicsview_log' doesn't exist #0 /var/www/vhosts/mysite.com/system/Db/Db.php(2169): IPS\Db->query() #1 /var/www/vhosts/mysite.com/system/Application/Application.php(1806): IPS\Db->changeColumnsAndIndexes() #2 /var/www/vhosts/mysite.com/applications/core/sources/Setup/Upgrade.php(565): IPS\Application->installDatabaseUpdates() #3 /var/www/vhosts/mysite.com/applications/core/sources/Setup/Upgrade.php(369): IPS\core\Setup\Upgrade->step1() #4 /var/www/vhosts/mysite.com/applications/core/modules/setup/upgrade/upgrade.php(60): IPS\core\Setup\Upgrade->process() #5 /var/www/vhosts/mysite.com/system/Helpers/MultipleRedirect/MultipleRedirect.php(104): IPS\core\modules\setup\upgrade\upgrade->IPS\core\modules\setup\upgrade\{closure}() #6 /var/www/vhosts/mysite.com/applications/core/modules/setup/upgrade/upgrade.php(90): IPS\Helpers\MultipleRedirect->__construct() #7 /var/www/vhosts/mysite.com/system/Dispatcher/Controller.php(139): IPS\core\modules\setup\upgrade\upgrade->manage() #8 /var/www/vhosts/mysite.com/system/Dispatcher/Setup.php(261): IPS\Dispatcher\Controller->execute() #9 /var/www/vhosts/mysite.com/admin/upgrade/index.php(38): IPS\Dispatcher\Setup->run() #10 {main}and lastly...Table 'mysite.topicsview_log' doesn't exist Any help is greatly appreciated. Edited Wednesday at 02:37 PM4 days by NAWAC
Wednesday at 02:39 PM4 days Community Expert To go along with this, I see this in the Admin Logs...Error (1146) Table 'mysite.topicsview_log' doesn't exist: changeColumnsAndIndexes ["topicsview_log",{"view_date":{"name":"read_time","type":"INT","length":null,"decimals":null,"values":null,"allow_null":false,"default":"0","comment":"","unsigned":false,"auto_increment":false},"read_time":{"name":"view_time","type":"INT","length":null,"decimals":null,"values":null,"allow_null":false,"default":"0","comment":"","unsigned":false,"auto_increment":false}}]and this...Error: Table 'mysite.topicsview_log' doesn't exist #0 /var/www/vhosts/mysite.com/system/Db/Db.php(2169): IPS\Db->query() #1 /var/www/vhosts/mysite.com/system/Application/Application.php(1806): IPS\Db->changeColumnsAndIndexes() #2 /var/www/vhosts/mysite.com/applications/core/sources/Setup/Upgrade.php(565): IPS\Application->installDatabaseUpdates() #3 /var/www/vhosts/mysite.com/applications/core/sources/Setup/Upgrade.php(369): IPS\core\Setup\Upgrade->step1() #4 /var/www/vhosts/mysite.com/applications/core/modules/setup/upgrade/upgrade.php(60): IPS\core\Setup\Upgrade->process() #5 /var/www/vhosts/mysite.com/system/Helpers/MultipleRedirect/MultipleRedirect.php(104): IPS\core\modules\setup\upgrade\upgrade->IPS\core\modules\setup\upgrade\{closure}() #6 /var/www/vhosts/mysite.com/applications/core/modules/setup/upgrade/upgrade.php(90): IPS\Helpers\MultipleRedirect->__construct() #7 /var/www/vhosts/mysite.com/system/Dispatcher/Controller.php(139): IPS\core\modules\setup\upgrade\upgrade->manage() #8 /var/www/vhosts/mysite.com/system/Dispatcher/Setup.php(261): IPS\Dispatcher\Controller->execute() #9 /var/www/vhosts/mysite.com/admin/upgrade/index.php(38): IPS\Dispatcher\Setup->run() #10 {main}and lastly...Table 'mysite.topicsview_log' doesn't exist Any help is greatly appreciated.Again, that table comes from my aforementioned app. It says that it doesn't exist. Not sure why the upgrader throws that error though seeing the fact that it's a table added by third party stuff.
Wednesday at 02:42 PM4 days Author Not sure why the upgrader throws that error though seeing the fact that it's a table added by third party stuff.Me neither. Right now I cannot access my site because it's caught in an upgrade and I can't upgrade due to the error. So, I'm caught between an rock and a hard place with no where to go.
Wednesday at 02:43 PM4 days Community Expert Me neither. Right now I cannot access my site because it's caught in an upgrade and I can't upgrade due to the error. So, I'm caught between an rock and a hard place with no where to go.You can try to re add that table in the database and hopefully it will help. You can take its schema either from a recent backup, or install the app on a test 4.7.20 forum and copy its table structure from there.
Wednesday at 02:45 PM4 days Author I go to /admin/upgrade again and it shows this...You have an unfinished upgrade from 03/26/25 09:12 Upgrading Applications Core Forums Calendar Gallery Downloads Convert Cms Nexus Topicsview Upgrade Status Status: 3 Application: topicsview Current Version: Not set Notice that Application: topicsview is in the list of applications to update. Is there anyway to take it out of the queue of applications to update? Edited Wednesday at 02:46 PM4 days by NAWAC
Wednesday at 02:47 PM4 days Community Expert Notice that Application: topicsview is in the list of applications to update.That explains why the upgrader was looking for the table of my app. Untick it from the list of the applications to update and give the upgrader another go. If you do that, I think that the upgrader will ignore it.
Wednesday at 02:48 PM4 days Author Untick it from the list of the applications to update and give the upgrader another go. If you do that, I think that the upgrader will ignore it.You cannot untick it, it's simply a list of items to upgrade. You can try to re add that table in the database and hopefully it will help. You can take its schema either from a recent backup, or install the app on a test 4.7.20 forum and copy its table structure from there.I added in the table from a backup, however, it didn't help. I still get the errors during the upgrade.
Wednesday at 04:00 PM4 days Author Long story short, I had to restore a backup of my database (from last night luckily) and manually re-upload IC 5.0.4 I had running on my site before all this mess-up started. My site is up and running again now.
