SQL Help

[SandTiger]

Hiya

 

I'm having a bit of a mare resolving the following when I try to add attributes:

 

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

 

insert into products_attributes values ('', '146', '15', '472', '', '+', '0')

 

[TEP STOP]

 

So I was wondering if anyone with a better knowledge of SQL (not hard) would be kind enough to help me decipher the above message?

 

Thanks

[rosemary]

See the couple empty fields denoted by ''? You may need to enter NULL into those fields when you are adding products or product attributes.

 

Hope this helps.

Rose

 

 

 

 

 

Hiya

 

I'm having a bit of a mare resolving the following when I try to add attributes:

 

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

 

insert into products_attributes values ('', '146', '15', '472', '', '+', '0')

 

[TEP STOP]

 

So I was wondering if anyone with a better knowledge of SQL (not hard) would be kind enough to help me decipher the above message?

 

Thanks

[SandTiger]

See the couple empty fields denoted by ''? You may need to enter NULL into those fields when you are adding products or product attributes.

 

Hope this helps.

Rose

 

Thanks for your reply Rosemary, I found an extra table created by a deleated contrib so I dropped that and it seems to be sorted, until I break it again :rolleyes: