Guest smcdonough Posted January 6, 2010 Share Posted January 6, 2010 We sell different size bottles of lotion and I'm not sure if I've made this option correctly because I get this error message every time I try to add an option: ------------------------------------------- MySQL Error Occurred Error Message: 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 '0,,'+')' at line 1 SQL: INSERT INTO CubeCart_options_bot (`product`,`option_id`,`value_id`,`option_price`,`option_symbol`) VALUES (1,,0,,'+'); ------------------------------------------- Here is where I stand; we sell skin lotions and they come in different sizes (2oz, 4oz, 8oz, 16oz...) so I went in, after I made the product page, and selected "Product Options". I then typed in "Sizes", selected "Textbox" and hit "Save". I then went to one of our products and a new box at the bottom appeared. It had a "Product Options" box that appeared and I selected the only option that appeared, "Sizes". In the box next to it, I typed in "16oz", which is one of it's sizes, and hit "Add Option". It then appeared above and read: Custom: Sizes (16oz) with a delete button over here. Everything seemed fine until I hit "Edit Product" and got this error message. Did I do this correctly or am doing this the wrong way? One last thing, I am new to this and have spent my time learning this by doing things incorrectly and then trying to figure out what I was doing wrong. Is there any type of "Owner's Manual" available for the program? The only type of help that I can find is like this. There has to be some type of directions for the program, right? I am using: CubeCart Version: 4.3.4 PHP Version: 5.2.9 MySQL Version: 5.1.30 Image upload folder size: 729.9 KB Server Software: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Client Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729) Thanx for any help Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.