Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Wrong table name when trying to insert tags data #102

Open
ngirard opened this issue Jan 2, 2024 · 3 comments
Open

Wrong table name when trying to insert tags data #102

ngirard opened this issue Jan 2, 2024 · 3 comments
Assignees
Labels
bug Something isn't working

Comments

@ngirard
Copy link

ngirard commented Jan 2, 2024

Using latest MarkdownDB version on Ubuntu 23.04.

Got the following error:

[Error: insert into `tags` (`name`) select 'Actionnable/Type/Activit' as `name` 
union all select 'Actionnable/Type/Activité' as `name` 
union all select 'Autodirection/Suivi_d_ex' as `name` 
union all select 'Chronologie' as `name` ... 
union all select 'Actionnable/Type/T' as `name` 
union all select 'Actionnable/Priorit' as `name` 
union all select 'actionable/objectif-mesurable' as `name` 
union all select 'actionable/projet' as `name` 
union all select 'projet' as `name` 
union all select 'Priorit' as `name` ... 
union all select 'AI' as `name` - SQLITE_ERROR: no such table: tags] {
  errno: 1,
  code: 'SQLITE_ERROR'
}

tags appears to be used in this statement, while the sqlite file contains such file_tags table.

@mohamedsalem401 mohamedsalem401 self-assigned this Jan 3, 2024
@mohamedsalem401
Copy link
Contributor

@ngirard I think you are using a Next.js application or running markdownDB from the CLI, right?

@mohamedsalem401 mohamedsalem401 added the bug Something isn't working label Jan 4, 2024
@ngirard
Copy link
Author

ngirard commented Jan 5, 2024

Hey @mohamedsalem401, indeed, I followed the README and just ran

npx mddb --watch ~/Obsidian

Are there alternative ways of running MarkdownDB ?

@mohamedsalem401
Copy link
Contributor

@ngirard
Sorry for the late response. Can you try running this in a separate terminal? I think you have to do this until the issue is fixed. The issue is caused because you might be running the command with another ongoing process like npm run dev & npx mddb --watch ~/Obsidian.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants