App tables has not been created

[vgdh]

I have not been updating my instance of NC for 2 years. And now I've updated it to the latest version.
For some reason, suspicious login app stopped working.
I get errors in the log

InvalidArgumentException
Datasets must have the same number of columns, 48 expected, but 16 given.
Caught unknown error during IPv4 background training

In the database only two tables related to the app:

Table: suspicious_login
Table: suspicious_login_model

In the opened issue for this error @mwdle talks about dropping oc_login_address, oc_login_flow_v2, oc_login_ips_aggregated, oc_suspicious_login and oc_suspicious_login_model but I don't have these data tables in the database.
Because reinstalling the app is not available, how can I recreate the tables by hand or maybe there is some dev command for that purpose?

[melroy89]

After a major upgrade. I did notice I was also missing the oc_login_address table for some reason in the logging...

For some reason the upgrade to NC32 didn't automatically re-enabled this app, causing SQL issues in the logging.

I manually enabled this app again in order to execute the new DB migrations 😖 .

[melroy89]

For info, this was the error I was seeing in the logs (without activating suspicious login app after NC32 major release upgrade):

{"reqId":"6dpn6GrEj5o0md9w3E3r","level":3,"time":"2025-10-10T11:31:59+00:00","remoteAddr":"192.168.1.194","user":"dennis","app":"no app in context","method":"GET","url":"/index.php/204","message":"An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud_db.oc_login_address' doesn't exist","userAgent":"Mozilla/5.0 (Linux) mirall/3.17.2-20251005.132336.d15dca2ae-1.0~noble1 (Nextcloud, linuxmint-6.8.0-85-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"32.0.0.13","clientReqId":"a17e3339-f32a-4fe2-bc48-e98837fe33ae","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud_db.oc_login_address' doesn't exist","Code":1146,"Trace":[{"file":"/var/www/ourdomain.com/html/lib/private/DB/ConnectionAdapter.php","line":69,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::"},{"file":"/var/www/ourdomain.com/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":308,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/ourdomain.com/html/lib/public/AppFramework/Db/QBMapper.php","line":116,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/ourdomain.com/html/apps/suspicious_login/lib/Service/LoginDataCollector.php","line":30,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/ourdomain.com/html/apps/suspicious_login/lib/Listener/LoginListener.php","line":70,"function":"collectSuccessfulLogin","class":"OCA\\SuspiciousLogin\\Service\\LoginDataCollector","type":"->"},{"file":"/var/www/ourdomain.com/html/apps/suspicious_login/lib/Listener/LoginListener.php","line":54,"function":"handleDataCollection","class":"OCA\\SuspiciousLogin\\Listener\\LoginListener","type":"->"},{"file":"/var/www/ourdomain.com/html/lib/private/EventDispatcher/ServiceEventListener.php","line":57,"function":"handle","class":"OCA\\SuspiciousLogin\\Listener\\LoginListener","type":"->"},{"file":"/var/www/ourdomain.com/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":220,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->"},{"file":"/var/www/ourdomain.com/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":56,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/ourdomain.com/html/lib/private/EventDispatcher/EventDispatcher.php","line":67,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/ourdomain.com/html/apps/suspicious_login/lib/AppInfo/Application.php","line":58,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/ourdomain.com/html/lib/private/legacy/OC_Hook.php","line":85,"function":"handle","class":"class@anonymous\u0000/var/www/ourdomain.com/html/apps/suspicious_login/lib/AppInfo/Application.php:44$39c7","type":"->"},{"file":"/var/www/ourdomain.com/html/lib/private/Server.php","line":522,"function":"emit","class":"OC_Hook","type":"::"},{"function":"{closure:{closure:OC\\Server::__construct():463}:520}","class":"OC\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/ourdomain.com/html/lib/private/Hooks/EmitterTrait.php","line":89,"function":"call_user_func_array"},{"file":"/var/www/ourdomain.com/html/lib/private/Hooks/PublicEmitter.php","line":23,"function":"emit","class":"OC\\Hooks\\BasicEmitter","type":"->"},{"file":"/var/www/ourdomain.com/html/lib/private/User/Session.php","line":351,"function":"emit","class":"OC\\Hooks\\PublicEmitter","type":"->"},{"file":"/var/www/ourdomain.com/html/lib/private/User/Session.php","line":620,"function":"completeLogin","class":"OC\\User\\Session","type":"->","args":["***

[ChristophWurst]

That's a strange one. The listener of the disabled app should not execute.