search

z-song / demo.laravel-admin.org

Source code of official http://demo.laravel-admin.org website.
507 stars 250 forks source link

資料庫缺少"demo_documents" 表格 #68

Open WingCH opened 4 years ago

WingCH commented 4 years ago

image

localhost:8000/documents

image

QueryException In Connection.php line 664 : SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_admin_demo.demo_documents' doesn't exist (SQL: select count(*) as aggregate from demo_documents where demo_documents.deleted_at is null)

我通過自行增加解決

CREATE TABLE `demo_documents` (
  `id` int NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `desc` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `view_count` int DEFAULT NULL,
  `download_count` int DEFAULT NULL,
  `rate` int DEFAULT NULL,
  `sort` int DEFAULT NULL,
  `privilege` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `uploader_id` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;