wolstech

Good to see the FTP issue is cleared up. As for the database issues, the connection issue and inability to drop databases are all related to the crash Stevie experienced in February. Unless you want to move to johnny, there is currently no fix for any of them. You will need to not use innodb, ignore the extra databases that won't drop, and tolerate the MySQL server downtime.

The database issue has no fix right now. Just ignore the extra database in phpmyadmin. Once Stevie's MySQL is fixed, an admin will need to drop it for you. The FTP issue sounds like either you using the wrong host, or port 21 being blocked on your end. What settings are you using (host and username)?

That site is working fine. I see this: http://imgur.com/YjXrjP3 Clear your cache again, and if it still does not work, try a different internet connection.

Not sure what was up with this one. It was showing as active but was actually suspended... Your account has been unsuspended.

Error 1045 is Access Denied, so likely a password or suspension-related issue. Try it again now. If it still doesn't work, try changing your password in cPanel. When you change it, be sure the box for "allow MySQL password change" is checked. After that, log out, then back in and try again. .

@yashrs: actually it's the other way around. A records do NOT work if you use it as an addon or parked domain (it won't let you add it). You need to set it as your main domain to use an A record. Also, proudlyb, please do not TYPE IN ALL CAPS, do not repeat the same thing 6 times, and please use proper grammar. It is quite difficult to understand you. If it is not working, it isn't set up right. What are you seeing when you visit your site, what is your username, and what is your domain?

CSS is another language used for describing the appearance of elements on a website. It sounds like your book should cover it. Font tags are commonly used in books for beginners because they are easy to understand and eliminate the complexity associated with CSS. They technically shouldn't be used anymore on published sites because they are from an older HTML standard, but that's not to say they won't work, as all major browsers still understand them. Since you're a beginner, you might just want to keep the font tags for now.

Our name servers are ns1.heliohost.org and ns2.heliohost.org. Do note though that NS2 is often slow to respond (or down entirely) because it is located on the same server as Johnny. Some people have reported trouble adding it to a domain because their registrar verifies it's availability. If this happens to you, your website will work fine with just NS1, and you can try adding NS2 again later.

Your account was suspended for inactivity, because you haven't logged into your account in the last 30 days. To reactivate your account, please visit http://www.heliohost.org/home/support/scripts/renew. To prevent this from happening in the future please remember to visit http://heliohost.org/ to log into your account at least once every 30 days. If you are still seeing the Account Suspended page after renewing your account, please clear your cache.

The innodb tables are read-only, so you won't be able to remove their records. If you have any MyISAM tables mixed in with the innodb tables though, you can remove the records from those particular tables (or drop the MyISAM table entirely.)

There are a few issues that doing the above won't fix, but those cases are few and far between. The above is thorough enough for many people. Some things to add: In step 6, you can't drop any databases that have InnoDB tables if you are on Stevie. Doing so will bring down Stevie's mysql sever for a few minutes, and will also leave them in a state where they are gone from cPanel, but still exist in phpmyadmin. Also, if you use cron jobs, be sure to delete them by going to the cron job page of cPanel.

Aside from the very outdated HTML (<font> tags are obsolete, use CSS for fonts), some code comments I have after a very quick look are these: <h1 align= "center" class= "blueshadow"><font color= "red" size= "8" face= "Comic Sans MS">Save a Pet</h1></font> You opened the <h1> first, but closed the <font> last. The first thing opened should be the last thing closed. Move the </font> inside of the </h1> so the header is closed last. <a/> Typo for the closing tag on your pet finder link. <td><img src= "images/shelterdog3.jpg" width= "200px"</td> The closing > is missing on your <img> tags for all of the images in that table.

That account is not suspended. If you are seeing the suspended or queued pages, please clear your cache.

The page renders fine in my browser when I copied it to an html file. The images are missing, but I expected that since I don't have them. What problems are you having with it?

I'll assume you reached that from the features page...it should be http://www.heliohost.org/home/features/databases Fixed.

InnoDB tends to trash itself more frequently when MySQL crashes. MyISAM can crash too, but it is more stable than innodb is, and repair is often easier if something does happen.

The way we recommend you convert innodb tables to myisam is to make a backup as an sql file, replace all of the ENGINE=InnoDB with ENGINE=MyISAM in the backup SQL file, import it into a blank database, then edit your application Config to use that new database. Last i tried, attempting to use ALTER on the existing tables to change engine doesn't seem to work. Also don't bother trying to drop databases with innodb tables in them, since doing so wont succeed and will crash the MySQL server for everyone on the server...and it takes 10 minutes for it to restart.

That'd be nice, but it just adds complexity to an already complex system.

Because doing that type of stuff is not nearly as easy as it sounds when you have hundreds of users on the server. The server is not like your typical PC and is not nearly as easy to maintain or rebuild as a PC is. Rebuilding the bare system and your data would take days of downtime for thousands of websites, and getting everything back the way it was configuration-wise could take weeks or months of continuous tweaking. Besides, if we made and used backups, they'd restore these half-deleted databases. Once mysql is working properly, an admin can remove them for you. We won't upgrade mysql because it's broken and an upgrade might make the problem worse. It may be upgraded in the future. If you need a newer version for some reason, Johnny has MySQL 5.5 that isn't damaged. PHP will likely not be upgraded to latest because PHP 5.5 is not backward-compatible with a lot of programs due to function deprecation. We might get 5.4 at some point, but I don't know when that would be.

Your account was suspended for inactivity, because you haven't logged into your account in the last 30 days. To reactivate your account, please visit http://www.heliohost.org/home/support/scripts/renew. To prevent this from happening in the future please remember to visit http://heliohost.org/ to log into your account at least once every 30 days. If you are still seeing the Account Suspended page after renewing your account, please clear your cache.

Your account was suspended for inactivity, because you haven't logged into your account in the last 30 days. To reactivate your account, please visit http://www.heliohost.org/home/support/scripts/renew. To prevent this from happening in the future please remember to visit http://heliohost.org/ to log into your account at least once every 30 days. If you are still seeing the Account Suspended page after renewing your account, please clear your cache.

I have an app on there that uses it for secured mail server connections and haven't had any trouble, so yes we do.

That'd be a half-dropped database. It's related to Stevie's mysql issues. cPanel deletes it from your list of databases, but mysql then crashes trying to drop it. The result is cPanel thinking it's gone, and mysql still having it. I have 3 of these half-gone databases in my account from when I created new ones to convert to MyISAM tables. I can't get rid of them, and several others on here have reported the same. The solution seems to be to just ignore them until the mysql issues are fixed (who knows when that will be...).

For those who can't/don't want to download it, the post and file he is referring to is a copy of dosbox and Turbo C v3 packed in an NSIS installer... Dosbox is open source. Turbo C is commercial software that has a trial and licensed version, and I can't tell which one you included. I'd delete it just to be sure.

When I do a dig I'm seeing an SOA only for NS1. Whether that's because NS2 is down or because the SOA record just doesn't exist, I don't know. Either way, an admin will need to fix the issue with NS2. For the time being, contact the registrar and ask them to set the NS for you, telling them that your host only provides one (working) NS. We've had at least 1 other person with the same issue, and they were able to set it up by contacting the registrar. Alternately, you could create an A record to 216.218.192.170 instead. You already have your domain set as your Heliohost account's main domain, so this should work without any additional configuration.