By framfield on

Hi there,

I've got a problem with installing of drupal website to my hosting. I followed the incrutions, installed the tables to my mysql, transfered drupal to my hosting, changeg /sites/default/settings.php mysql setting in there.
then I hope I can reach browser web browser installationg and setting, but I couldn't.
after I tried to run the program all I could see was 500 internal server error and the followind:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, root@exohosting.sk and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.
Apache Server at fabik.co.uk Port 80

I really don't know, what the problem could be and what can i do to sort it out. Thanks for any ideas.

⋅ Categories: Drupal 4.7.x

Comments

styro’s picture

styro commented

to find out what actually went wrong. Without that info, we can't really offer any concrete solutions.

But if I were to make a wild guess about what the problem is, I'd say your hosting providers Apache configuration is incompatible with the Drupal .htaccess file. Try deleting the .htaccess file from your Drupal directory and see if that changes anything.

--
Anton
New to Drupal? | Forum posting tips | Troubleshooting FAQ

framfield’s picture

framfield commented

thanks for advice Anton. It really helped and after I removed .htaccess file drupal site started. But it obviously still not quite all right. Now I can see new message on the top, saying:

Warning: Access denied for user 'framfield'@'%' to database 'framfield' query: LOCK TABLES cache WRITE in /www/fabik.co.uk/public_html/includes/database.mysql.inc on line 121

this message is on the top and below this is already drupal website.
btw, I couldn't find that error log on my server, that's why I didn't displayed it here.

intu.cz’s picture

intu.cz commented

Perhaps this will help:

1. Open the .htaccess file.
2. Locate the line at the end with RewriteRule^(.*)$ index.php?q=$1 [L,QSA]
3. Put a slash / before index,php:
RewriteRule^(.*)$ /index.php?q=$1 [L,QSA]

Did it help?

As to the DB issue, does the user of the DB have LOCK permissions?

Roman

framfield’s picture

framfield commented

hi, thanks for comment. unfortunately it didn't help and even I changed the .htaccess file I got back 500 internal server error (have also notice that at this point im not able to reach anything on my website). I removed the .htaccess back and at least I can see the basic drupal site.

as to the DB issue, I can't really answer, because I don't know anything about databases. I haven't changed any permissions on my mysql (don't even know how to do it). I got only database from my webhosting (it's not a free hosting I paid for it). I couldn't find anything to change permission through phpadmin. Do I have to change anything in there? If so, how to do it? Sorry, for probably silly questions, but I only started to with this issue, spend lot of time with drupal on my localhost a didn't realise that it shouldn't work on my own hosting. It's quite irritating.

intu.cz’s picture

intu.cz commented

If you look at phpmyadmin (tables listed on the left and the breadcrumb pointing at "Server: localhost" (or equivalent) " >> Database: framfield" (or the name of your database, you should see a tab labelled Privileges. Click on the tab, find your DB user on the list, click on the pen image and check what privileges you have. You should have LOCK TABLES checked. If not, this might be causing a problem.

What exactly did you change on your drupal on localhost? Did you use Clean URLs on localhost? Does the server support rewrite of URLs? Could you ask the hosting provider to send you the logs?

framfield’s picture

framfield commented

I checked my phpadmin and didn't find anything like privileges. my whole phpadmin on my hosting is very poor if I compare it with phpamdin from localhost (xampp). I can't do almost anything, can't even create new database, because have only one from my hosting provider. I also tried to contact support service of my hosting but they don't seem to bother with my questions. I learnt and play with drupal on my localhost, but now I tried to install clean installation on my hosting, following all instructions and settings from the manual. Don't thing I did anything wrong during istallation as I can now open drupal website on my www, but if I want to do anything I always get that message about Lock tables.

phildswan’s picture

phildswan commented

Hi framfield, i'm experiencing exactly the same problem as you and was wondering whether you have managed to solve this issue. My hosts are streamline.net.

Cheers

houen’s picture

houen commented

I had the same error when migrating a site. Turns out all my install needed was the drupal .htaccess file residing in the new drupal installation directory.

crazyben21’s picture

crazyben21 commented

Hi, I was getting 500 because I changed the permission of the folder drupal site reside on. On cpanel file manager I change the folder permission to 777. Bad idea. This the issue causing my 500 error. I change it back to 755 and my issue was fixed.

stjepan21’s picture

stjepan21 commented

Same here. As soon as i changed permissions back, it worked like a charm.

cheez’s picture

cheez commented

Hi,

i just want to insert an image into a Content of type Story.
I did it like it is documented:

1.Enable upload module
2.Set your role as allowed to upload files
3.Check your space and attachment settings administer > site configuration > file uploads
4.Enable your content type for uploads
5.Create content
6.Attach file - uncheck List file, copy the file path under the box once it's uploaded.

Thats image Link in the Body Input Field:
Only local images are allowed.

When i view the page. I see nothing.
When i copy the Image Link into the Browser, i get the message:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, you@example.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

I have set the permissions for the file folder to 775.

What is wronng? What can i do?

Thanks.

cheez

prasannah.ganeshan’s picture

prasannah.ganeshan commented

Hi All,

Thanks for all the heads ups :) You guys directed me in ways to find a good solution for this problem. But most of the issues we discussed are general stuff which could go wrong. But in my case it was totally different issue, which I had struggle to get the fix.

Finally I checked the Apache Logs on the server. I found this error message "UID of script is smaller than min_uid". Explanation is that your drupal installation directory and all it's content has been assigned to a user/group respectively to one which Apache cannot execute them.

Do "ls -l" on directory you can see what I'm talking about.

For me it was set to "root" "root" which is less UID. So I had to change it to something which has more. Please refer the below link it explains it in details.

below link explains all this and more. http://develobert.blogspot.com/2008/04/uid-of-script-is-smaller-than-min...

Cheers,
-Prasannah

karmaker’s picture

karmaker commented

I also had this problem. I developed my site in local pc. Then uploaded it to the hosting server. Imported database. Edited settings.php. And when ran the site the error came up "500 internal server error". For me the error was that the folder where i hosted the site was in 777 mod. So, i changed the mod to 755. And the site came to life.

superjose’s picture

superjose commented

This may happen because you have Clean URL installed, disable them. If it was too late, then add "?q=" (without commas) to the url.

Example:

http://myexamplesite.com/?q=admin

Clean URLs Directory:
http://imyexamplesite.com/?q=admin/settings/clean-urls

Hope this helped everyone.

Nexsoft’s picture

Nexsoft commented

Had the 500 internal server error aswell.
Uncommented the line # RewriteBase / and it works!

etki’s picture

etki commented

problem is in rights should be 705 or 755 and in .httacces
mark off Options directive

# Don't show directory listings for URLs which map to a directory.
#Options -Indexes

# Follow symbolic links in this directory.
#Options +FollowSymLinks

# Multiviews creates problems with aliased URLs and is not needed for Drupal.
#Options -Multiviews

xaris.tsimpouris’s picture

xaris.tsimpouris commented

I don't if this may help somebody, but for me no htaccess was the problem (deleted or not).
After migration I tried to rename module folders (to force not loading them while drupal bootstrap) and site was back after (for some reason) renamimg ubercart folder.

--
http://1024.gr - Programming by nature

lellobot’s picture

lellobot commented

In my case, it was because I upgraded the Imagefield module without upgrading the Filefield module to the same version as well. (Upgrading from 3.8 to 3.10).

Such a silly thing! And I spent half a day trying to work out why!

NenadP’s picture

NenadP commented

My recent case was migrating and not enabling Facebook connect module which was on user/login page!
I got 500 error untill i enabled facebook connect again. (code has called it, but module was disabled!)

payamspot’s picture

payamspot commented

Had same problem on Drupal 7.15

Commented line 14 of .htaccess ("Options +FollowSymLinks") and problem solved!

I hope I encounter no problem in the future by doing this.

bribread22’s picture

bribread22 commented

Believe it or not, this can also be a permissions issue. If the permissions are set to 777 on your web server, you may get this error basically for your added security. To fix the 500 error, set the permissions for your files to 755 or lower. This could be the solution to getting rid of your 500 error.

Stefaye’s picture

Stefaye commented

I just solved a 500 error received after uploading Drupal site to live server.
In my PHP error logs it mentioned something about the webform.
I ignored it for a while first assuming an error with one module on one page would not crash the entire site. Then got desperate
and disabled the webform module in my dev environment then re-uploaded and it all came good!
Have since been able to re-enable the webform module by updating PHP version in htaccess file.
The lesson being do not ignore the PHP error logs even if they seem strange as they may just hold the clue no matter how unlikely it seems.