Results 1 to 8 of 8
  1. #1

    Default attributes not working

    Hello there.

    I have some attributes setup on my proudcts.

    I loaded the newest version of zc along with some of the working contribs.

    for some reason i can no longer add attributes to my proudcts. I get this error

    1136 Column count doesn't match value count at row 1
    in:
    [insert into products_attributes values (0, '164', '6', '29', '0.0000', '+', '0', '0', '0', '+', '0', '1', '1', '', '1', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '', '', '0.0000', '0', '0.0000', '0', '0')]
    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.

    anyone know how to fix this problem?

  2. #2

    Default Re: attributes not working

    i just tried to install Improved attributes controlled modual. it makes things easyer, however it still dont work, i get the same error.

    i also tried to reset the attributes sort order in TOOLS>Store Manager, but that didnt help any eather...

    any advice on this problem would be very helpfull, as i have no idea how to fix it.

  3. #3

    Default Re: attributes not working

    sorry for all the posts, but iv been looking for a fix for this..

    i read all the posts i could find on "1136 Column" per instructions i found on another topic re. the same issue.

    however i didnt find any fix for the problem, other than finding what moduals where installed.

    Currently i have the fallowing.

    Super Orders2
    Info at a glance
    export email address
    encrypted master pass
    quick updates
    recover carts
    order questions
    Tabbed products lite - admin edition
    zen lightbox

    all these where installed when i noticed the problem.
    i just installed Improved Atributes controller, hoping it would fix the issue. however it didnt seem to help at all...

  4. #4

    Default Re: attributes not working

    issue fixed.

    Seems i had a field inside the Products_attributes table that was for an old modual that i installed...

    Must have been carried over to the new install when i upgraded, however its odd that it just broke now. was working fine for the last 3 weeks since i did the upgrade to the new version...

    wonder what happend.....

    anyways, its fixed, you can remove the topic if you would like..
    Super Orders2
    Info at a glance
    export email address
    encrypted master pass
    quick updates
    recover carts
    order Tracking
    Tabbed products lite - admin edition
    Hosted with sashbox.net <- best host around...

  5. #5
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: attributes not working

    Thanks for the update that what was causing the problems was an old add-on ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  6. #6
    Join Date
    Jun 2006
    Location
    Midlothian, Virginia, United States
    Posts
    111
    Plugin Contributions
    0

    Default Re: attributes not working

    what exactly did you do to fix this? i have the same issue

  7. #7

    Default Re: attributes not working

    Quote Originally Posted by anjordan77
    what exactly did you do to fix this? i have the same issue
    there was a field inside the database under product_attributes. it was somthing the ended in _w.

    In products_attributes table:
    options_values_price_w

    and you may also need to remove

    In products table:
    products_price_w


    this is a risky fix, so make sure that you backup before you attempt it. it seemed to solve my problems right away, so we will see if its the same for you.
    good luck!
    Super Orders2
    Info at a glance
    export email address
    encrypted master pass
    quick updates
    recover carts
    order Tracking
    Tabbed products lite - admin edition
    Hosted with sashbox.net <- best host around...

  8. #8
    Join Date
    Aug 2005
    Posts
    34
    Plugin Contributions
    0

    Default Re: attributes not working

    Thank you so much for posting this, this was exactly the same problem I was experiencing.

 

 

Similar Threads

  1. attributes not working
    By amebb in forum General Questions
    Replies: 6
    Last Post: 10 Jun 2011, 05:17 PM
  2. Attributes Not working
    By green couch designs in forum General Questions
    Replies: 0
    Last Post: 19 Jan 2011, 08:07 PM
  3. attributes not working
    By homebrewkits in forum General Questions
    Replies: 7
    Last Post: 19 Nov 2010, 06:36 PM
  4. Attributes not working
    By maxilious in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 26 Apr 2008, 08:12 AM
  5. attributes not working
    By stumped in forum Setting Up Categories, Products, Attributes
    Replies: 7
    Last Post: 9 Jan 2007, 04:43 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