Could not load file or assembly 'System.Data.SQLite, Version=1.0.89.0, Culture=neutral, PublicKeyToken=abcdefghijkl or one of its dependencies

If you are getting Sitecore WFFM error "Could not load file or assembly 'System.Data.SQLite, Version=1.0.89.0, Culture=neutral, PublicKeyToken=abcdefghijkl or one of its dependencies. The system cannot find the file specified."

Then check existence of "System.Data.SQLite.dll" in "Website\bin" folder.

If it’s missing then paste in "Website\bin" folder.

Please leave your comments or share this tip if it’s useful for you.

How to check your new or modification PAN request status online

I personally feel that most of the life related work should done online. Why to visit difference government and private offices, why to meet them personally, why to call them. For a common man it’s always a difficult to go to government office and do their tasks. Government people are always showing that they are busy even they don’t have no work. Common man is always frustrated with government offices and their babus. So I always prefer to do it online.

So here I am sharing my personal experience to do changes in PAN card and how to track the request online.

If you had applied for PAN card changes like name, DOB, signature, photo etc. then you can submit your request at Karvy. You have to fill a form and attached old PAN card copy, ID proof, address proof. Submit this form along with 105 Rs. In return they will provide a receipt which has acknowledgement number. From that acknowledgement track your request status from below link

https://tin.tin.nsdl.com/pantan/StatusTrack.html

Either enter Acknowledgement number or your personal detail. Click on SUBMIT button as shown in below image and you can get the status which should be either in process or completed.

Please leave your comments or share this tip if it’s useful for you.

Tip for how to check your Aadhaar- Gas linkage Status

To get subsidy on LPG gas cylinder. You need to link your Aadhar Card number with gas agency and bank.

If you had applied your Aadhar card linkage request at Bharat Gas and Bank then you can check the status at below link

http://www.ebharatgas.com/ebgas/faces/CC_include/ConsumerAadhaarStatus.jsp

Enter your Aadhar card or cell number and click on Proceed button. Check the status on the status screen as shown below

Please leave your comments or share this tip if it’s useful for you.

Tip for how and where to check status of any modification request of Aadhar Card

If you have applied for any information update request in Aadhar card like Name, mobile number, address, date of birth, email then you can check update status at below link

https://ssup.uidai.gov.in/check-status

You have to enter your Aadhar number and URN and on click of Get Status button you can check the status.

Please leave your comments or share this tip if it’s useful for you.

Empty strings are not allowed. Parameter name: fieldname

If you are getting “Empty strings are not allowed. Parameter name: fieldname” error in Sitecore then to fix it, do the Publish. Please note that only publish item will not work here. Either publish the site in smart way or do the full site publish.

Please leave your comments or share this tip if it’s useful for you.

How to update your Android mobile with new OS version Lollipop

The first thing is that your mobile should itself ask for system update. If not then you can also check it from Settings-> About Phone -> System Updates

The new #Lollipop setup is 378 MB in size.

First download and install the setup.

After installation, Lollipop optimizing all the apps, upgrading contact database according to new updates.

One thing to remember here is that you cannot make any call for next 15 min during this installation process or better word is you cannot do anything with your cell during installation for next 15 min.

Don't worry about installation of new OS. It will keep your all the apps and settings as it is.

After installation, I suggest just restart your mobile.

I notice lots of improvements in terms of UI, animation, phone contact screen, settings, performance etc.

So oo ahead and do the installation and become the part of new android world.

Please leave your comments or share this tip if it’s useful for you.

Script for LuckyOrange tracking code

Like Google Analytic, there are other analytic support available on web. One of them is #LuckyOrange. 

To work with this you need Site ID. I represented it in sample code as “NNNNN”. Below is script that you need to place it between <head> </head> section of webpage. The code is asynchronous and will not block your page from loading.

<script type='text/javascript'>

    window.__wtw_lucky_site_id = 'NNNNN';

    (function () {

        var wa = document.createElement('script'); wa.type = 'text/javascript'; wa.async = true;

        wa.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://cdn') + '.luckyorange.com/w.js';

        var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(wa, s);

    })();

</script>

Please leave your comments or share this code if it’s useful for you.