如果您对RailsPG::UndefinedTable：错误：缺少表的FROM子句条目感兴趣，那么本文将是一篇不错的选择，我们将为您详在本文中，您将会了解到关于RailsPG::UndefinedTa

如果您对Rails PG :: UndefinedTable：错误：缺少表的FROM子句条目感兴趣，那么本文将是一篇不错的选择，我们将为您详在本文中，您将会了解到关于Rails PG :: UndefinedTable：错误：缺少表的FROM子句条目的详细内容，我们还将为您解答ora00936缺少表达式的相关问题，并且为您提供关于ActiveStorage：按附件文件名排序 ActiveRecord 模型（错误缺少表“active_storage_blobs”的 FROM 子句条目）、android – bundling failed：错误：插件0提供了“default”的无效属性、golang 编译错误："undefined: file.Stat" 如何解决？、golang 编译错误："undefined: ioutil.WriteFile" 如何解决？的有价值信息。

• Rails PG :: UndefinedTable：错误：缺少表的FROM子句条目（ora00936缺少表达式）
• ActiveStorage：按附件文件名排序 ActiveRecord 模型（错误缺少表“active_storage_blobs”的 FROM 子句条目）
• android – bundling failed：错误：插件0提供了“default”的无效属性
• golang 编译错误："undefined: file.Stat" 如何解决？
• golang 编译错误："undefined: ioutil.WriteFile" 如何解决？

Rails PG :: UndefinedTable：错误：缺少表的FROM子句条目（ora00936缺少表达式）

我有模特

class Offer < ActiveRecord::Base  belongs_to :agencyendclass Agency < ActiveRecord::Base  has_many :offersend

当我发出这样的请求时-一切都很好

@offers = Offer.with_state(:confirmed).  includes(:destination, :cruise_line, :ship).  paginate(per_page: 10, page: params[:page]).decorate

但我想只选择属于报价active机构（列state从agencies，所以我尝试做这样的表），：

@offers = Offer.with_state(:confirmed).  includes(:destination, :cruise_line, :ship).  joins(:agency).  where(agency: {state: ''active''}).  paginate(per_page: 10, page: params[:page]).decorate

完成此操作后，我会出错PG::UndefinedTable: ERROR: missing FROM-clause entry for table"agency"。我的代码有什么问题？

查询给我这个错误和SQL：

PG::UndefinedTable: ERROR: missing FROM-clause entry for table "agency" LINE 1: ...id" WHERE ("offers"."state" IN (''confirmed'')) AND "agency"."... ^ : SELECT "offers"."id" AS t0_r0, "offers"."name" AS t0_r1, "offers"."destination_id" AS t0_r2, "offers"."cruise_line_id" AS t0_r3, "offers"."ship_id" AS t0_r4, "offers"."departure_date" AS t0_r5, "offers"."departure_port_id" AS t0_r6, "offers"."arrival_date" AS t0_r7, "offers"."arrival_port_id" AS t0_r8, "offers"."flight_price" AS t0_r9, "offers"."bonus" AS t0_r10, "offers"."itinerary" AS t0_r11, "offers"."board_language_id" AS t0_r12, "offers"."agency_landing_page" AS t0_r13, "offers"."benefits" AS t0_r14, "offers"."inner_price" AS t0_r15, "offers"."inner_price_normal" AS t0_r16, "offers"."outer_price" AS t0_r17, "offers"."outer_price_normal" AS t0_r18, "offers"."balcony_price" AS t0_r19, "offers"."balcony_price_normal" AS t0_r20, "offers"."suite_price" AS t0_r21, "offers"."suite_price_normal" AS t0_r22, "offers"."lucky_price" AS t0_r23, "offers"."lucky_price_normal" AS t0_r24, "offers"."valid_from" AS t0_r25, "offers"."valid_till" AS t0_r26, "offers"."created_at" AS t0_r27, "offers"."updated_at" AS t0_r28, "offers"."description" AS t0_r29, "offers"."agency_id" AS t0_r30, "offers"."state" AS t0_r31, "destinations"."id" AS t1_r0, "destinations"."name" AS t1_r1, "destinations"."created_at" AS t1_r2, "destinations"."updated_at" AS t1_r3, "cruise_lines"."id" AS t2_r0, "cruise_lines"."name" AS t2_r1, "cruise_lines"."created_at" AS t2_r2, "cruise_lines"."updated_at" AS t2_r3, "ships"."id" AS t3_r0, "ships"."name" AS t3_r1, "ships"."picture" AS t3_r2, "ships"."cruise_line_id" AS t3_r3, "ships"."created_at" AS t3_r4, "ships"."updated_at" AS t3_r5 FROM "offers" INNER JOIN "agencies" ON "agencies"."id" = "offers"."agency_id" LEFT OUTER JOIN "destinations" ON "destinations"."id" = "offers"."destination_id" LEFT OUTER JOIN "cruise_lines" ON "cruise_lines"."id" = "offers"."cruise_line_id" LEFT OUTER JOIN "ships" ON "ships"."id" = "offers"."ship_id" WHERE ("offers"."state" IN (''confirmed'')) AND "agency"."state" = ''active'' LIMIT 10 OFFSET 0

答案1

您添加的唯一内容是-where子句。似乎有问题：

where(agency: {state: ''active''})

…并产生错误的条件，因为在这种情况下，哈希键应表示表名。您可能应该有以下内容：

where(agencies: {state: ''active''})

更新

看到这一点吸引了很多关注，我想我还应该建议一种不同的方法来做同样的事情，它稍微有些可组合：

merge( Agency.where(state: ''active'') )

这个更好吗？它不对模型的表名做任何假设（并非在大多数情况下都很重要），并允许您使用 范围 ：

# Inside Agencyscope :active, -> { where(state: ''active'') }# Somewhere elsemerge(Agency.active)

ActiveStorage：按附件文件名排序 ActiveRecord 模型（错误缺少表“active_storage_blobs”的 FROM 子句条目）

class Quote < ApplicationRecord
  has_many :quote_documents,dependent: :destroy
end
class QuoteDocument < ApplicationRecord
  has_one_attached :document
end

@quote.quote_documents.includes(:document_attachment).order(''active_storage_blobs.filename ASC'')

@quote = Quote.includes(quote_documents: {document_attachment: :blob}).find(params[id])

@quote.quote_documents.order(''active_storage_blobs.filename ASC'')

react-native run-android

bundling Failed: Error: Plugin 0 specified in "C:\\Users\\ASUS\\test\\node_modules\\babel-preset-react-native\\index.js" provided an invalid property of "default" (While processing preset: "C:\\Users\\ASUS\\test\\node_modules\\babel-preset-react-native\\index.js")
    at Plugin.init (C:\Users\ASUS\test\node_modules\babel-core\lib\transformation\plugin.js:131:13)
    at Function.normalisePlugin (C:\Users\ASUS\test\node_modules\babel-core\lib\transformation\file\options\option-manager.js:152:12)
    at C:\Users\ASUS\test\node_modules\babel-core\lib\transformation\file\options\option-manager.js:184:30
    at Array.map (<anonymous>)
    at Function.normalisePlugins (C:\Users\ASUS\test\node_modules\babel-core\lib\transformation\file\options\option-manager.js:158:20)
    at OptionManager.mergeOptions (C:\Users\ASUS\test\node_modules\babel-core\lib\transformation\file\options\option-manager.js:234:36)
    at C:\Users\ASUS\test\node_modules\babel-core\lib\transformation\file\options\option-manager.js:265:14
    at C:\Users\ASUS\test\node_modules\babel-core\lib\transformation\file\options\option-manager.js:323:22
    at Array.map (<anonymous>)

{
  "presets": [
    "react-native"
    "@babel/preset-flow"
  ]
}

{
  "name": "test","version": "0.0.1","private": true,"scripts": {
    "start": "node node_modules/react-native/local-cli/cli.js start","test": "jest"
  },"dependencies": {
    "react": "16.4.1","react-native": "^0.55.4"
  },"devDependencies": {
    "babel-jest": "23.4.0","babel-preset-react-native": "5.0.2","jest": "23.4.1","react-test-renderer": "16.4.1"
  },"jest": {
    "preset": "react-native"
  }
}

yarn remove babel-preset-react-native
yarn add babel-preset-react-native@2.1.0

import "os"