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

Problem with "Add a Default Value" Locking Up

Thread began 5/19/2010 6:10 pm by bbolt360986 | Last modified 5/26/2010 5:51 pm by bbolt360986 | 1835 views | 17 replies


Totally Frustrated


The issue wasn't that the Webassist PowerStore3 wasn't designed properly,,, The hosting company indicated that they didn't have a problem with their servers... and they were correct in saying that their server was working properly.. The problem was the simple thing and it caused problems everywhere in the software from items not showing up, slow population of photos to the screen when previewing data and screens just crapping out. If you look at the Control Panel for your phpMyAdmin, Server status, Slow_Queries and other server variables like "select_full_join" to determine the indexes that should be place on your table. I found that the following increased the speed of the entire system from the model T to the GT40....

I think it should be part of the db.sql when installing the powerstore 2 or 3

Create index options_index on ps3_options( OptionID asc, OptionGroupID)
Create index productcategories_index on ps3_productcategories( ProductID asc, ProductCategoryID asc)
Create index productoptions_index on ps3_productoptions( ProductID asc, OptionID asc, ProductCategoryID asc)
Create index products_index_pricing on ps3_products( ProductID asc, ProductPrice asc)
Create index products_index_photo on ps3_products( ProductID asc, ProductThumb asc)

Plus other indexs as needed....

Feels good to get past this issue:
Bob at

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...