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

Getting issue with vendure-plugin-stock-monitoring with postgresql database #512

Open
ashishkpaul opened this issue Oct 2, 2024 · 0 comments

Comments

@ashishkpaul
Copy link

ashishkpaul commented Oct 2, 2024

Which plugin/repository is the issue about?
vendure-plugin-stock-monitoring

Describe the bug
With a same setup i tried both database postgresql and mariadb but when i am using 'stock monitoring' plugin with postgresql version 16 getting

[server] error 10/2/24, 1:06 PM - [Vendure Server] column "stockonhand" does not exist[server] QueryFailedError: column "stockonhand" does not exist
[server]     at PostgresQueryRunner.query (/home/ubuntu/projects/vendure/core/buylits-ecom/node_modules/typeorm/src/driver/postgres/PostgresQueryRunner.ts:331:19)
[server]     at processTicksAndRejections (node:internal/process/task_queues:95:5)
[server]     at async SelectQueryBuilder.loadRawResults (/home/ubuntu/projects/vendure/core/buylits-ecom/node_modules/src/query-builder/SelectQueryBuilder.ts:3805:25)
[server]     at async SelectQueryBuilder.executeEntitiesAndRawResults (/home/ubuntu/projects/vendure/core/buylits-ecom/node_modules/src/query-builder/SelectQueryBuilder.ts:3551:26)
[server]     at async SelectQueryBuilder.getRawAndEntities (/home/ubuntu/projects/vendure/core/buylits-ecom/node_modules/src/query-builder/SelectQueryBuilder.ts:1670:29)
[server]     at async SelectQueryBuilder.getMany (/home/ubuntu/projects/vendure/core/buylits-ecom/node_modules/src/query-builder/SelectQueryBuilder.ts:1760:25) 

but no issue with mariadb. and there is no pending migration

npx vendure migrate


┌  🛠️️ Vendure migrations
│
◇  What would you like to do?
│  Generate a new migration
│
◇  Project analyzed
│
●  Using VendureConfig from src/vendure-config.ts
│
◇  Enter a meaningful name for the migration
│  stock-monitoring
Using postgres connection
│
◇  Migration file location
│  /home/ubuntu/projects/vendure/core/buylits-ecom/src/migrations
│
verbose 10/2/24, 1:12 PM - [HardenPlugin] Configuring HideValidationErrorsPlugin 
◇  No changes in database schema were found, so no migration was generated
│
└  ✅ Done!

To Reproduce
Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Environment

  • NodeJS version: v20.15.1
  • Vendure version: v3.0.3
  • Plugin version 1.4.1
  • Database : postgresql
  • Any other version numbers from the environment you're using

Additional context
Add any other context about the problem here.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant