Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: jazz1 on August 21, 2008, 06:48:07 AM

Title: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 21, 2008, 06:48:07 AM
Suddenly "500 Internal Server Error"  ::)

Worked fine, till one day (today) i waked up and did get this error massage, instead of the smf forum.

What could case this? Could it be any kind of hackers attack?

Did write to my host support, but i don't think they can help me, since there is only smf not working on the server, and the rest of the site is working.

Tried to use the search but the only matching topic i found was in Turkish and the rest is not really talking about my problem.

So. Where sould i start solving the problem?

That is the link to the smf forum : http://smf.hikingbike.org/

Thanks
Title: Re: Suddenly "500 Internal Server Error"
Post by: Deprecated on August 21, 2008, 08:08:14 AM
Run repair_settings.php and see if you can get any info from that.

What is repair_settings.php? (http://docs.simplemachines.org/index.php?topic=663)
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 21, 2008, 08:11:35 AM
Thanks for the reply

I ran it and try to change some settings like compression/maintains mode /something else mode/ ... still no luck..
Title: Re: Suddenly "500 Internal Server Error"
Post by: JLHC on August 21, 2008, 08:32:02 AM
It could be a permissions issue. Have you checked the file permissions?
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 21, 2008, 08:45:00 AM
Im not sure what you are talking about. What is that file? and what permission has to with it?
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 21, 2008, 08:46:42 AM
If you mean permission settings, how can it be changed suddenly by itself? Is it possible  at all?

The smf directory is 755
Title: Re: Suddenly "500 Internal Server Error"
Post by: riker on August 21, 2008, 08:49:27 AM
Have you checked the server/database ?
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 21, 2008, 08:52:08 AM
riker

Please be more specific. What is to check at server or at DB?
Title: Re: Suddenly "500 Internal Server Error"
Post by: riker on August 21, 2008, 08:56:11 AM
Quote from: jazz1 on August 21, 2008, 08:52:08 AM
riker

Please be more specific. What is to check at server or at DB?

Can you access the server?.
Can you see html pages ?
Can you access the mysql database ?
Title: Re: Suddenly "500 Internal Server Error"
Post by: JLHC on August 21, 2008, 08:59:38 AM
Quote from: jazz1 on August 21, 2008, 08:46:42 AM
If you mean permission settings, how can it be changed suddenly by itself? Is it possible  at all?

The smf directory is 755

Permissions can be changed if your host has changed certain configurations. You should also check with your host to see whether they have changed anything during the night before.
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 21, 2008, 09:01:39 AM
I can login to phpmyadmin
I can access html (from other subdomain)
Mediawiki working from the main domain (same server).

Is this what you asked?  ::)
Title: Re: Suddenly "500 Internal Server Error"
Post by: riker on August 21, 2008, 09:03:06 AM
Quote from: jazz1 on August 21, 2008, 09:01:39 AM
I can login to phpmyadmin
I can access html (from other subdomain)
Mediawiki working from the main domain (same server).

Is this what you asked?  ::)

You could check the date/times on the SMF files to see if any have been tampered with since yesterday
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 21, 2008, 09:31:43 AM
JLHC:
Here is the list of some files from the smf folder and its permissions. Take a look on it, files has fewer permissions then folders..


riker:

What files should i check? may be something in the database?
Title: Re: Suddenly "500 Internal Server Error"
Post by: riker on August 21, 2008, 11:11:29 AM
Quote from: jazz1 on August 21, 2008, 09:31:43 AM
JLHC:
Here is the list of some files from the smf folder and its permissions. Take a look on it, files has fewer permissions then folders..


riker:

What files should i check? may be something in the database?

I see settingd has been updated today, was that you?
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 21, 2008, 11:13:33 AM
Yes, I tried to change some of it to 777 then changed it back
Title: Re: Suddenly "500 Internal Server Error"
Post by: riker on August 21, 2008, 11:15:59 AM
Quote from: jazz1 on August 21, 2008, 11:13:33 AM
Yes, I tried to change some of it to 777 then changed it back

Look through the rest to see if you can see anyting else that has been done today or yesterday.  If you don't find anything then it's back to your host
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 21, 2008, 11:16:38 AM
I created the htaccess, then used repair (think it changed the settings.php file .. )
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 21, 2008, 11:19:05 AM
OK, ill take a look at rest of files .. any suggestions were should i look? any specific  folder may be?
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 22, 2008, 02:19:03 AM
Deleted the .htaccess from main folder, from "cache" folder, and from "attachments" folder (renamed)

Forum still offline.

There is an idea to install a fresh' smf2 and set it to the old database. Is this possible  at all? What are steps to do it?

Thanks!
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 22, 2008, 04:25:41 AM
Bad news

Installed fresh smf2 installation in different path on different prefix (smf2_) on the same database. Then i ran the reapir, and changed the prefix to the  smf_

Try to run the forum, the same error i get - 500 Internal Server Error

That means that the problem is in the database? What can i try next?
Title: Re: Suddenly "500 Internal Server Error"
Post by: riker on August 22, 2008, 05:05:33 AM
Quote from: jazz1 on August 22, 2008, 04:25:41 AM
Bad news

Installed fresh smf2 installation in different path on different prefix (smf2_) on the same database. Then i ran the reapir, and changed the prefix to the  smf_

Try to run the forum, the same error i get - 500 Internal Server Error

That means that the problem is in the database? What can i try next?

It may not be the database though this could be something the host has done (trust me alot of hosts are clueless).  Back up your old forum and start a fresh one from scratch and see what happens
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 22, 2008, 05:20:29 AM
New forum with a new database is working .. (the one with one topic of greetings)
Title: Re: Suddenly "500 Internal Server Error"
Post by: riker on August 22, 2008, 09:14:53 AM
Quote from: jazz1 on August 22, 2008, 05:20:29 AM
New forum with a new database is working .. (the one with one topic of greetings)

Have you tried the old database with the new install now ?
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 22, 2008, 09:39:13 AM
Ye, like i said, i installed a new forum. it worked, didnt try to post there, but i could view it. Then, with repair tool, i changed the database to the old one. the one that did not work (current).

And i did get the same "500" error
Title: Re: Suddenly "500 Internal Server Error"
Post by: riker on August 22, 2008, 11:38:57 AM
Quote from: jazz1 on August 22, 2008, 09:39:13 AM
Ye, like i said, i installed a new forum. it worked, didnt try to post there, but i could view it. Then, with repair tool, i changed the database to the old one. the one that did not work (current).

And i did get the same "500" error
And you never had any backups of the database before this?
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 22, 2008, 11:41:56 AM
No, i recently convereted it from AEF and didnt think to make a back up yet ..  :-\
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 22, 2008, 01:58:57 PM
But, i have a back up from 115 version of the smf .. i think the one that was created when upgrated to smf2.

With the suffix backup_smf_ (or something like this). 
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 24, 2008, 04:50:09 AM
Any ideas on what can i try? May be partially restore the messages? May be i can try to run it on other server and then see if its works there and so move to other host?

may be somebody can provide me a host for a day or so?
Title: Re: Suddenly "500 Internal Server Error"
Post by: riker on August 24, 2008, 05:14:55 AM
Quote from: jazz1 on August 24, 2008, 04:50:09 AM
Any ideas on what can i try? May be partially restore the messages? May be i can try to run it on other server and then see if its works there and so move to other host?

may be somebody can provide me a host for a day or so?

You've anwsered your own question.  Go with 1.1.5
Quote from: jazz1 on August 22, 2008, 01:58:57 PM
But, i have a back up from 115 version of the smf
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 24, 2008, 06:01:35 AM
Just tried to istall the smf115 with the backuped database and it worked fine!   ::)

So now I'm not sure that the problem is in database ..
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 24, 2008, 07:04:59 AM
Tried to upgrade it to smf2, got this:

Notice: Undefined offset: 0 in /mnt/w0503/d38/s17/b02d1147/www/hikingbike.net/smf115/upgrade.php on line 1326

Warning: Division by zero in /mnt/w0503/d38/s17/b02d1147/www/hikingbike.net/smf115/upgrade.php on line 1327
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 28, 2008, 05:07:54 AM
Is there a possibility to start a new fresh smf, but to transfer the users (members) from last database?
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 28, 2008, 05:43:06 AM
found this: http://www.simplemachines.org/community/index.php?topic=253207.0

Is it correct for SMF2? that i can only transfer one table: smf_members ?

Thnaks
Title: Re: Suddenly "500 Internal Server Error"
Post by: jazz1 on August 28, 2008, 07:34:20 AM
OK, the forum is working!

In mysql  find this:

Quote
SQL-query :

PMA_mysql_list_fields(
d60464353, smf_log_activity
)

MySQL said:

Table './d60464353/smf_log_activity' is marked as crashed and last (automatic?) repair failed

Ran this:

Quote
REPAIR TABLE smf_log_activity

And it fixed the table. And the forum is back.

Thanks for your help!  :)
Title: Re: Suddenly "500 Internal Server Error"
Post by: JLHC on August 29, 2008, 02:00:24 AM
Glad that your issue is now solved. ;)