5 June, 2020 seen 5,866I was migrating Drupal 7 website to a newer infrastructure (PHP 7.4) and during the migration process when tried to connect to the MySQL database I faced following error - SQLSTATE: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'. Here is the error code: Resolve all issues below to…
In this Drupal tutorial I will show you how to add Pinterest Pin It Button to Drupal 7 site using views and html.tpl.php file.
Add Pinterest script to your html.tpl.php
Create a new view, or modify your existing one
- Add Contextual Filter: Nid
- Add Relationship: File usage
More for configuring Relationship for this task please read this comment: https://drupal.org/node/1098938#comment-5025942
- Content:Path (Excluded)
- File: Path (Excluded)
- Content (Title) (Excluded)
- Custom Text
In field Custom Text add:
<a href="//www.pinterest.com/pin/create/button/?url=[path]&media=[uri]&description=[title]" data-pin-do="buttonPin" data-pin-config="none"><img src="//assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png" /></a>
Where Path is path to your node, URI is path to your image, TITLE will be description field, you can change this to BODY if you prefer.
If everything done right, your Pin It Button should be fine. Just add a block in your theme.
By using this approach I have added Facebook, Twitter, G+ as well all in one view. You can see it in live above each of my posts.