close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues


ps3 options disappearing

Thread began 3/29/2010 8:42 pm by muddysmurf | Last modified 6/12/2012 4:48 pm by Jason Byrnes | 1095 views | 7 replies |


ps3 options disappearing

I've spent a lot of hours adding products and product simple and advanced options to my products.

I checked the actual store to make sure everything was working fine, and it was.

Finally, I go back to check some of the earlier work, and most of those options have disappeared. I haven't manually edited anything, I haven't even touched the database since I'm working live.

Any ideas what's going on?


Sign in to reply to this post

Eric Mittman

If you can please post back and detail a little about the options you were adding that are deleted and when you noticed this. The options should be retained for all of the products that you have entered them for unless you remove some or edit them. If there is a problem with your options disappearing it will be import to have as much info about the situation as possible.

Sign in to reply to this post


It's the Simple Options that I've noticed disappearing. If it were just the same option for many of the same products, I would think it was the way I was writing it.

I've been using: Option name: Chain Size
Options: 18&quot ; 16&quot ; 20&quot ; (I had to add the html version of " because there was a bug in powerstore and I couldn't update the name of it.)

Suppose to look like 18"

The other option for my Vinyl Decals was Color and I was just naming regular colors (Black, White, Red, etc). Now, the "I drive" decal is using an advance option, and it is still there. But my Simple Option for the color on the Initial went missing last night, and I updated it again with the Color. It is currently still there.

I would do a few, and go back to check it at my actual store, and it would be there. I would upload more, and then go back the next day, and they are missing.

I've done a couple of "Bottle cap necklaces" with options with just Chain Size, and used just 18, 20, 16 with out the inch symbol.

They are currently still there, but I stopped uploading products/options because I was scared I would have to redo everything again.

It just doesn't make sense to me. I haven't added or deleted any options, I didn't even touch the code and it should work out of the box.

Sign in to reply to this post

Eric Mittman

This is definitely some odd behavior to be experiencing. There should not be anything in PowerStore that will selectively delete options from one day to the next.

A good test of this problem might be to add in the options like you are doing, then afterwards export the db as a backup. Then the next day when you login and see that the options are missing export the db at that point as well.

If you can post back with these two versions of the db this might give us a better idea of where to start looking for problems. Are you the only user of this admin area? Do you have any backup or syncing scripts that run on a daily basis?

Sign in to reply to this post


I am the only admin. I've been backing up after around 10 products that I've added options to. It was doing ok last night, but the options have disappeared again.

Is there a way to open up a support ticket for me, and only me so I can upload my database sql file? It has some passwords etc in it.

Also, thinking I was going to help the situation, I went to delete my tables, and was going to upload the back up file. That didn't go as planned. When I uploaded the sql file, it shot back an error saying that I needed SUPER privileges. I took out the coupon section, and the database uploaded fine.

How do I fix this?

This was the section I took out..

CREATE ALGORITHM=UNDEFINED DEFINER=`***_leslie`@`localhost` SQL SECURITY DEFINER VIEW `***_store`.`ps3_coupondelete` AS (select `***_store`.`ps3_couponproducts`.`CouponProductID` AS `CouponProductID`,`alter13_store`.`ps3_couponproducts`.`CouponID` AS `CouponID`,`***_store`.`ps3_couponproducts`.`ProductID` AS `ProductID`,concat(`***_store`.`ps3_couponproducts`.`CouponID`,_latin1'_',`***_store`.`ps3_couponproducts`.`ProductID`) AS `JoinedKey` from `***_store`.`ps3_couponproducts`);


Sign in to reply to this post

Eric Mittman

Ok, I opened a ticket for you on this issue. To update your ticket login and visit your support history.


As for the view error you are getting you should take a look in the known issues section of the PowerStore 3 download to get a work around for creating views.

Sign in to reply to this post


Issue resolved?

Hi Eric,
Was there ever anything figured out or resolved regarding the inch mark issue? I had consistent problems using inch marks in my menus that were resolved when I removed the symbols. I can live with that, but I have intermittent problems with inch marks used in Descriptions. The strange thing is that I have had no problems in Short and Long Descriptions. But, in the Cart Descriptions, the last bit of text (which includes a part size and an inch mark) will sometimes drop out as if the Powerstore page is reading it as part of the code. I will be left with 2&q instead of 2". Can you help with this problem?

Sign in to reply to this post

Jason ByrnesWebAssist

especially in the cart description, you should not be using special characters like double quotes. Most payment gateways will break if double quotes are passed as part of the cart description.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...