SitePoint Sponsor

User Tag List

Results 1 to 9 of 9
  1. #1
    SitePoint Evangelist mafunk's Avatar
    Join Date
    Apr 2003
    Location
    portland
    Posts
    441
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Which OSC Guru Can Solve This?

    Hi,

    I hired a coder to build this site http://www.colishcreations.com and it's having some problems - I'm hoping that one of you osc gurus can help me with this. Since then I've started building the osc sites on my own, but for now I still have this little problem site to fix and can't seem to figure the error out. I know the answer is probably staring me in the face, but I can't find it.

    When my client tries to add attributes she gets this error:
    1136 - Column count doesn't match value count at row 1
    insert into products_attributes values ('', '43', '2', '3', '0', '+')
    [TEP STOP]

    Any ideas on how to fix?
    This is how I read the attribute values
    ' ' - not sure what this refers to - it seems that this referes to a blank space in one of the value fields, but I can't figure out why. I think that the product ID should be coming up there

    43 - Product Name

    2 - Option Name

    3 - Option Value

    0 - Value Price

    + - Prefix


    So do you have any ideas on how to fix this?


    Thanks
    MaFunk
    MaFunk

  2. #2
    SitePoint Evangelist mafunk's Avatar
    Join Date
    Apr 2003
    Location
    portland
    Posts
    441
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    oh - one other thing. The attributes to the products that were originally added to the store can be modified just fine. However when my client tries to add attributes to the newly added products she gets the error message. She did a fine job adding the products so its not a problem there.
    MaFunk

  3. #3
    Shiny Content! Pandrogas's Avatar
    Join Date
    Feb 2002
    Location
    Bozeman, MT
    Posts
    151
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Cool Hmm... Now where was that manual...

    MaFunk,

    Are you using an attribute manager?
    You could always install one to see if that
    will help, though I've never seen this error.

    Another thing you might try is to post this
    over at OSC's forums (I know, they are
    ungodly slow and screw up on occasion),
    but you never know.

    I'm also going to assume that rebuilding the
    store is not an option.

    I don't know, I'll have to look into this.

    Thanks and best of luck,
    Matthew Gowdy
    Seer Interactive
    Matthew Gowdy---AKA---Pandrogas
    SeerNET: Various Geekery All Around

    Contact Information: E-Mail - AIM: Pandrogas

  4. #4
    SitePoint Evangelist mafunk's Avatar
    Join Date
    Apr 2003
    Location
    portland
    Posts
    441
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi Mathew,

    Thanks for the reply.
    I've already posted at osc forums and several others. It seems that this is a very tricky problem!! No - can't rebuild the store. Many people seem to think that there is an extra column or something. I emailed the coders a couple of days ago, but they still haven't fixed it. . .

    On another note. I've got my settings so that I'm supposed to be notified when people reply to my posts, but it's suddenly not working. Has that ever happened to you?
    MaFunk

  5. #5
    Shiny Content! Pandrogas's Avatar
    Join Date
    Feb 2002
    Location
    Bozeman, MT
    Posts
    151
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    More OSC Stuff...

    MaFunk,

    Hmm... Well, the forums are definetly slow anyways,

    so maybe six months down the road, someone will have
    finally found a fix. Lol. In any case, I'm still not sure how
    to fix it, maybe if I come across it in the future.

    Can't say that I've ever had that thread e-mail function on
    to tell you the truth. Though I can imagine it might have glitched
    because they just made a major upgrade on the boards. Perhaps
    it will work now, if not they have a thread for bugs and problems here:
    http://www.sitepointforums.com/showt...604#post992604
    Just make a post there and I'm sure the Sitepoint team will look into it.

    Thanks,
    Matthew Gowdy
    Seer Interactive
    Matthew Gowdy---AKA---Pandrogas
    SeerNET: Various Geekery All Around

    Contact Information: E-Mail - AIM: Pandrogas

  6. #6
    SitePoint Evangelist mafunk's Avatar
    Join Date
    Apr 2003
    Location
    portland
    Posts
    441
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    $25 to first person that can fix this

    Ok - It's been almost a week and the best that I get from the coders of this site are "It's not from an error that we made, but an osc problem/erro". Which is bull-sh*t since I don't have this problem with any other osc sites that I built on my own!!!! I'm just so peaved off at these people. Working with them was a nightmare and I had to fix a couple of obvious things that they screwed up!!! - like they didn't put permissions on the folder so that my client could make changes!!!

    OK, enough ranting and raving. I need help. If you are a true guru, and think that can fix this, I'll pay $25 (via paypal) for the person that can make it happen. Just tell me which files you need to see. I'll send you the code. Then I'll make the updates myself.

    please email me off-line in regard to this monique.danielle@verizon.net

    Cheers,
    MaFunk
    MaFunk

  7. #7
    SitePoint Member Barb's Avatar
    Join Date
    Nov 2003
    Location
    NC
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Lightbulb No Guru here, lol, but...........

    Hi,
    First of all I would NEVER even try to claim to be a guru at this stuff. I am a newbie for sure. But sometimes a newbie might be able to see something that a guru just hasn't thought of? I don't know, but I will give it a shot, lol.

    Your post said this:
    When my client tries to add attributes she gets this error:

    1136 - Column count doesn't match value count at row 1
    insert into products_attributes values ('', '43', '2', '3', '0', '+')
    [TEP STOP]

    Any ideas on how to fix?
    This is how I read the attribute values
    ' ' - not sure what this refers to - it seems that this referes to a blank space in one of the value fields, but I can't figure out why. I think that the product ID should be coming up there


    I am new at MySQL, but have had some experience with MS Access. Have you gone in, using phpmyadmin or whatever and actually looked at the setups for those fields? Logically, it "looks like" you have a "mismatch" in formatting and once that is corrected, it should work fine. I think the code is right, but the setup FOR the field in the database needs looking at?

    Please don't laugh if I'm way off base here, lol. I'm the only one that can do that, lmbo.

    Hope that helps.........
    Barb
    You can't expect to get NEW results if you are still doing things the same old way.

  8. #8
    SitePoint Evangelist mafunk's Avatar
    Join Date
    Apr 2003
    Location
    portland
    Posts
    441
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I would hardly laugh - you're better off than I am. I can work with the osc and php, but I don't have any knowledge of databases. As a matter of fact I'm so lame that I don't even know where/how to look for this, even though I think that you are right and that this is what I need to fix.

    So where/how do I find the database? And where/how do I open it?

    I have built a few osc sites, but they were automatically installed, and all I had to do was work with the php and the html. In terms of this problem site I"m at a loss because I"m coming in late in the game and don't know what they did to all the files. . .
    MaFunk

  9. #9
    SitePoint Evangelist mafunk's Avatar
    Join Date
    Apr 2003
    Location
    portland
    Posts
    441
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The problem was fixed by Matt Fletcher from Sitepoint forums. Thank you all.
    MaFunk


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
  •