Sever Error - Error 500

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Sever Error - Error 500

Postby prom0406 » 03. September 2010 21:15

I'm using Xampp to install and test Wordpress Sites locally. As soon as I change the permalink settings inside of Wordpress and refresh the page, the following error message is displayed and I can no longer access the site...

Server error!
The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script.

If you think this is a server error, please contact the webmaster.

Error 500
localhost
9/3/2010 3:09:42 PM
Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1

Is there a way I can correct this problem and regain access to my site?
prom0406
 
Posts: 5
Joined: 03. September 2010 20:50

Re: Sever Error - Error 500

Postby JonB » 04. September 2010 01:08

I think the answer is yes :)

Can you still access localhost and phpmyadmin? (I'm guessing the ISE 500 problem rears its head when you access your WordPress site(s)???)

Start phpmyadmin, locate the database for your site. The table you want is xxxx_wpoptions

the option_id is 32 - permalink_structure - delete the longtext value that might look like "/archives/%post_id%"
leave the longtext field empty (that's what it is when WordPress permalinks are set to Default) save the value with 'Save' and 'go' option on the phpMyAdmin page.

Now your site (if that IS the problem) should work :shock:

Here is a note to self for you - "this is why you should never do development without daily backups"
ADD THIS plugin "WordPress Database Backup" and USE IT!

Good Luck
:shock:
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Sever Error - Error 500

Postby prom0406 » 04. September 2010 05:15

Thanks for your quick reply. I checked all of the tables in all of my local xampp installations and while I did locate the table you refered to I could not find any reference to the permalinks shown. I checked both my currently working and non-working sites. It should be noted that these are locally installed Wordpress sites, if that makes a difference.

Everything was working great until I changed the permalink format within Wordpress. After changing from the default setting and refreshing the page I received the mentioned error message and was not able to access the site anymore.

Anymore suggestions would be greatly appreciated.
prom0406
 
Posts: 5
Joined: 03. September 2010 20:50

Re: Sever Error - Error 500

Postby JonB » 04. September 2010 12:15

I'm afarid I don't have any more suggestions, as that IS the solution. If you didn't find permalink_structure'', you did not look far enouh - its a wordpress default - so it IS in there (in every site).

In phpMyAdmin, the tables are paginated - look on Page 2.
And start doing backups.

:shock:



ysf
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Sever Error - Error 500

Postby prom0406 » 04. September 2010 15:40

I feel like such an idiot, you were right. I did not see that there were more than one page to the table.

Anyway, I deleted what was shown under the permalink-structure as you instructed but it still did not correct the problem. After reading some of the other posts in this forum, I am wondering if maybe this is an issue with the htacess file? Where should this file be located? I assuming in the site root...

Thank you so much for your help!
prom0406
 
Posts: 5
Joined: 03. September 2010 20:50

Re: Sever Error - Error 500

Postby Nobbie » 04. September 2010 17:41

prom0406 wrote:I am wondering if maybe this is an issue with the htacess file?


Indirectly.

I am pretty sure the .htaccess file contains Rewrite URL statements, which requires mod_rewrite, what is not loaded in your Apache installation. This results in Server Error 500.

A quick look into the error_log will help you anyway.
Nobbie
 
Posts: 13165
Joined: 09. March 2008 13:04

Re: Sever Error - Error 500

Postby prom0406 » 04. September 2010 18:01

Where should the .htaccess file be located, I don't seem to be able to find it? I thought it was supposed to be in the root directory of your site. If Xampp does not create it do I need to create the file in the root directory and give it read-write permission?

Also, where can I find the error log?

Thanks for your help!
prom0406
 
Posts: 5
Joined: 03. September 2010 20:50

Re: Sever Error - Error 500

Postby prom0406 » 04. September 2010 18:35

After further investigation, I was able to locate my error log. I recreated the situation which caused my error (trying to access my locally installed website) and then checked my error log. This is what was shown in the error log:

[Sat Sep 04 12:29:16 2010] [alert] [client ::1] C:/xampp/htdocs/xampp/micromembership/.htaccess: RewriteEngine not allowed here.

Is there a way I can correct this problem and regain access to my website?

Thanks for all of your support, I'm really impressed with how fast I have received help with my issues...great job!
prom0406
 
Posts: 5
Joined: 03. September 2010 20:50

Re: Sever Error - Error 500

Postby Nobbie » 05. September 2010 16:33

prom0406 wrote:Is there a way I can correct this problem and regain access to my website?


Re-read my posting.
Nobbie
 
Posts: 13165
Joined: 09. March 2008 13:04


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 135 guests