Tag Archives: 500

Drupal 7 “500 – Internal server error” [SOLVED]

01/05/2013 14:10 \ Leave a Comment \

When you want to install a new Drupal 7 in a shared server or some web hosts, specially those concerned with security settings, there is a good chance that all you get is a “500 internal server error”. This is usually due to the .htaccess file included with the installation, and more precisely to these lines:

# Follow symbolic links in this directory.
Options +FollowSymLinks

Some web hosts tighten up security settings and now forbid +FollowSymLinks option in .htaccess. This causes an 500 error when accesing the site.

The fix is quite simple. Just replace +FollowSymLinks with +SymLinksIfOwnerMatch. So edit the lines above to this:

# Follow symbolic links in this directory.
# comment this one...
# Options +FollowSymLinks
# add this new line...
Options +SymLinksIfOwnerMatch

The issue should be fixed.

Please note that there is not just one .htacess file in your Drupal 7 site. There is one in / and usually there are other .htaccess files that must be modified too, for instance in sites/default/files. You must change that one too or every image that you upload to your Drupal 7 site won’t be rendered…

Discussion about this topic available here: http://drupal.org/node/1269780

Posted in: Drupal \ Tagged: , , , , , , , , , , ,

Google analytics: how to export more than 500 entries of data report [SOLVED]

12/03/2010 12:11 \ 1 Comment \

Currently, only up to 500 rows of Analytics table data can be exported at a time into CSV format. If you need to export larger data sets, like exporting all keywords that sent traffic to your site, you can export multiple times as long as each batch contains at maximum 500 rows.

If you have thousands of rows that require multiple exports, you can use the convenient workaround below to export all your rows in one go.

1. Go the report that contains the data you want to export.

2. Append the query parameter ‘limit’ to the url (to the end of URL!), and hit enter to reload the report. The limit parameter is needed prior to every report export.
For example:

https://www.google.com/analytics/reporting/top_content?id=14120873&pdr=20090101-20091231&cmp=average&trows=5000&gdfmt=nth_day#lts=1268387872421&limit=50000

3. Hit ‘Enter’ and visually confirm that the report now has the new parameter appended to it. While there won’t be any visible difference in user interface, exporting will now yield more rows.

4. Select the Export tab, and click ‘CSV’ (not the option that says ‘CSV for Excel’).
5. The exported data should contain all the rows from your Analytics table.

Via: Google Analytics FAQ’s

Posted in: Uncategorized \ Tagged: , , , , , , ,