ruby-on-rails - SQLite3::SQLException:没有这样的表:users:选择“users”。* FROM“users”-6ren

ruby-on-rails - SQLite3::SQLException:没有这样的表:users:选择“users”。* FROM“users”

转载作者：行者123 更新时间：2023-12-03 18:00:31

我正在尝试在Rails 3开发环境中使用sqlite3而不是MySQL，但是遇到了问题。尝试执行rake db:migrate时，我得到：

SQLite3::SQLException: no such table: users: SELECT "users".* FROM "users"

显然，在我尝试设置数据库时，还没有用户表。在尝试迁移之前是否需要运行某些程序？

瑞克文件

require File.expand_path('../config/application', __FILE__)
require 'rake'
Skateparks::Application.load_tasks

源代码

请随时在 Github上浏览该项目的所有源代码。

跟踪

** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
rake aborted!
SQLite3::SQLException: no such table: users: SELECT "users".* FROM "users"
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activerecord-3.0.9/lib/active_record/connection_adapters/abstract_adapter.rb:207:in `rescue in log'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activerecord-3.0.9/lib/active_record/connection_adapters/abstract_adapter.rb:199:in `log'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activerecord-3.0.9/lib/active_record/connection_adapters/sqlite_adapter.rb:135:in `execute'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activerecord-3.0.9/lib/active_record/connection_adapters/sqlite_adapter.rb:284:in `select'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activerecord-3.0.9/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activerecord-3.0.9/lib/active_record/connection_adapters/abstract/query_cache.rb:56:in `select_all'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activerecord-3.0.9/lib/active_record/base.rb:473:in `find_by_sql'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activerecord-3.0.9/lib/active_record/relation.rb:64:in `to_a'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activerecord-3.0.9/lib/active_record/relation.rb:13:in `collect'
/Users/Kyle/Desktop/skateparks-web/app/models/skatepark/comment.rb:33:in `<class:Comment>'
/Users/Kyle/Desktop/skateparks-web/app/models/skatepark/comment.rb:1:in `<top (required)>'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:454:in `load'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:454:in `block in load_file'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:596:in `new_constants_in'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:453:in `load_file'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:340:in `require_or_load'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:491:in `load_missing_constant'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:183:in `block in const_missing'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:181:in `each'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:181:in `const_missing'
/Users/Kyle/Desktop/skateparks-web/spec/factories.rb:15:in `<top (required)>'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:235:in `load'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:235:in `block in load'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:225:in `block in load_dependency'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:596:in `new_constants_in'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:225:in `load_dependency'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:235:in `load'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/factory_girl-2.0.3/lib/factory_girl/find_definitions.rb:16:in `block in find_definitions'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/factory_girl-2.0.3/lib/factory_girl/find_definitions.rb:15:in `each'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/factory_girl-2.0.3/lib/factory_girl/find_definitions.rb:15:in `find_definitions'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/factory_girl_rails-1.1.0/lib/factory_girl_rails/railtie.rb:11:in `block in <class:Railtie>'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/lazy_load_hooks.rb:34:in `call'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/lazy_load_hooks.rb:34:in `execute_hook'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/lazy_load_hooks.rb:43:in `block in run_load_hooks'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/lazy_load_hooks.rb:42:in `each'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/lazy_load_hooks.rb:42:in `run_load_hooks'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/railties-3.0.9/lib/rails/application/finisher.rb:46:in `block in <module:Finisher>'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/railties-3.0.9/lib/rails/initializable.rb:25:in `instance_exec'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/railties-3.0.9/lib/rails/initializable.rb:25:in `run'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/railties-3.0.9/lib/rails/initializable.rb:50:in `block in run_initializers'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/railties-3.0.9/lib/rails/initializable.rb:49:in `each'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/railties-3.0.9/lib/rails/initializable.rb:49:in `run_initializers'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/railties-3.0.9/lib/rails/application.rb:134:in `initialize!'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/railties-3.0.9/lib/rails/application.rb:77:in `method_missing'
/Users/Kyle/Desktop/skateparks-web/config/environment.rb:2:in `<top (required)>'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:239:in `require'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:239:in `block in require'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:225:in `block in load_dependency'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:596:in `new_constants_in'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:225:in `load_dependency'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:239:in `require'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/railties-3.0.9/lib/rails/application.rb:103:in `require_environment!'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/railties-3.0.9/lib/rails/application.rb:218:in `block in initialize_tasks'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/task.rb:205:in `call'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/task.rb:205:in `block in execute'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/task.rb:200:in `each'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/task.rb:200:in `execute'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/task.rb:158:in `block in invoke_with_call_chain'
/Users/Kyle/.rvm/rubies/ruby-1.9.2-p180/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/task.rb:151:in `invoke_with_call_chain'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/task.rb:176:in `block in invoke_prerequisites'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/task.rb:174:in `each'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/task.rb:174:in `invoke_prerequisites'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/task.rb:157:in `block in invoke_with_call_chain'
/Users/Kyle/.rvm/rubies/ruby-1.9.2-p180/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/task.rb:151:in `invoke_with_call_chain'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/task.rb:144:in `invoke'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/application.rb:112:in `invoke_task'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/application.rb:90:in `block (2 levels) in top_level'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/application.rb:90:in `each'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/application.rb:90:in `block in top_level'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/application.rb:129:in `standard_exception_handling'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/application.rb:84:in `top_level'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/application.rb:62:in `block in run'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/application.rb:129:in `standard_exception_handling'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/lib/rake/application.rb:59:in `run'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/gems/rake-0.9.2/bin/rake:32:in `<top (required)>'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/bin/rake:19:in `load'
/Users/Kyle/.rvm/gems/ruby-1.9.2-p180@skateparks/bin/rake:19:in `<main>'
Tasks: TOP => db:migrate => environment

最佳答案

在此行上：https://github.com/kyledecot/skateparks-web/blob/master/app/models/skatepark/comment.rb#L33

您正在调用User模型，该模型试图加载users表。为何不使用外键约束呢？

关于ruby-on-rails - SQLite3::SQLException:没有这样的表:users:选择“users”。* FROM“users”，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/7020317/

文章推荐： apache - 禁用特定图像文件的 mod_pagespeed 压缩

文章推荐： mapkit - calloutAccessoryControlTapped 未调用/触发

"this.users = users;" not binding to "users;" property(“this.users=用户；”不绑定到“用户；”属性)
export class UserListComponent implements OnInit{ users; constructor(private userService: UserS
java - user.region、user.language、user.country 和 user.variant 之间有什么区别？
我最近在我的系统中遇到了 Java 语言环境的问题，我试图用这个配置运行一个项目: -Duser.language=pt_BR -Duser.country=BR 谷歌搜索后，我找到了this sit
python - 经理不在； 'auth.User' 已替换为 'users.User'
1 当我希望出现注册错误时，我的代码出现问题:管理器不可用； 'auth.User' 已替换为 'users.User' ，我尝试解决其他问题，与 Manager 不可用相同； 'auth.User'
javascript - Loopback.js - 在 MongoDB 不创建 "User"和 "user"集合的情况下将基本 "User"模型扩展到 "user"
Loopback 非常酷，但这是我迄今为止遇到的一个缺点，我真的不确定如何解决它。内置用户模型在我的 MongoDB 数据库中生成一个名为“User”的集合，当我尝试根据 Loopback.js 自己
javascript - AWS认知: How to assign user to a user group when user signs up
我在 aws cognito 中有以下用户组。行政成员付费成员(member) 我想在所有用户注册我的应用程序时将所有用户默认分配到 Member 用户组，这样我就可以为该用户组分配不同的 IAM A
php - 找不到列 : 1054 Unknown column 'users.blog_id' :SQL: select * from `users` where `users` .`blog_id` = 1 and `users` .`blog_id` is not null
blogsIndex.blade.php @extends('layouts.default') @section('details')
ruby-on-rails - SQLite3::SQLException:没有这样的表:users:选择“users”。* FROM“users”
我正在尝试在Rails 3开发环境中使用sqlite3而不是MySQL，但是遇到了问题。尝试执行rake db:migrate时，我得到： SQLite3::SQLException: no such
data-structures - Phoenix 1.3 (Elixir) 错误 : Myapp. Users.User.__struct__/0 未定义，无法扩展 struct Myapp.Users.User
尝试使用构建 API Phoenix v1.3 按照本教程: https://dreamconception.com/tech/phoenix-full-fledged-api-in-five-mi
django - Postgres : Password authentication failed for user "user". 角色 "user"不存在
我正在使用通过模板 cookie-cutter 创建的 Django。当我尝试在本地使用 docker 运行项目时，出现以下错误。 FATAL: password authentication fai
node.js - 当我尝试创建新用户时，意外的 token user = wait User.create(user)
我正在尝试使用 node.js/adonis 创建新用户我创建了这两个函数: const User = use("App/Models/User") async store ({ request,
apache - 配置 Apache 将 "GET/user/foo"路由到/user/GET.php 并将 "PUT/user/foo"路由到/user/PUT.php
我想安排一些事情，例如 GET 请求 http://example.com/user/foo@bar.com 内部调用脚本 /var/www/example.com/rest/user/GET.php
user-interface - 有哪些很好的例子表明 "I am not the user"？
我是一名具有可用性工程背景的软件开发人员。当我在研究生院学习可用性工程时，其中一位教授有一句口头禅:“你不是用户”。我们的想法是，我们需要将 UI 设计基于实际的用户研究，而不是我们自己关于 UI 应
ios - 解析推送通知 : User to User
您好，我正在制作一个使用互联网发送消息的消息传递应用程序。我需要从用户 a 向用户 b 发出通知。我使用这段代码: if (toUser!= nil){ parseMessage[@
python - 使用 django，你可以做一些类似于 user = User.new(params[ :user]) during a form post?
在 ruby/ror 中你可以这样做: user = User.new(params[:user]) 它使用发布表单中的值填充新对象。使用 django/python 可以完成类似的事情吗？最
symfony - FOSUserBundle/Symfony2 : Force logout of a user given a user (not the currently logged in user)
每当我编辑用户的角色时，用户都需要注销并重新登录以查看更改。提升用户时没有问题，因为他们在再次登录之前不会看到额外的权限。但是，当降级发生时，用户仍将保留其现有角色，这会带来安全风险。想象一下，撤销一
ios - 一对一关系的值类型 Not Acceptable : property = "user"; desired type = User; given type = User;
我的核心数据有线问题。使用 iOS 10 中的 Swift3，每次使用获取或存储数据时，我都会获得托管对象上下文 func getContext () -> NSManagedObjectCont
ruby-on-rails - users_path(user) 在使用 devise 时返回/users.id 而不是/users/id
我发现当我使用 users_path(user) 时它返回 /users.id 其中 id 是用户的 ID 但我希望它返回 /用户/ID。我的配置 routes.rb 如下所示。 # config/r
android - 权限拒绝 : get/set setting for user asks to run as user -2 but is calling from user 0
我的应用程序在我的测试设备上正常运行(当我通过 ADT 安装它时，当我通过导出的 APK 文件安装它时)但它在 Play Store 测试设备上失败并出现以下错误: Permission Denial
python - 无法分配 "": "Model.user"必须是 "User"实例
创建模型的第一个条目会抛出错误我执行了以下命令进行迁移 manage.py makemigrations manage.py migrate 在我执行这些命令以在数据库中创建第一个“数据”之后，一切
android - 函数 'Stream' 无法返回类型为 'user' 的值，因为它在 flutter 中的返回类型为 'Stream'
我正在尝试实现一个 getter，但它在下面代码 fragment 的最后一行向我显示了这个错误。代码是—— class AuthRepository extends BaseAuthReposit

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

ruby-on-rails - SQLite3::SQLException:没有这样的表:users:选择“users”。* FROM“users”