Wednesday, October 26, 2016

How to display image from "image selection" field in transformation

You can use following sample code:

<img src="<%# GetDocumentUrl("Image", "") %>" />

Login failed for user 'IIS APPPOOL\DefaultAppPool'

If you don't change, each app pool has it's own identity. In your case, just add a new user to your database SmallBakery with the name IIS APPPOOL\SmallBakery using SQL Management Studio. You find the users list in the "Security/Users" subnode of your database. This should look something like that:

For testing, let the user be member of the db_owner role. If that works, remove this role and just let it be member of db_datareader and db_datawriter.

This way, each app pool (perhaps each website, if they all use their own app pool) only has access to the corresponding database.

If you use Default Web Site so you add "IIS APPPOOL\DefaultAppPool"

SQL Server can't login with newly created user

SQL Server was not configured to allow mixed authentication.

Here are steps to fix:

  1. Right-click on SQL Server instance at root of Object Explorer, click on Properties
  2. Select Security from the left pane.
  3. Select the SQL Server and Windows Authentication mode radio button, and click OK

  1. Right-click on the SQL Server instance, select Restart (alternatively, open up Services and restart the SQL Server service).

Monday, October 24, 2016

How to exclude column save into database for Contact Form 7 DB

When you submitted form data into database default Contact Form DB will insert all your data form into your database so if you want to exclude field something like Google Recaptcha not insert into database.

You just go to Contact Form 7 DB --> Options then click on Save Tab. Add filed name that you want to exclude after "/.*wpcf7.*/,_wpnonce".


Thursday, October 20, 2016

How to add Facebook Open Graph (og) meta tags to blog detail page in Kentico

We can use Head HTML Code WebPart in your Page Template and using macros to populate your tags content.

+ Configure the WebPart
     - Configure the webpart: fbgraph
     -  Web part title: Facebook Open Graph
     -  HTML code

<meta property="og:title" content="{% BlogPostTitle %}" />
<meta property="og:site_name" content="Kentico 9" />
<meta property="og:url" content="{% CurrentDocument.AbsoluteURL #%}" />
<meta property="og:description" content="{% StripTags(BlogPostSummary) %}" />
<meta property="og:image" content="http://{% domain %}/getattachment/{% BlogPostTeaser %}/.aspx" />
<meta property="og:type" content="article" />