MAMP MySQL server doesn't start
If your mysql server won't start in MAMP you should run
sudo killall -9 mysqld
and this will probably make it run again.
Getting user location on mobile phone or desktop and passing it to views filter
So this is not the cleanest thing possible and maybe some views filter should be made but I created it mostly for the purpose of adding extra button to search a search api index data with user current location. What maybe somebody doesn't know is that you can get user location with html5, so you will only need some little code and I also used reversed geocoding to get address from google api because I already have a filter that uses geocoded data.
Creating custom facet block for Search Api Location module
Facets work fine and by design they narrow down the search results with each facet option you click. But what happens when you want to make them work differently. Some of that can be achived with changing opearator to OR in facet settings. But in this case with search api location module this doesn't work, not sure is it a bug or by design but I solved that with creating my own facet block.
Solr Search Api, search Title as fulltext and sort as string
Currently if you use SOLR for search and deploy it with search API module you can index Title field as fulltext so you can make better use of it and find parts of it when searching. But then you can't sort by title in search api sorts module, what to do? Well use
Install xDebug with Sublime for Drupal (Mac, PC, Windows or OSX)
I'll try to make this quick. Installing xdebug for drupal is the same as installing it for anything else like wordpress etc
So what you need to do is to get xdebug to your php folder. This is different depending on system you use, for example OSX has it already when you install MAMP so you will just need to enable it. Go to your php.ini file and find XDEBUG part and active it(remove comment from zend_extension) and add some lines below like, but probably would even work without them, maybe just include first line.
Check if user is part of OG group
Seems that lates og_is_member needs 4 parametars when checking if user is part of the group, not 3 like it is written in most posts online, so you can get it like above.
FB connect - invite friends, no notification
If you are using FB connect module and its Invite friends submodule or making your own invite FB friends submodule (which is easy). You could probably get into a problem of having no notifications sent to user when you do click Invite in FB dialog box.
There are 2 possible reasons for that. One your app is missing the canvas configuration
Just add it from the your App panel in Facebook Developers. Currently it is in settings tab (4/2014) on link https://developers.facebook.com/apps/383569161782956/settings/
Using VBO to copy and paste fields inside a node, using field collections and node/entity reference
You can create VBO actions that can do something for you but for a quick solution and one time actions you can use "Execute arbitrary PHP script" and there you have $entity and $context object that you get one per each line of yout VBO view.
So what I did was copy some text and node reference fields to field collections fields, that have text and entity reference in them. This took a little bit more coding and clever thinking but with google and some help of this page
https://drupal.org/node/1842304
Views doubt: make a template or style in interface
Views has many options. You can change styling and structure of rows of data in interface of with templates. When I first started using views I choose templates, partly also because of not so much power in UI, but now you can do almost anything with UI. But after using UI, I would still recommend templates.
Database syncing over drush
This has been a long wish for me. Sync databases online and on localhost.
There is an add on for drush that does that
https://drupal.org/project/drush_sql_sync_pipe
Of course this didn't run smoothly and needed some extra config. First SSH didn't work correctly on connecting to remote server, and then MySql also had a problem with the same solution, they were both just needed to be added to windows enviroment, eniroment variables to be exact.
So
