Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009
    Posts
    2
    Plugin Contributions
    0

    Default Fedex Shipping Module error 1054 only when customore is logged in

    Hello,

    This is my first post, so I hope I am posting in the right place.

    I have installed the Fedex module on my site . When I test it without logging into the store, everything works fine. However, if I log into a customer account, and then try to either estimate shipping or checkout, I get the following error message.

    Code:
    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 FROM zen_products WHERE products_id = 4 LIMIT 1]
    If I turn off the two fedex modules, and then log in, I don't encounter any problems. Also, I am not a programmer so I don't understand what the error message even means. From looking in the forums I assume it has something to do with MySql. I chose zencart because I read it was the easiest one, I hope I'm not in over my head. Does anyone know how I can fix this problem?

    When I go to Tools>Server/Version info it says my version appears to be current, and I am running on MySQL 4.1.22-standard-log. I'm not really sure if that information is necessary. If you need more info let me know.

    Any help is sincerely appreciated,
    Sam

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

    Default Re: Fedex Shipping Module error 1054 only when customore is logged in

    Check the similar posts at the bottom of this thread
    Zen-Venom Get Bitten

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

    Default Re: Fedex Shipping Module error 1054 only when customore is logged in

    I looked at all the posts at the bottom, but those don't seem to relate directly to this situation.

    Why does the module work when nobody is logged in? Why does the module note work when customers are logged in?

    Also, how do I fix the problem?

    Thank you.

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

    Default Re: Fedex Shipping Module error 1054 only when customore is logged in

    Zen-Venom Get Bitten

 

 

Similar Threads

  1. Error 1054 Unknown column 'p.products_dim_type' - FEDEX module
    By manutd98 in forum Addon Shipping Modules
    Replies: 21
    Last Post: 30 Jan 2010, 03:14 AM
  2. Replies: 2
    Last Post: 10 Jun 2009, 12:24 PM
  3. Zone rate shipping only works when logged in
    By erekose in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 10 Mar 2009, 06:47 PM
  4. error 1054 ezpages only when I create a non external link but a page with content
    By giuly in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 8 Feb 2009, 05:59 PM
  5. Shipping Estimator Error 404 when cliet is not logged in
    By mikebr in forum Built-in Shipping and Payment Modules
    Replies: 29
    Last Post: 14 Jun 2007, 07:33 AM

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