No Such Column #36
Description
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.