Back

Technologies:

javascriptjavascript
reactjsreactjs
typescripttypescript
avatar
Tolerim
a month ago

How do I address a 500 internal server error with Prisma and Sqlite?

I have successfully incorporated Prisma into my Next.js application using Sqlite. The "Movies" table has been set up in the Prisma schema, and I have populated it with URLs and demo data. Additionally, I have created several files and a player button. When clicked, the player button creates a route to play that specific movie by using its unique ID. To achieve this, I utilized a logic that employs the "useSwr" hook. The "PlayButton" component is responsible for facilitating the route to the selected movie. Usage of a Sqlite database was chosen for this particular project, although I found MangoDB to be a viable solution as well. Despite this, working with Sqlite has been beneficial for testing purposes. However, a console error is displayed.
Answers(2)
avatar
Vogi
24 days ago
Verified Answer
It's great to hear that you have successfully incorporated Prisma into your Next.js application using Sqlite. However, you mentioned that a console error is displayed. Could you please provide more details about the error message? It would be helpful to know the exact error message and the context in which it appears so that I can provide you with a more accurate solution.

Sources

Best practice for instantiating PrismaClient with Next.jsjavascript - Error while sending data from form to sqlite database ...Prisma, Next JS api route prisma.create giving me a bad request
avatar
Tolerim
a month ago
The error in the console indicates that the movieId parameter passed to findUnique is not a string. You can convert movieId to a string explicitly before passing it to findUnique to solve the issue. Replace: 
id: Number(movieId).toString()
With: 
id: String(movieId)
This converts movieId to a string using the String constructor. Alternatively, you can use template literals to implicitly convert movieId to a string: 
id: `${movieId}`
Also note that you're using parseInt function to check if movieId is a valid integer but you're not returning error when movieId is not a number. You can add an else condition to return an error in that case: 
if (isNaN(parseInt(movieId as string, 10))) {
  throw new Error('Invalid Id');
} else {
  const movies = await prismadb.movie.findUnique({
    where: {
      id: String(movieId)
    }
  });
  return res.status(200).json(movies);
}
This block of code ensures that movieId is valid before attempting to retrieve the movie with findUnique.
;