Jump to content

Error with Product Options


Guest smcdonough

Recommended Posts

Guest smcdonough

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...