unknown function get user()

[Former user]

when i import data to database into table main using 2.7 version, i get error unknown function:get_user().

Please advise

[Ozan H]

Hello,

Kalibro 2.7 uses SQLite as database. Kalibro logs the history of records with associated user if logged in. Because of this, I register “get_user” function in application side to SQLite when connection is opened in Kalibro. There are some tables/views/triggers calling “get_user” in database. So, if you are using e.g. “SQLite Studio” while importing data, you should manually register “get_user()” as scalar function in “SQLite Studio”. What tool do you use to import data?

[Patrick Isaacson]

I stumbled onto this as I have the same issue. Could you provide an example of what to put in SQLite Studio, as I tried my hand and couldn’t make it work (not a sql person). I can also work with csvdb-importer if updating that is simpler.

‌

Thank you,