Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009
    Location
    Czech republic
    Posts
    10
    Plugin Contributions
    0

    application error cannot copy product after installing Short Description mod

    Hello Guys!
    After installing Short Decription mod I'm having problem with copy and create new product from my admin.
    The error I'm getting is as following:

    136 Column count doesn't match value count at row 1
    in:
    [insert into products_description (products_id, language_id, products_name, products_description, products_url, products_viewed) values ('57', '2'.....
    =================================

    I think the problem is in copy_to_confirm.php file but not so good in programming to identify where the problem it is.

    Could please someone have a look at the code and help me identify what is error in code?


    copy_to_confirm.zip
    Thank you in advance!

  2. #2
    Join Date
    Mar 2009
    Location
    Czech republic
    Posts
    10
    Plugin Contributions
    0

    Default Re: cannot copy product after installing Short Description mod

    any idea? thanks.

  3. #3
    Join Date
    Mar 2009
    Location
    Czech republic
    Posts
    10
    Plugin Contributions
    0

    Default Re: cannot copy product after installing Short Description mod

    find out the solution..

    in the first end eights lines of the code missed "products_short_desc" entity. So the correct code is below.

    PHP Code:
                $description $db->Execute("select language_id, products_name, products_short_desc, products_description, 
                                                                 products_url
                                             from " 
    TABLE_PRODUCTS_DESCRIPTION "
                                             where products_id = '" 
    . (int)$products_id "'");
                while (!
    $description->EOF) {
                  
    $db->Execute("insert into " TABLE_PRODUCTS_DESCRIPTION "
                                            (products_id, language_id, products_name, products_short_desc, products_description,
                                             products_url, products_viewed)
                                values ('" 
    . (int)$dup_products_id "',
                                        '" 
    . (int)$description->fields['language_id'] . "',
                                        '" 
    zen_db_input($description->fields['products_name']) . "',
                        '" 
    zen_db_input($description->fields['products_short_desc']) . "',
                                        '" 
    zen_db_input($description->fields['products_description']) . "',
                                        '" 
    zen_db_input($description->fields['products_url']) . "', '0')");
                  
    $description->MoveNext();
                } 

  4. #4
    Join Date
    Apr 2006
    Location
    Ohio
    Posts
    6,162
    Plugin Contributions
    0

    Default Re: cannot copy product after installing Short Description mod

    Ty for posting the correct fix ..
    Mark
    Hare Do

  5. #5
    Join Date
    Mar 2009
    Location
    Czech republic
    Posts
    10
    Plugin Contributions
    0

    Default Re: cannot copy product after installing Short Description mod

    to haredo
    what did you mean? it is correct fix. it's working for me.

 

 

Similar Threads

  1. v150 Short Description Mod - PHP errors
    By CharBee in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 9 Jul 2012, 11:44 PM
  2. Short Description mod - bigger textbox for Product Add page?
    By christopherw in forum Addon Templates
    Replies: 9
    Last Post: 1 Nov 2010, 12:07 AM
  3. Short Description for Cat. Mod: SQL error
    By RobertG in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 15 Feb 2010, 08:50 PM
  4. Short Description mod - left aligning the text?
    By sarad in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 15 Jan 2009, 08:20 AM
  5. Short Description Mod help
    By bswinnerton in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 27 Jul 2008, 02:34 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