Problem with Osc " Reinstall? "

[Guest]

Hello there.

 

I installed the contrib Attributes Copier and got it to work on my testsite.

after i got it working there i tried to modify a shop im running..

That didn?t work to well...

 

All i get when i try to make a new attribute befoer copying it is:

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

insert into products_attributes values ('', '28', '6', '9', '', '+')

[TEP STOP]

 

Thing is that ive added attributes before but when i installed the attributes copier i thought that id eraze all old ones and start over so i can copy fresh ones.

 

think this may have something to do with it....

 

Im also thinking of reinstalling OscMs2 and i wonder if that helps, and all "over 500 products" will still be in the shop and the images too ???

[Guest]

dont reinstall osCommerce until you make a backup. your error means something is not correct for communicating with the database, you need to take a look at your products attributes table, i have additional fields in my database, so mine is a bit different,

insert into products_attributes values ('', '4664','8','44','9.95','+','3','','0.34','+','','0','0','','1','', '');

from looking at your insert statement, you are missing the last field, after the '+' you should add ,'dollaramount');

 

where dollar amount is whatever value the attribute is adding

 

 

thus it is much easier than you think

[Guest]

dont reinstall osCommerce until you make a backup.  your error means something is not correct for communicating with the database, you need to take a look at your products attributes table, i have additional fields in my database,  so mine is a bit different,

insert into products_attributes values ('', '4664','8','44','9.95','+','3','','0.34','+','','0','0','','1','', '');

from looking at your insert statement, you are missing the last field, after the '+' you should add ,'dollaramount');

 

where dollar amount is whatever value the attribute is adding

 

 

thus it is much easier than you think

Even if i add 0.0000 to the Value Price field i get

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

insert into products_attributes values ('', '34', '6', '6', '0.0000', '+')

[TEP STOP]

 

ive looked into the mysql database and the fields are Empty..

 

theyre empty because ive deleted all attributes via

admin/products_attributes.php