Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by roback

  1. Probably not a surprising error to anyone, but while trying to use the shipping module in the admin, I am getting the following errors: Step 2. Error: Failed check in /home/suchgirl/public_html/shop/admin/includes/languages/english/ship_canadapost.php at line 9. This most likely means that Canada Post has changed their user interface. You need to update your Canada Post Automatic Shipping Labels module. Now after reviewing the previous threads, I noticed the cURL and Port issues so I check with my host (Hostgator) and this was their reply: Regarding cURL: Regarding Port 30000: Now the one thing I noted from the posts was: Could this be what is causing the problems? Any help would be appreciated. Thanks
  2. Hey I tried reverting shopping_cart.php back to the original file and it again displays the correct price. Now I also proceeded through the checkout and it appeared to work just the same with the default shopping_cart.php. Now a WinDiff on the two version shows the only significant difference is that p.products_weight, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship[\code] are added to two of the queries (approx lines 259 and 319) and [code] 'length' => $products['products_length'], 'width' => $products['products_width'], 'height' => $products['products_height'], 'ready_to_ship' => $products['products_ready_to_ship'], [\code] added to the product array (approx line 336). I am not great at picking apart the code to determine where things go and how they function so can you explain the need for these in the shopping_cart.php thanks appreciated.
  3. No other mod that effects that page. Any idea on what line approximately the total is figured out in shopping_cart.php ??
  4. The fine tooth comb of agony has revealed this: There is no length, width, height or ready to ship column in the DB Products Table.... .... .... Okay so I went back and did the sql command again... ta-da! Okay so that seemed to fix the errors in all 3 places... BUT now in the front end, My subtotal does not tally up on the first shopping_cart.php page (Or Cart Contents from top right nav). Very odd. No displayed errors. And when you walk through the rest of the checkout process to the checkout_confirmation.php page, it correctly displays the subtotal and other totals. Any ideas?
  5. Okay, installing this contrib on a OSC that already has products in it. followed the instructions and double checked (good instructions I might add) but I am getting some errors. Firstly let me point out that I have not configured the CP account details yet, but I don't think that is causing the problem. I have also installed the Ultra Pics contrib and I believe that is where the problems are coming from. So now lets look at the errors: 1) Front End - > shopping_cart.php (Immediately after clicking add to cart). Under the product list box I get the following error: Sub-Total: 1054 - Unknown column 'p.products_length' in 'field list' select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, 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 = '110' and pd.products_id = p.products_id and pd.language_id = '0' [TEP STOP] 2)Back End -> Adding Product > Preview Product > Insert. (All part of the admin/categories.php page) When inserting a new product the additional fields appear in the for the CP tariffs, length, weight. But after previewing it and pressing Insert it produces this error: 1054 - Unknown column 'products_length' in 'field list' insert into products (products_quantity, products_description_short, products_tariff, products_model, products_price, products_date_available, products_weight, products_length, products_height, products_width, products_ready_to_ship, products_status, products_tax_class_id, manufacturers_id, products_image, products_image_med, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_date_added) values ('100', 'CanPost MOD', 'NONE', '', '3', null, '2.5', '6', '1', '5', '1', '1', '1', '0', '120_bv_M.jpg', '120_bv_M.jpg', '121_bv_M.jpg', '121_bv_M.jpg', '121_fv_M.jpg', '121_fv_M.jpg', now()) [TEP STOP] 3)Back End - > Editing a product (Again admin/categories.php). You receive this error: 1054 - Unknown column 'p.products_length' in 'field list' select pd.products_name, pd.products_description, p.products_description_short, p.products_tariff , pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, p.products_price, p.products_weight, 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 = '154' and p.products_id = pd.products_id and pd.language_id = '1' [TEP STOP] Now I have two guesses at what the problem could be. All of these segments of code, which were amended from the UltraPic contrib already, are not as they should be. What I did is I compared the code from the instructions with the modified code of UltraPic From what I gathered is that UltraPic interjected a bunch of things between p.products_image and p.products_price. So I interject the weight, length, width, height and ready to ship between the p.products_price and p.products_date_added - effectively keeping things the same (or so I assumed). the other guess is that the p.products_length was not set up in the database correctly. Though I have very limited experience with this, so I am not even sure how to check/debug this. I hope that provides sufficient info for someone to help me out. thanks Rob
  6. I figured it out... the file it was looking for was includes/languages/YOURLANG/mainpage.php, but the file in the package is define_mainpage.php and in the original Define Mainpage you update the catalog/includes/filenames.php to look for define_mainpage.php. So you have to correct it so that everything is looking for the same file and that that file is named correctly. Who would I notify to have this updated on the contrib page?