Advanced Options errors

I am trying to add a size option with a different pricing structure to a product. I keep the box checked for changing per size, changing the cost but the save delivers an error of:

Update ps4_products set ProductPrice = '65', ProductUpdateDate = '2021-04-23 15:11:18' WHERE ProductID in ( select Distinct ProductID from ps4_productoptions where ps4_productoptions.OptionID in ('') AND ProductID in (select ProductID from ps4_productoptions where OptionID = 30)) OR ProductID = 33
Truncated incorrect DOUBLE value: ''

Any thoughts on what to look for?

ps4_productoptions.OptionID in ('')

That part is wrong... it isn't getting the optionID set correctly.

So what should I do to fix?

I'd have to look a the code. Do you have a url I can look at? I'd need FTP access.

yes, thanks

more details

The FTP information isn't working for me. Please check it and make sure it is all correct.

Actually I got it to work... I must have copied the password wrong with a space at the end.

thanks
also there was an autocorrect space in user...
thanks for looking at it for me
holler when I can retest...

Much thanks

I have fixed this issue. Please try again and let me know if you run into anything else.