Results 1 to 9 of 9
  1. #1
    Join Date
    Aug 2008
    Location
    Sydney Australia
    Posts
    495
    Plugin Contributions
    0

    Default Copy Categories / Products

    Hi All,

    I am getting this message when I am trying to copy a product in categories.

    WARNING: An Error occurred, please let us know! If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data.

    1. I click copy on the product that I wish to copy
    2. I then select Create a Duplicate product into the category selected above
    3. Then in Copy linked categories to duplicate (it does not matter what I select I get the same error)
    4. I then press copy and the error comes up

    Any help to get this corrected would be great because it is one thing that I need to do to add new products to the site and I am unable to make it live till it works.

  2. #2
    Join Date
    Oct 2008
    Location
    Croatia
    Posts
    1,542
    Plugin Contributions
    19

    Default Re: Copy Categories / Products

    Please remember that ANY TIME you get such an error message, there will always be an error log associated with the error in your logs folder. If there are many and you can't find the latest one, delete them all and re-do whatever you need to get the error again, then check logs again and you'll find it.
    Then paste the contents of the log file here and help us help you. Without the logs, we can just rub the magic ball and start answering your questions.

    Did I emphasize "any time" enough?

  3. #3
    Join Date
    Aug 2008
    Location
    Sydney Australia
    Posts
    495
    Plugin Contributions
    0

    Default Re: Copy Categories / Products

    Hi Balihr,

    This is what is one on the log files:
    [05-Dec-2023 10:04:38 UTC] Request URI: /koala/index.php?cmd=category_product_listing&action=copy_product_confirm&cPath=416&pag e=1, IP address: 45.125.247.117, Language id 1
    #0 [internal function]: zen_debug_error_handler()
    #1 /home/xxxx/public_html/includes/classes/db/mysql/query_factory.php(667): trigger_error()
    #2 /home/xxxx/public_html/includes/classes/db/mysql/query_factory.php(634): queryFactory->show_error()
    #3 /home/xxxx/public_html/includes/classes/db/mysql/query_factory.php(275): queryFactory->set_error()
    #4 /home/xxxx/public_html/includes/functions/database.php(130): queryFactory->Execute()
    #5 /home/xxxx/public_html/xxxx/includes/modules/copy_product_confirm.php(109): zen_db_perform()
    #6 /home/xxxx/public_html/xxxx/category_product_listing.php(253): require('/home/a1ntacdk3...')
    #7 /home/xxxx/public_html/xxxx/index.php(11): require('/home/a1ntacdk3...')
    --> PHP Fatal error: 1054:Unknown column 'products_description2' in 'field list' :: INSERT INTO products (products_type, products_quantity, products_model, products_sku, products_image, products_price, products_price_w, products_price_carrot, products_virtual, products_weight, products_length, products_height, products_width, dangerous_goods, products_carrot, threshold_set, products_tax_class_id, manufacturers_id, products_ordered, 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, master_categories_id, products_mixed_discount_quantity, metatags_title_status, metatags_products_name_status, metatags_model_status, metatags_price_status, metatags_title_tagline_status, products_condition, products_EHF, additional_skus, additional_skus_only, discontinue, products_pdf_attachment, products_vendor_code, products_vendor_price, availability_id, pro_src, p_name, products_price_carrot_gross, extra_field, demo_url, products_stock_location, product_warranty, suppliers, products_description2, care_instructions, products_status, products_date_added, products_date_available) VALUES ('1', '0', 'DEU1550', '1550', 'Product images directory/deutscher_logo.jpg', '10.4545', '0', '0.0000', '0', '0.01', '0.00', '0.00', '0.00', '0', '0', '0', '1', '50', '0', '1', '1', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '10.4545', '416', '1', '0', '0', '0', '0', '0', 'NEW', 'none', 'G30, 1550', '', '0', '', '1550', '6.3600', '8', '37248 Deutsher Genuine Spindle Lock Nut G30 1550 DEU1550 1550 1550 G30 1550 <p>&nbsp;< p>\\r\\n\\r\\n<table border=\\\"1\\\" cellpadding=\\\"1\\\" cellspacing=\\\"1\\\" style=\\\"width: 100%;\\\">\\r\\n <tbody>\\r\\n <tr>\\r\\n <td style=\\\"text-align: center; background-color: rgb(51 51 51);\\\"><span style=\\\"color:#fff0f5;\\\"><strong>OEM Number< strong>< span>< td>\\r\\n <td style=\\\"text-align: center; background-color: rgb(51 51 51);\\\"><span style=\\\"color:#fff0f5;\\\"><strong>Description< strong>< span>< td>\\r\\n <td style=\\\"text-align: center; background-color: rgb(51 51 51);\\\"><span style=\\\"color:#fff0f5;\\\"><strong>Fits Models< strong>< span>< td>\\r\\n < tr>\\r\\n <tr>\\r\\n <td style=\\\"text-align: center; background-color: rgb(204 204 204);\\\">G30 1550< td>\\r\\n <td style=\\\"text-align: center; background-color: rgb(204 204 204);\\\">Genuine Deutsher Lock Nut< td>\\r\\n <td style=\\\"text-align: center; background-color: rgb(204 204 204);\\\">N A< td>\\r\\n < tr>\\r\\n < tbody>\\r\\n< table>\\r\\n\\r\\n<p>&nbsp;< p>\\r\\n\\r\\n<p>&nbsp;< p>', '', '0.0000', '', '', '', '3 Months Warranty', 'Deutscher', '', '', '0', now(), null) ==> (as called by) /home/xxxx/public_html/includes/functions/database.php on line 130 <== in /home/xxxx/public_html/includes/classes/db/mysql/query_factory.php on line 667.

  4. #4
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,696
    Plugin Contributions
    123

    Default Re: Copy Categories / Products

    You have modified your files to set a field called products_description2 which doesn't exist in your database.

    Either remove the field products_description2 from the INSERT statement above, or create a field called products_description2 in your products table.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  5. #5
    Join Date
    Aug 2008
    Location
    Sydney Australia
    Posts
    495
    Plugin Contributions
    0

    Default Re: Copy Categories / Products

    Which file would that be located in to adjust.

  6. #6
    Join Date
    Oct 2008
    Location
    Croatia
    Posts
    1,542
    Plugin Contributions
    19

    Default Re: Copy Categories / Products

    Yup, exactly as swguy said. You seem to have quite a few extra fields in your query so it's obviously been heavily modified. The simplest solution is to add products_description2 to your products table (although it should actually go to products_description to allow it to be multilingual, but probably irrelevant and would cause new problems for you).
    You can also edit your ADMIN/includes/modules/copy_product_confirm.php and remove the products_description2 from that query. Don't forget to remove the comma as well.

  7. #7
    Join Date
    Aug 2008
    Location
    Sydney Australia
    Posts
    495
    Plugin Contributions
    0

    Default Re: Copy Categories / Products

    These are the only reference that I could find to products_description2. The file you mentioned did not have the reference quoted in it.

    /home/xxxx/public_html/xxxx/includes/npf_includes/prebuilt_fields/products_description2/YOUR_ADMIN/includes/npf_includes/npf_templates/products_description2.php
    /home/xxxx/public_html/xxxx/includes/npf_includes/prebuilt_fields/products_description2/YOUR_ADMIN/includes/npf_includes/npf_sql/products_description2.php
    /home/xxxx/public_html/xxxx/includes/npf_includes/prebuilt_fields/products_description2/YOUR_ADMIN/includes/npf_includes/npf_description_sql_array/products_description2.php
    /home/xxxx/public_html/xxxx/includes/npf_includes/prebuilt_fields/products_description2/YOUR_ADMIN/includes/languages/english/npf_definitions/lang.products_description2.php
    /home/xxxx/public_html/xxxx/includes/modules/product/preview_info.php
    /home/xxxx/public_html/xxxx/includes/modules/product/collect_info.php
    /home/xxxx/public_html/xxxx/includes/modules/document_product/preview_info.php
    /home/xxxx/public_html/xxxx/includes/modules/document_product/collect_info.php
    /home/xxxx/public_html/xxxx/includes/modules/document_general/preview_info.php
    /home/xxxx/public_html/xxxx/includes/modules/document_general/collect_info.php
    /home/xxxx/public_html/xxxx/includes/init_includes/extra_sanitation_rules/numinix_product_fields.php
    /home/xxxx/public_html/xxxx/includes/functions/extra_functions/npf_functions.php
    /home/xxxx/public_html/xxxx/includes/extra_datafiles/sanitize_numinix_product_fields.php
    /home/xxxx/public_html/includes/templates/bootstrap/templates/tpl_product_info_display.php
    /home/xxxx/public_html/includes/templates/bootstrap/product_info/extra_main_template_vars/numinix_product_fields.php

  8. #8
    Join Date
    Aug 2008
    Location
    Sydney Australia
    Posts
    495
    Plugin Contributions
    0

    Default Re: Copy Categories / Products

    I forgot to mention that the database does have products_description2 in it but in the field it has NULL in it so I am at a loss as to what I need to do.

  9. #9
    Join Date
    Oct 2008
    Location
    Croatia
    Posts
    1,542
    Plugin Contributions
    19

    Default Re: Copy Categories / Products

    I can't say for sure because I don't use the plugin you're using (Numinix Product Fields), but this doesn't look right:
    Code:
    /home/xxxx/public_html/xxxx/includes/npf_includes/prebuilt_fields/products_description2/YOUR_ADMIN/includes/npf_includes/npf_templates/products_description2.php
    /home/xxxx/public_html/xxxx/includes/npf_includes/prebuilt_fields/products_description2/YOUR_ADMIN/includes/npf_includes/npf_sql/products_description2.php
    /home/xxxx/public_html/xxxx/includes/npf_includes/prebuilt_fields/products_description2/YOUR_ADMIN/includes/npf_includes/npf_description_sql_array/products_description2.php
    /home/xxxx/public_html/xxxx/includes/npf_includes/prebuilt_fields/products_description2/YOUR_ADMIN/includes/languages/english/npf_definitions/lang.products_description2.php
    I'd say this is supposed to be in
    Code:
    /home/xxxx/public_html/xxxx/includes/npf_includes/npf_templates/products_description2.php
    Again, I don't use that plugin (I really don't like it) and I don't know how it works, but the above looks wrong. You might get more help in the correct thread if it exists, or maybe try updating that plugin to the latest version.

 

 

Similar Threads

  1. How can I copy attributes AND their prices to multiple products / categories?
    By bendlikewillow in forum Setting Up Categories, Products, Attributes
    Replies: 17
    Last Post: 4 Feb 2014, 02:17 AM
  2. Copy categories / products to new zencart website
    By level5 in forum Setting Up Categories, Products, Attributes
    Replies: 9
    Last Post: 29 Nov 2009, 02:05 PM
  3. v1.37: Unable to copy categories, only products
    By bettysue in forum Setting Up Categories, Products, Attributes
    Replies: 6
    Last Post: 26 Dec 2008, 06:18 PM
  4. Replies: 2
    Last Post: 19 Nov 2008, 10:37 PM

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