Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2009
    Posts
    187
    Plugin Contributions
    0

    Default Import database problem

    Trying to re-do an installation that started as Chinese. I imported most of the databases, I only excluded ones that were not needed. Now I keep getting

    1054 Unknown column 'products_price_w' in 'field list'
    in:
    [select products_price, products_price_w, products_priced_by_attribute from products where products_id = '7261']

    What is a way to fix this?

    Thanks

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: Import database problem

    Import all tables

    Post additional detail asked when you create a post

  3. #3
    Join Date
    Jun 2009
    Posts
    187
    Plugin Contributions
    0

    Default Re: Import database problem

    The reason I did not want to import all tables is because the original installation has chinese language. So many of the config options are in chinese only.

    Any idea on how to isolate this?

    1054 Unknown column 'products_price_w' in 'field list'
    in:
    [select products_price, products_price_w, products_priced_by_attribute from products where products_id = '7220']

    Thank you!

    Quote Originally Posted by kobra View Post
    Import all tables

    Post additional detail asked when you create a post

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: Import database problem

    ZenCart version
    Server details

  5. #5
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,269
    Plugin Contributions
    3

    Default Re: Import database problem

    Kobra's right. You must import ALL tables.

    By leaving some tables out, you are inviting errors. Your installation is hunting for tables that are not there.

    And furthermore, having just the TABLES is sometimes not enough- you may also need the DATA inside some tables.
    20 years a Zencart User

 

 

Similar Threads

  1. v150 Import Database
    By CnTGifts in forum Upgrading to 1.5.x
    Replies: 12
    Last Post: 6 Apr 2012, 05:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg