Problem adding a new Product

***Tinydancer*** · 01-18-2004, 04:18 PM

Hey Tony

I tried adding L'Artisian (perfume) and it gave me this message:

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 'Artisan' AND category_id='3'' at line 1

**Tony-admin** · 01-18-2004, 04:22 PM

Did you try add this as a NEW BRAND? or just a new product?

***Tinydancer*** · 01-18-2004, 04:28 PM

Hi *thought* new brand but maybe I goofed up. I just got an email saying it was approved, so I guess its OK. Thanks!

**Tony-admin** · 01-18-2004, 04:30 PM

I just approved a brand, let me know if that was it and it is working fine

***Tinydancer*** · 01-18-2004, 05:12 PM

Yep, that was the one. Its working fine now. Thanks.

***Tinydancer*** · 01-18-2004, 05:17 PM

Woops, my bad! It wasn't this one. I was trying to add L'Artisan, so I guess it did mess up.

**Tony-admin** · 01-18-2004, 05:21 PM

Can you do us a favor and try to add a few more (even if you dont know if you like it) just for testing purposes. I would like to know if you still get that database error

Quote:

Originally Posted by Tinydancer

Woops, my bad! It wasn't this one. I was trying to add L'Artisan, so I guess it did mess up.

***Tinydancer*** · 01-18-2004, 05:31 PM

OK, I'll do that now.

***Tinydancer*** · 01-18-2004, 06:57 PM

I added a few new brands, just waiting for the approval.

Quote:

Originally Posted by Tony(admin)

Can you do us a favor and try to add a few more (even if you dont know if you like it) just for testing purposes. I would like to know if you still get that database error

**Tony-admin** · 01-18-2004, 07:04 PM

OK will approve right now, let me know if you receive the approval email

***Tinydancer*** · 01-18-2004, 07:28 PM

Yep, I got all 3, it worked!

***allisong*** · 01-23-2004, 03:31 PM

Tony...I did a review for UD Lounge eyeshadow..When I tried to review a lipstick(same name,same brand)I got a red"Oops items name already exists"message

**Tony-admin** · 01-23-2004, 10:17 PM

Yep you will get that message if it is in there. After you choose Urban Decay and then Eyes-Eye Shadows, it will take you to another screen where you add the product name. BUt if you look just UNDER that spot where you add the name there are a BUNCH of links there...look to see if the NAME of the product is there (it will be cuz that is why you are getting that message of OOPS) CLICK that link on your product name and then begin to write the review.....

OR are you trying to ADD THE a new brand?