Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Attributes Problem again- Need help please


tektek

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

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

Link to comment
Share on other sites

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

 

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!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

yes, it is attitudes like that what keeps me away from negative posters . . .

 

 

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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...