php - MySQL 错误 1054 : Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'

Question

我正在与客户端一起使用 ZenCart，但遇到了问题。我基本上是将他的网站之一复制到另一个网站，但出现以下错误。

任何帮助都会很棒，

谢谢。

MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
INSERT INTO kyk_products SET
                        products_model                  =   'Beauty 01 pink' ,
                        products_price                  =   '54.95' ,
                        products_image                  =   'BEAUTY-01L-BPSAT.jpg' ,
                        products_weight                 =   '0' ,
                        products_tax_class_id           =   '' ,
                        products_date_available         =   '' ,
                        products_date_added             =   '2011-09-13 10:05:22' ,
                        products_last_modified          =   CURRENT_TIMESTAMP ,
                        products_quantity               =   '100' ,
                        master_categories_id            =   '9' ,
                        manufacturers_id                =   '1',
                        products_status                 =   '0',
                        metatags_title_status           =   '0',
                        metatags_products_name_status   =   '0',
                        metatags_model_status           =   '0',
                        metatags_price_status           =   '0',
                        metatags_title_tagline_status   =   '0' , 
                        EASYPOPULATE_CONFIG_CUSTOM_FIELDS='' 

Answer 1

您的查询没问题(尽管不是 SQL 标准)。看到它工作here .

也许您有两个不同版本的产品？在新目标上，EASYPOPULATE_CONFIG_CUSTOM_FIELDS 列不存在。