tektek Posted November 17, 2004 Posted November 17, 2004 Ok, I had a problem with an attribute showing up on products that I hadn't added it to. When I went to delete it, it said I couldn't because it was part of the attributes for those products, when it wasn't because it wasn't selected! So I went to the database, and manually removed the attribute from products_attributes column. So the attribute went away, but now I get this error when I try to add any attributes to the products. 1136 - Column count doesn't match value count at row 1 insert into products_attributes values ('', '39', '1', '1', '', '', '') [TEP STOP] Does anyone know how to fix this? I need your help please!! Thanks.
Damon122 Posted November 19, 2004 Posted November 19, 2004 How many columns are in the products_attributes database table?.
tektek Posted November 19, 2004 Author Posted November 19, 2004 How many columns are in the products_attributes database table?. <{POST_SNAPBACK}> 121. I read that other post, everyone has the same issue but no fix is posted on there.
tektek Posted November 19, 2004 Author Posted November 19, 2004 GOD oscommerce is annoying me lol there's always one problem to fix, can never get it to run smooth :\. I'm going to keep trying to fix this, i know you can just remove all attributes and redo themand it will work fine, but i dont want to retype 121 attributes :\ so on to figuring out a method to make this work, if anyone has any fix please post it! thnx.
OceanRanch Posted November 19, 2004 Posted November 19, 2004 GOD oscommerce is annoying me lolthere's always one problem to fix, can never get it to run smooth :\. I'm going to keep trying to fix this, i know you can just remove all attributes and redo themand it will work fine, but i dont want to retype 121 attributes :\ so on to figuring out a method to make this work, if anyone has any fix please post it! thnx. <{POST_SNAPBACK}> No easy fix, just the school of hard knocks and lessons.... Well Joe, in your first post you stated you removed the "attribute" column in the database tablr product_attributes. That's the root cause of your problem. Also, you don't have 121 columns in the table as Ramon had ask, you have 121 rows in the product_attributes table. It looks like you'll need to do the following. 1. Restore your database back to the state it was before you started deleting columns in the database. Chances are you don't have a backup so now you'll need to do step 2. 2. Add the column that you deleted back into the table via phpmyadmin in the proper sequence and structure. You'll probably need to look at the oscommerce.sql file to see the exact specs. That will at least get you back up and running to be able to add attributes to your products. HTH Tom
tektek Posted November 20, 2004 Author Posted November 20, 2004 No easy fix, just the school of hard knocks and lessons.... Well Joe, in your first post you stated you removed the "attribute" column in the database tablr product_attributes. That's the root cause of your problem. Also, you don't have 121 columns in the table as Ramon had ask, you have 121 rows in the product_attributes table. It looks like you'll need to do the following. 1. Restore your database back to the state it was before you started deleting columns in the database. Chances are you don't have a backup so now you'll need to do step 2. 2. Add the column that you deleted back into the table via phpmyadmin in the proper sequence and structure. You'll probably need to look at the oscommerce.sql file to see the exact specs. That will at least get you back up and running to be able to add attributes to your products. HTH Tom <{POST_SNAPBACK}> Actually, i fixed the problem myself...anytime i post an issue here i fix it myself so i don't even know why i post, i guess this can help someone else with the problem and get it fixed. I fixed this issue by doing the most simple thing in the world, i just deleted product_attributes and readded it thru SQL. The attributes are NOT stored in product_attributes by the looks of it because i did not lose any of the attributes i had before. They are all there and working fine. Anyways I'll post another thread with the fix so everyone that has this problem can give it a shot! cheers!
OceanRanch Posted November 20, 2004 Posted November 20, 2004 Actually, i fixed the problem myself...anytime i post an issue here i fix it myself so i don't even know why i post, i guess this can help someone else with the problem and get it fixed. :-" Next time I guess I won't spend anytime helping/responding to any of your problems since "you don't even know why you post". Tom
Guest Posted November 20, 2004 Posted November 20, 2004 yes, it is attitudes like that what keeps me away from negative posters . . .
tektek Posted November 20, 2004 Author Posted November 20, 2004 yes, it is attitudes like that what keeps me away from negative posters . . . <{POST_SNAPBACK}> Meh, every time i've had an issue i'v fixed it myself. Nobody here knows anything other than what's stated on the help files of oscommerce. I post here only when i have to go to workand have no time to play with it hoping there's some replies so I can fix it when I get back. But everytime I get the same replies of "are you sure you didnt..." as if i dont know what i'm doing. Besides, you two did not help at all I do not know why you care so much lol. And don't reply to my posts if you don't like my attitude, i'm just being honest. Later kiddies.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.