Clover13 Posted April 21, 2023 Share Posted April 21, 2023 Invision Community v4.7.9 Receiving this error on both of my sites when accessing Notification Settings via the AdminCP's bell icon (top right). Error: EX1146 Something went wrong. Please try again. SELECT COUNT(*) FROM `nexus_hosting_servers` IPS\Db\Exception: Table 'xxxxxxxx.nexus_hosting_servers' doesn't exist (1146) #0 /home/xxxxxxxx/public_html/system/Db/Select.php(388): IPS\_Db->preparedQuery() #1 /home/xxxxxxxx/public_html/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #2 /home/xxxxxxxx/public_html/system/Db/Select.php(370): IPS\Db\_Select->rewind() #3 /home/xxxxxxxx/public_html/applications/nexus/extensions/core/AdminNotifications/HostingError.php(97): IPS\Db\_Select->first() #4 /home/xxxxxxxx/public_html/applications/core/modules/admin/overview/notifications.php(126): IPS\nexus\extensions\core\AdminNotifications\_HostingError::permissionCheck() #5 /home/xxxxxxxx/public_html/system/Dispatcher/Controller.php(107): IPS\core\modules\admin\overview\_notifications->settings() #6 /home/xxxxxxxx/public_html/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #7 /home/xxxxxxxx/public_html/admin/index.php(13): IPS\_Dispatcher->run() #8 {main} pidje 1 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted April 21, 2023 Share Posted April 21, 2023 You are missing tables there, unfortunately. By the look of it, from commerce. You would need to recover this table from your most recent backup Link to comment Share on other sites More sharing options...
Clover13 Posted April 21, 2023 Author Share Posted April 21, 2023 Hmmm no idea how that could happen, especially on both sites. I'll have to see what host says. Thanks Marc. Link to comment Share on other sites More sharing options...
Adriano Faria Posted April 21, 2023 Share Posted April 21, 2023 4 minutes ago, Marc Stridgen said: You are missing tables there, unfortunately. By the look of it, from commerce. You would need to recover this table from your most recent backup I would say it worths to check as hosting were removed from Commerce last month: https://invisioncommunity.com/deprecation-tracker/commerce-hosting-reselling-r18/ Maybe something was forgotten in notifications? pidje and Clover13 1 1 Link to comment Share on other sites More sharing options...
Clover13 Posted April 21, 2023 Author Share Posted April 21, 2023 Is there a way to run a check for anything else that may be missing I'm not aware of? Rest of Commerce appears to be working ok (at least the parts I use). This Notification Settings is something I can't recall ever clicking before, I was just looking at it as now I see System Log error notifications that I didn't before and many of them happen often (i.e. bots trying to access endpoints they shouldn't, etc). Just now, Adriano Faria said: I would say it worths to check as hosting were removed from Commerce last month: https://invisioncommunity.com/deprecation-tracker/commerce-hosting-reselling-r18/ Maybe something was forgotten in notifications? I didn't double check the deprecation tracker, I thought hosting wasn't removed yet and maybe this was done prematurely when I saw the nexus_hosting_servers table. But it appears to be related to that. The Commerce menus for hosting are gone now, so assuming this table (or it's reference in Notification Settings) is residual. @Adriano Faria do you get the error on your site(s)? Link to comment Share on other sites More sharing options...
Adriano Faria Posted April 21, 2023 Share Posted April 21, 2023 4 minutes ago, Clover13 said: do you get the error on your site(s)? Where exactly? Members-> Notifications works fine to me: Link to comment Share on other sites More sharing options...
Clover13 Posted April 21, 2023 Author Share Posted April 21, 2023 @Adriano Faria Click the Bell with the 2 counter, and then click the Notification Settings link on top right of that modal popup. Link to comment Share on other sites More sharing options...
Adriano Faria Posted April 21, 2023 Share Posted April 21, 2023 Oh yes, I can reproduce: Clover13 and pidje 1 1 Link to comment Share on other sites More sharing options...
Clover13 Posted April 21, 2023 Author Share Posted April 21, 2023 OK so looks like a residual reference from the deprecation of hosting servers you linked to. @Marc Stridgen Link to comment Share on other sites More sharing options...
Marc Stridgen Posted April 24, 2023 Share Posted April 24, 2023 On 4/21/2023 at 3:59 PM, Clover13 said: OK so looks like a residual reference from the deprecation of hosting servers you linked to. @Marc Stridgen Just spoken to my colleague, and it seems this may well be the case. I have created a ticket for you Clover13 1 Link to comment Share on other sites More sharing options...
Stuart Silvester Posted April 24, 2023 Share Posted April 24, 2023 We made a patch available earlier today that fixes this issue. If you are using an affected version of 4.7.9, it can be obtained from the AdminCP > System > Support page (top left box will tell you if there is a patch or update available) Clover13, Adriano Faria and ArashDev 2 1 Link to comment Share on other sites More sharing options...
Adriano Faria Posted April 24, 2023 Share Posted April 24, 2023 Fixed. Clover13 1 Link to comment Share on other sites More sharing options...
Clover13 Posted April 24, 2023 Author Share Posted April 24, 2023 Looks good, thanks for the fix! 👍 Link to comment Share on other sites More sharing options...
Recommended Posts