Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial![](https://ecs-static.teamtreehouse.com/assets/views/marketing/shared/community-banner-white-47072046c51352fe6a69f5e691ff5700b28bb11d45197d7bdf066d9ea3f72d0c.webp)
![A R](https://uploads.teamtreehouse.com/production/profile-photos/10838162/micro_derailment1.jpg)
A R
12,834 PointsSequelize/Tables Problem
I'm having a problem with some linked SQL tables, and trying to retrieve data from them with Sequelize. When I'm on DB Browser for SQLite, the tables all exist. But when I try to findAll() or findByPK() my table 'Courses' I'm getting a "SequelizeDatabaseError" with the message: "SQLITE_ERROR: no such table: Courses"
I'll link the repository here: https://github.com/AeronRoemer/rest-api-project
And this is the code from the 'routes' page where the GET request is coming from
const express = require('express');
const router = express.Router();
const Users = require('../models').Users;
const Courses = require('../models').Course;
module.exports = router;
/* Handler function to wrap each route. */
function asyncHandler(cb){
return async(req, res, next) => {
try {
await cb(req, res, next)
res.status(201)
} catch(error){
res.status(500).send(error);
}
}
}
//send a GET request to view all quotes
router.get('/courses', asyncHandler(async (req, res) =>{
let allCourses
//console.log(Courses)
try {
allCourses = await Courses.findAll();
res.json(courses) //converts to JSON object
} catch (error) {
res.json({error: error,
message: error.message})
}
}))