Results 1 to 3 of 3
  1. #1
    Join Date
    May 2010
    Posts
    13
    Plugin Contributions
    0

    Default Please Help having trouble with my estimate shipping!

    I instaled the newest version of zen cart as well as the fedex module for shipping. However when I was doing a test session attempting to estimate the shipping costs of the item I come up with this error.
    "
    1054 Unknown column 'products_length' in 'field list'
    in:
    [SELECT products_length, products_width, products_height, products_ready_to_ship, product_is_always_free_shipping, products_weight FROM products WHERE products_id = 1 LIMIT 1]

    "

    www.simoastreats.biz/shop

    Can somone please help we are trying to launch as soon as possible. Also does anyone have any suggestions on installation of the shiprush software no avaiable we are currently using it for both amazon and ebay sales and wanted to incorporate it with our zen art as well to help speed things up but are unsure of compatabilty since we are running into a problem with the shipping calc as is.

    YOur expeditited response is extremely appreciated as I just got some seo managing and dont want to pay for clicks to a non functioning cart.

    Thanks,
    Landon
    President Simoa's Treats INC.

  2. #2
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,167
    Plugin Contributions
    7

    Default Re: Please Help having trouble with my estimate shipping!

    Quote Originally Posted by SimoasTreats View Post
    I instaled the newest version of zen cart as well as the fedex module for shipping. However when I was doing a test session attempting to estimate the shipping costs of the item I come up with this error.
    "
    1054 Unknown column 'products_length' in 'field list'
    in:
    [SELECT products_length, products_width, products_height, products_ready_to_ship, product_is_always_free_shipping, products_weight FROM products WHERE products_id = 1 LIMIT 1]
    The following three fields are NOT a part of the default zencart distribution.
    "products_length, products_width, products_height".

    What this means is that your zencart database and the zencart files are out of sync.

    You have two options.

    1. Rerun the SQL update scripts that came with your shipping module(s). or

    2. Re-install the relevant files under /admin/ to bring them back in line with the distribution files.

    Cheers
    Rod

  3. #3
    Join Date
    May 2010
    Posts
    1
    Plugin Contributions
    0

    Default Re: Please Help having trouble with my estimate shipping!

    Quote Originally Posted by SimoasTreats View Post
    Also does anyone have any suggestions on installation of the shiprush software no avaiable we are currently using it for both amazon and ebay sales and wanted to incorporate it with our zen art as well to help speed things up but are unsure of compatabilty since we are running into a problem with the shipping calc as is.
    The ShipRush support forums are at http://forums.zfirm.com

    Any questions, please ask! ShipRush has full, direct shipping integration for eBay, Amazon & ZenCart.

 

 

Similar Threads

  1. Having Trouble With Attributes
    By HBELLC in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 18 Aug 2011, 02:12 AM
  2. Please help with attributes and pricing trouble
    By dat311 in forum Setting Up Categories, Products, Attributes
    Replies: 7
    Last Post: 7 Jun 2011, 03:38 AM
  3. Having trouble with my purchased template. Need HELP!
    By shkad14 in forum Templates, Stylesheets, Page Layout
    Replies: 6
    Last Post: 9 Aug 2010, 12:20 AM
  4. Having trouble with Checkout
    By trafficzombie in forum Basic Configuration
    Replies: 1
    Last Post: 6 Jul 2009, 09:49 AM
  5. Newbie- Please help with installation trouble.
    By talk2mejjv in forum Installing on a Linux/Unix Server
    Replies: 3
    Last Post: 12 Jun 2009, 05:34 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