AdminCP >> Administrator Notifications >> Notification Settings: EX1146 Something went wrong

[Clover13]

 

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}

 

[Marc]

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

[Clover13]

Hmmm no idea how that could happen, especially on both sites.  I'll have to see what host says.  Thanks Marc.

[Adriano Faria]

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?

[Clover13]

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)?

[Adriano Faria]

4 minutes ago, Clover13 said:

do you get the error on your site(s)?

Where exactly? Members-> Notifications works fine to me:

[Clover13]

@Adriano Faria

Click the Bell with the 2 counter, and then click the Notification Settings link on top right of that modal popup.

[Adriano Faria]

Oh yes, I can reproduce:

[Clover13]

OK so looks like a residual reference from the deprecation of hosting servers you linked to.

@Marc Stridgen

[Marc]

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

[Stuart Silvester]

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)

[Adriano Faria]

Fixed.

[Clover13]

Looks good, thanks for the fix! 👍