Faster, better…

Posts Tagged ‘Network Solutions’

There have been many Internet searches associated with yesterday’s Network Solutions database problem. At about 1730 yesterday 11/18/08 users of the UBB bulletin board at PopularWireless.com were greeted with an SQL error. A database cache table was read only. Yikes! Here at dougweb I could see that some functions in WordPress were not working properly including posting.

I put a call in to Network Solutions and luckily for me the contractors in the Philippines were not answering the help desk telephone. Now I’m a Gold VIP customer. All that has meant so far is that I am offered more and more ways to spend my money EVEN when reporting down time. None of the promises like periodic updates of help desk requests ever came true. It was interesting that they were prepping customers to receive calls from a company surveying customers on service issues. A recording said I might get a call.

In four to five hours the service came back but remains a little sluggish today. How is your blog? How did the down time affect your website?

We’re sorry for the inconvenience, but there has been an internal server error. Please click on the back button to return to the former page.

These are caused by the database failing to respond. I have a call in to Network Solutions to find out why. Call number 1-348827615.

This has been an issue for months, especially this week. Your patience is appreciated.

…or at least slowed down just enough to become a pain. (mysqlv1)

Both DougWeb and PopularWireless are facing DEAD SLOW mySQL server problems again. Third weekend in a row. The AIS page looks like it can’t accept new data. Attempts to repair tables on that small database took quite a while – waiting on the database IP to finish whatever it was doing. An attempt to optimize the largest table in the PopularWireless database produced the following:

Error

SQL query: Edit

INSERT INTO `pma`.`pma_history` (
`username` ,
`db` ,
`table` ,
`timevalue` ,
`sqlquery`
)
VALUES (
‘popwireblog’, ‘wp_popwireless’, ”, NOW( ) , ‘OPTIMIZE TABLE `wp_wassup`’
)

MySQL said: Documentation
#2006 – MySQL server has gone away

Second weekend in a row. Database applications using the mySQL 4.0 server are toast and the SQL 5.0 server is slow as molasses.

PopularWireless Blog, BBS, and the AIS MAP are down as of 7AM Sunday. I have family obligations that I cannot cancel so I am going to send Network Solutions an email and alert them. They took 48 hours to respond to me the last time.

Woo hoo! Gold VIP program!

Network Solutions busy tackling a database server problem that has been an issue for over 24 hours. Access to the bulletin board and the blog is not possible as of Sunday morning.

As a Gold VIP member at Network Solutions I was promised periodic updates on situations like this but I have received NOTHING since I called around 7 PM yesterday evening.

It looks like the SQL 4 database is down but the SQL 5 is up.

Network Solutions had  one this evening. The database server went down causing the blog to fail.  Looks like it is back up. Sorry for the inconvenience.

Does anyone have a clue how to determine the path to mySQLdump and mySQL at this web host?

Near as I can tell when you use the Network Solutions automatic install of WordPress the new Automatic Upgrade plugin will report that it does not have the rights to write in the WordPress directory.  I was able to eliminate this problem by installing WordPress 2.5 manually after creating my own database using their PHP interface. The Automatic Upgrade pre-test passes once you have installed the blog manually. Lots of folks have written about this issue in various places. Maybe this will give someone an idea where to look for a cure. 

It is not rocket science. You can do it.

I used the WP interface at Network Solutions to obtain the server name for mySQL. They just upgraded to mySQL version 5.0 and that value has changed with the IP address. They do not tell uyou what this value is and Tech Support has no idea what it is. All they can give you is the IP address of the database server which might work but I have never tried it. When you use their interface to install a blog inspect the created myconfig.php file. The value is written there. It might be different for other customers so I won’t share it here. You then delete the blog you created adn follow the WP 2.5 install procedures.

Network Solutions is stuck at WP 2.3.3. You don’t want anything less than 2.5 anyway. Last I checked, they have no idea if or when they will ever upgrade their interface. Since it is clunky and doesn’t allow access to your database from myPHP don’t use it.

All you need to do is upload all of your WP 2.5 files to a directory at your site. You use the Network Solutions interface to create a database for your blog. By default they use 82 MB of space so I chose 100 mb. You then create a username, database name etc. Wirte it all down so you can fill out the few blanks on your new myconfig.php file from the previous blog you created. Send that to your new blog directory. Run the install routine and you are in. The steps are in the WP 2.5 readme in your WP directory.

Ask questions here if you think I can help.

Get the Automatic Upgrade Plug in so that when the updates are published you can install them with virtually no hassle.