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]

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

[ingdesarr1]

Good morning. I attach a document with the tables that I created in my db. All of this is created with sqlite3 in python.

Tables.txt

[andinux]

Hi @ingdesarr1,

Thanks for the details you shared. We’ve identified the root cause: the sqlite-sync extension had an undocumented 64-column-per-table limit. When cloudsync_init('*', 'cls', true) tries to create triggers for all tables, any table exceeding that limit caused the
dbutils_create_triggers error too many arguments on function cloudsync_update (1) error.

We’ve just released v0.8.26, which removes this column limit and should resolve the error:

• Release notes & download: sqlite-sync v0.8.26

How to update locally

1. Download the 0.8.26 binary for your OS from the release page.
2. Replace your current sqlite-sync extension file with the new one.
3. Restart your app / reload the extension.
4. (Optional) Verify the version: SELECT cloudsync_version();
5. Re-run: SELECT cloudsync_init('*','cls', true);

Early upgrade on SQLite Cloud

We plan to roll out v0.8.26 to all projects shortly. If you’d like it applied to your project right away, please share your project_id or the account email via the “Contact Us” form in the dashboard (top-right), and we’ll update your project immediately.

Best,
Andrea Donetti
SQLite Cloud