Results 1 to 10 of 2252

Threaded View

  1. #11
    Join Date
    Nov 2006
    Location
    Dartmouth, NS Canada
    Posts
    2,378
    Plugin Contributions
    0

    Default Re: ozpost shipping module

    Hi Rod,

    An odd one for you. I created a new site for our favourite horsey shop, for some new products. It was a clean install of 1.3.9h, without any of the old data for products or customers. In other words, a fresh start. Nevertheless, the product input fields contain the "products_height, products_length, products_width" fields, which I think come only from OzPost. The OzPost files were uploaded as usual (v2.0.5) because I thought J wanted it, but when its Install button was clicked I got a warning about cURL not working. I left it at that as the site was in limbo at the time. Now J is entering, or trying to enter, new products and is getting the following warning...

    1054 Unknown column 'products_height' in 'field list'
    in:
    [insert into products (products_quantity, products_type, products_model,
    products_price, products_date_available, products_weight, products_height,
    products_length, products_width, products_status, products_virtual,
    products_tax_class_id, manufacturers_id, products_quantity_order_min,
    products_quantity_order_units, products_priced_by_attribute,
    product_is_free, product_is_call, products_quantity_mixed,
    product_is_always_free_shipping, products_qty_box_status,
    products_quantity_order_max, products_sort_order, products_discount_type,
    products_discount_type_from, products_price_sorter, products_image,
    products_date_added, master_categories_id) values ('10', '1', '125685',
    '80', null, '0', '0', '0', '0', '1', '0', '0', '0', '1', '1', '0', '0', '0',
    '1', '0', '1', '0', '0', '0', '0', '0', '', now(), '4')]
    If you were entering information, press the BACK button in your browser and
    re-check the information you had entered to be sure you left no blank
    fields.
    I tried carefully removing all the files, either completely or in some cases replacing them with the stock ZC files, to no avail.

    I'm guessing the DB was modified during the incomplete OzPost install. But I can't hit the Remove button because it's not fully installed. J has decided not to use OzPost this time, preferring free shipping. So how do I get rid of the three dimension fields and the incorrect SQL command during creation of new products?

    Rob
    Last edited by rstevenson; 31 Dec 2012 at 02:07 PM.

 

 

Similar Threads

  1. v151 Product dimensions revert to 0 - using ozpost module
    By mpforum in forum General Questions
    Replies: 8
    Last Post: 18 Apr 2014, 09:49 AM
  2. Ozpost and module help
    By janelle in forum Addon Shipping Modules
    Replies: 2
    Last Post: 15 Jun 2012, 09:19 AM
  3. Ozpost Combine shipping !! Possible ?
    By toytemple in forum Addon Shipping Modules
    Replies: 7
    Last Post: 21 Jan 2010, 02:22 PM
  4. ozpost module problems
    By hspark in forum Addon Shipping Modules
    Replies: 19
    Last Post: 7 Dec 2009, 12:44 PM
  5. store pick-ip in ozpost shipping module
    By lazerweb in forum Addon Shipping Modules
    Replies: 2
    Last Post: 29 Jul 2008, 05:04 AM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR