Drupal 7 - Update Modules

Updating Drupal 7 modules can be a more involved process than installing or removing modules. Follow the steps closely, as they are necessary to ensure the stability of your website.
To update a module that's used by your website:
  1. Check for module-specific update instructions.
  2. Back up your database and files.
  3. Put your site into Maintenance mode.
  4. Replace the module code with the updated version.
  5. Run update.php.
  6. Turn off Maintenance mode.

Check for module-specific update instructions

First, check the module's project page "Read Documentation" link, as well as the instructions (for example, README.txt, INSTALL.txt, and UPGRADE.txt) that come with the module's installation file (tarball or zip)for any module-specific update instructions. This is typically necessary when updating modules that involve the usage of third party libraries. Be sure to read and understand all module specific requirements before proceeding with the updates.

Back up your database and files

Your website's database contains all of its content, as well as all of its settings and configuration. Though unlikely, any operation that modifies the database can be potentially damaging. Back up your website's files to ensure that you can revert back to the point when things were working. We highly recommend you back up your site before updating modules.

Put your site into Maintenance mode

From the Drupal Administration pages, go to /admin/config/development/maintenance and put the site into maintenance mode by selecting "Put site into maintenance mode".

Replace the module code with the updated version

You can use either of the following methods to update your module: manually updating the files or Drush.

Manually updating files

To replace the module's code with the new version, download a copy of the new module from the drupal.org project page, or use the link projected by the Update module from your site's update status report. Delete the entire outdated module's directory and upload the new one as if you were installing the module for the first time. If you don't delete the outdated module, Drupal may not reflect the update, and report an outdated module.


If you have the Drush module installed, you can also update your modules from the command line.
To update one or more modules using Drush run the following command from a command prompt, where [module] is the drupal.org project name of the module you want to update:
drush up [module] 
If you have more than one module to update, add the additional module project names to the end of the command, separated by spaces. If you want to update all modules and the installed version of Drupal core, run the following:
drush up 
Note: If you use Drush to update your module, you don't need to run update.php, allowing you to skip the next step in this process.

Run update.php

Update.php is a script that is used to update the database after modules, themes, or core have been updated or upgraded. A new version of a module may change the structure of the database; this script adjusts the database to fit the updated module. Since the database contains all of the content and the settings of your website, this is an essential step to ensure its continued operation.
If you are running multiple sites, you must run update.php on each site.

Launch the update.php file on your site using a web browser. This file is located in the same directory as Drupal itself, for example http://example.com/update.php

Performing updates requires admin privileges. The first account created on your site ("user 1") has the required privileges. If you do not have the proper privileges, you will see the following screen. Either sign in or follow the instructions on the page to perform the update.

After you're signed in with the proper privileges, you'll see this screen. Click the Select versions link to expand the section.

These dropdown lists contain database updates specified by modules you have installed. If you are not developing your own module or troubleshooting, you should leave them alone and just click Update. The correct items should already be selected by default — either “No updates available” if there have not been any database changes, or a number, which is simply an ID number of the database update being applied.

This next page may take time to load, as the server is modifying your database. This page displays any errors that may have occurred during the process. If none have occurred, your module updates are complete!

Turn off Maintenance mode

Put the site back online by visiting /admin/settings/site-maintenance and disabling maintenance mode.

DRUPAL - Update - Notice: Undefined index: distribution_name in drupal_install_profile_distribution_name()

Notice: Undefined index: distribution_name in drupal_install_profile_distribution_name()

To reproduce the issue

  1. Open admin/modules.
  2. At admin/reports/, open the Recent log messages, it will show the following notice:
Notice: Undefined index: distribution_name in drupal_install_profile_distribution_name() (line 207 of ...).

To solve

Adapt the table name if you use prefix and then execute the following SQL statement:
UPDATE `system` 
SET `status` = '1' 
WHERE `filename` = 'profiles/standard/standard.profile';


Ontario Job Posting Sites


Wherever your career takes you, Kelly has the connections and industry expertise to offer you the best jobs at the world’s leading companies. Let us help you achieve your career goals.

New Technology to Buy and Explore


(formerly Pro)
  • Includes Creator kit capabilities
  • Walabot Black Shell Case
  • Wider freqs. range (US)
  • High 3D resolution
  • 18 antenna array
  • Imaging API
  • Raw signal data
Works on Linux, Windows and RPI

Windows Server 2012: How to Add an Account to a Local Administrator Group

The new interactions on Server Manager as well as the next generation of administration interface may get you stuck on doing common administrative tasks which you have done quickly on Windows Server 2008. One of the tasks I have to do is add an account to the Local Administrator group. In this article, I will show you the step-by-step guidance on how to add an account to Local Administrator group. This article helps Windows Server 2012 beginning administrators facilitate server management as well as get Windows Server 2010 knowledge.

Open Server Manager. Click Tool in the right corner of Server Manager and then select Computer Management.

In the Computer Management windows, expand Local Users and Groups and select Groups. Double click on Administrators group.

In the Administrators Properties, click Add...In the Select Users, Computers, Service Accounts, or Groups windows, type the account you want to add to Local Administrator group and then click OK.

Click OK.

Note: If you are on the Domain Controller, you cannot find Local Users and Groups in the Computer Management. In the case you want to add any account to the local Administrator group on the domain controller machine, just open Active Directory Users and Computer.

You cannot open the BIM file. Reason: You are not an Administrator on the workspace database server

In Analysis Services tabular, the database administrator can make modifications to the model schema and can query all data in the model designer, reporting client, and SQL Server Management Studio. But cannot add or delete databases on the server, or grant administrator rights to other databases on the same server. That privilege belongs to server administrators alone. So if you want to open a model.bim file in SSDT and deploy it onto SSAS server, you need to be server admin.

Most of us might get this error message when we start to work on SSAS tabular model in client sides.

The solution is very straight forward but this can’t be solved by same login which is getting this error message. Contact the SQL Server administrator or use "sa" login and add your username under Sever administrators list in SSAS as shown below.

Wordpress - Plugins must have


Remove HTTP is a plugin that automatically scans and removes both http: and https: protocols from all links. This helps resolve websites that are having “mixed content warnings” which is when the website has assets (images, JavaScript, and CSS) loading both HTTP and HTTPS.
No changes to the links are made in the database. Simply install and activate the plugin and the changes will be immediate. Links that have http:// or https:// will only have //, making them protocol relative URLs. Below is a before and after example.

Redirect from HTTP to HTTPS using the IIS URL Rewrite module

A production deployment of SharePoint 2013 or 2016 should ensure that all HTTP traffic is encrypted in transit, however many users will still type http:// in their browser or have links that point to http:// instead of  https://. In these cases it can beneficial to automatically redirect users to the proper URL. One way of accomplishing this is the URL Rewrite module for IIS.

Key Terms

Rewrite - Modifies the incoming URL, the outgoing URL, or both.
Redirection - Uses HTTP status codes such as 301 or 302 to redirect the client to a different location. This involves an additional client round trip.

Supportability for SharePoint

The support for redirects and rewrites with SharePoint is documented in KB2818415. Since a HTTP 301/302 redirect to inform the browser of the updated URL is the preferred option for SharePoint, that will be the focus of this post. Please note that 301/302 redirects may not work with Office client applications.

Uses for redirect

In most cases a redirect is used for one of two reasons:
  1. Redirecting the user from http to https to enforce SSL communication. When a SharePoint farm is load balanced this is typically done using the load balancer but it some cases can be done on the SharePoint server or another server running IIS by using the IIS URL Rewrite module
  2. Redirecting a user who has a stale URL, typically when the name is changed during a farm migration or upgrade. This can also be done using a load balancer or any IIS server by implementing the URL Rewrite module.

Step by Step Instructions for HTTP to HTTPS redirect

#1 Download the URL Rewrite tool by following the instructions here

#2 Ensure that the IIS site you are using is configured for the proper port 80 binding. In this case we are listening for all traffic on port 80. But you could restrict this based on host header as needed


#3 Create a new URL rewrite rule


#4 Configure Rule Settings Exactly as follows

Note: In this example {HTTPS}, {HTTP_HOST}, and {REQUEST_URI} are all URL parts that can be accessed using the URL Rewrite module. More information on URL parts can be found here.

#5 Apply the rule


#6 From the top node disable and enable the rule (alternatively perform IISReset)


Note: web.config file modifications

The URL rewrite rules get written to the web.config file for the site you are working in. For example, the above configuration should result in this addition to the web.config file:

   name="Redirect to http" enabled="true" patternSyntax="Wildcard" stopProcessing="true">
    url="*" negate="false" />
     input="{HTTPS}" pattern="off" />
    type="Redirect" url="https://{HTTP_HOST}{REQUEST_URI}" redirectType="Found" />

Additional Resources

Supportability of Rewrite and Redirects with SharePoint 2007/2010/2013http://support.microsoft.com/kb/2818415

Power BI - Can not save report to server

i'm just download the power bi report server and power BI desktop (report server )
i could enter the web portal of Power BI report Server
then  i created the report to save to report server
but this error appeared:

then i tried to save the report to local file and upload the file to report server
but  another error says  have an error and try later...


So one of my techs made some progress and got Power BI Reports working on PBIRS for now.  The service account used in RS Configuration Manager was not a local administrator on the server.  As soon as he replaced the service account we had in the past used with SSRS with a user that is a local administrator on the server, we were able to get PBI Reports working on PBIRS.
The tech's hypothesis was that it has something to do with URL reservations, but I'm not 100% sure that's right since everything else about PBIRS was working except PBI Reports.  In any case, changing the service account made it work.

I will say we're not willing at this point to allow the PBIRS service account to be a local administrator on a permanent basis.  We're going to experiment with making the regular service account a local administrator, getting things set up, then removing local administrator rights from that user to see if things will continue to work in that manner.  If that fails, then unless Microsoft gives us an unambiguous notice that the service account MUST be a local administrator, we don't see a reasonable way to move forward.

Install Power BI Report Server

Learn how to install Power BI Report Server.
Download download
To download Power BI Report Server, go to On-premises reporting with Power BI Report Server. For Power BI Desktop optimized for Power BI Report Server, go to the Microsoft Download Center.
tip For the current release notes, see Power BI Report Server - Release notes.

Before you begin

Before you install Power BI Report Server, it is recommended that you review the Hardware and Software Requirements for installing Power BI Report Server.

Power BI Report Server product key

Power BI Premium

If you have purchased Power BI Premium, within the Premium settings tab of the Power BI admin portal, you will have access to your Power BI Report Server product key. This will only be available for Global Admins or users assigned the Power BI service administrator role.
Selecting Power BI Report Server key will display a dialog contain your product key. You can copy it and use it with the installation.

SQL Server Enterprise Software Assurance (SA)

If you have a SQL Server Enterprise SA agreement, you can get your product key from the Volume Licensing Service Center.

Install your report server

Installing Power BI Report Server is straight forward. There are only a few steps to install the files.
You do not need a SQL Server Database Engine server available at the time of install. You will need one to configure Reporting Services after install.
  1. Find the location of PowerBIReportServer.exe and launch the installer.
  2. Select Install Power BI Report Server.
    Install Power BI Report Server
  3. Choose an edition to install and then select Next.
    Choose an edition
    You can choose either Evaluation or Developer edition from the drop down.

    Otherwise, you can enter a product key for the server that you acquired from either the Power BI service or the Volume License Service Center. For more information about how to get your product key, see the Before you begin section.
  4. Read and agree to the license terms and conditions and then select Next.
    License terms
  5. You need to have a Database Engine available to store the report server database. Select Next to install the report server only.
    Install files only
  6. Specify the install location for the report server. Select Install to continue.
    Specify install path
    The default path is C:\Program Files\Microsoft Power BI Report Server.
  7. After a successful setup, select Configure Report Server to launch the Reporting Services Configuration Manager.
    Configure the report server

Configuration your report server

After you select Configure Report Server in the setup, you will be presented with Reporting Services Configuration Manager. For more information, see Reporting Services Configuration Manager.
You need to create a report server database to complete the initial configuration of Reporting Services. A SQL Server Database server is required to complete this step.

Creating a database on a different server

If you are creating the report server database on a database server on a different machine, you need to change the service account for the report server to a credential that is recognized on the database server.
By default, the report server uses the virtual service account. If you try to create a database on a different server, you may receive the following error on the Applying connection rights step.
System.Data.SqlClient.SqlException (0x80131904): Windows NT user or group '(null)' not found. Check the name again.
To work around the error, you can change the service account to either Network Service or a domain account. Changing the service account to Network Service applies rights in the context of the machine account for the report server.
Configure report server service account
For more information, see Configure the report server service account.

Windows Service

A windows service is created as part of the installation. It is displayed as Power BI Report Server. The service name is PowerBIReportServer.
Report Server Windows Service
Report Server Windows Service properties

Default URL reservations

URL reservations are composed of a prefix, host name, port, and virtual directory:
Part Description
Prefix The default prefix is HTTP. If you previously installed a Secure Sockets Layer (SSL) certificate, Setup tries to create URL reservations that use the HTTPS prefix.
Host name The default host name is a strong wildcard (+). It specifies that the report server accepts any HTTP request on the designated port for any host name that resolves to the computer, including http:///reportserver, http://localhost/reportserver, or http:///reportserver.
Port The default port is 80. If you use any port other than port 80, you have to explicitly add it to the URL when you open web portal in a browser window.
Virtual directory By default, virtual directories are created in the format of ReportServer for the Report Server Web service and Reports for the web portal. For the Report Server Web service, the default virtual directory is reportserver. For the web portal, the default virtual directory is reports.
An example of the complete URL string might be as follows:
  • http://+:80/reportserver, provides access to the report server.
  • http://+:80/reports, provides access to the web portal.


If you are accessing the report server from a remote machine, you want to make sure you have configured any firewall rules if there is a firewall present.
You need to open up the TCP port that you have configured for your Web Service URL and Web Portal URL. By default, these are configured on TCP port 80.

Additional configuration

Next steps

Administrator handbook
How to find your report server product key
Install Power BI Desktop optimized for Power BI Report Server
Verify a reporting services installation
Configure the report server service account
Configure report server URLs
Configure a report server database connection
Initialize a report server
Configure SSL connections on a report server
Configure windows service accounts and permissions
Browser support for Power BI Report Server

Reporting Server - Power BI - Introduction

What is Microsoft Power BI?

Power BI is a cloud-based business analytics service that enables anyone to visualize and analyze data with greater speed, efficiency, and understanding. It connects users to a broad range of data through easy-to-use dashboards, interactive reports, and compelling visualizations that bring data to life.

What’s the difference between Power BI and Power BI Pro?

Power BI provides all sorts of features to help you get started exploring data in a whole new way. Power BI Pro provides all of the same great features in Power BI, plus additional features like more storage capacity, scheduling data refresh more frequent than daily, live data sources with full interactivity, groups, and more. Learn more about the differences between Power BI Pro and the free Power BI.

How much does Power BI cost?

Power BI Desktop are free. There is a 60-day free trial available for Power BI Pro. Read about pricing at Power BI pricing.

What if I have questions about Power BI Premium?

For questions related to Power BI Premium, see Power BI Premium FAQ.

Are users who signed up after May 3, 2017 eligible for the Extended Pro Trial?

Users who signed up to Power BI (free) on or after May 3, 2017 are not eligible for the Extended Pro Trial. However, they are eligible for the standard 60-day Pro Trial.

How do I find out who in my organization is eligible for the Extended Pro Trial?

While there is not a direct way to discover this, you can view the Azure Active Directory Integrated Applications report for Power BI to see who are active users within your organization. Those active users in the eligibility period, and who are on free licenses, will receive the pop-up notification. For more information, see Find Power BI users that have signed in.
The Azure AD report does not indicate if a user is Free of Pro within Power BI. It only reports which users have signed in to Power BI and when they logged in. If a user is listed in this report, it does not necessarily mean that they are eligible for the Extended Pro Trial.

What is Power BI Desktop?

Power BI Desktop is a free desktop application you can install right on your own computer. Power BI Desktop works cohesively with the Power BI service by providing advanced data exploration, shaping, modeling, and report creation with highly interactive visualizations. You can save your work to a file, and publish your data and reports right to your Power BI site to share with others.

What do I need to use Power BI?

Just a Web browser and work email address.
Work email addresses ending in .gov and .mil aren’t currently supported.

Why do I have to sign up with my work email?

Power BI does not support email addresses provided by consumer email services or telecommunications providers. Learn more about the Power BI self-service sign-up process.

Which work email addresses are supported?

Work email addresses ending in .edu and .org are supported.
Those ending in .gov and .mil aren’t currently supported.

Is government, academic and non-profit pricing available for Power BI?

Yes, non-profit pricing is available when purchasing directly from Microsoft. You can learn more and sign up through the Microsoft Product Donation site. Government and academic pricing is offered through the MOSP/Direct, EA, and Open licensing programs. Government pricing is also available in syndication. Power BI is not yet available for the US Government Community Cloud (GCC).

Is Power BI available on-premises?

The Power BI service https://powerbi.com isn't available as a private, internal cloud service. However, you have three other options for viewing and working with data on premises.

On-premises data gateway

With Power BI and Power BI Desktop, you can securely connect to your own on-premises data sources. With the On-premises Data Gateway, you can connect live to your on-premises SQL Server Analysis Services server, and other data sources. You can also set scheduled refresh with a centralized gateway. If a gateway is not available, you can refresh data from on-premises data sources using the Power BI Gateway - Personal.

Power BI Report Server

Power BI Report Server is a solution that you deploy on your own premises for creating, publishing, and managing reports, then delivering them to different users in different ways: in a web browser, on their mobile device, or as an email in their in-box. Read more about Power BI Report Server.

Power BI mobile apps

You can also view on-premises Power BI reports, Reporting Services mobile reports, and KPIs with the Power BI mobile apps.

Does Power BI support mobile devices?

Yes. Power BI has native apps for Android phones and tablets, iOS devices, and Windows 10 devices. Download one of the Power BI mobile apps from its respective store:

What data sources can I connect to?

The list of data sources for Power BI is extensive, but it can be grouped into the following:
Read more about getting data in Power BI.

What are content packs?

Content packs for services are pre-built solutions for popular services as part of the Power BI experience. A subscriber to a supported service can quickly connect to their account from Power BI and see their data through live dashboards and interactive reports that have been pre-built for them. We’ve released content packs for popular services such as Salesforce.com, Marketo, and Adobe Analytics. Read more about connecting to services with content packs.
Organizational content packs provide users, BI professionals, and system integrators the tools to build their own content packs to share purpose-built dashboards, reports, and datasets within their organization.

What do I need to install in order to use Power BI?

To use the Power BI service for free, you just need a Web browser and email.
To explore data and create reports in Power BI Desktop, download Power BI Desktop for free.
You can download the Power BI mobile apps from their respective stores, also for free:

Am I limited to one copy of Power BI Desktop for my entire company?

Power BI Desktop’s Software License Terms say "You may install and use one copy of the software on your premises." This does not limit you to one copy of Power BI Desktop for the entire company. Each individual user at the company may install and use one copy on their premises.

Where do I get started with Power BI?

The following resources are available to help get your started:

What browsers does Power BI support?

Here's a complete list of supported browsers for Power BI.

What regions and languages does Power BI support?

Here's a complete list of regions and languages supported by Power BI.

How can I buy Power BI Pro in my country?

You can purchase Power BI Pro licenses directly or chat with a representative at www.powerbi.com.
You can also find a Microsoft Partner to help you with your Power BI implementation.

Does Power BI meet national, regional, and industry-specific compliance requirements?

Learn more about Power BI compliance, at the Microsoft Trust Center.

Where can I learn more about security?

Learn more about Power BI security, privacy and compliance in this Power BI Security whitepaper and our Power BI security support article.

What has happened to the Power BI for Office 365 experience?

The Power BI for Office 365 experience has been deprecated.

How do I undo in Power BI?

Like many other Microsoft services and software, Power BI provides an easy way to undo your last command.
  • To undo your last action, or last few actions, press CTRL+Z.

How to download OS X El Capitan

Can your Mac use El Capitan?

OS X El Capitan requires any of the following Mac models and versions of OS X. It also requires at least 2GB of memory and 8.8GB of storage space.
  • OS X Yosemite
  • OS X Mavericks
  • OS X Mountain Lion
  • OS X Lion
  • OS X Snow Leopard

To find your model, memory, storage, and macOS version, choose About This Mac from the Apple () menu.

Get El Capitan from the App Store

Now that High Sierra is available, you should upgrade to High Sierra instead of El Capitan. For security and compatibility reasons, Apple always recommends using the latest version of macOS. 
If your Mac doesn't support High Sierra, or you're using Snow Leopard or Lion and would like to upgrade to High Sierra, follow these steps:
  1. Use this link to open the El Capitan page on the App Store: Get OS X El Capitan.
  2. Click the Download button on the El Capitan page. A file named Install OS X El Capitan downloads to your Applications folder.
  3. After download is complete, the installer opens automatically. Click Continue and follow the onscreen instructions.

Installer screen

Web CMS Detecting Tools

CMS AnalyzerEffectiveness
W3Techs (w3techs.com/sites)73%
BuiltWith (builtwith.com)64%
Wappalyzer (firefox add-on)36%
CMS Detector (detectcms.com)27%
CMSeye (cms.targetinfolabs.com)27%


Imports System.Net.Mail
Public Class Form1
    Private Sub Button1_Click(ByVal sender As System.Object, _
    ByVal e As System.EventArgs) Handles Button1.Click
            Dim SmtpServer As New SmtpClient()
            Dim mail As New MailMessage()
            SmtpServer.Credentials = New _
  Net.NetworkCredential("username@gmail.com", "password")
            SmtpServer.Port = 587
            SmtpServer.Host = "smtp.gmail.com"
            mail = New MailMessage()
            mail.From = New MailAddress("YOURusername@gmail.com")
            mail.Subject = "Test Mail"
            mail.Body = "This is for testing SMTP mail from GMAIL"
            MsgBox("mail send")
        Catch ex As Exception
        End Try
    End Sub
End Class

SharePoint 2013/2010 - Remove Columns Name from Group View


To remove the column name from group view and retaining the collapse and expand option,copy and paste the below javascript in the page using content editor or script editor.

JavaScript (SharePoint 2013/SharePoint 2010):
<script type="text/javascript" language="javascript">
        function HideHeaders() {
            var elements = getElementsByClassName(document, "td""ms-gb");
            var elem;
            for (var i = 0; i < elements.length; i++) {
                elem = elements[i];
                elem.childNodes[0].childNodes[1].nodeValue = "";
                elem.childNodes[1].nodeValue = elem.childNodes[1].nodeValue.replace(':''');
            elements = getElementsByClassName(document, "td""ms-gb2");
            for (var i = 0; i < elements.length; i++) {
                elem = elements[i];
                elem.childNodes[1].childNodes[1].nodeValue = "";                elem.childNodes[2].nodeValue = elem.childNodes[2].nodeValue.replace(':''');
        function getElementsByClassName(oElm, strTagName, strClassName) {
            var arrElements = (strTagName == "*" && oElm.all) ? oElm.all : oElm.getElementsByTagName(strTagName);
            var arrReturnElements = new Array();
            strClassName = strClassName.replace(/\-/g, "\\-");
            var oRegExp = new RegExp("(^|\\s)" + strClassName + "(\\s|$)");
            var oElement;
            for (var i = 0; i < arrElements.length; i++) {
                oElement = arrElements[i];
                if (oRegExp.test(oElement.className)) {
            return (arrReturnElements)