Error with cloudsync_init

[ingdesarr1]

Good afternoon. I try to connect my db with sqlite_sync. I upload my db to the SQLite Cloud dashboard, and in my app, when I execute this code:

    c.execute("SELECT cloudsync_init('users','cls',true)")

The following error appears:

Error executing WITH table_names AS (SELECT format('%w', name) as tbl_name FROM sqlite_master WHERE type='table' AND name LIKE '%_cloudsync'), query_parts AS (SELECT 'SELECT max(db_version) as version FROM "' || tbl_name || '"' as part FROM table_names), combined_query AS (SELECT GROUP_CONCAT(part, ' UNION ALL ') || ' UNION SELECT value as version FROM cloudsync_settings WHERE key = ''pre_alter_dbversion''' as full_query FROM query_parts) SELECT CONCAT('SELECT max(version) as version FROM (', full_query, ');') FROM combined_query;
in dbutils_exec (no such function: CONCAT).

Why is this error occurring, and how can I fix it? Thanks

[marcobambini]

Hi @ingdesarr1,

Thanks for reporting this issue — we’re looking into it and want to get it resolved as quickly as possible.
To help us reproduce the problem on our side, could you please share the following details?

1. The email address linked to your sqlite.ai or sqlitecloud.io account
2. The SQL schema of your users table
3. Your operating system
4. The programming language or framework you’re using
5. Your local SQLite version

Once we have this information, we’ll be able to investigate further and get back to you with an update.
Thanks a lot.

[andinux]

Hi @ingdesarr1,

The issue seems to be caused by using a SQLite version between 3.38.0 and 3.44.0, which lacks a built-in function previously required by the sqlite-sync extension.
We have just released sqlite-sync v0.8.25, which lowers the local SQLite version requirements.
Updating to this version should resolve the error.

Please let us know if this solves the issue.

Andrea Donetti
SQLite Cloud

[ingdesarr1]

Thanks for the answer. I download the sqlite-sync v0.8.25 and the problem was solved, but a new problem appears. When I using this line:

c.execute("SELECT cloudsync_init('*','cls',true)")

The following error appears:

dbutils_create_triggers error too many arguments on function cloudsync_update (1)

When I use the cloudsync_init with different tables, separately, the error does not occur.

[ingdesarr1]

Aditionally, in the dashboard of sqlite cloud, when I try to activate the Offsync function, this error appears:

How can I set this argument in 1?

[andinux]

Hi,

Great to hear v0.8.25 solved the first issue.

• cloudsync_init('*', ...) error
  To help us reproduce the “too many arguments on function cloudsync_update (1)” issue, please share the schema (DDL only, no data) of all tables in your database.
  If you prefer to share it privately, use the “Contact Us” form in the dashboard (top-right).
  As a temporary workaround, please initialize tables individually (as you already did).

• Offsync activation in the dashboard
  We’ll change the dashboard’s default behavior to skip this check — you don’t need to set that argument to 1. I’ll let you know as soon as the change is deployed.
  If you need this unblocked immediately, please reach out via “Contact Us” and we’ll handle it for you.

Thanks!

Andrea Donetti
SQLite Cloud

[andinux]

As an update on the OffSync activation issue — the change has now been deployed to the dashboard.
You can activate the OffSync function on your table without setting any extra arguments.

Thanks,
Andrea Donetti
SQLite Cloud