Issue with notifications module

Scriptcase 9 General
#1

Dear all,

I am having issues with the notifications module. When I deploy the project to production, it throws a warning about access to the notifications table and does not retrieve any notifications. The table structures are identical in both development and production.

The error message is as follows:
Invalid object name ‘dbo.noti_inbox’. [20018] (severity 16) [ SELECT dbo.noti_notifications.notif_message, dbo.noti_notifications.notif_title, dbo.noti_notifications.notif_login_sender, dbo.noti_notifications.notif_dtexpire, dbo.noti_notifications.notif_categ, dbo.noti_inbox.notif_isread, dbo.noti_inbox.notif_ontop, dbo.noti_inbox.notif_dtsent, dbo.noti_inbox.notif_tags, dbo.noti_notifications.notif_id, dbo.usuario.login, dbo.usuario.apynom, dbo.usuario.picture, dbo.noti_notifications.notif_link FROM dbo.noti_inbox INNER JOIN dbo.noti_notifications ON dbo.noti_inbox.notif_id = dbo.noti_notifications.notif_id INNER JOIN dbo.usuario ON dbo.usuario.login = dbo.noti_notifications.notif_login_sender WHERE …]
The user connecting to the database is owner.
If anyone can give me a hint about what the issue might be, I would really appreciate it in advance!

PD: The driver is MSSqlServer

#2

hi @bruthus , did you solve your issue?

i’m trying to use the notification module in production and i have a similar issue:

when used in production it will complain that the notification tables don’t exist. but that’s because it will look for the tables in the wrong db

i have many db instances on the same server, hence many db connections defined in scriptcase

i double checked the db connection settings both in dev and in prod and they are exactly the same (the db server used by both is actually the same db server)

#3

i solved my issue:

no idea why, but in production the notification module was looking for its tables in the same db connection as the one set in the “Log” setting of the menu application.

i disabled logging for the menu application and now it works in production as well.

#4

Hellow @robydago! Thank’s for your post.

I don’t have the log enabled in the menu application, and I’m still getting the same error. Do you know where that notification query might be executed when the menu opens?
Thank you very much!

#5

Hi @bruthus
Sorry but I have no idea.