Installing Modules in Drupal without using FTP

Let's make a quick note about installing modules in Drupal7. Usually when moving your site from your localhost to your production server, you will notice several problems in moving your site.

One of those problems is when you're installing  new modules in your site using the url in  the Drupal modules page and then this wild pokemon appear:

Drupal FTP Installation
This is not the normal way that Drupal7 use to install modules. you are going to see this interface when the file owning and permission in Drupal dont work.

So, how do I fix this?

Easy, well this depend on what Linux are you using (please use Linux). You can always see the Linux version using version in the command line.In my case, I use Ubuntu and to fix this you must go to var/www/html7yoursite/sites and then exec this litle gem:  sudo chown -R www-data *.

There, fixed :)

What kind of Magic is this?

Well, usually in Drupal, you must give permission to the Apache user (if youre using Nginx, I assume is the same) so Drupal can work as usual. In this case we do a chown with -R (recursivity) putting www-data (the Apache user usually in Ubuntu)  as the owner of all files inside sites. You welcome ;)

Recovering Lost Data with PhotoRec for Free

So, we all have been in the same problem, we format our PC and discovered that we didn't save our photos from last christmas. What a shame.  Of course around the web you can find a pletora of tools to do the job and most of them require a payment to be done. But not this, PhotoRec is a small and powerful program that can try to recover your lost data. So hands to the job.


Download PhotoRec from his wikipage. We are trying the 7.0 version, released on december 2014. It worked good for me. When on the Download page, you will see a green big button that say Free Download, so go ahead.


Unzip the beast, and exec the file called qphotorec_win.exe


Select the physical drive that you want to scan, select the kind of files you want to recover (photos come in *.jpg,*.bmp and *.png)


Select where do you want to recover your Photos. Of course it has to be in a diferent Disk that the one being scanned. If you create it on the same disk then you could lose your data because it will overwrite on the remaining pieces of data, son don't play with your luck


Press Start and Cash In

Do I really have to put this image? Hell yes.

Why do I choose Photorec instead of other recovery products?

Well first of all, its awesomely free, easy to use and it do the dirty job. All the payed software that I tried, first scan the disk, then ask you for money (Oh I have test the first page of google when looking for Recovery Software and most of them ask you for money) . The awesome thing with PhotoRec is that when you press start, it really start to recover your data, so let's say you have a blackout in your city, if Photorec is working, and your pc survives the blackout, then you may have some data recovered from your pc.

Second of all, it's pretty fast and stable. Other options couldn't work all the data I was trying to save. I got a 1 Terabyte disk that was formatted and also got an installation of Windows 7 on it, so some of my data could have been lost, but Photorec still managed to recover like 50 gigabytes worth of photos, and I just waited for 6 hours to do it.

Tips and Fun when using Photorec

  • Although it will slow down the recovery, always start your antivirus software just in case you may find virus. The first time I tried Photorec with all the file extension turned on , I discovered like 300 virus on my hard drive. Also never ever ever execute a *.exe file freshly recovered from Photorec, you are calling your own doom doing that.
  • Remember to select your file extension. The first time that I tried the recovery, I matched all the extension and it never ended running. I stoped it at the third day of running, and I was deleting all kind of files because my backup disk has less space than the one being recovered.
  • Please dont save your data ON the disk being recovered, I repeat it again, if you do that, you ARE GOING to loose the deleted files forever.
So how does Photorec works? Well its magic, the only thing I know is that when you format a disk, you dont delete the physical files, you just delete the index that point to your physical files, that is why when you write new files to your disk, you are really overwriting on top of all the physical files that are not in the index. There's a special case when formating your disk that is called low level formatting that really delete the files from the hard drive, in that case you are not going to recover your files with this tool.

So please, take a look at that software, it really help me a lot, so this is a tribute to the guy that made this software. Please have a nice day Mr C. Grenier!.

MySQL server has gone away and Drupal

So if you got this problem, it's not really a Drupal problems, it's a problem with mysql configuration. The easy way to fix it is entering to my.ini and search for the string max_allowed_packet and set it to 32M or more.

Have fun!

Correct Way to Translate Content in Drupal

Ok, this will be a small post about keeping a multilanguage web page in Drupal7. As you know  Drupal is powerfull, but a bit complicate when configuring it. This WILL NOT be a tutorial, but a general map of instruction to translate your website. So let's see howto do it.

How Drupal knows what is the current language on your page.

There's a lot of ways of how drupal can recognise the current language. In fact you choose one when configuring the languages that are going to be on Drupal. But I really recommend using the URL method. This work as follow. Suppose you have a domain When using URL for internationalization, your webpage in spanish are going to be on So your node1 should be, in english it will be (node2 because that's your translated module). There are other ways like having a global variable, but it will mess up your SEO, because google really hates having the same URL with different content (ok, its the same content but in a different language).

Translating Content

For translating content, you have to install the i18n module. When installed, a new tab called translate will appear when editing your node. The way you translate a content is creating a new node that is related to the original node. 

Translating WebForms

This will be the same as content. You create a clon of the original webform and relate it to the original.

Translating Blocks

You are going to need to activate the block Language Module. Works the same as Content.

Translating things in Views

So, lets say you create your awesome view and have put some global text button, or put a main title on it. the way you have to translate that is using the Content Translation module that comes with core of Drupal. After that you have to search for the string you want to translate, include the HTML if your title or global text have that, or else it will not appear in your search list. But!, and this is a very big but, when translating string, make sure youre currently on the language the translate string is. For example is you create a title in Spanish, let's say "Hola Mundo" (yes with the span tags to separe Hola from Mundo), you have to search that string using the admin in spanish, like or else your string will appear in the wrong language.

Menus and URL

This is the last thing you want to translate. For me its easy to create a new menu item in a different language. And why do it last? Because the URL of your content will exist only after your content is created. 

So, what thing's cannot be done easily?

My only problem right now is looking  for a way to translate the URL of a View in Page form. If you know, please tell me in the comment. Good luck!

Image corrupt or truncated in Firefox

Ok this will be a small entry. I got this problem in a Drupal7 Web Page using a slider module, the classic rotating image block.

It was kinda strange, because even in Internet Explorer the images were ok (IE!). So after trying the same webpage in Opera and Safari, and seeing that it worked ok, I disabled my Firebug extension and it worked like a charm!. I enable it, and the problem was gone.

So next time you have this problem, a corrupt image in firefox only, maybe you should deactivate any Firefox plugin youre having right now, specially Firebug. Hope it help someone.

Improving the Performance of BigDump

BigDump its my favorite way to move a Drupal Database from one server to another. Lately I had a "feeling" that this migration was becoming slower and slower. I really dont know if it is because of the way Drupal7 store the data, or because the new WAMP versions just come with a bad default configuration.

Anyway I was decided to confront this problem and find some interesting things that we can use to improve BigDump. So I made some experiments in my CoreI5 with 8GB of Ram and here is what i found:

About Drupal 7 and WAMP Mysql

Well this entry is mainly for Drupal7 users with Mysql as their main database in a WAMP server, I guess a lot of people have that configuration as a developing server. well seems like Drupal7 change their storage engine, instead of MyISAM, the default storage engine of Drupal6, its now use InnoDB. There are a lot of opinions about what is better but Seems like InnoDB can get you more performance if you give it an adequate quantity of RAM memory.  Now a simple site in Drupal, lets say a Blog, will usually weight between 5 to 10 MB in database data. That quantity of data doesn't work with the default configuration  of a Mysql WAMP installation, you will surely have a Server Gone Away error or Time Limit error, that's why we need to use BigDump for such quantity of data.

First: Configuring Mysql

Ok open your my.ini (in Linux it should be my.cfg but I not quite sure where it is)  file to start modifying it, Don't know where to find it? Follow this simple image and do it baby:

After some trial an error messing up this file , here are some configuration that you should try in order of importance:
  • innodb_flush_log_at_trx_commit = 2, by default it is set on 1, putting it on 2 means that your log will be stored temporaly in RAM instead of saving it on the HD every time you do an insert delete or update. This configuration have a side effect that it may corrupt the Log if crazy stuff happens to your RAM but you will not loose too much if your server is not your web hosting. Changing this variable makes my BigDump script run from 190 seconds to only 90 seconds, almost doubling the speed of this. If by any reason you cannot change this variable, maybe you can put your SQL exported script inside a transaction:

This is the export tool of PhpMyAdmin, check that option in Green and all your Data will be inside a Transaction
  • innodb_buffer_pool_size = 1024M, Ok I put 1024MB of RAM but you can put more according to the quantity of RAM in your rig. The default I think it is 1M or 16M, just changing this variable improve the speed from 90 seconds to only 50! 
  • Moar!!!: This blog gave me some more good ideas about other variables that we can tweak, but just with these two you can get an improvement of quad the speed.
Dont forget to remove the # on the start of the line, # is used for code comments. Yes you know that, but you already forget to delete it, check it again ;)

Second: Configuring PHP

This is optional really, but giving more memory to PHP improve the efficiency of the BigDump Script in 2 to 3 seconds, its not really too much but it will really help when you have Drupal installed

  • memory_limit 1024M :Play with it if you have more RAM, but 1024 worked fine for me.

PHP.ini after modifying it.

So to recap, change those 3 values showed to you and your BigDump script will fly!. Have fun

THIRD: Host File (update Jul2014):

After a hard drive format on my main disk, I installed again WAMP, and discovered that is was slow as hell, in a CoreI7 machine with 16GB of RAM, so I follow some advice to improve the general Wamp performance. One of those tricks is to modify the hosts file of windows, configure my.ini (of mysql) to listen to and to disable IP6. Please take a look at those tricks here.

FOUR: Mysql Bind parameter (update Jul2014):

In  my.ini use the following under the [wampmysqld] tag.

bind-address = ::

Find this information in stack overflow

Outlook 2007 Errors: 0x8004010D and 0x80004005

Well this is a reminder about those two errors that appear in Outlook.

The error 0x80004005

This is one tricky  b@astard message, it really doesn't tell you whats going on. This error appeared to me when I tried to receive new emails in Outlook 2007. For what I have discovered, it just tell you that you can receive new mails. It may appear if you .pst files weights more than 4Gb and youre using Windows XP, or maybe there's an Antivirus blocking the entry of new mails.

The error 0x8004010D

This one is easy, its about your .pst file. As I told you before, thers a limit of space of 2Gb or 4Gb, after that the file cannot grow more. This will happen if youre still using Windows XP or use a FAT hard drive instead of NTSF.


Well, I dont really know what to do, but you can check this tool to change the size of the PST file and split it in more parts. Hope this help anyone.

More Links: