Zen Cart Logo
Forums / General Questions / Please Help having trouble with my estimate shipping!

Please Help having trouble with my estimate shipping!

Locked

Views: 557

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
21 May 2010, 6:01 PM
#1
simoastreats avatar

simoastreats

New Zenner

Join Date:
May 2010
Posts:
13
Plugin Contributions:
0

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]

"

https://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.

22 May 2010, 3:07 AM
#2
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Location:
Australia
Posts:
6,263
Plugin Contributions:
4

Re: Please Help having trouble with my estimate shipping!

SimoasTreats:

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

24 May 2010, 3:49 AM
#3
shiprush avatar

shiprush

New Zenner

Join Date:
May 2010
Posts:
1
Plugin Contributions:
0

Re: Please Help having trouble with my estimate shipping!

SimoasTreats:

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.