'random' and 'mysterious' problems...

[BoA]

have currently experienced many 'random' and 'mysterious' problems...

Sometimes, some posts are deleted in my forum...

Sometimes, some html codes are missing...

Sometimes, the site breaks down for 2 minutes, giving the
"HTTP 500 Internal Server Errror"

Sometimes, my domain redirects to a completely random site...


What is all of this??? I will leave bluehost if this continues. Can you recommend me some other RELIABLE hosts?

[troy]

what browser are you useing and have you tried useing a different browser.?

Internal Server Error 500 is usually caused by either a malformed cgi script or an invalid directive in an .htaccess file located either in the same directory as the page throwing an error, or in any directory above it.If it happens some of the time and works most of the time then I have no idea
Now about the browsers
I can go to my site and see all text with ie but when I use firefox some text is missing.haven't figured that out yet.Thats why I ask about the browsers.

[areidmtm]

Sounds like you have a problem with your account being compromised. Have you given out your passwords and usernames to anyone? Is your PHPBB username and password the same as your cPanel login???

[BoA]

Thanks for the replies.

First of all, the errors appear with all browsers. (IE6, FF1.5 and Opera 9)

Here is the sad error log:

[Wed Jul 5 13:43:55 2006] [alert] [client 213.164.91.2] /home/gadgetko/.htaccess: Invalid command '<deactivated', perhaps mis-spelled or defined by a module not included in the server configuration
[Wed Jul 5 13:43:55 2006] [internal] Fixing /home/gadgetko/.htaccess
[Wed Jul 5 13:43:55 2006] [alert] [client 213.164.91.2] /home/gadgetko/.htaccess: Invalid command '<deactivated', perhaps mis-spelled or defined by a module not included in the server configuration
[Wed Jul 5 13:43:55 2006] [internal] Fixing /home/gadgetko/.htaccess

I have attached the .htaccess...(located at the error log above)

It just goes down and down...I see no end to that error.

Help...please..

And yes, I do not use phpBB and my passwords are very complicated, not the same and never told anywhere in my life.

[areidmtm]

so are you asking what the CPU quota message is or the use of 'deactivated' tag?

The deactivated is not supported and the CPU quota is a message that appears when your account has exceeded the CPU quota, usually due to poorly written MySQL and PHP scripts, such as PHPBB does.

Search the forums to find out how to index your MySQL tables

[BoA]

What are you talking about?

I use SMF, which is well coded and I only have a few members online in my site.

If it is an account cpu quota exceed, the proper message would appear and I wouldn't really worry about it.

However, it doesn't and this random 500 internal server error pops up, although usually it should be this:

http://box136.bluehost.com/highload.html

So there is something wrong with that .htaccess...

PS: If this REALLY is a CPU quota issue, than I will leave bluehost. Clearly,my well coded SMF forum with a few members CANNOT cause that.

[areidmtm]

You need to INDEX YOUR MYSQL TABLES if your having CPU quota problems. And if you leave bluehost, you will find the same issues at other hosts

[BoA]

How do you index it?

Can you give me a link to it please.

I cant understand. There is something mispelled or wrong with the .htaccess file, what has the mysql todo with this???

[areidmtm]

search the forum for mysql indexing or CPU quota or google it

You are getting the CPU error because it is taking to long to get the data from the MySQL DB's and exceeding your CPU quota. Just search the forum and you will find all the info you need

[BoA]

I can't find it, is it really that difficult to just give a link???

Also, I am a real newbie in this tech stuff...I really don't know how to do it.

[areidmtm]

Is it that hard to search Google and the forums? Apparently it is. There are LOTS AND LOTS of info out there on MySQL indexing. If you are that incompetent to use the internet and do a little bit of searching, then maybe you shouldn’t be using it.

As that said, look here

http://www.google.com/search?q=MySQL+Indexing&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official

http://www.sitepoint.com/article/optimizing-mysql-application

[BoA]

So what should I do with that???

I don't understand a clue what they are on about.

I really do not think this is a MySQL problem - Website was running perfectly fine, never got anything like that and I never indexed anything. It was just until those guys moved me to a new box when this problem appeared.

I tried it in the new host, with 15% CPU limit and was rock solid for 3 days now.

You just seem to dismiss everything with that excuse, I am the exception of 1% and I don't get a clue on how to index my database.

[areidmtm]

I am not going to teach you how to use and build your website. It is assumed that you already have a little bit of knowledge of website building. If you are absolutely clueless on what you are doing, then we can’t help you here.

If you think it’s a problem with the box, then contact support.

[BoA]

Is it just something where you run a query in phpMyadmin???

Do you run "OPTIMIZE TABLE whatever" to every table??

[areidmtm]

It's more then that. If you don't know, then I’m sorry, you’ll need to do some research on mysql. Buy a book, take some classes, and find some tutorials. Bluehost nor the bluehost forum is going to teach you how to use mysql and how to optimize it. Like I said, bluehost sells you their service with the assumption that you already know what you are doing. If you don’t, then peope here at the forums can help you to the point of holding your hand step by step while you learn how to build a website. If you want to set up a website, then you have to have prior knowledge or you are not going to go anywhere.

[BoA]

Wasn't these scripts such as phpBB and Joomla designed to make people's life easier in creating websites??

Anyway, do you think that running that optimize table query will improve the situation?

I mean, as far as I can do, that's my limit. I don't have time to read mysql books.

[areidmtm]

Wasn't these scripts such as phpBB and Joomla designed to make people's life easier in creating websites??


That was the idea and that sure would be nice, but in reality, as with all things in life, that is not the case. Most of those pre-written scripts are really not written very well. Some are better then others, but the programmers can only guess and make a general version.


Anyway, do you think that running that optimize table query will improve the situation?

You could try that. I would delete the entire forum and start from a fresh one and delete EVERYTHING in your .htaccess file.

If you really want a nicely written forum script then you are going to have to pay for it. vBulletin would be the best.

[BoA]

Hmm...

I am actually thinking about vBulletin.

It is the best, I know, but I can't really afford 160 dollars...:(

But if it really is well coded and supported, then I might think about it again.