zencart批量上傳，出現如下錯誤提示：
ADD NEW PRODUCT FAILED! – Model: no200 – SQL error. Check Easy Populate error log in uploads directoryMySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'。
Zen Cart開源網店系統是優秀的, 這點不用懷疑. Easy Populate 是方便的, 這點也不用懷疑. 從Zen Cart官網 下載的到目前為止最新的ep是v1.2.5.7版, 安裝后發現了兩個小問題:
watches for sale
1. install_sql 最后少了一行語句, 語句用于寫入 `EASYPOPULATE_CONFIG_CUSTOM_FIELDS` 設置
2. /admin/easypopulate.php 多了兩行語句, 這兩行語句將引起執行錯誤, 典型的錯誤如下:
MySQL error 1110: Column 'products_last_modified' specified twice
When executing:
INSERT INTO zen_products SET
products_model = '10001' ,
products_price = '239' ,
products_image = 'images/10000.jpg' ,
products_weight = '0' ,
products_tax_class_id = '' ,
products_last_modified = '2009-11-07 10:43:00' ,
products_date_added = '2009-11-07 10:31:00' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '15' ,
master_categories_id = '55' ,
manufacturers_id = 'NULL',
products_status = '1',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = '0'
最模板解決方法:
1. 將install_sql最后一個 ” ; ” 替換為 ” , ” 并在下一行加入以下代碼:
('', 'Custom Products Fields', 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS', '', 'Enter a comma seperated list of fields to be automatically added to import/export file(ie: products_length, products_width). Please make sure field exists in PRODUCTS table.', " . last_insert_id() . ", '10', NULL, now(), NULL, NULL);
解決了1054錯誤問題。
或者在安裝完成后 reinstall :
轉到 Tools -> Easy Populate , 在地址欄最后加上 ” ?langer=remove ” 參數(不包括引號)并回車運行, 根據頂部提示點擊 click 重裝.
2. 錯誤原因是 `products_last_modified ` 字段重復定義, 將它們刪除即可:
打開 /admin/easypopulate.php , 刪除位于行 1776 與 1832 的兩行代碼即可.
