Skip to main content

Posts

Showing posts from April, 2019

Contact Form 7 reCAPTCHA not showing

Contact Form 7 latest version not supporting the reCAPTCHA, So, We need to downgrade the Recaptcha plugin, Steps to Rollback the Contact Form 7 : Install the Plugin "wp rollback". After Installing go to the plugins, you will find an option below all the plugins for rollback. So, rollback the Contact Form 7  from 5.1 to 5.0.5 After this go to integration on the contact form and paste your keys again like you did in the beginning. Open your contact form on the backend and save it again. Make sure you add the recaptha again Now go to your front-end and refresh your page.And your done! Wait for next update with the fix. No need te install any other plugins.

RadTimePicker, showing error as " 'SelectedDate' should be between 'MinDate' and 'MaxDate'".

The default minimum date for the RadDatePicker is 01/01/1980. So, when you try to assign the value this than this date you will get the below error: if you will set the Mindate of RadDatePicker to a minimum range than this will fix the issue ID ="RadDateofBirth" DateInput-DateFormat ="dd/MM/yyyy" MinDate =" 01/01/1940 "   DateInput-DisplayDateFormat ="dd/MM/yyyy" runat ="server"> This will solved the issue.

Microsoft SQL Server - How to check all empty tables in database?

Process to check all empty tables in a Database: 1. Select the database in the SSMS and open the "New Query" window. 2. Run the below query. SELECT sch.name as SchemaName, t.NAME AS TableName,  p.rows AS RowCounts FROM   sys.tables t INNER JOIN  sys.partitions p ON t.object_id = p.OBJECT_ID INNER JOIN sys.schemas sch on t.schema_id = sch.schema_id WHERE  t.NAME NOT LIKE 'dt%'   AND t.is_ms_shipped = 0   AND p.rows <=0 GROUP BY  sch.name,t.Name, p.Rows ORDER BY  sch.name,t.Name

System.InvalidOperationException: 'String[n]: the Size property has an invalid size of 0.'

This error occurs generally when we are not passing the Output parameter in the SqlDbType.VarChar value like the below example SqlParameter job1 = cmd2 . Parameters . Add ( "@job" , SqlDbType . VarChar ); job1 . Direction = ParameterDirection . Output ; You need to define a length when specifying SqlDbType.VarChar parameter, So SqlParameter job1 = cmd2 . Parameters . Add ( "@job" , SqlDbType . VarChar , 50 ); You should use the same length as defined in your SQL Server stored procedure.

How to Import and Export SSL Certificates in IIS 7

How to Import and Export SSL Certificates in IIS 7 This Article Explains how to export your certificate from working server, import the certificate to another server, and then enable the certificate for use on the new server. Exporting/Backing Up to a .pfx File On the Start menu click Run and then type mmc. Click File > Add/Remove Snap-in. Click Certificates > Add. Select Computer Account and then click Next. Select Local Computer and then click Finish. Then close the add standalone snap-in window and the add/remove snap-in window. Click the + to expand the certificates (local computer) console tree and look for the personal directory Warning: Do not select the delete private key option. Leave the default settings and then enter your password if required. Choose to save the file and then click Finish. You should receive an "export successful" message. The .pfx file is now saved to the location you sel...