LUDevNet / ParadoxServer

Server-side component of LU-Explorer
https://lu-dev.net/lu-explorer
4 stars 3 forks source link

No Such Column #36

Open Cromarko opened 3 weeks ago

Cromarko commented 3 weeks ago

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

image

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 commented 3 weeks ago

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 commented 3 weeks ago

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