ISSUE 4.3.8 after update SQLITE Error near "Returnin"

Questions and Answers
1
System Information
  • Strapi Version: 4.3.8
  • Operating System:
  • Database: SQLITE
  • Node Version:
  • NPM Version:
  • Yarn Version:

With 4.3.6 it worked well and after the update to 4.3.8 two environments have the same issue while updateing or creating new entries. Reading works a expected.

[2022-09-19 08:20:33.052] error: insert into `urm_contacts` (`created_at`, `created_by_id`, `first_name`, `last_name`, `locked`, `published_at`, `updated_at`, `updated_by_id`) values ('2022-09-19 08:20:33.049', 1, 'Hello', 'Master', false, NULL, '2022-09-19 08:20:33.049', 1) returning `id` - SQLITE_ERROR: near "returning": syntax error
Error: insert into `urm_contacts` (`created_at`, `created_by_id`, `first_name`, `last_name`, `locked`, `published_at`, `updated_at`, `updated_by_id`) values ('2022-09-19 08:20:33.049', 1, 'Hello', 'Master', false, NULL, '2022-09-19 08:20:33.049', 1) returning `id` - SQLITE_ERROR: near "returning": syntax error
2

And if I roll back to 4.3.6 everything works well again. Maybe something is wrong with the 4.3.8 in combination with SQLITE.

3

Would suggest possible create a bug report if it works on 4.3.6 and not in 4.3.8 this could be done in github issues providing as much information as possible for the team to look at it,.

4

I created an bug report on GitHub:
SQLITE ERROR in 4.3.8 · Issue #14442 · strapi/strapi (github.com)

5

Hello @mchotti :wave: We have noticed this bug when using the older sqlite3 package in v4.3.7+ versions. We are going to add a migration guide about this but you can switch your sqlite3 package for better-sqlite3 as mentioned at the end of this issue. #14193

  • Replace sqlite3 for better-sqlite3 in your package.json.

Thank you for reaching out!

6

Thank you and this solves my problem in v4.3.8