Jump to content
Sign in to follow this  
Cath

problem with canada post module

Recommended Posts

I am getting an error on the page:

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

 

select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_dim_type, p.products_weight_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from products p, products_description pd where p.products_id = '47' and p.products_id = pd.products_id and pd.language_id = '1'

 

 

This seems to be in the shoppingcart file.

Whats happening?

Share this post


Link to post
Share on other sites

well thats fixed now

 

the problem NOW is i get an XML parse error when it comes for a customer to choose their shipping method.

what does this mean?

Share this post


Link to post
Share on other sites

how many shipping options do you offer ? Just Canada Post ?

 

It is possible that you will have to set up your CP account first. You must be running on the demo version.

 

WW

 

www.callibo.com

Share this post


Link to post
Share on other sites

There are two Can Post Modules

 

one standard and the other with dimensions.

 

If you are just getting started I would suggest you go to the contribution with dimensions. You get more accurate rates from CanPost using it. You will simply need to provide more info for the items being shipped.

Share this post


Link to post
Share on other sites

its good it worked

i was getting an error because the postal code has to be written in without a space.

thanks!

Share this post


Link to post
Share on other sites
I am getting an error on the page:

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

 

select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_dim_type, p.products_weight_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from products p, products_description pd where p.products_id = '47' and p.products_id = pd.products_id and pd.language_id = '1'

This seems to be in the shoppingcart file.

Whats happening?

 

:'( Hey Cath,

 

I have the exact error you listed above. How exactly did you fix this 1054 error? This is one of the last things holding my store up and I've been racking my brains (or lack there of) to figure this out. Any help would be greatly, greatly, greatly apprieciated!

 

Randal

Share this post


Link to post
Share on other sites
Cath,

 

Which module are you using ?

 

WW

 

www.callibo.com

 

:'( Hey WW,

 

I am getting the exact same error as Cath (see below). Do you know how to fix it? Anything you can do to help a fellow Canadian would be greatly appreciated.

 

Thanks,

Randal

 

Error I'm getting -->

 

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

 

select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_dim_type, p.products_weight_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from products p, products_description pd where p.products_id = '73' and p.products_id = pd.products_id and pd.language_id = '1'

 

[TEP STOP]

Edited by FLIBIU

Share this post


Link to post
Share on other sites
just XML parsing error

 

i dont knwo what the problem could be

I'm also getting a simple 'xml parsing error' on checkout. I have the 3.7 version of the shipping module with dimensions. AFAIK, the module is installed correctly, and my Canada Post account is setup correctly. Port 30000 is open, and if I test by changing to another port, then the module says it can not connect to Canada Post's server, so I'm confidend that port 30000 is no the problem and that it is getting to CPost's server.

 

However, it simply says XML Parsing error, which is not a lot of help. My cart is populated with stock (as is my shelves) so I'd really love to get selling, and any help would be appreciated.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×