SQLite3Error: No Such Table When Switching Locales in Nuxt Content v3

[hasan-ozbey]

I'm using Nuxt Content v3.2.1 with localized content. Everything works fine when I first load the app at http://localhost:3000. When I switch locales inside the app (e.g., from en-US to tr-TR), it correctly redirects to http://localhost:3000/tr-TR and fetches the content.

However, when I switch back to en-US inside the app, I get the following error:

Failed to fetch page: SQLite3Error: SQLITE_ERROR: sqlite3 result code 1: no such table: _content_content_en_US

Here is my content.config.ts

import { defineCollection, defineContentConfig } from '@nuxt/content'

export default defineContentConfig({
  collections: {
    content_en_US: defineCollection({
      type: 'page',
      source: {
        include: 'en-US/*.{md,yml}',
        prefix: '',
      },
    }),
    content_tr_TR: defineCollection({
      type: 'page',
      source: {
        include: 'tr-TR/*.{md,yml}',
        prefix: '',
      },
    }),
  },
})

My directory structure looks like this:

content/
├── en-US/
│   ├── index.yml
├── tr-TR/
│   ├── index.yml

This is how my pages/index.vue looks like:

<script setup lang="ts">
import type { Collections } from '@nuxt/content'

const { locale } = useI18n()

const { data: page } = await useAsyncData(
  `index-${locale.value}`,
  async () => {
    try {
      const collection = (`content_${locale.value.replace('-', '_')}`) as keyof Collections
	  
      const result = await queryCollection(collection).where('stem', '=', 'index').first()
	  
      if (!result)
        throw new Error('Page data is empty')
		
      return result
    }
    catch (err) {
      console.error('Failed to fetch page:', err)
	  
      return null
    }
  },
  {
    watch: [locale],
  },
)

if (!page.value) {
  throw createError({ statusCode: 404, statusMessage: 'Page not found', fatal: true })
}
</script>

[hasan-ozbey]

is this somehow related with #3182 ?

edit: downgrading to 3.1.1 fixed this issue.
edit 2: see #3188