Results 1 to 5 of 5

Hybrid View

  1. #1
    Join Date
    Jun 2007
    Posts
    68
    Plugin Contributions
    0

    red flag Insert product error

    After uploading picture and filling out necessary boxes for my product im getting this error when i got too insert the product. ive noticed that i have a product upc box and a product isbn box in admin/catalog/catagories and products/new product. now i get this message when i try to insert into site:


    1054 Unknown column 'products_weight_type' in 'field list'
    in:
    [insert into products (products_quantity, products_type, products_model, products_upc, products_isbn, products_price, products_date_available, products_weight, products_weight_type, products_dim_type, products_length, products_width, products_height, products_ready_to_ship, 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', '32294', '', '', '14.95', null, '0', 'SYSTEM_WEIGHT_UNITS', 'SYSTEM_DIMENSION_UNITS', '0', '0', '0', '0', '1', '0', '1', '0', '1', '1', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '0', '31509.jpg', now(), '72')]
    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.

  2. #2
    Join Date
    Jun 2007
    Posts
    68
    Plugin Contributions
    0

    Default Re: Insert product error

    Sorry is there a way too turn off upc and isbn boxes so it will except my insert in to site?

  3. #3
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: Insert product error

    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  4. #4
    Join Date
    Jun 2007
    Posts
    68
    Plugin Contributions
    0

    Default Re: Insert product error

    Thanks dr.byte that will help.
    maybe you can help me with this problem. i posted it a couple of days ago but no reply:

    I was just wondering if some one has a answer for the first question:
    If you go to this link
    http://urconnection.net/index.php?ma...=index&cPath=2
    You can see the picture I have put there and I like it and it works. The issue I am having is it has the category name above it in text format. If I get rid of that in my catalog section of my admin it makes the catagories headline disappear.
    Is there a way to remove the text header at the center of page above the picture without removing it from my Catagories side box?

  5. #5
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: Insert product error

    Quote Originally Posted by slik666 View Post
    maybe you can help me with this problem. i posted it a couple of days ago but no reply:
    1. There are many reasons for "no reply" to any given forum post, including but not limited to:
    a. not enough info, or maybe the problem needs to be described in another way, or looked at from a completely different angle.
    b. not an easy or fast answer, thus requiring extensive research by an unpaid volunteer
    c. aggressive tone or unfriendly wording in a post
    d. site has numerous customizations and thus too complicated to narrow down cause of problem easily
    e. cannot answer without having access to live site in order to diagnose properly
    f. sometimes things are very involved and would be better suited as a Commercial Help Wanted post instead, where you hire someone to do the research and the fix
    g. the volunteer with the right insight to spot the solution maybe hasn't seen the post yet
    h. multiple posts all over the forum on the same topic tend to be irritating to those responding, and thus often get ignored. Making repeat posts on the same topic is akin to spam, and gives you a rather unpleasant reputation.
    i. etc

    2. You just asked for help with something else you already posted. Instead of reposting the question, why not post the link to the original post, so that the answers and all known details can be kept in one place, rather than scattered about, and having to be asked the same questions over again, etc.
    ie: Here's the link to your other post: http://www.zen-cart.com/forum/showthread.php?t=70756
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. v154 Manufacturers Insert Error
    By adb34 in forum General Questions
    Replies: 4
    Last Post: 7 Jun 2015, 08:17 PM
  2. v136 SQL syntax error INSERT INTO user_adverts_map
    By mainzone in forum General Questions
    Replies: 1
    Last Post: 13 Sep 2013, 10:58 AM
  3. Code corrupted. Insert fresh copy. error !
    By ff7799 in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 12 Jul 2006, 05:17 AM

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