Guest Posted June 14, 2008 Share Posted June 14, 2008 I had successfully added EP and exported and created files just fine. However, when trying to import the file with a change to price it fails and produces the following error. We have double checked documentation and have tried to find a similar error in the threads. We even reduced the number of lines being imported so we didn't have to deal with splitting the file. We have also tried the suggestions of saving the file from Excel as different formats before re-importing. Here is the error message - after that is the info of what version of EP I'm running on. After that is the sample file we were trying to import with the headers listed. My biggest thanks in advance for any suggestions...I'm not a techie - but, I was very happy I was able to install EP and actually produce the files. I worship the ground you walk on!!!! :lol: File uploaded. Temporary filename: /var/tmp/phpLzh0mo User filename: test2.txt Size: 79474 1054 - Unknown column 'p.products_cost' in 'field list' SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_cost as v_products_cost, p.products_weight as v_products_weight, p.products_date_available as v_date_avail, p.products_date_added as v_date_added, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id, p.products_status as v_status_current FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_model = 'MP5500' AND p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id LIMIT 1 [TEP STOP] Settings & Info EP vers: 2.76g-MS2 osCommerce 2.2-MS2 OS: Linux 2.6.22-19_1.BHsmp HTTP: Apache/2.2.8 (Unix) mod_ssl/2.2.8 OpenSSL/0.9.8g DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/184.108.40.20635 DB: MySQL 5.0.45-community-log PHP: 5.2.6 (Zend: 2.2.0) Temp Directory: /home/ematrixs/public_html/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: on Split files on: 27000 records Model Num Size: 12 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: comma Excel safe output: true Preserve tab/cr/lf: false Category depth: 7 Enable attributes: false SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: false SPPC: false Extra Fields: false v_products_model v_products_price v_products_quantity EOREOR MP5500 2199.99 100 EOREOR A-RMPT515000 2199.99 100 EOREOR 52PFL3603D 2199.99 100 EOREOR EOS-40D 2188.88 100 EOREOR Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.