PostgreSQL – Error in top level: flunt.entityError.Nodatabase

if let retreivedSite = try Site.all().first {
 site = retreivedSite
} else {
 drop.get {req in
 return Response(redirect: "http://localhost:8080/login")
 }
}

I am trying to fix the error I recently encountered while running the Vapor project.

It builds well, but when it runs , It crashes. This is my log:

I am using the VaporPostgreSQL package. This is my Package.swift:

 import PackageDescription

let package = Package(
 name: "mist",
 dependencies: [
 .Package(url: "https://github.com/ vapor/vapor.git", majorVersion: 1, minor: 2),
 .Package(url: "https://github.com/vapor/postgresql-provider.git", majorVersion: 1, minor: 1 )
 ],
 exclude: [
 "Config",
 "Database",
 "Localization",
 "Public",
 "Resources",
 "Tests",
 ]
)

and main.swift:

import Vapor 
import VaporPostgreSQL
import Auth
import HTTP

let drop = Droplet()
let auth = AuthMiddleware(user: User.self)

try drop.addProvider(VaporPostgreSQL.Provider.self)
drop.preparations.append(Post.self)
drop.preparations.append(User.self)
drop.preparations.append(Site.self)
drop.middleware.append(auth)

let admin = AdminController()
var site = Site(name: " ", theme: "")

if let retreivedSite = try Site.all().first {
 site = retreivedSite
} else {
 drop.get { req in
 return Response(redirect: "http://localhost:8080/login")
 }
}

drop.get {req in
 return try drop.view.make("Themes/VaporDark/index", [
 "posts": Node(node: JSON(Post.all().makeNode()))
 ])< br />}

admin.addRoutes(to: drop)

drop.resource("posts", PostController())

drop. run()

My postgres version is 9.6.1

For some reason, VaporPostgreSQL will not be updated, I think this may be part of the problem. I have tried steam xcode, steam construction and steam cleaning, but I cannot get the latest version.

I think the problem is here:

if let retreivedSite = try Site.all().first {
 site = retreivedSite
} else {
 drop.get {req in
 return Response(redirect: "http://localhost:8080/login")
 }
}< /pre> 

More specifically, Site.all() is called. Before calling the run() command, we do not prepare the model, so to find the Site before that point, you need to prepare the model manually.
Hope this helps!