Deleting attributes or items

[nate009]

I am getting sql errors and my programmer told me it is because I have deleted an attribute. Does that mean in OSC you can never delete any items or attributes that you make? Only make them inactive?

 

Here's the error 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 

select products_attributes_id from products_attributes where products_id=39 and options_id =10 and options_values_id=

 

[TEP STOP]

[nate009]

I have made some progress in figuring this out. Basically I used to go in to my order and edit some of the text. For my attributes I used to edit the value. Now I am getting these sql errors and I think it's a setting somewhere that I do not know about. I am hoping someone can help.

 

I know that when I changed the text that it used to work. I know this because when I look at where my sql errors are now they are coming from this text. I have located the problem. The reason I know it used to work is because I changed the text with no problem a few months ago, now that same text that was changed with no problem is now causing that sql error.

 

It is as if that field in my attributes table has been changed from "Text" to "Value" or something. Can anyone help with this? I have no idea why or how or what do do.

 

Thank you