logo标签列表

在开发环境中表格条目可以正常工作，但在生产环境中无法正常工作。

ruby-on-railsrubypostgresql
3
我有一个产品页面，当你购买该产品时，它会重定向到一个购买页面（收据和下载页面）。
在我的本地计算机上开发时，一切正常，但是当在远程服务器上生产环境中进行购买时，它会向客户（使用Stripe）收费，但不会在“purchase”表中创建条目，这将导致客户无法下载其产品。我在远程服务器上的“purchases”表中检查了“psql”，它没有任何行/条目。
它应该发送一封电子邮件 - 链接到购买页面，这也只在开发环境中有效。
我在本地计算机和远程服务器上都使用PostgreSQL。
charges控制器：
class ChargesController < ApplicationController

  def new
    set_meta_tags noindex: true
  end

  def create
    pack = Pack.find(params[:product_id])

    customer = Stripe::Customer.create(
      :email => params[:stripeEmail],
      :source  => params[:stripeToken],
    )

    # Amount in cents
    charge = Stripe::Charge.create(
      :customer    => customer.id,
      :amount      => pack.price_in_cents,
      :description => 'Product Purchase',
      :currency    => 'usd',
    )

    purchase = Purchase.create(
      email: params[:stripeEmail],
      card: params[:stripeToken],
      amount: pack.price_in_cents,
      description: charge.description,
      currency: charge.currency,
      customer_id: customer.id,
      product_id: pack.id,
      uuid: SecureRandom.uuid,
    )

    redirect_to purchase

  rescue Stripe::CardError => e
    flash[:error] = e.message
    redirect_to new_charge_path
  end

end

purchases_controller:

class PurchasesController < ApplicationController

  def show
    @title = 'Purchase Receipt';
    @purchase = Purchase.find_by_uuid(params[:id])
    @pack = Pack.find(@purchase.product_id)
    set_meta_tags noindex: true
  end

end

购买模式:

class Purchase < ApplicationRecord
  attr_accessor :download_token
  after_create :email_purchaser

  def to_param
    uuid
  end

  def email_purchaser
    PurchaseMailer.purchase_receipt(self).deliver
  end

  def Purchase.new_token
    SecureRandom.urlsafe_base64
  end

  def create_download
    self.download_token = Purchase.email.new_token
    update_attribute(:download, Purchase.email(download_token))
    update_attribute(:download_sent_at, Time.zone.now)
  end

end

购买邮件：

class PurchaseMailer < ActionMailer::Base
  layout 'purchase_mailer'
  default from: "First Last <myemail@gmail.com>"

  def purchase_receipt purchase
    @purchase = purchase
    mail to: purchase.email, subject: "Thank you for your purchase. Here's your download link, enjoy!"
  end

end

购买链接在发送的电子邮件中的显示：

<%= link_to "下载", purchase_url(@purchase), target: "_blank" %>

以下是服务器日志：

I, [2019-01-11T22:04:21.404919 #17222]  INFO -- : [14c2eed0-3aae-4ab6-8142-9aa9744819af] Started HEAD "/https://mywebsite.com/" for XX.XXX.XXX.XXX at 2019-01-11 22:04:21 +0000
F, [2019-01-11T22:04:21.405538 #17222] FATAL -- : [14c2eed0-3aae-4ab6-8142-9aa9744819af]
F, [2019-01-11T22:04:21.405585 #17222] FATAL -- : [14c2eed0-3aae-4ab6-8142-9aa9744819af] ActionController::RoutingError (No route matches [HEAD] "/https:/mywebsite.com"):
F, [2019-01-11T22:04:21.405611 #17222] FATAL -- : [14c2eed0-3aae-4ab6-8142-9aa9744819af]
F, [2019-01-11T22:04:21.405648 #17222] FATAL -- : [14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/actionpack-5.1.6/lib/action_dispatch/middleware/debug_exceptions.rb:63:in `call'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/actionpack-5.1.6/lib/action_dispatch/middleware/show_exceptions.rb:31:in `call'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/railties-5.1.6/lib/rails/rack/logger.rb:36:in `call_app'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/railties-5.1.6/lib/rails/rack/logger.rb:24:in `block in call'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/activesupport-5.1.6/lib/active_support/tagged_logging.rb:69:in `block in tagged'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/activesupport-5.1.6/lib/active_support/tagged_logging.rb:26:in `tagged'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/activesupport-5.1.6/lib/active_support/tagged_logging.rb:69:in `tagged'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/railties-5.1.6/lib/rails/rack/logger.rb:24:in `call'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/actionpack-5.1.6/lib/action_dispatch/middleware/remote_ip.rb:79:in `call'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/actionpack-5.1.6/lib/action_dispatch/middleware/request_id.rb:25:in `call'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/rack-2.0.5/lib/rack/method_override.rb:22:in `call'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/rack-2.0.5/lib/rack/runtime.rb:22:in `call'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/activesupport-5.1.6/lib/active_support/cache/strategy/local_cache_middleware.rb:27:in `call'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/actionpack-5.1.6/lib/action_dispatch/middleware/executor.rb:12:in `call'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/rack-2.0.5/lib/rack/sendfile.rb:111:in `call'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] vendor/bundle/ruby/2.5.0/gems/railties-5.1.6/lib/rails/engine.rb:522:in `call'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] /usr/lib/ruby/vendor_ruby/phusion_passenger/rack/thread_handler_extension.rb:97:in `process_request'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] /usr/lib/ruby/vendor_ruby/phusion_passenger/request_handler/thread_handler.rb:157:in `accept_and_process_next_request'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] /usr/lib/ruby/vendor_ruby/phusion_passenger/request_handler/thread_handler.rb:110:in `main_loop'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] /usr/lib/ruby/vendor_ruby/phusion_passenger/request_handler.rb:415:in `block (3 levels) in start_threads'
[14c2eed0-3aae-4ab6-8142-9aa9744819af] /usr/lib/ruby/vendor_ruby/phusion_passenger/utils.rb:113:in `block in create_thread_and_abort_on_exception'

在收费控制器中添加 ! 到 purchase = Purchase.create!( 后，这是服务器日志：

F, [2019-01-15T21:21:12.869293 #24540] FATAL -- : [932479d4-c710-4ac6-9159-8c3fa5299adc] ActiveModel::UnknownAttributeError (unknown attribute 'uuid' for Purchase.):

这是我的routes.rb文件：

  resources :charges
  resources :purchases, only: [:show]

我已经从routes.rb中删除了get 'purchase' => 'purchases#show', as: 'purchase'，因为它破坏了我的代码。

它会使URL变成这样：https://mywebsite.com/purchase.uuid

而不是这样：https://mywebsite.com/purchase/uuid

这是我的config/environments/production.rb文件：

Rails.application.configure do
config.cache_classes = true
  config.eager_load = true
  config.consider_all_requests_local       = false
  config.action_controller.perform_caching = true
  config.public_file_server.enabled = ENV['RAILS_SERVE_STATIC_FILES'].present?
  config.assets.js_compressor = :uglifier
  config.assets.compile = false
  config.log_level = :debug
  config.log_tags = [ :request_id ]
  config.action_mailer.perform_caching = false
  config.action_mailer.raise_delivery_errors = true
  config.action_mailer.delivery_method = :smtp
  host = 'transverseaudio.com'
  config.action_mailer.default_url_options = { host: host }
  ActionMailer::Base.smtp_settings = {
    :address        => 'smtp.sendgrid.net',
    :port           => '587',
    :authentication => :plain,
    :user_name      => ENV['SENDGRID_USERNAME'],
    :password       => ENV['SENDGRID_PASSWORD'],
    :domain         => 'transverseaudio.com',
    :enable_starttls_auto => true
  }
  config.i18n.fallbacks = true
  config.active_support.deprecation = :notify
  config.log_formatter = ::Logger::Formatter.new
  if ENV["RAILS_LOG_TO_STDOUT"].present?
    logger           = ActiveSupport::Logger.new(STDOUT)
    logger.formatter = config.log_formatter
    config.logger = ActiveSupport::TaggedLogging.new(logger)
  end
  config.active_record.dump_schema_after_migration = false
end

在运行rails routes命令之后：
            charges GET    /charges(.:format)                                charges#index
                    POST   /charges(.:format)                                charges#create
         new_charge GET    /charges/new(.:format)                            charges#new
        edit_charge GET    /charges/:id/edit(.:format)                       charges#edit
             charge GET    /charges/:id(.:format)                            charges#show
                    PATCH  /charges/:id(.:format)                            charges#update
                    PUT    /charges/:id(.:format)                            charges#update
                    DELETE /charges/:id(.:format)                            charges#destroy
           purchase GET    /purchases/:id(.:format)                          purchases#show
更新后，你有什么问题？ - ray
运行 rake routes | grep purchase。 - ray
1
也许您在生产环境中没有运行迁移，导致购买表中不存在uuid列？ - MatFiz
1
我很高兴能够帮助。我会在下面提供答案，请接受 ;) - MatFiz
@MatFiz 抱歉，我的意思是我通过使用“！”找到了我提到的uuid错误，是的，我找到了，并且它起作用了，请更新您的答案，这样我就可以接受它。 - Jake
显示剩余6条评论
2个回答
1
我建议您将ChargesController.create包装在一个事务中。如果Purchase.create出现某些错误（例如验证错误），则会在数据库中创建一些部分数据和Stripe中的实际交易。此外，检查purchase是否已经创建也是一个很好的改进。
if purchase
  redirect_to purchase
else 
  render :new, error: purchase.errors
end

然后在生产GUI中，您将清楚地看到问题所在。

此外，在您的日志中F，[2019-01-15T21：21：12.869293＃24540] FATAL - ：[932479d4-c710-4ac6-9159-8c3fa5299adc] ActiveModel :: UnknownAttributeError（Purchase的未知属性'uuid'）：，这可能意味着您的迁移未在生产环境中应用，您只是缺少Purchase中的uuid列。

0
网页内容由stack overflow 提供, 点击上面的
可以查看英文原文，
原文链接