最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

sequelize'on'子句中的未知列''

运维笔记admin15浏览0评论

sequelize'on'子句中的未知列''

sequelize'on'子句中的未知列''

亲爱的,我有下面的代码,它工作正常,但我有一个问题,我试图包括图像表

订单和图像之间已经存在关联,但我不知道为什么它会显示以下错误

Unhandled rejection SequelizeDatabaseError: ER_BAD_FIELD_ERROR: Unknown column 'images.imageable' in 'on clause'

在代码下面:

models.Order.findOne({
        where : {
            id : req.params.orderId
        },
        attributes: ['id','comment','rating','orderDescription','userLat','userLng','orderStatus','providerId','isUsingBalance','userId','serviceId','createdAt','updatedAt','ticketNumber',

            'orderScheduledDate', 'promoId','paymentMethodId',
            [sequelize.Sequelize.fn('date_format', sequelize.Sequelize.col('orderScheduledDate'), '%Y-%m-%D %h:%i'),'orderScheduledDateToEdit']

        ],
        include: [
            {
                model : models.Comment,

                include: [
                    {
                        model : models.User,
                        attributes: ['firstName','lastName','id']
                    }
                ]
            },
            {
                model:  models.Provider,
                attributes: ['id','userId'],
                include:
                    [
                        {
                            model :  models.User,
                            attributes: ['id','firstName','lastName','phoneNumber']
                        },
                        {
                        model : models.ProviderLocation,
                        attributes: ['lat','lng','providerId']
                        },
                        {
                            model : models.PaymentMethod,
                            through: {
                                where: {status: "ACTIVE"}
                            }
                        }
                    ]
            },
            {
                model : models.User,
                attributes: ['id','firstName','lastName','phoneNumber','status'],
                include : [
                    {
                        model: models.Balance,
                        attributes: ['balance']

                    }
                ]
            },
            {
                model : models.notified_providers ,
                attributes: ['orderId','providerBroadcastedId','distance','duration','status','rank_score','rate_score','distance_score','nationality_score','total_score'],
                include: [
                    {
                        model: models.Provider,
                        attributes: ['id'],
                        include: [
                            {
                                model: models.User,
                                attributes: ['id','firstName','lastName','phoneNumber','status','rate','rankId']
                            },
                            {
                                model : models.PaymentMethod,
                                through: {
                                    where: {status: "ACTIVE"}
                                }
                            }

                        ]
                    }
                ]
            },
            {
                model : models.rate,
                attributes: ['rate']
            },
            {
                model : models.Service,
                attributes: ['serviceType']
            },
            {
                model : models.Promotion,
                attributes: ['code','conditions']
            },
            {
                model : models.PaymentMethod,
                attributes: ['name','image']
            },
            {
                model: models.images,
                attributes: ['imageble','image','imagebleId']
            }
        ]
    })
回答如下:

我试过@Ellebkey解决方案(上面发表评论)

尝试在as模型关联定义和include上添加images属性。

使用(AS)就像一个魅力。

发布评论

评论列表(0)

  1. 暂无评论