Loris icon indicating copy to clipboard operation
Loris copied to clipboard

Incorrect `login_summary_statistics` table name in LORIS 27 SQL patch

Open MaximeBICMTL opened this issue 2 months ago • 0 comments

Describe the bug

I was updating my local LORIS VM (Debian / MariaDB) for testing purposes, and am getting 500 errors that "Table 'LORIS.login_summary_statistics' doesn't exist". The reason seems to be that the related patch creates the table Login_Summary_Statistics (noticed the uppercase letters), while the LORIS SQL schema and queries use the login_summary_statistics table name (all lowercase, more conventional with regards to other table names).

While field names are often case-insensitive, table names often are (as each table is stored as a file, and file names are often case-sensitive). As such, LORIS 27 and its patch should be updated to always use the login_summay_statistics table name. Note that some places in the documentation use wrong casing and should also be updated:

Image

MaximeBICMTL avatar Nov 06 '25 05:11 MaximeBICMTL