Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 - Unknown column 'p.products_subimage1' in 'field list'


Guest

Recommended Posts

I dont know if this is the right place to post this? Im a noobie and trying to figure this easy populate module out and every time i try to download the .csv file of my database or even try to upload a .csv file i keep getting this message

 

 

1054 - Unknown column 'p.products_subimage1' 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_subimage1 as v_products_subimage1, p.products_subimage2 as v_products_subimage2, p.products_subimage3 as v_products_subimage3, p.products_subimage4 as v_products_subimage4, p.products_subimage5 as v_products_subimage5, p.products_subimage6 as v_products_subimage6, p.products_price as v_products_price, 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 FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id

 

[TEP STOP]

 

 

Can someone please help and tell me how to fix this so i can start populating my site the EASY way.

 

Thanks

Link to comment
Share on other sites

It should be no products_subimage1 in your products table in the db, either add the new field in db or remove it from the php code could be working.

 

PS: I think EP doesn't need the field

Link to comment
Share on other sites

These are my settings

 

Settings & Info

 

EP vers: 2.76g-MS2

osCommerce Online Merchant v2.2 RC2a

OS: Linux 2.6.16.33-20070131a-areca-filemon-3ware-e1000

HTTP: Apache/1.3.34 Ben-SSL/1.55

DB: MySQL 4.0.27-standard-log

PHP: 4.4.8 (Zend: 1.3.0)

 

Temp Directory:

/homepages/32/d235068558/htdocs/Wholesale/catalog//temp/

Temp Dir is Writable

Magic Quotes is: off

register_globals is: on

Split files on: 300 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: true

Category depth: 40

Enable attributes: true

SEF Froogle URLS: true

More Pics: true

Unknown Pics: false

HTC: false

SPPC: false

Extra Fields: false

 

 

 

Can someone please help and tell me how to fix this so i can start populating my site the EASY way.

 

Thanks

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...