next.js/examples/with-mongodb-mongoose/ TypeError: conn.openUri(...).then is not a function

[TylerJNewman]

Bug report

Describe the bug

When adding a pet, post request to mongoose DB seems returns a 500 internal server error

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

1. Go to https://github.com/vercel/next.js/tree/canary/examples/with-mongodb-mongoose
2. yarn create next-app --example with-mongodb-mongoose with-mongodb-mongoose-app
3. Get the connection string of your MongoDB servermongodb+srv://:@my-project-abc123.mongodb.net/test?retryWrites=true&w=majority
4. Set MONGODB_URI in .env.local
5. yarn install && yarn dev
6. go to localhost:3000
7. Add pet
8. Shows the following text ("Failed to add pet")

Expected behavior

Add pet and return home

Screenshots

If applicable, add screenshots to help explain your problem.

System information

• OS: macOs Catalina
• Browser Chrome
  "mongoose": "^5.9.13",
  "next": "^9.4.2",
• Version of Node.js: (v12.18.2 - on my computer)

Additional context

Images are being added to DB sometimes and when I kill server and start back up the data ojbect with images show up which means in must be connecting and retrieving from mongo

Uri string seems to be fine

Add any other context about the problem here.

[charliewilco]

this is a problem with mongoose itself in 5.10.0. i'm guessing on your yarn.lock or package-lock.json is grabbing 5.10 instead of 5.9.13 because of the ^. you can checkout by running cat node_modules/mongoose/package.json | grep 'version' to see what's really installed. the fastest way to fix this is by in your project's package.json is to pin the version.

diff --git a/package.json b/package.json
index 1d14380..4382643 100644
--- a/package.json
+++ b/package.json
@@ -7,7 +7,7 @@
     "start": "next start"
   },
   "dependencies": {
-    "mongoose": "^5.9.13",
+    "mongoose": "5.9.13",
     "next": "^9.4.2",
     "react": "^16.13.1",
     "react-dom": "^16.13.1",

[charliewilco]

More details here Automattic/mongoose#9335

[TylerJNewman]

cat node_modules/mongoose/package.json | grep 'version' "version": "5.10.0",
you are exactly right
pinned my version to "mongoose": "5.9.13" and it works! thanks!

[balazsorban44]

This issue has been automatically locked due to no recent activity. If you are running into a similar issue, please create a new issue with the steps to reproduce. Thank you.