rocky Posted February 9, 2004 Share Posted February 9, 2004 I have tried to set up the Canada Post shipping module but to no avail... I have an account with Canada Post already set up... When I try to install the shipping module contribution Canada Post 3.6 I get the following error below... Any help would be very much appreciated... Thank you in advance... :rolleyes: 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 = '595' and p.products_id = pd.products_id and pd.language_id = '1' Quote Link to comment Share on other sites More sharing options...
bowvalleysports Posted February 9, 2004 Share Posted February 9, 2004 There is a file named cpMS2.sql. You must import this into your database to add the appropriate column headings to your database. Quote Link to comment Share on other sites More sharing options...
rocky Posted February 11, 2004 Author Share Posted February 11, 2004 Subject: Re: Problems??? When I go to my admin catalog site and try to access the catalog part of it I receive the following error: Parse error: parse error in /home/www/username/catalog/admin/categories.php on line 669 I have redone all the configurations outlined in the instructions provided with the install and have looked at line 669 and everything according to the installation is done correctly ??? Also when I go to my site and try to purchase an item I receive the following error: 1054 - Unknown column 'p.products_dim_type' in 'field list' select p.products_id, pd.products_name, 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_tax_class_id from products p, products_description pd where p.products_id = '595' and pd.products_id = p.products_id and pd.language_id = '1' [TEP STOP] What can I do now??? Please help??? Quote Link to comment Share on other sites More sharing options...
Pipey Posted June 3, 2004 Share Posted June 3, 2004 (edited) There is a file named cpMS2.sql.You must import this into your database to add the appropriate column headings to your database. Hi, With no prior PHP knowledge and lucky that the cart has worked so far, how do you import this file in the database? I have no admin access to the database unless it can be done through this cart? Thanks in advance Andy Edited June 3, 2004 by Pipey Quote Link to comment Share on other sites More sharing options...
jeffmars_1 Posted October 4, 2005 Share Posted October 4, 2005 When I add the Canada Post module found on osCommerce dated Jan 2005 I get: Warning: shipping(includes/languages/english/modules/shipping/canadapost.php): failed to open stream: No such file or directory in /hsphere/local/home/myname/websitename.com/catalog/includes/classes/shipping.php on line 36 Warning: shipping(includes/languages/english/modules/shipping/canadapost.php): failed to open stream: No such file or directory in /hsphere/local/home/myname/websitename.com/catalog/includes/classes/shipping.php on line 36 Warning: shipping(): Failed opening 'includes/languages/english/modules/shipping/canadapost.php' for inclusion (include_path='.:/usr/local/lib/php') in /hsphere/local/home/myname/websitename.com/catalog/includes/classes/shipping.php on line 36 How can I fix this problem? Thanks! Jeff Quote Link to comment Share on other sites More sharing options...
204HOE Posted January 15, 2006 Share Posted January 15, 2006 i have the same problem too.. if anyone know how to do it pls speak up. Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.