Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error when trying to assign attributes


Guest

Recommended Posts

Hi,

 

I've been trying to assign attributes to my items but I was promted with the error message below:

 

 

1136 - Column count doesn't match value count at row 1

 

insert into products_attributes values ('', '361', '1', '10', '', '+')

 

[TEP STOP]

 

 

Any kind souls willing to advise what i can do? Is is possible that installing of different modules and contributions results in this?

 

I'm also thinking of reinstalling my OSc as I have a feeling my DB is filled with stuffs and tables i don't need (due to installing and trying out different contributions). Is it possible for me to only transfer only the data of my customers, orders, and items over, without much "chaos", as i believe there're quite a few extra fields and such created when new contributions are added.

 

Aplogise if i sound very confusing, but i hope u understand. :) Thanks for ur help! :D

Link to comment
Share on other sites

depends upon the contribution you installed, as to how many fields need to go into products attributes, you will need to look at the database itself and seee how many are there versus how many you are inserting.

for the customer info, orders, products not too bad, however you probably have fields with those too. be better off trying to salvage this one if you have a few orders.

now for development, i suggest you make a copy of your current site and then work on the copy so as to not disrpt the current site.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...