Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted March 26Mar 26 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 March 26Mar 26 by NAWAC
March 26Mar 26 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 March 26Mar 26 by Adriano Faria
March 26Mar 26 Community Expert Application.phpYou need to update the app to IPS5 if it keeps identifying incompatible files.
March 26Mar 26 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 March 26Mar 26 by Miss_B
March 26Mar 26 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 March 26Mar 26 by NAWAC
March 26Mar 26 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 March 26Mar 26 by NAWAC
March 26Mar 26 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.
March 26Mar 26 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.
March 26Mar 26 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.
March 26Mar 26 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 March 26Mar 26 by NAWAC
March 26Mar 26 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.
March 26Mar 26 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.
March 26Mar 26 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.
