No Such Column

[Cromarko]

No such table error shows up anytime I click Objects, Activities etc on the dashboard.

Heres the error:
INFO paradox_server::api > API Route: Query(PercentDecoded("select \n ActivityID as ID,\n ifnull(ActivityName_en_US, description) as Name from \n Activities a\n left join\n (select\n objectTemplate,\n case i = a\n when 1 then i\n else rtrim(substr(i, 0, instr(i, ltrim(i, a))), '- ')\n end description\n from (\n select\n objectTemplate,\n min(description) as i,\n max(description) as a\n from ActivityRewards\n group by objectTemplate\n )\n ) ar on a.ActivityID = ar.objectTemplate\n order by \"ID\" asc")) [src\api\query.rs:26:5] &query = PercentDecoded( "select \n ActivityID as ID,\n ifnull(ActivityName_en_US, description) as Name from \n Activities a\n left join\n (select\n objectTemplate,\n case i = a\n when 1 then i\n else rtrim(substr(i, 0, instr(i, ltrim(i, a))), '- ')\n end description\n from (\n select\n objectTemplate,\n min(description) as i,\n max(description) as a\n from ActivityRewards\n group by objectTemplate\n )\n ) ar on a.ActivityID = ar.objectTemplate\n order by \"ID\" asc", ) ERROR tower_http::trace::on_failure > response failed classification=Error: no such column: ActivityName_en_US latency=6 ms

paradox.toml:
`[general]
port = 3030
public = false
domain = "127.0.0.1:3030"

[data]
res = "../client/res"
versions = "../client/versions"
lu_res_cache = "../lu-res"
lu_json_cache = "../lu-json"
cdclient = "../client/res/cdclient.fdb"
locale = "../client/locale/locale.xml"
explorer_spa = "dist"
sqlite = "../client/res/cdclient.sqlite"`

cdclient.fdb is original.

[Xiphoseer]

Hi, welcome to LU-Explorer! That issue comes from the fact that the sqlite integration is fairly recent and requires a script from https://assembly.lu-dev.net (specifically assembly-xml) to import the locale into the sqlite.

I guess we can use this issue to track docs improvements on that.

In the meantime: do you know there is an instance at https://explorer.lu ? Username is lu password explorer.

[Xiphoseer]

https://github.com/LUDevNet/Assembly/blob/main/modules/xml/examples/add-locale-to-sqlite.rs is the script I'm referring to